控件操作类文件的部分手写代码[3]

    }
   }
  }
  /// <summary>
  /// 重载上面的函数将Reader参数换成Array
  /// </summary>
  /// <param name="dl"></param>
  /// <param name="al"></param>
  public void ShowDrData(DropDownList dl,ArrayList al)
  {
   dl.DataSource=al;
   //dl.DataTextField=strtext;
   //dl.DataValueField=strvalue;
   dl.DataBind();
  }
  /// <summary>
  /// 把数据库里的数据读到LB里面去.
  /// </summary>
  /// <param name="lb"></param>
  /// <param name="dr"></param>
  /// <param name="strtext"></param>
  /// <param name="strvalue"></param>
  public void ShowDrData(ListBox lb,SqlDataReader dr,string strtext,string strvalue)
  {
   lb.DataSource=dr;
   lb.DataTextField=strtext;
   lb.DataValueField=strvalue;
   lb.DataBind();
  }
  /// <summary>
  /// 将数据读到Array数组//
  /// </summary>
  /// <param name="dr"></param>
  /// <param name="strslt"></param>
  /// <param name="strfield"></param>
  /// <returns></returns>
  public ArrayList ReturnArray(SqlDataReader dr,string strslt,string strfield)
  {
   ArrayList objarr;
   objarr=new ArrayList();
   if (dr.HasRows)
   {
    while (dr.Read())
    {
     objarr.Add(dr[strfield].ToString());
    }
    dr.Close();
   }
   objarr.Insert(0,strslt);
   return objarr;
  }
  public void Close()
  {
   db.Close();
   userdata=null;
  }
  /// <summary>
  /// 读取Check组的值;
  /// </summary>
  /// <param name="lb"></param>
  /// <returns></returns>
  public string ReadCheckBoxList(CheckBoxList lb)
  {
   string returnvalue="0";
   for (int i=0; i<lb.Items.Count; i++)
   {
    if (lb.Items[i].Selected)
     returnvalue=returnvalue +","+ lb.Items[i].Value;
   }
   return returnvalue;
  }
  /// <summary>
  /// 显示Check组的值
  /// </summary>
  /// <param name="cbl"></param>
  /// <param name="strCheckValue"></param>
  public void ShowCheckBoxList(CheckBoxList cbl,string strCheckValue)
  {
   for (int i=0;i<cbl.Items.Count;i++)
   {
    if (strCheckValue.IndexOf(cbl.Items[i].Value)>0)
    {
        cbl.Items[i].Selected=true;
    }
   }
  }
  /// <summary>
  /// DateDiff功能实现函数
  /// </summary>
  /// <param name="howtocompare"></param>
  /// <param name="startDate"></param>
  /// <param name="endDate"></param>
  /// <returns></returns>
  public double DateDiff(string howtocompare, System.DateTime startDate, System.DateTime endDate)
  {
   double diff=0;
   System.TimeSpan TS = new System.TimeSpan(startDate.Ticks-endDate.Ticks);
   switch (howtocompare.ToLower())
   {
    case "m":
     diff = Convert.ToDouble(TS.TotalMinutes);
     break;
    case "s":
     diff = Convert.ToDouble(TS.TotalSeconds);
     break;
    case "t":
     diff = Convert.ToDouble(TS.Ticks);