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);
}
