//从缓存中获取K_SysActionPermit表
//public DataTable GetActionPermitFromCache()
//{
// if (AppCache.IsExist("ActionPermitCache"))
// {
// return (DataTable)AppCache.Get("ActionPermitCache");
// }
// else
// {
// DataTable dt = GetList("Cache", Utils.getOneParams(""));
// AppCache.Add("ActionPermitCache", dt, "K_SysActionPermit");
// return dt;
// }
//}
#region 增、改K_SysActionPermit表
/// <summary>
/// 增、改K_SysActionPermit表
/// </summary>
/// <param name="tranType">操作类型，NEW=增，EDIT=改</param>
/// <param name="AutModel"></param>
/// <returns>返回大于0的数字操作正常，返回非数字表示操作错误，返回的是系统错误说明</returns>
public string Save(string trantype, KingTop.Model.SysManage.ActionPermit ActionPermitModel)
{
string re;
re = dal.Save(trantype, ActionPermitModel);
//更新缓存
KingTop.Common.AppCache.Remove("ModuleActionCache");
KingTop.BLL.SysManage.RightTool rtBll = new RightTool();
rtBll.GetModuleActionFromCache();
return(re);
}
/// <summary>
/// 增、改K_SysActionPermit表
/// </summary>
/// <param Name="tranType">操作类型，NEW=增，EDIT=改</param>
/// <param Name="paramsModel"></param>
/// <returns>返回大于0的数字操作正常，返回非数字表示操作错误，返回的是系统错误说明</returns>
public string Save(string tranType, KingTop.Model.SysManage.ActionPermit paramsModel)
{
string isOk = "";
try
{
SqlParameter returnValue = new SqlParameter("@ReturnValue", SqlDbType.Int, 4);
returnValue.Direction = ParameterDirection.Output;
string cmdText = "proc_K_SysActionPermitSave";
SqlParameter[] paras = new SqlParameter[] {
new SqlParameter("tranType", tranType),
new SqlParameter("ID", paramsModel.ID),
new SqlParameter("ModuleID", paramsModel.ModuleID),
new SqlParameter("operCode", paramsModel.operCode),
new SqlParameter("OperName", paramsModel.OperName),
new SqlParameter("OperOrder", paramsModel.OperOrder),
new SqlParameter("IsValid", paramsModel.IsValid),
new SqlParameter("OperDesc", paramsModel.OperDesc),
new SqlParameter("OperEngDesc", paramsModel.OperEngDesc),
new SqlParameter("IsDefaultOper", paramsModel.IsDefaultOper),
new SqlParameter("IsSystem", paramsModel.IsSystem),
returnValue
};
SQLHelper.ExecuteNonQuery(SQLHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, cmdText, paras);
isOk = returnValue.Value.ToString();
}
catch (Exception ex)
{
isOk = ex.Message;
}
return(isOk);
}
