/// <summary> /// 根据主键删除安全措施 /// </summary> /// <param name="SafetyMeasuresId"></param> public static void DeleteSafetyMeasuresById(string SafetyMeasuresId) { Model.SUBHSSEDB db = Funs.DB; Model.Base_SafetyMeasures SafetyMeasures = db.Base_SafetyMeasures.FirstOrDefault(e => e.SafetyMeasuresId == SafetyMeasuresId); if (SafetyMeasures != null) { db.Base_SafetyMeasures.DeleteOnSubmit(SafetyMeasures); db.SubmitChanges(); } }
/// <summary> /// 修改安全措施 /// </summary> /// <param name="SafetyMeasures"></param> public static void UpdateSafetyMeasures(Model.Base_SafetyMeasures SafetyMeasures) { Model.SUBHSSEDB db = Funs.DB; Model.Base_SafetyMeasures newSafetyMeasures = db.Base_SafetyMeasures.FirstOrDefault(e => e.SafetyMeasuresId == SafetyMeasures.SafetyMeasuresId); if (newSafetyMeasures != null) { newSafetyMeasures.SortIndex = SafetyMeasures.SortIndex; newSafetyMeasures.SafetyMeasures = SafetyMeasures.SafetyMeasures; newSafetyMeasures.LicenseType = SafetyMeasures.LicenseType; db.SubmitChanges(); } }
/// <summary> /// 添加安全措施 /// </summary> /// <param name="SafetyMeasures"></param> public static void AddSafetyMeasures(Model.Base_SafetyMeasures SafetyMeasures) { Model.Base_SafetyMeasures newSafetyMeasures = new Model.Base_SafetyMeasures { SafetyMeasuresId = SafetyMeasures.SafetyMeasuresId, SortIndex = SafetyMeasures.SortIndex, SafetyMeasures = SafetyMeasures.SafetyMeasures, LicenseType = SafetyMeasures.LicenseType }; db.Base_SafetyMeasures.InsertOnSubmit(newSafetyMeasures); db.SubmitChanges(); }
/// <summary> /// 保存按钮 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSave_Click(object sender, EventArgs e) { if (this.drpLicenseType.SelectedValue == Const._Null) { Alert.ShowInParent("请作业许可证类型!", MessageBoxIcon.Warning); return; } if (BLL.SafetyMeasuresService.IsExistSafetyMeasures(this.SafetyMeasuresId, this.txtSafetyMeasures.Text.Trim())) { Alert.ShowInParent("安全措施名称已存在,请修改后再保存!", MessageBoxIcon.Warning); return; } Model.Base_SafetyMeasures newSafetyMeasures = new Model.Base_SafetyMeasures { SortIndex = Funs.GetNewInt(this.txtSortIndex.Text.Trim()), SafetyMeasures = this.txtSafetyMeasures.Text.Trim() }; if (this.drpLicenseType.SelectedValue != Const._Null) { newSafetyMeasures.LicenseType = this.drpLicenseType.SelectedValue; } if (string.IsNullOrEmpty(this.SafetyMeasuresId)) { newSafetyMeasures.SafetyMeasuresId = SQLHelper.GetNewID(typeof(Model.Base_SafetyMeasures)); BLL.SafetyMeasuresService.AddSafetyMeasures(newSafetyMeasures); BLL.LogService.AddSys_Log(this.CurrUser, newSafetyMeasures.SortIndex.ToString(), newSafetyMeasures.SafetyMeasuresId, BLL.Const.SafetyMeasuresMenuId, Const.BtnAdd); } else { newSafetyMeasures.SafetyMeasuresId = this.SafetyMeasuresId; BLL.SafetyMeasuresService.UpdateSafetyMeasures(newSafetyMeasures); BLL.LogService.AddSys_Log(this.CurrUser, newSafetyMeasures.SortIndex.ToString(), newSafetyMeasures.SafetyMeasuresId, BLL.Const.SafetyMeasuresMenuId, Const.BtnModify); } PageContext.RegisterStartupScript(ActiveWindow.GetHideRefreshReference()); }