protected void btnInfoFromDocBatch_Click(object sender, EventArgs e) { DataTable dt = new DataTable(); dt = GetTemplateColumn(dt); dt = FileLibrary.GetDataFromWordBatch(ConstantsManager.WEBSITE_VIRTUAL_ROOT_DIR + "/" + ConstantsManager.UPLOAD_DOC_DIR + "/" + "T_BM_DWXX", dt, true, true); T_BM_DWXXApplicationLogic instanceT_BM_DWXXApplicationLogic = (T_BM_DWXXApplicationLogic)CreateApplicationLogicInstance(typeof(T_BM_DWXXApplicationLogic)); foreach (DataRow dr in dt.Rows) { appData = new T_BM_DWXXApplicationData(); appData.DWBH = instanceT_BM_DWXXApplicationLogic.AutoGenerateDWBH(appData); int i = 0; appData = instanceT_BM_DWXXApplicationLogic.Add(appData); } }
protected void btnInfoFromDS_Click(object sender, EventArgs e) { int totalCount = 0; int importCount = 0; int updateCount = 0; try { var appDatas = T_BM_DWXXApplicationData.GetDataFromDataFile <T_BM_DWXXApplicationData>(InfoFromDoc.Text, true, true, recordStartLine: T_BM_DWXXContants.ImportDataSetStartLineNum); T_BM_DWXXApplicationLogic instanceT_BM_DWXXApplicationLogic = (T_BM_DWXXApplicationLogic)CreateApplicationLogicInstance(typeof(T_BM_DWXXApplicationLogic)); totalCount = appDatas.Count; foreach (var app in appDatas) { app.DWBH = instanceT_BM_DWXXApplicationLogic.AutoGenerateDWBH(app); if (!DWMC.Text.IsHtmlNullOrWiteSpace()) { app.DWMC = Convert.ToString(DWMC.Text); } string strSJDWBH = GetValue(new RICH.Common.BM.T_BM_DWXX.T_BM_DWXXApplicationLogicBase().GetValueByFixCondition("DWMC", app.SJDWBH, "DWBH")); if (!DataValidateManager.ValidateIsNull(strSJDWBH)) { app.SJDWBH = strSJDWBH; } if (!SJDWBH.SelectedValue.IsHtmlNullOrWiteSpace()) { app.SJDWBH = Convert.ToString(SJDWBH.SelectedValue); } if (!DZ.Text.IsHtmlNullOrWiteSpace()) { app.DZ = Convert.ToString(DZ.Text); } if (!YB.Text.IsHtmlNullOrWiteSpace()) { app.YB = Convert.ToString(YB.Text); } if (!LXBM.Text.IsHtmlNullOrWiteSpace()) { app.LXBM = Convert.ToString(LXBM.Text); } if (!LXDH.Text.IsHtmlNullOrWiteSpace()) { app.LXDH = Convert.ToString(LXDH.Text); } if (!Email.Text.IsHtmlNullOrWiteSpace()) { app.Email = Convert.ToString(Email.Text); } if (!LXR.Text.IsHtmlNullOrWiteSpace()) { app.LXR = Convert.ToString(LXR.Text); } if (!SJ.Text.IsHtmlNullOrWiteSpace()) { app.SJ = Convert.ToString(SJ.Text); } instanceT_BM_DWXXApplicationLogic.Add(app); if (app.ResultCode == RICH.Common.Base.ApplicationData.ApplicationDataBase.ResultState.Succeed) { importCount++; } else { app.OPCode = RICH.Common.Base.ApplicationData.ApplicationDataBase.OPType.PK; instanceT_BM_DWXXApplicationLogic.Modify(app); if (app.ResultCode == RICH.Common.Base.ApplicationData.ApplicationDataBase.ResultState.Succeed) { updateCount++; } } } MessageContent += @"<font color=""green"">共{0}条数据,导入数据{1}条,更新数据{2}条。</font>".FormatInvariantCulture(totalCount, importCount, updateCount); } catch (Exception ex) { MessageContent += @"<font color=""red"">导入数据过程出错:{0}<br/>共{1}条数据,已导入数据{2}条,已更新数据{3}条。</font>".FormatInvariantCulture(ex.Message, totalCount, importCount, updateCount); } }
//===================================================================== // FunctionName : GetAddInputParameter /// <summary> /// 得到添加用户输入参数操作 /// </summary> //===================================================================== protected override Boolean GetAddInputParameter() { Boolean boolReturn = true; ValidateData validateData = new ValidateData(); // 验证输入参数 validateData = ValidateDWMC(DWMC.Text, false, false); if (validateData.Result) { if (!validateData.IsNull) { appData.DWMC = Convert.ToString(validateData.Value.ToString()); } DWMC.BackColor = System.Drawing.Color.Empty; } else { DWMC.BackColor = System.Drawing.Color.YellowGreen; MessageContent += @"<font color=""red"">" + validateData.Message + "</font>"; boolReturn = validateData.Result; } validateData = ValidateSJDWBH(SJDWBH.SelectedValue, true, false); if (validateData.Result) { if (!validateData.IsNull) { appData.SJDWBH = Convert.ToString(validateData.Value.ToString()); } SJDWBH.BackColor = System.Drawing.Color.Empty; } else { SJDWBH.BackColor = System.Drawing.Color.YellowGreen; MessageContent += @"<font color=""red"">" + validateData.Message + "</font>"; boolReturn = validateData.Result; } validateData = ValidateDZ(DZ.Text, true, false); if (validateData.Result) { if (!validateData.IsNull) { appData.DZ = Convert.ToString(validateData.Value.ToString()); } DZ.BackColor = System.Drawing.Color.Empty; } else { DZ.BackColor = System.Drawing.Color.YellowGreen; MessageContent += @"<font color=""red"">" + validateData.Message + "</font>"; boolReturn = validateData.Result; } validateData = ValidateYB(YB.Text, true, false); if (validateData.Result) { if (!validateData.IsNull) { appData.YB = Convert.ToString(validateData.Value.ToString()); } YB.BackColor = System.Drawing.Color.Empty; } else { YB.BackColor = System.Drawing.Color.YellowGreen; MessageContent += @"<font color=""red"">" + validateData.Message + "</font>"; boolReturn = validateData.Result; } validateData = ValidateLXBM(LXBM.Text, true, false); if (validateData.Result) { if (!validateData.IsNull) { appData.LXBM = Convert.ToString(validateData.Value.ToString()); } LXBM.BackColor = System.Drawing.Color.Empty; } else { LXBM.BackColor = System.Drawing.Color.YellowGreen; MessageContent += @"<font color=""red"">" + validateData.Message + "</font>"; boolReturn = validateData.Result; } validateData = ValidateLXDH(LXDH.Text, true, false); if (validateData.Result) { if (!validateData.IsNull) { appData.LXDH = Convert.ToString(validateData.Value.ToString()); } LXDH.BackColor = System.Drawing.Color.Empty; } else { LXDH.BackColor = System.Drawing.Color.YellowGreen; MessageContent += @"<font color=""red"">" + validateData.Message + "</font>"; boolReturn = validateData.Result; } validateData = ValidateEmail(Email.Text, true, false); if (validateData.Result) { if (!validateData.IsNull) { appData.Email = Convert.ToString(validateData.Value.ToString()); } Email.BackColor = System.Drawing.Color.Empty; } else { Email.BackColor = System.Drawing.Color.YellowGreen; MessageContent += @"<font color=""red"">" + validateData.Message + "</font>"; boolReturn = validateData.Result; } validateData = ValidateLXR(LXR.Text, true, false); if (validateData.Result) { if (!validateData.IsNull) { appData.LXR = Convert.ToString(validateData.Value.ToString()); } LXR.BackColor = System.Drawing.Color.Empty; } else { LXR.BackColor = System.Drawing.Color.YellowGreen; MessageContent += @"<font color=""red"">" + validateData.Message + "</font>"; boolReturn = validateData.Result; } validateData = ValidateSJ(SJ.Text, true, false); if (validateData.Result) { if (!validateData.IsNull) { appData.SJ = Convert.ToString(validateData.Value.ToString()); } SJ.BackColor = System.Drawing.Color.Empty; } else { SJ.BackColor = System.Drawing.Color.YellowGreen; MessageContent += @"<font color=""red"">" + validateData.Message + "</font>"; boolReturn = validateData.Result; } // 自动生成编号 T_BM_DWXXApplicationLogic instanceT_BM_DWXXApplicationLogic = (T_BM_DWXXApplicationLogic)CreateApplicationLogicInstance(typeof(T_BM_DWXXApplicationLogic)); appData.DWBH = instanceT_BM_DWXXApplicationLogic.AutoGenerateDWBH(appData); return(boolReturn); }