/// <summary> /// 添加安全日常巡检 /// </summary> /// <param name="checkDay"></param> public static void AddCheckDay(Model.Check_CheckDayXA checkDay) { Model.SUBHSSEDB db = Funs.DB; Model.Check_CheckDayXA newCheckDay = new Model.Check_CheckDayXA { CheckDayId = checkDay.CheckDayId, CheckDayCode = checkDay.CheckDayCode, ProjectId = checkDay.ProjectId, NotOKNum = checkDay.NotOKNum, DutyUnitIds = checkDay.DutyUnitIds, DutyTeamGroupIds = checkDay.DutyTeamGroupIds, WorkAreaIds = checkDay.WorkAreaIds, Unqualified = checkDay.Unqualified, CompileMan = checkDay.CompileMan, CompileUnit = checkDay.CompileUnit, CheckDate = checkDay.CheckDate, HandleStation = checkDay.HandleStation, IsOK = checkDay.IsOK, States = checkDay.States }; db.Check_CheckDayXA.InsertOnSubmit(newCheckDay); db.SubmitChanges(); ////增加一条编码记录 BLL.CodeRecordsService.InsertCodeRecordsByMenuIdProjectIdUnitId(BLL.Const.ProjectCheckDayXAMenuId, checkDay.ProjectId, null, checkDay.CheckDayId, checkDay.CheckDate); }
/// <summary> /// 保存按钮 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSave_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(this.rblIsOK.SelectedValue)) { ShowNotify("请选择是否闭环!", MessageBoxIcon.Warning); return; } Model.Check_CheckDayXA checkDay = BLL.Check_CheckDayXAService.GetCheckDayByCheckDayId(this.CheckDayId); if (checkDay != null) { checkDay.HandleStation = this.txtHandleStation.Text.Trim(); checkDay.IsOK = Convert.ToBoolean(this.rblIsOK.SelectedValue); BLL.Check_CheckDayXAService.UpdateCheckDay(checkDay); } PageContext.RegisterStartupScript(ActiveWindow.GetHidePostBackReference()); }
/// <summary> /// 修改安全日常巡检 /// </summary> /// <param name="checkDay"></param> public static void UpdateCheckDay(Model.Check_CheckDayXA checkDay) { Model.SUBHSSEDB db = Funs.DB; Model.Check_CheckDayXA newCheckDay = db.Check_CheckDayXA.FirstOrDefault(e => e.CheckDayId == checkDay.CheckDayId); if (newCheckDay != null) { newCheckDay.CheckDayCode = checkDay.CheckDayCode; newCheckDay.NotOKNum = checkDay.NotOKNum; newCheckDay.DutyUnitIds = checkDay.DutyUnitIds; newCheckDay.DutyTeamGroupIds = checkDay.DutyTeamGroupIds; newCheckDay.WorkAreaIds = checkDay.WorkAreaIds; newCheckDay.Unqualified = checkDay.Unqualified; newCheckDay.CheckDate = checkDay.CheckDate; newCheckDay.HandleStation = checkDay.HandleStation; newCheckDay.IsOK = checkDay.IsOK; newCheckDay.States = checkDay.States; db.SubmitChanges(); } }
/// <summary> /// 获取受检单位/班组 /// </summary> /// <param name="WorkStage"></param> /// <returns></returns> protected string ConvertUnitOrTeamGroup(object CheckDayId) { string name = string.Empty; if (CheckDayId != null) { Model.Check_CheckDayXA checkDay = BLL.Check_CheckDayXAService.GetCheckDayByCheckDayId(CheckDayId.ToString()); if (checkDay != null) { if (!string.IsNullOrEmpty(checkDay.DutyUnitIds)) { string[] unitIds = checkDay.DutyUnitIds.Split(','); foreach (var item in unitIds) { Model.Base_Unit unit = BLL.UnitService.GetUnitByUnitId(item); name += unit.UnitName + ","; } if (!string.IsNullOrEmpty(name)) { name = name.Substring(0, name.LastIndexOf(",")); } } if (!string.IsNullOrEmpty(checkDay.DutyTeamGroupIds)) { string[] teamGroupIds = checkDay.DutyTeamGroupIds.Split(','); foreach (var item in teamGroupIds) { Model.ProjectData_TeamGroup unit = BLL.TeamGroupService.GetTeamGroupById(item); name += unit.TeamGroupName + ","; } if (!string.IsNullOrEmpty(name)) { name = name.Substring(0, name.LastIndexOf(",")); } } } } return(name); }
/// <summary> /// 保存数据 /// </summary> /// <param name="type"></param> private void SaveData(string type) { Model.Check_CheckDayXA checkDay = new Model.Check_CheckDayXA { CheckDayCode = this.txtCheckDayCode.Text.Trim(), ProjectId = this.ProjectId, NotOKNum = Funs.GetNewIntOrZero(this.txtNotOKNum.Text.Trim()), CheckDate = Funs.GetNewDateTimeOrNow(this.txtCheckDate.Text.Trim()) }; if (this.trUnit.Hidden == false) { //受检单位 string unitIds = string.Empty; foreach (var item in this.drpDutyUnitIds.SelectedValueArray) { unitIds += item + ","; } if (!string.IsNullOrEmpty(unitIds)) { unitIds = unitIds.Substring(0, unitIds.LastIndexOf(",")); } checkDay.DutyUnitIds = unitIds; } if (this.trTeamGroup.Hidden == false) { //受检班组 string teamGroupIds = string.Empty; foreach (var item in this.drpDutyTeamGroupIds.SelectedValueArray) { teamGroupIds += item + ","; } if (!string.IsNullOrEmpty(teamGroupIds)) { teamGroupIds = teamGroupIds.Substring(0, teamGroupIds.LastIndexOf(",")); } checkDay.DutyTeamGroupIds = teamGroupIds; } //检查区域 string workAreaIds = string.Empty; foreach (var item in this.drpWorkAreaIds.SelectedValueArray) { workAreaIds += item + ","; } if (!string.IsNullOrEmpty(workAreaIds)) { workAreaIds = workAreaIds.Substring(0, workAreaIds.LastIndexOf(",")); } checkDay.WorkAreaIds = workAreaIds; checkDay.Unqualified = this.txtUnqualified.Text.Trim(); if (this.drpCheckMan.SelectedValue != BLL.Const._Null) { checkDay.CompileMan = this.drpCheckMan.SelectedValue; } else { checkDay.CompileMan = this.CurrUser.UserId; } ////单据状态 //checkDay.States = BLL.Const.State_0; //if (type == BLL.Const.BtnSubmit) //{ // checkDay.States = this.ctlAuditFlow.NextStep; //} if (!string.IsNullOrEmpty(this.CheckDayId)) { checkDay.CheckDayId = this.CheckDayId; BLL.Check_CheckDayXAService.UpdateCheckDay(checkDay); BLL.LogService.AddSys_Log(this.CurrUser, checkDay.CheckDayCode, checkDay.CheckDayId, BLL.Const.ProjectCheckDayXAMenuId, BLL.Const.BtnModify); } else { checkDay.CheckDayId = SQLHelper.GetNewID(typeof(Model.Check_CheckDayXA)); this.CheckDayId = checkDay.CheckDayId; checkDay.CompileUnit = this.CurrUser.UnitId; BLL.Check_CheckDayXAService.AddCheckDay(checkDay); BLL.LogService.AddSys_Log(this.CurrUser, checkDay.CheckDayCode, checkDay.CheckDayId, BLL.Const.ProjectCheckDayXAMenuId, BLL.Const.BtnAdd); } }
/// <summary> /// 绑定数据 /// </summary> private void BindGrid() { string strSql = @"SELECT CheckDay.CheckDayId,CheckDay.ProjectId,CodeRecords.Code AS CheckDayCode,CheckDay.WorkAreaIds,CheckDay.CheckDate,CheckDay.CompileUnit,Users.UserName as CheckPersonName,CheckDay.NotOKNum,CheckDay.Unqualified,CheckDay.HandleStation" + @" ,(CASE WHEN CheckDay.States = " + BLL.Const.State_0 + " OR CheckDay.States IS NULL THEN '待['+OperateUser.UserName+']提交' WHEN CheckDay.States = " + BLL.Const.State_2 + " THEN '审核/审批完成' ELSE '待['+OperateUser.UserName+']办理' END) AS FlowOperateName" + @" FROM Check_CheckDayXA AS CheckDay " + @" LEFT JOIN Sys_FlowOperate AS FlowOperate ON CheckDay.CheckDayId=FlowOperate.DataId AND FlowOperate.IsClosed <> 1" + @" LEFT JOIN Sys_User AS OperateUser ON FlowOperate.OperaterId=OperateUser.UserId " + @" LEFT JOIN Sys_User AS Users ON CheckDay.CompileMan=Users.UserId " + @" LEFT JOIN Sys_CodeRecords AS CodeRecords ON CheckDay.CheckDayId=CodeRecords.DataId WHERE 1=1 "; List <SqlParameter> listStr = new List <SqlParameter>(); strSql += " AND CheckDay.ProjectId = @ProjectId"; listStr.Add(new SqlParameter("@ProjectId", this.ProjectId)); if (!string.IsNullOrEmpty(this.txtCheckDayCode.Text.Trim())) { strSql += " AND CheckDayCode LIKE @CheckDayCode"; listStr.Add(new SqlParameter("@CheckDayCode", "%" + this.txtCheckDayCode.Text.Trim() + "%")); } if (BLL.ProjectUnitService.GetProjectUnitTypeByProjectIdUnitId(this.ProjectId, this.CurrUser.UnitId)) { strSql += " AND CheckDay.CompileUnit = @UnitId"; ///状态为已完成 listStr.Add(new SqlParameter("@UnitId", this.CurrUser.UnitId)); } //if (!string.IsNullOrEmpty(this.txtUnitName.Text.Trim())) //{ // strSql += " AND Area LIKE @UnitName"; // listStr.Add(new SqlParameter("@UnitName", "%" + this.txtUnitName.Text.Trim() + "%")); //} //if (!string.IsNullOrEmpty(this.txtWorkAreaName.Text.Trim())) //{ // strSql += " AND Area LIKE @WorkAreaName"; // listStr.Add(new SqlParameter("@WorkAreaName", "%" + this.txtWorkAreaName.Text.Trim() + "%")); //} if (this.drpUnit.SelectedValue != BLL.Const._Null) { strSql += " AND CheckDay.CompileUnit = @UnitId2"; listStr.Add(new SqlParameter("@UnitId2", this.drpUnit.SelectedValue)); } SqlParameter[] parameter = listStr.ToArray(); DataTable tb = SQLHelper.GetDataTableRunText(strSql, parameter); // 2.获取当前分页数据 //var table = this.GetPagedDataTable(Grid1, tb1); Grid1.RecordCount = tb.Rows.Count; tb = GetFilteredTable(Grid1.FilteredData, tb); var table = this.GetPagedDataTable(Grid1, tb); Grid1.DataSource = table; Grid1.DataBind(); for (int i = 0; i < Grid1.Rows.Count; i++) { Model.Check_CheckDayXA checkHoliday = BLL.Check_CheckDayXAService.GetCheckDayByCheckDayId(this.Grid1.DataKeys[i][0].ToString()); if (checkHoliday != null) { if (checkHoliday.IsOK != true) { Grid1.Rows[i].RowCssClass = "yellow"; } } } }