开发日记

生成Excel 文件

 

DataSet ds = xtDAO.SqlText.ExecuteDataset(Sql+sb.ToString());

              StringBuilder Sb = new StringBuilder();

              Sb.Append("<table width=/"100%/" heifht=/"100%/" border=1>");

              Sb.Append("<tr align=left><td>物料编号</td><td>物料名称</td><td>规格</td><td>单位</td><td>来源</td><td>实收单价</td><td>实收数量</td>")

                   .Append("<td>实收小计</td><td>验收人员</td><td>进场时间</td></tr>");

             

              foreach(DataRow dr in ds.Tables[0].Rows )

              {

                   Sb.Append("<tr align=left>");

                   Sb.Append("<td>"+dr["M_Num"].ToString()+"</td>");

                   Sb.Append("<td>"+dr["M_ClName"].ToString()+"</td>");

                   Sb.Append("<td>"+dr["M_GuiGe"].ToString()+"</td>");

                   Sb.Append("<td>"+dr["M_DanWei"].ToString()+"</td>");

                   Sb.Append("<td>"+dr["M_LaiYuan"].ToString()+"</td>");

                   Sb.Append("<td>"+dr["sjdj"].ToString()+"</td>");

                   Sb.Append("<td>"+dr["sssl"].ToString()+"</td>");

                   Sb.Append("<td>"+dr["ssxj"].ToString()+"</td>");

                   Sb.Append("<td>"+dr["ysry"].ToString()+"</td>");

                   Sb.Append("<td>"+dr["jcsj"].ToString()+"</td>");

                   Sb.Append("</tr>");

              }

              Sb.Append("</table>");

              string strFile = "../PubFiles/Material_Files/"+DateTime.Now.ToString("yyyyMMddhhmmss")+".xls";

             

              StreamWriter sw =new StreamWriter (Server.MapPath(strFile),true,Encoding.Default);

              sw.Write(Sb.ToString());

              sw.Close();

Response.Write("<script language='javascript'>window.open('"+strFile+"');</script>");

 

 

                       截取String

string str=”AAA/BBB”;

int index = str.IndexOf("/");

string str = str.Substring(0,index);

这样就能取到AAA了！

两个时间相减 再加1

DateTime dt1=Convert.ToDateTime(this.tb_kssj.Text);

                   DateTime dt2=Convert.ToDateTime(this.tb_jssj.Text);

                   TimeSpan ts=dt2.Subtract(dt1);

                   int i =ts.Days;

                   return i+1;

 

 

 

 

<asp:TemplateColumn HeaderText="序号">

                                                 <ItemTemplate >

                                                 <asp:Label ID="Label" Runat="server" Text='<%# Container.ItemIndex+1 %>'></asp:Label>

                                                 </ItemTemplate>

时间类型

DateTime.Now.ToString("yyyy-MM-dd:HH:mm:ss");

 

DateTime.Now.ToString("yyyy-MM-dd ");

 

DateTime.Now.ToString("yyyyMMddhhmmss ");

 

if ( this.txtInTime.Text.Trim() !="" )

              {

                   string s = this.txtInTime.Text;

                   sb.Append(" and Convert(varchar(10), tjsj, 120) >= '"+s+"'");

              }转为长时间型

                                                数组

this.H_zsrid.Value＝”a,b,c,d,e,”;

string zsrID=this.H_zsrid.Value.TrimEnd(',');

                   string zsr = this.txt_zsr.Text.TrimEnd(',');

                   string[] zsr_s = zsr.Split(',');

                   string[] zid = zsrID.Split(',');

                  

                   int[] arraylist = new int[zid.Length];

                   for(int i=0;i<arraylist.Length;i++ )

                   {

                       arraylist[i] = Convert.ToInt(zid[i]);

}

                                         

 

                                   URL参数转码

Server.UrlEncode(s)

                            DataGrid未查看的记录显示为红色

private void DataGrid1_ItemDataBound(object sender, DataGridItemEventArgs e)

         {

              for(int i=0;i<this.DataGrid1.Items.Count;i++)

              {

                   Label lblRead=(Label)this.DataGrid1.Items[i].Cells[7].FindControl("lblRead");

                   if(lblRead.Text=="1")

                   {

                       this.DataGrid1.Items[i].Style["color"]="Red";

                   }

              }

 

         }