/// <summary>
/// 更新
/// </summary>
public int Update(Data.Model.UsersRole model)
{
int i = dataUsersRole.Update(model);
ClearCache();
return(i);
}
/// <summary>
/// 新增
/// </summary>
public int Add(Data.Model.UsersRole model)
{
int i = dataUsersRole.Add(model);
ClearCache();
return(i);
}
/// <summary>
/// 将DataRedar转换为List
/// </summary>
private List <Data.Model.UsersRole> DataReaderToList(SqlDataReader dataReader)
{
List <Data.Model.UsersRole> List = new List <Data.Model.UsersRole>();
Data.Model.UsersRole model = null;
while (dataReader.Read())
{
model = new Data.Model.UsersRole();
model.MemberID = dataReader.GetGuid(0);
model.RoleID = dataReader.GetGuid(1);
model.IsDefault = dataReader.GetBoolean(2);
List.Add(model);
}
return(List);
}
/// <summary>
/// 更新记录
/// </summary>
/// <param name="model">Data.Model.UsersRole实体类</param>
public int Update(Data.Model.UsersRole model)
{
string sql = @"UPDATE UsersRole SET
IsDefault=@IsDefault
WHERE MemberID=@MemberID and RoleID=@RoleID" ;
SqlParameter[] parameters = new SqlParameter[] {
new SqlParameter("@IsDefault", SqlDbType.Bit, -1)
{
Value = model.IsDefault
},
new SqlParameter("@MemberID", SqlDbType.UniqueIdentifier, -1)
{
Value = model.MemberID
},
new SqlParameter("@RoleID", SqlDbType.UniqueIdentifier, -1)
{
Value = model.RoleID
}
};
return(dbHelper.Execute(sql, parameters));
}
/// <summary>
/// 添加记录
/// </summary>
/// <param name="model">Data.Model.UsersRole实体类</param>
/// <returns>操作所影响的行数</returns>
public int Add(Data.Model.UsersRole model)
{
string sql = @"INSERT INTO UsersRole
(MemberID,RoleID,IsDefault)
VALUES(@MemberID,@RoleID,@IsDefault)" ;
SqlParameter[] parameters = new SqlParameter[] {
new SqlParameter("@MemberID", SqlDbType.UniqueIdentifier, -1)
{
Value = model.MemberID
},
new SqlParameter("@RoleID", SqlDbType.UniqueIdentifier, -1)
{
Value = model.RoleID
},
new SqlParameter("@IsDefault", SqlDbType.Bit, -1)
{
Value = model.IsDefault
}
};
return(dbHelper.Execute(sql, parameters));
}
public ActionResult EditRole(FormCollection collection)
{
Business.Platform.Role brole = new Business.Platform.Role();
Data.Model.Role role = null;
string roleID = Request.QueryString["id"];
Guid roleGID;
string name = string.Empty;
string useMember = string.Empty;
string note = string.Empty;
if (roleID.IsGuid(out roleGID))
{
role = brole.Get(roleGID);
}
if (!Request.Form["Copy"].IsNullOrEmpty())
{
string tpl = Request.Form["ToTpl"];
if (tpl.IsGuid())
{
new Business.Platform.RoleApp().CopyRoleApp(roleGID, tpl.ToGuid());
Business.Platform.Log.Add("复制了模板应用", "源：" + roleID + "复制给：" + tpl, Business.Platform.Log.Types.角色应用);
ViewBag.Script = "alert('复制成功!');";
}
}
if (!Request.Form["Save"].IsNullOrEmpty() && role != null)
{
Business.Platform.UsersRole busersRole = new Business.Platform.UsersRole();
using (System.Transactions.TransactionScope scope = new System.Transactions.TransactionScope())
{
name = Request.Form["Name"];
useMember = Request.Form["UseMember"];
note = Request.Form["Note"];
role.Name = name.Trim();
role.Note = note.IsNullOrEmpty() ? null : note.Trim();
role.UseMember = useMember.IsNullOrEmpty() ? null : useMember;
brole.Update(role);
busersRole.DeleteByRoleID(role.ID);
if (!useMember.IsNullOrEmpty())
{
busersRole.DeleteByRoleID(role.ID);
var users = new Business.Platform.Organize().GetAllUsers(useMember);
foreach (var user in users)
{
Data.Model.UsersRole ur = new Data.Model.UsersRole();
ur.IsDefault = true;
ur.MemberID = user.ID;
ur.RoleID = role.ID;
busersRole.Add(ur);
}
}
scope.Complete();
}
ViewBag.Script = "alert('保存成功!');parent.frames[0].location = 'Tree?appid=" + Request.QueryString["appid"] + "&roleid=" + roleID + "';";
}
if (!Request.Form["Delete"].IsNullOrEmpty())
{
using (System.Transactions.TransactionScope scope = new System.Transactions.TransactionScope())
{
brole.Delete(roleGID);
new Business.Platform.RoleApp().DeleteByRoleID(roleGID);
new Business.Platform.UsersRole().DeleteByRoleID(roleGID);
scope.Complete();
}
Business.Platform.Log.Add("删除的角色其及相关数据", roleID, Business.Platform.Log.Types.角色应用);
ViewBag.Script = "parent.frames[0].location = parent.frames[0].location;";
}
ViewBag.RoleOptions = brole.GetRoleOptions("", roleID);
return(View(role));
}
/// <summary>
/// 更新
/// </summary>
public int Update(Data.Model.UsersRole model)
{
return(dataUsersRole.Update(model));
}
/// <summary>
/// 新增
/// </summary>
public int Add(Data.Model.UsersRole model)
{
return(dataUsersRole.Add(model));
}
