/// <summary> /// 保存按钮事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSave_Click(object sender, EventArgs e) { Model.Check_CheckHolidayDetail detail = BLL.Check_CheckHolidayDetailService.GetCheckHolidayDetailByCheckHolidayDetailId(this.CheckHolidayDetailId); if (detail != null) { detail.CheckResult = this.txtCheckResult.Text.Trim(); detail.CheckOpinion = this.txtCheckOpinion.Text.Trim(); detail.HandleResult = this.txtHandleResult.Text.Trim(); detail.CheckStation = this.txtCheckStation.Text.Trim(); detail.CheckContent = this.txtCheckItem.Text.Trim(); BLL.Check_CheckHolidayDetailService.UpdateCheckHolidayDetail(detail); } PageContext.RegisterStartupScript(ActiveWindow.GetHidePostBackReference()); }
/// <summary> /// 修改季节性/节假日检查明细信息 /// </summary> /// <param name="CheckHolidayDetail"></param> public static void UpdateCheckHolidayDetail(Model.Check_CheckHolidayDetail CheckHolidayDetail) { Model.SUBHSSEDB db = Funs.DB; var newCheckHolidayDetail = db.Check_CheckHolidayDetail.FirstOrDefault(x => x.CheckHolidayDetailId == CheckHolidayDetail.CheckHolidayDetailId); if (newCheckHolidayDetail != null) { newCheckHolidayDetail.CheckResult = CheckHolidayDetail.CheckResult; newCheckHolidayDetail.CheckOpinion = CheckHolidayDetail.CheckOpinion; newCheckHolidayDetail.CheckStation = CheckHolidayDetail.CheckStation; newCheckHolidayDetail.HandleResult = CheckHolidayDetail.HandleResult; newCheckHolidayDetail.CheckContent = CheckHolidayDetail.CheckContent; newCheckHolidayDetail.WorkArea = CheckHolidayDetail.WorkArea; db.SubmitChanges(); } }
/// <summary> /// 增加季节性/节假日检查明细信息 /// </summary> /// <param name="CheckHolidayDetail"></param> public static void AddCheckHolidayDetail(Model.Check_CheckHolidayDetail CheckHolidayDetail) { Model.SUBHSSEDB db = Funs.DB; Model.Check_CheckHolidayDetail newCheckHolidayDetail = new Model.Check_CheckHolidayDetail { CheckHolidayDetailId = CheckHolidayDetail.CheckHolidayDetailId, CheckHolidayId = CheckHolidayDetail.CheckHolidayId, CheckItem = CheckHolidayDetail.CheckItem, CheckResult = CheckHolidayDetail.CheckResult, CheckOpinion = CheckHolidayDetail.CheckOpinion, CheckStation = CheckHolidayDetail.CheckStation, HandleResult = CheckHolidayDetail.HandleResult, CheckContent = CheckHolidayDetail.CheckContent, WorkArea = CheckHolidayDetail.WorkArea }; db.Check_CheckHolidayDetail.InsertOnSubmit(newCheckHolidayDetail); db.SubmitChanges(); }
/// <summary> /// Grid1行点击事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Grid1_RowCommand(object sender, GridCommandEventArgs e) { string checkHolidayDetailId = Grid1.DataKeys[e.RowIndex][0].ToString(); Model.Check_CheckHolidayDetail detail = BLL.Check_CheckHolidayDetailService.GetCheckHolidayDetailByCheckHolidayDetailId(checkHolidayDetailId); if (e.CommandName == "click") { Model.Check_CheckHolidayDetail newDetail = new Model.Check_CheckHolidayDetail { CheckHolidayDetailId = SQLHelper.GetNewID(typeof(Model.Check_CheckHolidayDetail)), CheckHolidayId = detail.CheckHolidayId, CheckItem = detail.CheckItem, CheckContent = detail.CheckContent, CheckResult = "隐患", CheckOpinion = "整改" }; BLL.Check_CheckHolidayDetailService.AddCheckHolidayDetail(newDetail); checkHolidayDetails = (from x in Funs.DB.View_Check_CheckHolidayDetail where x.CheckHolidayId == this.CheckHolidayId orderby x.CheckItem select x).ToList(); Grid1.DataSource = checkHolidayDetails; Grid1.DataBind(); ChangeGridColor(); } }
/// <summary> /// 确认按钮 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSave_Click(object sender, EventArgs e) { List <string> newParentIds = new List <string>(); TreeNode[] nodes = this.tvCheckItemSet.GetCheckedNodes(); foreach (var item in nodes) { if (item.Nodes.Count == 0) { parentIds.Add(item.NodeID); //集合中增加末级节点 if (item.ParentNode != null) { newParentIds.Add(item.ParentNode.NodeID); //记录已增加的末级节点的父级节点集合 } } } foreach (var item in nodes) { if (item.Nodes.Count > 0) { if (!newParentIds.Contains(item.NodeID)) { parentIds.Add(item.NodeID); } } } if (parentIds.Count == 0 && list.Count == 0) { ShowNotify("请至少选择一项!", MessageBoxIcon.Warning); return; } if (!string.IsNullOrEmpty(Request.Params["CheckDayId"])) { foreach (var item in parentIds) { Model.Check_CheckDayDetail detail = new Model.Check_CheckDayDetail { CheckDayDetailId = SQLHelper.GetNewID(typeof(Model.Check_CheckDayDetail)), CheckDayId = Request.Params["CheckDayId"], CheckItem = item }; Model.Check_ProjectCheckItemDetail checkItemDetail = BLL.Check_ProjectCheckItemDetailService.GetCheckItemDetailById(item); if (checkItemDetail != null) { detail.CheckContent = checkItemDetail.CheckContent; } else { var projectCheckItemDetail = BLL.Check_ProjectCheckItemDetailService.GetCheckItemDetailById(item); if (projectCheckItemDetail != null) { detail.CheckContent = projectCheckItemDetail.CheckContent; } } detail.Unqualified = "隐患"; detail.Suggestions = "整改"; detail.CompleteStatus = true; BLL.Check_CheckDayDetailService.AddCheckDayDetail(detail); } } else if (!string.IsNullOrEmpty(Request.Params["CheckSpecialId"])) { foreach (var item in parentIds) { Model.Check_CheckSpecialDetail detail = new Model.Check_CheckSpecialDetail { CheckSpecialDetailId = SQLHelper.GetNewID(typeof(Model.Check_CheckSpecialDetail)), CheckSpecialId = Request.Params["CheckSpecialId"], CheckItem = item }; Model.Check_ProjectCheckItemDetail checkItemDetail = BLL.Check_ProjectCheckItemDetailService.GetCheckItemDetailById(item); if (checkItemDetail != null) { detail.CheckContent = checkItemDetail.CheckContent; } else { var projectCheckItemDetail = BLL.Check_ProjectCheckItemDetailService.GetCheckItemDetailById(item); if (projectCheckItemDetail != null) { detail.CheckContent = projectCheckItemDetail.CheckContent; } } detail.Unqualified = "隐患"; detail.Suggestions = "整改"; detail.CompleteStatus = true; BLL.Check_CheckSpecialDetailService.AddCheckSpecialDetail(detail); } } else if (!string.IsNullOrEmpty(Request.Params["CheckColligationId"])) { foreach (var item in parentIds) { Model.Check_CheckColligationDetail detail = new Model.Check_CheckColligationDetail { CheckColligationDetailId = SQLHelper.GetNewID(typeof(Model.Check_CheckColligationDetail)), CheckColligationId = Request.Params["CheckColligationId"], CheckItem = item }; Model.Check_ProjectCheckItemDetail checkItemDetail = BLL.Check_ProjectCheckItemDetailService.GetCheckItemDetailById(item); if (checkItemDetail != null) { detail.CheckContent = checkItemDetail.CheckContent; } else { var projectCheckItemDetail = BLL.Check_ProjectCheckItemDetailService.GetCheckItemDetailById(item); if (projectCheckItemDetail != null) { detail.CheckContent = projectCheckItemDetail.CheckContent; } } detail.Unqualified = "隐患"; detail.Suggestions = "整改"; detail.CompleteStatus = true; BLL.Check_CheckColligationDetailService.AddCheckColligationDetail(detail); } } else if (!string.IsNullOrEmpty(Request.Params["CheckWorkId"])) { foreach (var item in parentIds) { Model.Check_CheckWorkDetail detail = new Model.Check_CheckWorkDetail { CheckWorkDetailId = SQLHelper.GetNewID(typeof(Model.Check_CheckWorkDetail)), CheckWorkId = Request.Params["CheckWorkId"], CheckItem = item, CheckResult = "合格", }; Model.Check_ProjectCheckItemDetail checkItemDetail = BLL.Check_ProjectCheckItemDetailService.GetCheckItemDetailById(item); if (checkItemDetail != null) { detail.CheckContent = checkItemDetail.CheckContent; detail.SortIndex = checkItemDetail.SortIndex; } else { var projectCheckItemDetail = BLL.Check_ProjectCheckItemDetailService.GetCheckItemDetailById(item); if (projectCheckItemDetail != null) { detail.CheckContent = projectCheckItemDetail.CheckContent; detail.SortIndex = projectCheckItemDetail.SortIndex; } } BLL.Check_CheckWorkDetailService.AddCheckWorkDetail(detail); } } else if (!string.IsNullOrEmpty(Request.Params["CheckHolidayId"])) { foreach (var item in parentIds) { Model.Check_CheckHolidayDetail detail = new Model.Check_CheckHolidayDetail { CheckHolidayDetailId = SQLHelper.GetNewID(typeof(Model.Check_CheckHolidayDetail)), CheckHolidayId = Request.Params["CheckHolidayId"], CheckItem = item, CheckResult = "合格", }; Model.Check_ProjectCheckItemDetail checkItemDetail = BLL.Check_ProjectCheckItemDetailService.GetCheckItemDetailById(item); if (checkItemDetail != null) { detail.CheckContent = checkItemDetail.CheckContent; } else { var projectCheckItemDetail = BLL.Check_ProjectCheckItemDetailService.GetCheckItemDetailById(item); if (projectCheckItemDetail != null) { detail.CheckContent = projectCheckItemDetail.CheckContent; } } BLL.Check_CheckHolidayDetailService.AddCheckHolidayDetail(detail); } } if (!string.IsNullOrEmpty(Request.Params["CheckDayId"])) { foreach (var item in list) { Model.Check_CheckDayDetail detail = new Model.Check_CheckDayDetail { CheckDayDetailId = SQLHelper.GetNewID(typeof(Model.Check_CheckDayDetail)), CheckDayId = Request.Params["CheckDayId"], CheckItem = item }; Model.Check_ProjectCheckItemSet checkItemSet = BLL.Check_ProjectCheckItemSetService.GetCheckItemSetById(item); if (checkItemSet != null) { detail.CheckContent = checkItemSet.CheckItemName; } else { var projectCheckItemDetail = BLL.Check_ProjectCheckItemDetailService.GetCheckItemDetailById(item); if (projectCheckItemDetail != null) { detail.CheckContent = projectCheckItemDetail.CheckContent; } } detail.Unqualified = "隐患"; detail.Suggestions = "整改"; detail.CompleteStatus = true; BLL.Check_CheckDayDetailService.AddCheckDayDetail(detail); } } else if (!string.IsNullOrEmpty(Request.Params["CheckSpecialId"])) { foreach (var item in list) { Model.Check_CheckSpecialDetail detail = new Model.Check_CheckSpecialDetail { CheckSpecialDetailId = SQLHelper.GetNewID(typeof(Model.Check_CheckSpecialDetail)), CheckSpecialId = Request.Params["CheckSpecialId"], CheckItem = item }; Model.Check_ProjectCheckItemSet checkItemSet = BLL.Check_ProjectCheckItemSetService.GetCheckItemSetById(item); if (checkItemSet != null) { detail.CheckContent = checkItemSet.CheckItemName; } else { var projectCheckItemDetail = BLL.Check_ProjectCheckItemDetailService.GetCheckItemDetailById(item); if (projectCheckItemDetail != null) { detail.CheckContent = projectCheckItemDetail.CheckContent; } } detail.Unqualified = "隐患"; detail.Suggestions = "整改"; detail.CompleteStatus = true; BLL.Check_CheckSpecialDetailService.AddCheckSpecialDetail(detail); } } else if (!string.IsNullOrEmpty(Request.Params["CheckColligationId"])) { foreach (var item in list) { Model.Check_CheckColligationDetail detail = new Model.Check_CheckColligationDetail { CheckColligationDetailId = SQLHelper.GetNewID(typeof(Model.Check_CheckColligationDetail)), CheckColligationId = Request.Params["CheckColligationId"], CheckItem = item }; Model.Check_ProjectCheckItemSet checkItemSet = BLL.Check_ProjectCheckItemSetService.GetCheckItemSetById(item); if (checkItemSet != null) { detail.CheckContent = checkItemSet.CheckItemName; } else { var projectCheckItemDetail = BLL.Check_ProjectCheckItemDetailService.GetCheckItemDetailById(item); if (projectCheckItemDetail != null) { detail.CheckContent = projectCheckItemDetail.CheckContent; } } detail.Unqualified = "隐患"; detail.Suggestions = "整改"; detail.CompleteStatus = true; BLL.Check_CheckColligationDetailService.AddCheckColligationDetail(detail); } } else if (!string.IsNullOrEmpty(Request.Params["CheckWorkId"])) { foreach (var item in list) { Model.Check_CheckWorkDetail detail = new Model.Check_CheckWorkDetail { CheckWorkDetailId = SQLHelper.GetNewID(typeof(Model.Check_CheckWorkDetail)), CheckWorkId = Request.Params["CheckWorkId"], CheckItem = item }; var checkItemSet = BLL.Check_ProjectCheckItemSetService.GetCheckItemSetById(item); if (checkItemSet != null) { detail.CheckContent = checkItemSet.CheckItemName; } else { var projectCheckItemDetail = BLL.Check_ProjectCheckItemDetailService.GetCheckItemDetailById(item); if (projectCheckItemDetail != null) { detail.CheckContent = projectCheckItemDetail.CheckContent; } } detail.CheckResult = "合格"; detail.CheckOpinion = "整改"; BLL.Check_CheckWorkDetailService.AddCheckWorkDetail(detail); } } else if (!string.IsNullOrEmpty(Request.Params["CheckHolidayId"])) { foreach (var item in list) { Model.Check_CheckHolidayDetail detail = new Model.Check_CheckHolidayDetail { CheckHolidayDetailId = SQLHelper.GetNewID(typeof(Model.Check_CheckHolidayDetail)), CheckHolidayId = Request.Params["CheckHolidayId"], CheckItem = item }; Model.Check_ProjectCheckItemSet checkItemSet = BLL.Check_ProjectCheckItemSetService.GetCheckItemSetById(item); if (checkItemSet != null) { detail.CheckContent = checkItemSet.CheckItemName; } detail.CheckResult = "合格"; detail.CheckOpinion = "整改"; BLL.Check_CheckHolidayDetailService.AddCheckHolidayDetail(detail); } } PageContext.RegisterStartupScript(ActiveWindow.GetHidePostBackReference()); }
/// <summary> /// 将Dataset的数据导入数据库 /// </summary> /// <param name="pds">数据集</param> /// <param name="Cols">数据集行数</param> /// <returns></returns> private bool AddDatasetToSQL(DataTable pds) { string results = string.Empty; int ir = pds.Rows.Count; if (pds != null && ir > 0) { var getCheckHoliday = BLL.Check_CheckHolidayService.GetCheckHolidayByCheckHolidayId(this.CheckHolidayId); if (getCheckHoliday != null) { var units = from x in Funs.DB.Base_Unit select x; var sysConsts = from x in Funs.DB.Sys_Const where x.GroupId == BLL.ConstValue.Group_HandleStep select x; var supCheckSets = from x in Funs.DB.Check_ProjectCheckItemSet where x.ProjectId == this.CurrUser.LoginProjectId && x.SupCheckItem == "0" && x.CheckType == "5" select x; for (int i = 0; i < ir; i++) { string result = string.Empty; string col0 = pds.Rows[i][0].ToString().Trim(); string col1 = pds.Rows[i][1].ToString().Trim(); string col2 = pds.Rows[i][2].ToString().Trim(); string col3 = pds.Rows[i][3].ToString().Trim(); string col4 = pds.Rows[i][4].ToString().Trim(); string col5 = pds.Rows[i][5].ToString().Trim(); if (!string.IsNullOrEmpty(col0) || !string.IsNullOrEmpty(col1)) { Model.View_Check_CheckHolidayDetail newViewDetail = new Model.View_Check_CheckHolidayDetail { CheckHolidayDetailId = SQLHelper.GetNewID(typeof(Model.View_EduTrain_TrainRecordDetail)), CheckHolidayId = getCheckHoliday.CheckHolidayId, CheckContent = col1, CheckResult = col2, CheckOpinion = col3, HandleResult = col4, CheckStation = col5, }; var checkName = supCheckSets.FirstOrDefault(x => x.CheckItemName == col0); if (checkName != null) { newViewDetail.CheckItem = checkName.CheckItemSetId; newViewDetail.CheckItemStr = checkName.CheckItemName; } else { result += "第" + (i + 2).ToString() + "行," + "项目检查项中不存在!" + "|"; } ///判断是否已存在 var addItem = Funs.DB.Check_CheckHolidayDetail.FirstOrDefault(x => x.CheckHolidayId == newViewDetail.CheckHolidayId && x.CheckContent == newViewDetail.CheckContent && x.CheckItem == newViewDetail.CheckItem); if (addItem == null) { if (string.IsNullOrEmpty(result)) { Model.Check_CheckHolidayDetail newDetail = new Model.Check_CheckHolidayDetail { CheckHolidayDetailId = newViewDetail.CheckHolidayDetailId, CheckHolidayId = newViewDetail.CheckHolidayId, CheckItem = newViewDetail.CheckItem, CheckContent = newViewDetail.CheckContent, CheckResult = newViewDetail.CheckResult, CheckOpinion = newViewDetail.CheckOpinion, CheckStation = newViewDetail.CheckStation, HandleResult = newViewDetail.HandleResult, }; BLL.Check_CheckHolidayDetailService.AddCheckHolidayDetail(newDetail); ///加入 viewDetails.Add(newViewDetail); } } else { result += "第" + (i + 2).ToString() + "行," + "导入数据重复" + "|"; } if (!string.IsNullOrEmpty(result)) { results += result; } } } if (viewDetails.Count > 0) { viewDetails = viewDetails.Distinct().ToList(); this.Grid1.Hidden = false; this.Grid1.DataSource = viewDetails; this.Grid1.DataBind(); } if (!string.IsNullOrEmpty(results)) { viewDetails.Clear(); results = "数据导入完成,未成功数据:" + results.Substring(0, results.LastIndexOf("|")); errorInfos = results; Alert alert = new Alert { Message = results, Target = Target.Self }; alert.Show(); } else { errorInfos = string.Empty; ShowNotify("导入成功!", MessageBoxIcon.Success); PageContext.RegisterStartupScript(ActiveWindow.GetHidePostBackReference()); } } else { Alert.ShowInTop("培训数据为空!", MessageBoxIcon.Warning); } } else { Alert.ShowInTop("导入数据为空!", MessageBoxIcon.Warning); } BLL.UploadFileService.DeleteFile(Funs.RootPath, initPath + this.hdFileName.Text); return(true); }