/// <summary> /// 加载总功能信息 /// </summary> private void LoadPermissionsTatal() { PermissionstatalEO ptEO = new PermissionstatalEO(); ptEO = ptManage.GetPermissionsTatalByPK(Request.QueryString["Ptid"]); if (!string.IsNullOrEmpty(ptEO.PtName)) { this.txtPtName.Text = ptEO.PtName; this.hfPtName.Value = ptEO.PtName; this.ddlPf.SelectedValue = ptEO.PfId; this.rblState.SelectedValue = ptEO.PtState; } }
/// <summary> /// 更新数据 /// </summary> /// <param name = "item">要更新的实体对象</param> /// <param name="tm">事务管理对象</param> /// <return>受影响的行数</return> public virtual int UpdatePermissionsTatal(PermissionstatalEO item, TransactionManager tm = null) { const string sql = @"UPDATE permissionstatal SET Pt_name=@Pt_name, Pf_id=@Pf_id, Pt_addUser=@Pt_addUser, Pt_addTime=@Pt_addTime, Pt_state=@Pt_state, Pt_del=@Pt_del, Pt_text1=@Pt_text1, Pt_text2=@Pt_text2 WHERE Pt_id=@Pt_id"; return(Database.CreateSqlDao(sql) .AddInParameter("@Pt_id", item.PtId, DbType.String, 50) .AddInParameter("@Pt_name", item.PtName, DbType.String, 50) .AddInParameter("@Pf_id", item.PfId, DbType.String, 50) .AddInParameter("@Pt_addUser", item.PtAddUser, DbType.String, 50) .AddInParameter("@Pt_addTime", item.PtAddTime, DbType.DateTime, 8) .AddInParameter("@Pt_state", item.PtState, DbType.AnsiStringFixedLength, 1) .AddInParameter("@Pt_del", item.PtDel, DbType.AnsiStringFixedLength, 1) .AddInParameter("@Pt_text1", item.PtText1 != null ? (object)item.PtText1 : DBNull.Value, DbType.String, 200) .AddInParameter("@Pt_text2", item.PtText2 != null ? (object)item.PtText2 : DBNull.Value, DbType.String, 200) .ExecNonQuery(tm)); }
/// <summary> /// 修改总功能信息 /// </summary> /// <param name="item"></param> /// <returns></returns> public int EditPermissionsTatal(PermissionstatalEO item) { return(ptMO.UpdatePermissionsTatal(item)); }
/// <summary> /// 创建总功能信息 /// </summary> /// <param name="item"></param> /// <returns></returns> public int AddPermissionsTatal(PermissionstatalEO item) { return(ptMO.Add(item)); }
/// <summary> /// 维护信息 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnOK_Click(object sender, EventArgs e) { if (this.CheckForms() == false) { CloseDivImplementation(); return; } PermissionstatalEO ptEO = new PermissionstatalEO(); //总功能 PermissionstatalpEO ptpEO = new PermissionstatalpEO(); //总功能关系 if (Request.QueryString["State"] == "U") { ptEO = ptManage.GetPermissionsTatalByPK(Request.QueryString["Ptid"]); } //总功能数据 ptEO.PtName = this.txtPtName.Text.Trim(); ptEO.PfId = this.ddlPf.SelectedValue; ptEO.PtState = this.rblState.SelectedValue; //创建总功能信息 if (Request.QueryString["State"] == "A") { //判断总功能名称是否存在 if (this.ChecPtName() == false) { //Jswork.Alert("总功能名称 " + this.txtPtName.Text.Trim() + " 已存在", this.Page); this.divAlert.Visible = true; this.lblAlert.Text = this.ddlPf.SelectedItem.Text + Resources.Resource.Name_of_total_function_in + this.txtPtName.Text.Trim() + Resources.Resource.Already_exist; CloseDivImplementation(); return; } //总功能数据 ptEO.PtId = GetBigGuid(); ptEO.PtDel = "0"; ptEO.PtAddUser = GetUserID(); ptEO.PtAddTime = DateTime.Now; //总功能关系数据 for (int i = 0; i < this.cblPermissions.Items.Count; i++) { if (this.cblPermissions.Items[i].Selected) { ptpEO.PtId = ptEO.PtId; ptpEO.PmId = this.cblPermissions.Items[i].Value; ptpEO.PpUser = GetUserID(); ptpEO.PpAddTime = DateTime.Now; ptpManage.AddPermissionsTatalP(ptpEO); } } if (ptManage.AddPermissionsTatal(ptEO) > 0) { //插入操作日志 InsertLog(Resources.Resource.Create_general_function_information, string.Format("permissionstatalname:{0},id:{1}", ptEO.PtName, ptEO.PtId), 7, GetPlatformIdByValue(1)); CloseDivImplementation(); Jswork.Alert(Resources.Resource.Total_function_information_creation_success, "PermissionsTatalList.aspx"); } else { //Jswork.Alert("总功能信息创建失败", this.Page); this.divAlert.Visible = true; this.lblAlert.Text = Resources.Resource.Total_function_information_creation_failed;//"总功能信息创建失败"; } } //修改总功能信息 if (Request.QueryString["State"] == "U") { //修改时判断总功能名称是否存在 if (this.hfPtName.Value != this.txtPtName.Text.Trim()) { //判断平台名称是否存在 if (this.ChecPtName() == false) { //Jswork.Alert("总功能名称 " + this.txtPtName.Text.Trim() + " 已存在", this.Page); this.divAlert.Visible = true; this.lblAlert.Text = this.ddlPf.SelectedItem.Text + Resources.Resource.Name_of_total_function_in + this.txtPtName.Text.Trim() + Resources.Resource.Already_exist; CloseDivImplementation(); return; } } //总功能关系数据 ptpManage.RemoveByPK(Request.QueryString["Ptid"]); //插入关系表数据前先删除数据 for (int i = 0; i < this.cblPermissions.Items.Count; i++) { if (this.cblPermissions.Items[i].Selected) { ptpEO.PtId = Request.QueryString["Ptid"]; ptpEO.PmId = this.cblPermissions.Items[i].Value; ptpEO.PpUser = GetUserID(); ptpEO.PpAddTime = DateTime.Now; ptpManage.AddPermissionsTatalP(ptpEO); } } if (ptManage.EditPermissionsTatal(ptEO) > 0) { //插入操作日志 InsertLog(Resources.Resource.Modify_general_function_information, string.Format("permissionstatalname:{0},id:{1}", ptEO.PtName, ptEO.PtId), 8, GetPlatformIdByValue(1)); CloseDivImplementation(); Jswork.Alert(Resources.Resource.The_success_of_total_functional_information_modification, "PermissionsTatalList.aspx"); } else { //Jswork.Alert("总功能信息修改失败", this.Page); this.divAlert.Visible = true; this.lblAlert.Text = Resources.Resource.Failure_of_total_functional_information_modification; } } CloseDivImplementation(); }