摘要:
public void ExportExcel(DataSet _dsTemp){StringWriter sw=new StringWriter(); string Title = "序号\t";foreach(DataColumn col in _dsTemp.Tables[0].Columns){Title+=col.ColumnName+"\t"; }//Title = HttpUtili... 阅读全文
摘要:
1:依某字段分组取最大记录值的所有数据select * from Attachment a ,(select max(edition) edition,docno from Attachment group by docno) b where a.edition=b.edition and a.docno=b.docno order by filename,uploadtime 阅读全文