/// <summary> /// 根据主键删除违规人员记录 /// </summary> /// <param name="violationPersonId"></param> public static void DeleteViolationPersonById(string violationPersonId) { Model.SUBHSSEDB db = Funs.DB; Model.Check_ViolationPerson violationPerson = db.Check_ViolationPerson.FirstOrDefault(e => e.ViolationPersonId == violationPersonId); if (violationPerson != null) { CodeRecordsService.DeleteCodeRecordsByDataId(violationPersonId); CommonService.DeleteFlowOperateByID(violationPersonId); db.Check_ViolationPerson.DeleteOnSubmit(violationPerson); db.SubmitChanges(); } }
/// <summary> /// 修改违规人员记录 /// </summary> /// <param name="violationPerson"></param> public static void UpdateViolationPerson(Model.Check_ViolationPerson violationPerson) { Model.SUBHSSEDB db = Funs.DB; Model.Check_ViolationPerson newViolationPerson = db.Check_ViolationPerson.FirstOrDefault(e => e.ViolationPersonId == violationPerson.ViolationPersonId); if (newViolationPerson != null) { //newViolationPerson.ProjectId = violationPerson.ProjectId; newViolationPerson.ViolationPersonCode = violationPerson.ViolationPersonCode; newViolationPerson.UnitId = violationPerson.UnitId; newViolationPerson.PersonId = violationPerson.PersonId; newViolationPerson.WorkPostId = violationPerson.WorkPostId; newViolationPerson.ViolationDate = violationPerson.ViolationDate; newViolationPerson.ViolationName = violationPerson.ViolationName; newViolationPerson.ViolationType = violationPerson.ViolationType; newViolationPerson.CompileMan = violationPerson.CompileMan; newViolationPerson.ViolationDate = violationPerson.ViolationDate; newViolationPerson.States = violationPerson.States; newViolationPerson.HandleStep = violationPerson.HandleStep; newViolationPerson.ViolationDef = violationPerson.ViolationDef; db.SubmitChanges(); } }
/// <summary> /// 添加违规人员记录 /// </summary> /// <param name="violationPerson"></param> public static void AddViolationPerson(Model.Check_ViolationPerson violationPerson) { Model.SUBHSSEDB db = Funs.DB; Model.Check_ViolationPerson newViolationPerson = new Model.Check_ViolationPerson { ViolationPersonId = violationPerson.ViolationPersonId, ProjectId = violationPerson.ProjectId, ViolationPersonCode = violationPerson.ViolationPersonCode, UnitId = violationPerson.UnitId, PersonId = violationPerson.PersonId, WorkPostId = violationPerson.WorkPostId, ViolationDate = violationPerson.ViolationDate, ViolationName = violationPerson.ViolationName, ViolationType = violationPerson.ViolationType, CompileMan = violationPerson.CompileMan }; newViolationPerson.ViolationDate = violationPerson.ViolationDate; newViolationPerson.States = violationPerson.States; newViolationPerson.HandleStep = violationPerson.HandleStep; newViolationPerson.ViolationDef = violationPerson.ViolationDef; db.Check_ViolationPerson.InsertOnSubmit(newViolationPerson); db.SubmitChanges(); CodeRecordsService.InsertCodeRecordsByMenuIdProjectIdUnitId(Const.ProjectViolationPersonMenuId, violationPerson.ProjectId, null, violationPerson.ViolationPersonId, violationPerson.CompileDate); }
/// <summary> /// 加载页面 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { this.ProjectId = this.CurrUser.LoginProjectId; this.btnClose.OnClientClick = ActiveWindow.GetHideReference(); this.BindGrid(string.Empty); this.InitDropDownList(); this.ViolationPersonId = Request.Params["ViolationPersonId"]; if (!string.IsNullOrEmpty(this.ViolationPersonId)) { Model.Check_ViolationPerson violationPerson = BLL.ViolationPersonService.GetViolationPersonById(this.ViolationPersonId); if (violationPerson != null) { this.ProjectId = violationPerson.ProjectId; if (violationPerson != null) { this.txtViolationPersonCode.Text = CodeRecordsService.ReturnCodeByDataId(this.ViolationPersonId); } if (!string.IsNullOrEmpty(violationPerson.PersonId)) { BindGrid(violationPerson.PersonId); this.drpPersonId.Value = violationPerson.PersonId; } if (!string.IsNullOrEmpty(violationPerson.UnitId)) { this.hdUnitId.Text = violationPerson.UnitId; if (!string.IsNullOrEmpty(this.hdUnitId.Text)) { var unit = BLL.UnitService.GetUnitByUnitId(this.hdUnitId.Text.Trim()); if (unit != null) { this.txtUnitName.Text = unit.UnitName; } } } if (!string.IsNullOrEmpty(violationPerson.WorkPostId)) { this.hdWorkPostId.Text = violationPerson.WorkPostId; if (!string.IsNullOrEmpty(this.hdWorkPostId.Text)) { var workPost = BLL.WorkPostService.GetWorkPostById(this.hdWorkPostId.Text); if (workPost != null) { this.txtWorkPostName.Text = workPost.WorkPostName; } } } if (violationPerson.ViolationDate != null) { this.txtViolationDate.Text = string.Format("{0:yyyy-MM-dd}", violationPerson.ViolationDate); } if (!string.IsNullOrEmpty(violationPerson.ViolationName)) { this.drpViolationName.SelectedValue = violationPerson.ViolationName; if (violationPerson.ViolationName == "1") { BLL.ConstValue.InitConstValueDropDownList(this.drpViolationType, ConstValue.Group_ViolationType, true); } else if (violationPerson.ViolationName == "2") { BLL.ConstValue.InitConstValueDropDownList(this.drpViolationType, ConstValue.Group_ViolationTypeOther, true); } } if (!string.IsNullOrEmpty(violationPerson.ViolationType)) { this.drpViolationType.SelectedValue = violationPerson.ViolationType.Trim(); } if (!string.IsNullOrEmpty(violationPerson.HandleStep)) { this.drpHandleStep.SelectedValue = violationPerson.HandleStep; } this.txtViolationDef.Text = violationPerson.ViolationDef; } } else { this.txtViolationDate.Text = string.Format("{0:yyyy-MM-dd}", DateTime.Now); ////自动生成编码 this.txtViolationPersonCode.Text = BLL.CodeRecordsService.ReturnCodeByMenuIdProjectId(BLL.Const.ProjectViolationPersonMenuId, this.ProjectId, this.CurrUser.UnitId); } ///初始化审核菜单 this.ctlAuditFlow.MenuId = BLL.Const.ProjectViolationPersonMenuId; this.ctlAuditFlow.DataId = this.ViolationPersonId; this.ctlAuditFlow.ProjectId = this.ProjectId; this.ctlAuditFlow.UnitId = this.CurrUser.UnitId; } }
/// <summary> /// 保存数据 /// </summary> /// <param name="p"></param> private void SaveData(string type) { Model.Check_ViolationPerson violationPerson = new Model.Check_ViolationPerson { ProjectId = this.ProjectId, ViolationPersonCode = this.txtViolationPersonCode.Text.Trim() }; if (!string.IsNullOrEmpty(this.drpPersonId.Value)) { violationPerson.PersonId = this.drpPersonId.Value; } if (!string.IsNullOrEmpty(this.hdUnitId.Text.Trim())) { violationPerson.UnitId = this.hdUnitId.Text.Trim(); } if (!string.IsNullOrEmpty(this.hdWorkPostId.Text.Trim())) { violationPerson.WorkPostId = this.hdWorkPostId.Text.Trim(); } violationPerson.ViolationDate = Funs.GetNewDateTime(this.txtViolationDate.Text.Trim()); if (this.drpViolationName.SelectedValue != BLL.Const._Null) { if (!string.IsNullOrEmpty(this.drpViolationName.SelectedValue)) { violationPerson.ViolationName = this.drpViolationName.SelectedValue.Trim(); } } if (this.drpViolationType.SelectedValue != BLL.Const._Null) { if (!string.IsNullOrEmpty(this.drpViolationType.SelectedValue)) { violationPerson.ViolationType = this.drpViolationType.SelectedValue.Trim(); } } if (this.drpHandleStep.SelectedValue != BLL.Const._Null) { if (!string.IsNullOrEmpty(this.drpHandleStep.SelectedValue)) { violationPerson.HandleStep = this.drpHandleStep.SelectedValue.Trim(); } } violationPerson.ViolationDef = this.txtViolationDef.Text.Trim(); violationPerson.CompileMan = this.CurrUser.UserId; violationPerson.CompileDate = DateTime.Now; violationPerson.States = BLL.Const.State_0; if (type == BLL.Const.BtnSubmit) { violationPerson.States = this.ctlAuditFlow.NextStep; } if (!string.IsNullOrEmpty(this.ViolationPersonId)) { violationPerson.ViolationPersonId = this.ViolationPersonId; BLL.ViolationPersonService.UpdateViolationPerson(violationPerson); BLL.LogService.AddSys_Log(this.CurrUser, violationPerson.ViolationPersonCode, violationPerson.ViolationPersonId, BLL.Const.ProjectViolationPersonMenuId, BLL.Const.BtnModify); } else { this.ViolationPersonId = SQLHelper.GetNewID(typeof(Model.Check_ViolationPerson)); violationPerson.ViolationPersonId = this.ViolationPersonId; BLL.ViolationPersonService.AddViolationPerson(violationPerson); BLL.LogService.AddSys_Log(this.CurrUser, violationPerson.ViolationPersonCode, violationPerson.ViolationPersonId, BLL.Const.ProjectViolationPersonMenuId, BLL.Const.BtnAdd); } ////保存流程审核数据 this.ctlAuditFlow.btnSaveData(this.ProjectId, BLL.Const.ProjectViolationPersonMenuId, this.ViolationPersonId, (type == BLL.Const.BtnSubmit ? true : false), violationPerson.ViolationPersonCode, "../Check/ViolationPersonView.aspx?ViolationPersonId={0}"); }
/// <summary> /// 加载页面 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { this.btnClose.OnClientClick = ActiveWindow.GetHideReference(); this.ViolationPersonId = Request.Params["ViolationPersonId"]; if (!string.IsNullOrEmpty(this.ViolationPersonId)) { Model.Check_ViolationPerson violationPerson = BLL.ViolationPersonService.GetViolationPersonById(this.ViolationPersonId); if (violationPerson != null) { this.txtViolationPersonCode.Text = CodeRecordsService.ReturnCodeByDataId(this.ViolationPersonId); } if (!string.IsNullOrEmpty(violationPerson.PersonId)) { var person = BLL.PersonService.GetPersonById(violationPerson.PersonId); if (person != null) { this.txtPersonName.Text = person.PersonName; var workPost = BLL.WorkPostService.GetWorkPostById(person.WorkPostId); if (workPost != null) { this.txtWorkPostName.Text = workPost.WorkPostName; } } } if (!string.IsNullOrEmpty(violationPerson.UnitId)) { var unit = BLL.UnitService.GetUnitByUnitId(violationPerson.UnitId); if (unit != null) { this.txtUnitName.Text = unit.UnitName; } } if (violationPerson.ViolationDate != null) { this.txtViolationDate.Text = string.Format("{0:yyyy-MM-dd}", violationPerson.ViolationDate); } if (!string.IsNullOrEmpty(violationPerson.ViolationName)) { var c = BLL.ConstValue.GetConstByConstValueAndGroupId(violationPerson.ViolationName, BLL.ConstValue.Group_ViolationName); if (c != null) { this.txtViolationName.Text = c.ConstText; } } if (!string.IsNullOrEmpty(violationPerson.ViolationType)) { var v = BLL.ConstValue.GetConstByConstValueAndGroupId(violationPerson.ViolationType, BLL.ConstValue.Group_ViolationType); var v2 = BLL.ConstValue.GetConstByConstValueAndGroupId(violationPerson.ViolationType, BLL.ConstValue.Group_ViolationTypeOther); if (v != null) { this.txtViolationType.Text = v.ConstText; } if (v2 != null) { this.txtViolationType.Text = v2.ConstText; } } if (!string.IsNullOrEmpty(violationPerson.HandleStep)) { var v = BLL.ConstValue.GetConstByConstValueAndGroupId(violationPerson.HandleStep, BLL.ConstValue.Group_ViolationPersonHandleStep); if (v != null) { this.txtHandleStep.Text = v.ConstText; } } this.txtViolationDef.Text = violationPerson.ViolationDef; } ///初始化审核菜单 this.ctlAuditFlow.MenuId = BLL.Const.ProjectViolationPersonMenuId; this.ctlAuditFlow.DataId = this.ViolationPersonId; } }