private void IniPage()
{
try
{
BLL.SupplierMaterialImport imp = new SupplierMaterialImport();
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 = '1413'").Tables[0];
Session["tbAllSystemGroup"] = tbAllSystemGroup;
}
finally
{
qa.Dispose();
}
}
catch (Exception ex)
{
ApplicationLog.WriteLog(this.ToString(), ex, "");
Response.Write(JavaScript.Alert(true, "初始化页面出错：" + ex.Message));
}
}
/// <summary>
/// 导入
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnOK_ServerClick(object sender, System.EventArgs e)
{
if (this.txtFile.PostedFile.FileName == "")
{
Response.Write(Rms.Web.JavaScript.Alert(true, "请选择文件"));
return;
}
int succ_count = 0;
int err_count = 0;
try
{
this.txtResult.Value = "";
StreamReader m_sr = new StreamReader(this.txtFile.PostedFile.InputStream, System.Text.Encoding.Default);
int r = 0;
//第1行是标题
if (m_sr.Peek() >= 0)
{
m_sr.ReadLine();
r++;
}
BLL.SupplierMaterialImport imp = new SupplierMaterialImport();
EntityData entity = DAL.EntityDAO.MaterialDAO.GetAllSupplierMaterial();
while (m_sr.Peek() >= 0)
{
string s = m_sr.ReadLine();
r++;
string hint = "";
string SupplierName = "";
string SupplierMaterialGroupFullName = "";
DataRow dr = imp.ImportSupplierMaterialSingle(s, entity, ref hint, ref SupplierName, ref SupplierMaterialGroupFullName, false, (DataTable)Session["tbAllSystemGroup"]);
if (dr == null)
{
//出错
err_count++;
this.txtResult.Value = this.txtResult.Value + string.Format("第 {0} 行 {1}：", r, "") + hint + "\n";
}
else
{
//成功
succ_count++;
}
}
DAL.EntityDAO.MaterialDAO.SubmitAllSupplierMaterial(entity);
}
catch (Exception ex)
{
ApplicationLog.WriteLog(this.ToString(), ex, "");
Response.Write(JavaScript.Alert(true, "导入出错：" + ex.Message));
return;
}
if (err_count > 0)
{
this.txtResult.Value = string.Format("导入完成，{0}条成功， {1}条出错：", succ_count, err_count) + "\n" + this.txtResult.Value;
}
else
{
this.txtResult.Value = string.Format("{0}条导入成功", succ_count);
}
//导入有错时记日志
ApplicationLog.WriteFile("厂商材料导入.log", this.ToString(), this.txtResult.Value);
RefreshParent();
// Response.Write(JavaScript.WinClose(false));
}
/// <summary>
/// 另存为csv
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnDownloadCsv_ServerClick(object sender, System.EventArgs e)
{
try
{
if (Session["entityImportSupplierMaterial"] == null)
{
throw new Exception("超时，请重新导入");
}
EntityData entity = (EntityData)Session["entityImportSupplierMaterial"];
DataView dv = new DataView(entity.CurrentTable, "IsImport = 1", "rowid", DataViewRowState.CurrentRows);
RmsPM.BLL.FileIO io = new FileIO(Response, Request, Server, Session);
io.SaveFileName = "SupplierMaterialImportPrepare.csv";
StreamWriter w = new StreamWriter(io.SaveFileNamePhy, false, System.Text.Encoding.Default);
try
{
BLL.SupplierMaterialImport imp = new SupplierMaterialImport();
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));
}
}
/// <summary>
/// 完成
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnComplete_ServerClick(object sender, System.EventArgs e)
{
try
{
int step = 9;
this.txtStep.Value = step.ToString();
int succ_count = 0;
int err_count = 0;
int succ_add_count = 0;
try
{
this.txtResult.Value = "";
if (Session["tbImportSupplierMaterialStream"] == null)
{
throw new Exception("超时，请重新导入");
}
DataTable tbStream = (DataTable)Session["tbImportSupplierMaterialStream"];
BLL.SupplierMaterialImport imp = new SupplierMaterialImport();
EntityData entity = DAL.EntityDAO.MaterialDAO.GetAllSupplierMaterial();
foreach (DataRow drStream in tbStream.Rows)
{
string s = BLL.ConvertRule.ToString(drStream["text"]);
int r = BLL.ConvertRule.ToInt(drStream["rowid"]);
string hint = "";
string SupplierName = "";
string GroupFullName = "";
DataRow dr = imp.ImportSupplierMaterialSingle(s, entity, ref hint, ref SupplierName, ref GroupFullName, false, (DataTable)Session["tbAllSystemGroup"]);
if (dr == null)
{
//出错
err_count++;
this.txtResult.Value = this.txtResult.Value + string.Format("第 {0} 行 {1}：", r, "") + hint + "\n";
}
else
{
//成功
succ_count++;
if (dr.RowState == DataRowState.Added) //新增
{
succ_add_count++;
}
}
}
DAL.EntityDAO.MaterialDAO.SubmitAllSupplierMaterial(entity);
}
catch (Exception ex)
{
ApplicationLog.WriteLog(this.ToString(), ex, "");
Response.Write(JavaScript.Alert(true, "导入出错：" + ex.Message));
return;
}
int succ_edit_count = succ_count - succ_add_count;
if (err_count > 0)
{
this.txtResult.Value = string.Format("导入完成，{0}条成功（新增{1}条、修改{2}条），{3}条出错：", succ_count, succ_add_count, succ_edit_count, err_count) + "\n" + this.txtResult.Value;
}
else
{
this.txtResult.Value = string.Format("导入完成，{0}条导入成功（新增{1}条、修改{2}条）", succ_count, succ_add_count, succ_edit_count);
}
//导入有错时记日志
ApplicationLog.WriteFile("厂商材料导入.log", this.ToString(), this.txtResult.Value);
RefreshParent();
}
catch (Exception ex)
{
ApplicationLog.WriteLog(this.ToString(), ex, "");
Response.Write(JavaScript.Alert(true, "完成出错：" + ex.Message));
}
}
/// <summary>
/// 显示要导入的厂商材料列表
/// </summary>
private void ShowImportList()
{
try
{
if (Session["tbImportSupplierMaterialStream"] == null)
{
throw new Exception("超时，请重新导入");
}
DataTable tbStream = (DataTable)Session["tbImportSupplierMaterialStream"];
BLL.SupplierMaterialImport imp = new SupplierMaterialImport();
// EntityData entity = new EntityData("SupplierMaterial");
EntityData entity = DAL.EntityDAO.MaterialDAO.GetAllSupplierMaterial();
//增加预导入结果列
entity.CurrentTable.Columns.Add("GroupFullName");
entity.CurrentTable.Columns.Add("SupplierName");
entity.CurrentTable.Columns.Add("rowid", typeof(int));
entity.CurrentTable.Columns.Add("text");
entity.CurrentTable.Columns.Add("ImportHint");
entity.CurrentTable.Columns.Add("ImportResult", typeof(int));
entity.CurrentTable.Columns.Add("ImportResultName");
entity.CurrentTable.Columns.Add("IsImport", typeof(int));
int add_count = 0;
int edit_count = 0;
int err_count = 0;
foreach (DataRow drStream in tbStream.Rows)
{
string s = BLL.ConvertRule.ToString(drStream["text"]);
int r = BLL.ConvertRule.ToInt(drStream["rowid"]);
string hint = "";
string SupplierName = "";
string GroupFullName = "";
DataRow dr = imp.ImportSupplierMaterialSingle(s, entity, ref hint, ref SupplierName, ref GroupFullName, true, (DataTable)Session["tbAllSystemGroup"]);
if (dr == null)
{
//出错
err_count++;
dr = entity.CurrentTable.NewRow();
dr["SupplierMaterialCode"] = "ERR_" + r.ToString();
dr["ImportHint"] = hint;
dr["ImportResult"] = -1;
dr["ImportResultName"] = "有错";
entity.CurrentTable.Rows.Add(dr);
}
else
{
//成功
if (dr.RowState == DataRowState.Added)
{
add_count++;
dr["ImportResult"] = 1;
dr["ImportResultName"] = "新增";
}
else
{
edit_count++;
dr["ImportResult"] = 2;
dr["ImportResultName"] = "修改";
}
}
dr["GroupFullName"] = GroupFullName;
dr["SupplierName"] = SupplierName;
dr["rowid"] = r;
dr["text"] = s;
dr["IsImport"] = 1;
}
this.lblCountAdd.Text = add_count.ToString();
this.lblCountEdit.Text = edit_count.ToString();
this.lblCountErr.Text = err_count.ToString();
Session["entityImportSupplierMaterial"] = entity;
BindImportList();
// entity.Dispose();
}
catch (Exception ex)
{
ApplicationLog.WriteLog(this.ToString(), ex, "");
Response.Write(JavaScript.Alert(true, "显示要导入的厂商材料列表出错：" + ex.Message));
}
}
