protected override void btnSaveFilterReport_Click(object sender, EventArgs e) { if (FilterReportName.Text.IsHtmlNullOrWiteSpace()) { return; } appData = new DictionaryApplicationData(); GetQueryInputParameter(); FilterReportApplicationLogic filterReportApplicationLogic = (FilterReportApplicationLogic)CreateApplicationLogicInstance(typeof(FilterReportApplicationLogic)); FilterReportApplicationData filterReportApplicationData = new FilterReportApplicationData() { BGMC = FilterReportName.Text.TrimIfNotNullOrWhiteSpace(), UserID = (string)Session[ConstantsManager.SESSION_USER_ID], BGLX = FilterReportType, GXBG = "0", XTBG = "0", BGCXTJ = JsonHelper.ObjectToJson(appData), BGCJSJ = DateTime.Now, }; FilterReportApplicationData filterReportQueryApplicationData; if (!FilterReportName.Text.IsHtmlNullOrWiteSpace()) { filterReportQueryApplicationData = new FilterReportApplicationData() { BGMC = FilterReportName.Text.TrimIfNotNullOrWhiteSpace(), UserID = (string)Session[ConstantsManager.SESSION_USER_ID], BGLX = FilterReportType, XTBG = "0", CurrentPage = 1, PageSize = 1000, }; filterReportQueryApplicationData = filterReportApplicationLogic.Query(filterReportQueryApplicationData); if (filterReportQueryApplicationData.ResultSet.Tables.Count > 0) { foreach (DataRow item in filterReportQueryApplicationData.ResultSet.Tables[0].Rows) { filterReportApplicationLogic.Delete(new FilterReportApplicationData() { ObjectID = GetValue(item["ObjectID"]), OPCode = RICH.Common.Base.ApplicationData.ApplicationDataBase.OPType.ID }); } } } filterReportApplicationLogic.Add(filterReportApplicationData); FilterReportDataBind((string)Session[ConstantsManager.SESSION_USER_ID], FilterReportList); FilterReportList.Items.FindByText(FilterReportName.Text.TrimIfNotNullOrWhiteSpace()).Selected = true; }
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 + "/" + "FilterReport", dt, true, true); FilterReportApplicationLogic instanceFilterReportApplicationLogic = (FilterReportApplicationLogic)CreateApplicationLogicInstance(typeof(FilterReportApplicationLogic)); foreach (DataRow dr in dt.Rows) { appData = new FilterReportApplicationData(); int i = 0; appData = instanceFilterReportApplicationLogic.Add(appData); } }
protected void btnInfoFromDS_Click(object sender, EventArgs e) { int totalCount = 0; int importCount = 0; int updateCount = 0; try { var appDatas = FilterReportApplicationData.GetDataFromDataFile <FilterReportApplicationData>(InfoFromDoc.Text, true, true, recordStartLine: FilterReportContants.ImportDataSetStartLineNum); FilterReportApplicationLogic instanceFilterReportApplicationLogic = (FilterReportApplicationLogic)CreateApplicationLogicInstance(typeof(FilterReportApplicationLogic)); totalCount = appDatas.Count; foreach (var app in appDatas) { if (!BGMC.Text.IsHtmlNullOrWiteSpace()) { app.BGMC = Convert.ToString(BGMC.Text); } app.UserID = (string)Session[ConstantsManager.SESSION_USER_ID]; string strUserID = GetValue(new RICH.Common.BM.T_PM_UserInfo.T_PM_UserInfoApplicationLogicBase().GetValueByFixCondition("UserLoginName", app.UserID, "UserID")); if (!DataValidateManager.ValidateIsNull(strUserID)) { app.UserID = strUserID; } if (!BGLX.Text.IsHtmlNullOrWiteSpace()) { app.BGLX = Convert.ToString(BGLX.Text); } string strGXBG = GetValue(new RICH.Common.BM.Dictionary.DictionaryApplicationLogicBase().GetValueByFixCondition("MC", app.GXBG, "DM")); if (!DataValidateManager.ValidateIsNull(strGXBG)) { app.GXBG = strGXBG; } if (!GXBG.SelectedValue.IsHtmlNullOrWiteSpace()) { app.GXBG = Convert.ToString(GXBG.SelectedValue); } string strXTBG = GetValue(new RICH.Common.BM.Dictionary.DictionaryApplicationLogicBase().GetValueByFixCondition("MC", app.XTBG, "DM")); if (!DataValidateManager.ValidateIsNull(strXTBG)) { app.XTBG = strXTBG; } if (!XTBG.SelectedValue.IsHtmlNullOrWiteSpace()) { app.XTBG = Convert.ToString(XTBG.SelectedValue); } if (!BGCXTJ.Text.IsHtmlNullOrWiteSpace()) { app.BGCXTJ = Convert.ToString(BGCXTJ.Text); } app.BGCJSJ = DateTime.Now; instanceFilterReportApplicationLogic.Add(app); if (app.ResultCode == RICH.Common.Base.ApplicationData.ApplicationDataBase.ResultState.Succeed) { importCount++; } else { app.OPCode = RICH.Common.Base.ApplicationData.ApplicationDataBase.OPType.PK; instanceFilterReportApplicationLogic.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); } }