/// <summary> /// 添加(管理组)角色分配 /// </summary> /// <returns></returns> public int Add() { MasterGroupDAL dal = new MasterGroupDAL(connectionString); _id = dal.Add(_masterid, _mastername, _groupid, _masterid2, _mastername2, _createdate); return(_id); }
private void LoadData() { MasterGroupDAL _dal = null; Hashtable _htParameters = null; try { _dal = new MasterGroupDAL(); _htParameters = new Hashtable(); _htParameters["p_usergroupid"] = Request.Params["id"]; DataTable _dt = _dal.GetRow(_htParameters); MPF23.Shared.Mapper.DBToUI.Map(pnlBody.Controls, _dt.Rows[0]); } catch (Exception ex) { Utility.ShowMessageBox(this, Utility.LOAD_DATA_FAIL_MESSAGE, ex, null); } }
private void BindGrid() { MasterGroupDAL _dal = null; Hashtable _htParameters = null; try { _dal = new MasterGroupDAL(); _htParameters = new Hashtable(); _htParameters["p_keywords"] = txtSearch.Text; gvwList.DataSource = _dal.GetRows(_htParameters); gvwList.DataBind(); } catch (Exception ex) { Utility.ShowMessageBox(this, Utility.LOAD_DATA_FAIL_MESSAGE, ex, null, null); } }
public static void BindDDLUsergroup(DropDownList ddl) { MasterGroupDAL _dalgroup = null; Hashtable _htParameter = null; try { _dalgroup = new MasterGroupDAL(); _htParameter = new Hashtable(); _htParameter["p_keywords"] = ""; ddl.DataSource = _dalgroup.GetRows(_htParameter); ddl.DataValueField = "USERGROUP"; ddl.DataTextField = "USERGROUPDESCNID"; ddl.DataBind(); } catch (Exception) { } }
private void SaveData() { MasterGroupDAL _dalGroup = null; MasterGroupRoleDAL _dalGroupRole = null; Hashtable _htParameters = null; int iNextID = 0; int iNextIDRole = 0; int flag = 1; try { _dalGroup = new MasterGroupDAL(); _htParameters = new Hashtable(); MPF23.Shared.Mapper.UIToDB.Map(pnlBody.Controls, _htParameters); Utility.ApplyDefaultProp(_htParameters); if (Request.Params["action"] == "add") { _dalGroup.Insert(_htParameters, ref iNextID); } else { //_htParameters["p_usergroupid"] = Request.Params["id"]; _dalGroup.Update(_htParameters); iNextID = Int32.Parse(lblUSERGROUPID.Text.ToString()); } //_dalJobAccess = new SysJobAccessDAL(); _htParameters.Clear(); _dalGroupRole = new MasterGroupRoleDAL(); _htParameters["p_group_code"] = txtUSERGROUP.Text; _dalGroupRole.DeleteByGroupCode(_htParameters); _htParameters.Clear(); #region checkboxChecking foreach (GridViewRow gvr in gvwList.Rows) { MPF23.Shared.Mapper.UIToDB.Map(gvr.Controls, _htParameters); _htParameters["p_module_id"] = gvwList.DataKeys[gvr.RowIndex][0]; _htParameters["p_group_code"] = txtUSERGROUP.Text; Utility.ApplyDefaultProp(_htParameters); if (((CheckBox)gvr.FindControl("chkAccess")).Checked) { _htParameters["p_action_code"] = "A"; _dalGroupRole.Insert(_htParameters, ref iNextIDRole); } if (((CheckBox)gvr.FindControl("chkNew")).Checked) { _htParameters["p_action_code"] = "N"; _dalGroupRole.Insert(_htParameters, ref iNextIDRole); } if (((CheckBox)gvr.FindControl("chkEdit")).Checked) { _htParameters["p_action_code"] = "E"; _dalGroupRole.Insert(_htParameters, ref iNextIDRole); } if (((CheckBox)gvr.FindControl("chkDelete")).Checked) { _htParameters["p_action_code"] = "D"; _dalGroupRole.Insert(_htParameters, ref iNextIDRole); } if (((CheckBox)gvr.FindControl("chkPrint")).Checked) { _htParameters["p_action_code"] = "P"; _dalGroupRole.Insert(_htParameters, ref iNextIDRole); } if (((CheckBox)gvr.FindControl("chkAppr")).Checked) { _htParameters["p_action_code"] = "R"; _dalGroupRole.Insert(_htParameters, ref iNextIDRole); } } #endregion Utility.ShowMessageBox(this, Utility.SAVE_DATA_SUCCESS_MESSAGE, null, "usergroupdetail.aspx?action=edt&id=" + iNextID.ToString()); } catch (Exception ex) { Utility.ShowMessageBox(this, Utility.SAVE_DATA_FAIL_MESSAGE, ex, null); } }