private void IniPage() { try { BLL.MaterialCostImport imp = new MaterialCostImport(); this.lblFieldDesc.Text = imp.GetDefineFieldDesc(); //取所有的系统类别及其全名 QueryAgent qa = new Rms.ORMap.QueryAgent(); try { DataTable tbAllSystemGroup = qa.ExecSqlForDataSet("select dbo.GetSystemGroupFullName(GroupCode) as FullName, * from SystemGroup where ClassCode = '1411'").Tables[0]; Session["tbAllSystemGroup"] = tbAllSystemGroup; } finally { qa.Dispose(); } } catch (Exception ex) { ApplicationLog.WriteLog(this.ToString(), ex, ""); Response.Write(JavaScript.Alert(true, "初始化页面出错:" + ex.Message)); } }
/// <summary> /// 另存为csv /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnDownloadCsv_ServerClick(object sender, System.EventArgs e) { try { if (Session["entityImportMaterialCost"] == null) { throw new Exception("超时,请重新导入"); } EntityData entity = (EntityData)Session["entityImportMaterialCost"]; DataView dv = new DataView(entity.CurrentTable, "IsImport = 1", "rowid", DataViewRowState.CurrentRows); RmsPM.BLL.FileIO io = new FileIO(Response, Request, Server, Session); io.SaveFileName = "MaterialCostImportPrepare.csv"; StreamWriter w = new StreamWriter(io.SaveFileNamePhy, false, System.Text.Encoding.Default); try { BLL.MaterialCostImport imp = new MaterialCostImport(); string s; //第1行是列标题 s = imp.GetDefineFieldDesc(); s += ",预导入结果,错误提示"; w.WriteLine(s); int count = imp.tbDefine.Rows.Count; //数据 foreach (DataRowView drv in dv) { DataRow dr = drv.Row; s = ""; s = BLL.ConvertRule.ToString(dr["text"]); string[] arr = BLL.ImportRule.SplitCsvLine(s); //用“,”补足列数 for (int k = arr.Length; k < count; k++) { s += ","; } /* * //按字段定义重新写入 * for (int i=0;i<count;i++) * { * DataRow drDefine = imp.tbDefine.Rows[i]; * string FieldName = drDefine["FieldName"].ToString(); * * if (i > 0) * s += ","; * * if (FieldName != "") * { * s += BLL.ConvertRule.ToString(dr[FieldName]); * } * } */ //写入预导入结果 s += "," + BLL.ConvertRule.ToString(dr["ImportResultName"]); s += "," + BLL.ConvertRule.ToString(dr["ImportHint"]); w.WriteLine(s); } } finally { w.Close(); } io.ShowClient(); } catch (Exception ex) { ApplicationLog.WriteLog(this.ToString(), ex, ""); Response.Write(JavaScript.Alert(true, "另存为csv出错:" + ex.Message)); } }