/// <summary> /// 将记录集转为sys_ModuleExtPermissionTable实体类 /// </summary> /// <param name="dr">记录集</param> /// <returns>sys_ModuleExtPermissionTable</returns> protected object Populatesys_ModuleExtPermission(IDataReader dr) { sys_ModuleExtPermissionTable nc = new sys_ModuleExtPermissionTable(); if (!Convert.IsDBNull(dr["ExtPermissionID"])) nc.ExtPermissionID = Convert.ToInt32(dr["ExtPermissionID"]); // 扩展权限ID if (!Convert.IsDBNull(dr["ModuleID"])) nc.ModuleID = Convert.ToInt32(dr["ModuleID"]); // 模块ID if (!Convert.IsDBNull(dr["PermissionName"])) nc.PermissionName = Convert.ToString(dr["PermissionName"]).Trim(); // 权限名称 if (!Convert.IsDBNull(dr["PermissionValue"])) nc.PermissionValue = Convert.ToInt32(dr["PermissionValue"]); // 权限值 return nc; }
/// <summary> /// ����/ɾ��/�� sys_ModuleExtPermission /// </summary> /// <param name="fam">sys_ModuleExtPermissionTableʵ����</param> /// <returns>����0������</returns> public override int sys_ModuleExtPermissionInsertUpdate(sys_ModuleExtPermissionTable fam) { int rInt = 0; using (OracleConnection Conn = GetSqlConnection()) { string CommTxt; OracleCommand cmd = new OracleCommand(); cmd.Connection = Conn; if (fam.DB_Option_Action_ == "Insert") { CommTxt = "Insert into sys_ModuleExtPermission(ExtPermissionID,ModuleID,PermissionName,PermissionValue)VALUES(SEQ_sys_ModuleExtPermission_ID.NEXTVAL,:ModuleID,:PermissionName,:PermissionValue)"; cmd.CommandText = CommTxt; cmd.Parameters.Add("ModuleID", OracleType.Int32).Value = fam.ModuleID; //ģ��ID cmd.Parameters.Add("PermissionName", OracleType.NVarChar).Value = fam.PermissionName + ""; //Ȩ������ cmd.Parameters.Add("PermissionValue", OracleType.Int32).Value = fam.PermissionValue; //Ȩ��ֵ } else if (fam.DB_Option_Action_ == "Update") { CommTxt = "UPDATE sys_ModuleExtPermission SET ModuleID = :ModuleID,PermissionName = :PermissionName,PermissionValue = :PermissionValue WHERE (ExtPermissionID = :ExtPermissionID)"; cmd.CommandText = CommTxt; cmd.Parameters.Add("ModuleID", OracleType.Int32).Value = fam.ModuleID; //ģ��ID cmd.Parameters.Add("PermissionName", OracleType.NVarChar).Value = fam.PermissionName + ""; //Ȩ������ cmd.Parameters.Add("PermissionValue", OracleType.Int32).Value = fam.PermissionValue; //Ȩ��ֵ cmd.Parameters.Add("ExtPermissionID", OracleType.Int32).Value = fam.ExtPermissionID; } else if (fam.DB_Option_Action_ == "Delete") { CommTxt = "Delete from sys_ModuleExtPermission WHERE (ExtPermissionID = :ExtPermissionID)"; cmd.CommandText = CommTxt; cmd.Parameters.Add("ExtPermissionID", OracleType.Int32).Value = fam.ExtPermissionID; } else throw new ApplicationException("��ʶ��IJ�������!"); Conn.Open(); OracleTransaction Tran = Conn.BeginTransaction(); cmd.Transaction = Tran; try { rInt = cmd.ExecuteNonQuery(); cmd.Parameters.Clear(); if (fam.DB_Option_Action_ == "Insert") { cmd.CommandText = "select SEQ_sys_ModuleExtPermission_ID.CURRVAL from dual"; rInt = Convert.ToInt32(cmd.ExecuteScalar()); } Tran.Commit(); } catch (Exception ex) { Tran.Rollback(); throw new ApplicationException(ex.ToString()); } finally { Tran.Dispose(); cmd.Dispose(); Conn.Dispose(); Conn.Close(); } } return rInt; }
/// <summary> /// 新增/删除/修改 sys_ModuleExtPermission /// </summary> /// <param name="fam">sys_ModuleExtPermissionTable实体类</param> /// <returns>返回0操正常</returns> public abstract int sys_ModuleExtPermissionInsertUpdate(sys_ModuleExtPermissionTable fam);
protected void DeleteExtPermissionID(int extPermissionID) { if (!FrameWorkMenuTree.CheckModuleLastLevel(ModuleID)) return; sys_ModuleExtPermissionTable se = new sys_ModuleExtPermissionTable(); se.DB_Option_Action_ = "Delete"; se.ExtPermissionID = extPermissionID; BusinessFacade.sys_ModuleExtPermissionInsertUpdate(se); sys_ModuleExtPermission_Cache.ReLoadCache(); EventMessage.MessageBox(1, "操作成功", "删除扩展权限成功!", Icon_Type.OK, Common.GetHomeBaseUrl(string.Format("ModuleManager.aspx?cmd=ExtPermission&S_ID={0}&ModuleID={1}", S_ID, ModuleID))); }
/// <summary> /// 新增/删除/修改 sys_ModuleExtPermission /// </summary> /// <param name="fam">sys_ModuleExtPermissionTable实体类</param> /// <returns>返回0操正常</returns> public override int sys_ModuleExtPermissionInsertUpdate(sys_ModuleExtPermissionTable fam) { int rInt = 0; using (OleDbConnection Conn = GetSqlConnection()) { string CommTxt; OleDbCommand cmd = new OleDbCommand(); cmd.Connection = Conn; if (fam.DB_Option_Action_ == "Insert") { CommTxt = "Insert into sys_ModuleExtPermission(ModuleID,PermissionName,PermissionValue)VALUES(@ModuleID,@PermissionName,@PermissionValue)"; cmd.CommandText = CommTxt; cmd.Parameters.Add("@ModuleID", OleDbType.Integer).Value = fam.ModuleID; //模块ID cmd.Parameters.Add("@PermissionName", OleDbType.VarWChar).Value = fam.PermissionName + ""; //权限名称 cmd.Parameters.Add("@PermissionValue", OleDbType.Integer).Value = fam.PermissionValue; //权限值 } else if (fam.DB_Option_Action_ == "Update") { CommTxt = "UPDATE sys_ModuleExtPermission SET ModuleID = @ModuleID,PermissionName = @PermissionName,PermissionValue = @PermissionValue WHERE (ExtPermissionID = @ExtPermissionID)"; cmd.CommandText = CommTxt; cmd.Parameters.Add("@ModuleID", OleDbType.Integer).Value = fam.ModuleID; //模块ID cmd.Parameters.Add("@PermissionName", OleDbType.VarWChar).Value = fam.PermissionName + ""; //权限名称 cmd.Parameters.Add("@PermissionValue", OleDbType.Integer).Value = fam.PermissionValue; //权限值 cmd.Parameters.Add("@ExtPermissionID", OleDbType.Integer).Value = fam.ExtPermissionID; } else if (fam.DB_Option_Action_ == "Delete") { CommTxt = "Delete from sys_ModuleExtPermission WHERE (ExtPermissionID = @ExtPermissionID)"; cmd.CommandText = CommTxt; cmd.Parameters.Add("@ExtPermissionID", OleDbType.Integer).Value = fam.ExtPermissionID; } else throw new ApplicationException("无法识别的操作命令!"); Conn.Open(); rInt = cmd.ExecuteNonQuery(); if (fam.DB_Option_Action_ == "Insert") { cmd.CommandText = "SELECT @@identity"; rInt = Convert.ToInt32(cmd.ExecuteScalar()); } cmd.Dispose(); Conn.Dispose(); Conn.Close(); } return rInt; }
protected void Button3_Click(object sender, EventArgs e) { if (!FrameWorkMenuTree.CheckModuleLastLevel(ModuleID)) return; string PermissionName_Value = (string)Common.sink(PermissionName.UniqueID, MethodType.Post, 100, 1, DataType.Str); sys_ModuleExtPermissionTable st = new sys_ModuleExtPermissionTable(); st.DB_Option_Action_ = "Insert"; st.ModuleID = ModuleID; st.PermissionName = PermissionName_Value; st.PermissionValue = BusinessFacade.sys_ModuleExtPermissionGetLastPermissionValue(ModuleID); if (st.PermissionValue == 0) EventMessage.MessageBox(1, "操作失败", string.Format("增加自定义权限失败,权限值已经达到最大值,无法再增加!"), Icon_Type.Alert, Common.GetHomeBaseUrl(string.Format("ModuleManager.aspx?cmd=ExtPermission&S_ID={0}&ModuleID={1}", S_ID, ModuleID))); int returnint = BusinessFacade.sys_ModuleExtPermissionInsertUpdate(st); if (returnint < 0) { EventMessage.MessageBox(1, "操作失败", string.Format("增加自定义权限失败!"), Icon_Type.Error, Common.GetHomeBaseUrl(string.Format("ModuleManager.aspx?cmd=ExtPermission&S_ID={0}&ModuleID={1}", S_ID, ModuleID))); } sys_ModuleExtPermission_Cache.ReLoadCache(); TabOptionWebControls1.SelectIndex = 3; BindPermissionList(); }
/// <summary> /// 新增/删除/修改 sys_ModuleExtPermission /// </summary> /// <param name="fam">sys_ModuleExtPermissionTable实体类</param> /// <returns>返回0操正常</returns> public static int sys_ModuleExtPermissionInsertUpdate(sys_ModuleExtPermissionTable fam) { return DataProvider.Instance().sys_ModuleExtPermissionInsertUpdate(fam); }
/// <summary> /// 根据ID返回 sys_ModuleExtPermissionTable实体类 单笔资料 /// </summary> /// <param name="ExtPermissionID">扩展权限ID</param> /// <returns>返回sys_ModuleExtPermissionTable实体类 ExtPermissionID为0则无记录</returns> public static sys_ModuleExtPermissionTable sys_ModuleExtPermissionDisp(int ExtPermissionID) { sys_ModuleExtPermissionTable fam = new sys_ModuleExtPermissionTable(); QueryParam qp = new QueryParam(); qp.PageIndex = 1; qp.PageSize = 1; qp.Where = " Where sys_ModuleExtPermission.ExtPermissionID = " + ExtPermissionID; int RecordCount = 0; ArrayList lst = sys_ModuleExtPermissionList(qp, out RecordCount); if (RecordCount > 0) { fam = (sys_ModuleExtPermissionTable)lst[0]; } return fam; }
/// <summary> /// 新增/删除/修改 sys_ModuleExtPermission /// </summary> /// <param name="fam">sys_ModuleExtPermissionTable实体类</param> /// <returns>返回0操正常</returns> public override int sys_ModuleExtPermissionInsertUpdate(sys_ModuleExtPermissionTable fam) { int rInt = 0; using (SqlConnection Conn = GetSqlConnection()) { SqlCommand cmd = new SqlCommand("sys_ModuleExtPermissionInsertUpdateDelete", Conn); cmd.CommandType = CommandType.StoredProcedure; //设置参数 cmd.Parameters.Add("@DB_Option_Action_", SqlDbType.NVarChar).Value = fam.DB_Option_Action_; //操作方法 Insert:增加 Update:修改 Delete:删除 Disp:显示单笔记录 cmd.Parameters.Add("@ExtPermissionID", SqlDbType.Int).Value = fam.ExtPermissionID; //扩展权限ID cmd.Parameters.Add("@ModuleID", SqlDbType.Int).Value = fam.ModuleID; //模块ID cmd.Parameters.Add("@PermissionName", SqlDbType.NVarChar).Value = fam.PermissionName; //权限名称 cmd.Parameters.Add("@PermissionValue", SqlDbType.Int).Value = fam.PermissionValue; //权限值 Conn.Open(); rInt = Convert.ToInt32(cmd.ExecuteScalar()); cmd.Dispose(); Conn.Dispose(); Conn.Close(); } return rInt; }
/// <summary> /// 设置扩展模块缓存 /// </summary> /// <param name="sm"></param> static void set_ModuleExtCache(sys_ModuleExtPermissionTable sm) { sys_ModuleExtCache.Add(sm.ExtPermissionID, sm); if (sys_ModuleExtListCache.ContainsKey(sm.ModuleID)) { sys_ModuleExtListCache[sm.ModuleID].Add(sm); } else { List<sys_ModuleExtPermissionTable> lst = new List<sys_ModuleExtPermissionTable>(); lst.Add(sm); sys_ModuleExtListCache.Add(sm.ModuleID, lst); } }