/// <summary>
/// 编辑一条数据
/// </summary>
/// <returns>"true"/"false"</returns>
private string doUpdate()
{
try
{
string selectvalue = IRequest.GetFormString("selectvalue").TrimStart(new char[] { ',' });
string[] selectCateId = selectvalue.Split(',');
if (selectCateId.Length > 0)
{
using (ISession session = dbContext.Current().GetContext("SqlDb").GetSession())
{
int roleId = Dcms.Utility.IRequest.GetFormInt("roleId", 0);
if (roleId > 0)
{
//处理select权限
session.simple("delete from [Dcms_Permissions] where [Permissions_RoleId]=" + roleId);
for (int i = 0; i < selectCateId.Length; i++)
{
SqlDb.Dcms_Permissions perm = new SqlDb.Dcms_Permissions();
perm.Permissions_AdminId = 0;
perm.Permissions_CateId = Utils.StrToInt(selectCateId[i], 0);
perm.Permissions_Delete = 0;
perm.Permissions_Insert = 0;
perm.Permissions_RoleId = roleId;
perm.Permissions_Select = 1;
perm.Permissions_Update = 0;
session.Create(perm);
}
string Sql = string.Empty;
//处理insert权限
string insertvalue = IRequest.GetFormString("insertvalue").TrimStart(new char[] { ',' });
if (insertvalue.Length > 0)
{
Sql = "update [Dcms_Permissions] set Permissions_Insert=1 where [Permissions_CateId] in(" + insertvalue + ") and [Permissions_RoleId]=" + roleId;
session.simple(Sql);
}
//处理update权限
string updatevalue = IRequest.GetFormString("updatevalue").TrimStart(new char[] { ',' });
if (updatevalue.Length > 0)
{
Sql = "update [Dcms_Permissions] set Permissions_Update=1 where [Permissions_CateId] in(" + updatevalue + ") and [Permissions_RoleId]=" + roleId;
session.simple(Sql);
}
//处理delete权限
string deletevalue = IRequest.GetFormString("deletevalue").TrimStart(new char[] { ',' });
if (deletevalue.Length > 0)
{
Sql = "update [Dcms_Permissions] set Permissions_Delete=1 where [Permissions_CateId] in(" + deletevalue + ") and [Permissions_RoleId]=" + roleId;
session.simple(Sql);
}
//处理角色语言版本权限
string catelang = IRequest.GetFormString("catelang").TrimStart(new char[] { ',' });
SqlDb.Dcms_Role role = new SqlDb.Dcms_Role();
role.Role_Id = roleId;
IQuery query = session.GetQuery(role).Where(SqlDb.Dcms_Role._ROLE_ID_.EqulesExp());
List<SqlDb.Dcms_Role> rList = query.GetList<SqlDb.Dcms_Role>();
if (rList.Count > 0)
{
role = rList[0];
role.Role_CateLang = catelang.ToUpper();
role.Update();
}
}
}
}
return "true";
}
catch
{
return "false";
}
}
/// <summary>
/// 编辑一条数据
/// </summary>
/// <returns>"true"/"false"</returns>
private string doUpdate()
{
try
{
string selectvalue = IRequest.GetFormString("selectvalue").TrimStart(new char[] { ',' });
string[] selectCateId = selectvalue.Split(',');
if (selectCateId.Length > 0)
{
using (ISession session = dbContext.Current().GetContext("SqlDb").GetSession())
{
int roleId = Dcms.Utility.IRequest.GetFormInt("roleId", 0);
if (roleId > 0)
{
//处理select权限
session.simple("delete from [Dcms_Permissions] where [Permissions_RoleId]=" + roleId);
for (int i = 0; i < selectCateId.Length; i++)
{
SqlDb.Dcms_Permissions perm = new SqlDb.Dcms_Permissions();
perm.Permissions_AdminId = 0;
perm.Permissions_CateId = Utils.StrToInt(selectCateId[i], 0);
perm.Permissions_Delete = 0;
perm.Permissions_Insert = 0;
perm.Permissions_RoleId = roleId;
perm.Permissions_Select = 1;
perm.Permissions_Update = 0;
session.Create(perm);
}
string Sql = string.Empty;
//处理insert权限
string insertvalue = IRequest.GetFormString("insertvalue").TrimStart(new char[] { ',' });
if (insertvalue.Length > 0)
{
Sql = "update [Dcms_Permissions] set Permissions_Insert=1 where [Permissions_CateId] in(" + insertvalue + ") and [Permissions_RoleId]=" + roleId;
session.simple(Sql);
}
//处理update权限
string updatevalue = IRequest.GetFormString("updatevalue").TrimStart(new char[] { ',' });
if (updatevalue.Length > 0)
{
Sql = "update [Dcms_Permissions] set Permissions_Update=1 where [Permissions_CateId] in(" + updatevalue + ") and [Permissions_RoleId]=" + roleId;
session.simple(Sql);
}
//处理delete权限
string deletevalue = IRequest.GetFormString("deletevalue").TrimStart(new char[] { ',' });
if (deletevalue.Length > 0)
{
Sql = "update [Dcms_Permissions] set Permissions_Delete=1 where [Permissions_CateId] in(" + deletevalue + ") and [Permissions_RoleId]=" + roleId;
session.simple(Sql);
}
//处理角色语言版本权限
string catelang = IRequest.GetFormString("catelang").TrimStart(new char[] { ',' });
SqlDb.Dcms_Role role = new SqlDb.Dcms_Role();
role.Role_Id = roleId;
IQuery query = session.GetQuery(role).Where(SqlDb.Dcms_Role._ROLE_ID_.EqulesExp());
List <SqlDb.Dcms_Role> rList = query.GetList <SqlDb.Dcms_Role>();
if (rList.Count > 0)
{
role = rList[0];
role.Role_CateLang = catelang.ToUpper();
role.Update();
}
}
}
}
return("true");
}
catch
{
return("false");
}
}