private List <DefineOperRight> GetCompanyDefineOperRight(string companyID) { List <DefineOperRight> list = CompanyRightCached.getInstance().GetDefineOperRight(companyID); if (list == null) { try { string sqlText = "SP_GetDefineOperRight"; SqlParameter[] parms = new SqlParameter[] { new SqlParameter("CompanyID", companyID) }; using (DataSet ds = SQLHelper.ExecuteDataSet(SQLHelper.SchuleConnection, CommandType.StoredProcedure, sqlText, parms)) { if (ds.Tables.Count > 0) { list = ConvertHelper.GetList <DefineOperRight>(ds.Tables[0]); } } CompanyRightCached.getInstance().SetDefineOperRight(companyID, list); } catch { } finally { } } return(list); }
public Message EditCompanyOperRight(string CompanyID, string OperID, List <DefineRight> list) { Message m = new Message() { Result = true, TxtMessage = "操作成功。" }; string sqlText = string.Empty; try { sqlText = string.Format("delete from S_DefineOperRight where CompanyID='{0}' and OperID='{1}'" , CompanyID, OperID); SQLHelper.ExecuteScalar(SQLHelper.SchuleConnection, CommandType.Text, sqlText); foreach (DefineRight tmp in list) { sqlText = string.Format("Insert Into S_DefineOperRight" + "(CompanyID,RightCode,OperID)" + "values('{0}','{1}','{2}')" , tmp.CompanyID, tmp.RightCode, OperID); SQLHelper.ExecuteScalar(SQLHelper.SchuleConnection, CommandType.Text, sqlText); } //此处需要清理缓存 CompanyRightCached.getInstance().RemoveDefineOperRight(CompanyID); } catch (Exception e) { m = new Message() { Result = false, TxtMessage = "操作失败,【" + e.Message + "】" }; } return(m); }
public Message DelCompanyDefineRight(DefineRight dRight) { Message m = new Message() { Result = true, TxtMessage = "操作成功。" }; string sqlText = string.Empty; try { //sqlText = string.Format("select COUNT(1) from S_DefineOperRight where CompanyID='{0}' and RightCode='{1}' ", dRight.CompanyID, dRight.RightCode); //object count= SQLHelper.ExecuteScalar(SQLHelper.SchuleConnection, CommandType.Text, sqlText); //if (Convert.ToInt32(count) > 0) //{ // m = new Message() { Result = false, TxtMessage = "操作失败,【权限组使用当中无法删除!】" }; // return m; //} sqlText = string.Format("delete from S_DefineRightMenu where CompanyID='{0}' and RightCode='{1}' " + "delete from S_DefineRight where CompanyID='{0}' and RightCode='{1}' ", dRight.CompanyID, dRight.RightCode); SQLHelper.ExecuteScalar(SQLHelper.SchuleConnection, CommandType.Text, sqlText); //此处需要清理缓存 CompanyRightCached.getInstance().RemoveDefineOperRight(dRight.CompanyID); CompanyRightCached.getInstance().RemoveDefineRightMenu(dRight.CompanyID); CompanyRightCached.getInstance().RemoveDefineRight(dRight.CompanyID); } catch (Exception e) { m = new Message() { Result = false, TxtMessage = "操作失败,【" + e.Message + "】" }; } return(m); }
public Message RemoveCompanyRightCache(string CompanyID) { Message m = new Message() { Result = true, TxtMessage = "更新缓存操作成功。" }; string sqlText = string.Empty; try { CompanyRightCached.getInstance().RemoveDefineRight(CompanyID); CompanyRightCached.getInstance().RemoveDefineOperRight(CompanyID); CompanyRightCached.getInstance().RemoveDefineRightMenu(CompanyID); CompanyRightCached.getInstance().RemoveDefineMenu(CompanyID); } catch (Exception e) { m = new Message() { Result = false, TxtMessage = "操作失败,【" + e.Message + "】" }; } return(m); }