/// <summary>
/// 更新记录
/// </summary>
/// <param name="model">MyCreek.Data.Model.Role实体类</param>
public int Update(MyCreek.Data.Model.Role model)
{
string sql = @"UPDATE Role SET
Name=@Name,UseMember=@UseMember,Note=@Note
WHERE ID=@ID" ;
SqlParameter[] parameters = new SqlParameter[] {
new SqlParameter("@Name", SqlDbType.NVarChar, 400)
{
Value = model.Name
},
model.UseMember == null ? new SqlParameter("@UseMember", SqlDbType.VarChar, -1)
{
Value = DBNull.Value
} : new SqlParameter("@UseMember", SqlDbType.VarChar, -1)
{
Value = model.UseMember
},
model.Note == null ? new SqlParameter("@Note", SqlDbType.NVarChar, -1)
{
Value = DBNull.Value
} : new SqlParameter("@Note", SqlDbType.NVarChar, -1)
{
Value = model.Note
},
new SqlParameter("@ID", SqlDbType.UniqueIdentifier, -1)
{
Value = model.ID
}
};
return(dbHelper.Execute(sql, parameters));
}
/// <summary>
/// 更新记录
/// </summary>
/// <param name="model">MyCreek.Data.Model.Role实体类</param>
public int Update(MyCreek.Data.Model.Role model)
{
string sql = @"UPDATE Role SET
Name=:Name,UseMember=:UseMember,Note=:Note
WHERE ID=:ID" ;
OracleParameter[] parameters = new OracleParameter[] {
new OracleParameter(":Name", OracleDbType.NVarchar2, 400)
{
Value = model.Name
},
model.UseMember == null ? new OracleParameter(":UseMember", OracleDbType.Clob)
{
Value = DBNull.Value
} : new OracleParameter(":UseMember", OracleDbType.Clob)
{
Value = model.UseMember
},
model.Note == null ? new OracleParameter(":Note", OracleDbType.NVarchar2)
{
Value = DBNull.Value
} : new OracleParameter(":Note", OracleDbType.NVarchar2)
{
Value = model.Note
},
new OracleParameter(":ID", OracleDbType.Varchar2, 40)
{
Value = model.ID
}
};
return(dbHelper.Execute(sql, parameters));
}
/// <summary>
/// 添加记录
/// </summary>
/// <param name="model">MyCreek.Data.Model.Role实体类</param>
/// <returns>操作所影响的行数</returns>
public int Add(MyCreek.Data.Model.Role model)
{
string sql = @"INSERT INTO Role
(ID,Name,UseMember,Note)
VALUES(@ID,@Name,@UseMember,@Note)" ;
SqlParameter[] parameters = new SqlParameter[] {
new SqlParameter("@ID", SqlDbType.UniqueIdentifier, -1)
{
Value = model.ID
},
new SqlParameter("@Name", SqlDbType.NVarChar, 400)
{
Value = model.Name
},
model.UseMember == null ? new SqlParameter("@UseMember", SqlDbType.VarChar, -1)
{
Value = DBNull.Value
} : new SqlParameter("@UseMember", SqlDbType.VarChar, -1)
{
Value = model.UseMember
},
model.Note == null ? new SqlParameter("@Note", SqlDbType.NVarChar, -1)
{
Value = DBNull.Value
} : new SqlParameter("@Note", SqlDbType.NVarChar, -1)
{
Value = model.Note
}
};
return(dbHelper.Execute(sql, parameters));
}
/// <summary>
/// 添加记录
/// </summary>
/// <param name="model">MyCreek.Data.Model.Role实体类</param>
/// <returns>操作所影响的行数</returns>
public int Add(MyCreek.Data.Model.Role model)
{
string sql = @"INSERT INTO Role
(ID,Name,UseMember,Note)
VALUES(:ID,:Name,:UseMember,:Note)" ;
OracleParameter[] parameters = new OracleParameter[] {
new OracleParameter(":ID", OracleDbType.Varchar2, 40)
{
Value = model.ID
},
new OracleParameter(":Name", OracleDbType.NVarchar2, 400)
{
Value = model.Name
},
model.UseMember == null ? new OracleParameter(":UseMember", OracleDbType.Clob)
{
Value = DBNull.Value
} : new OracleParameter(":UseMember", OracleDbType.Clob)
{
Value = model.UseMember
},
model.Note == null ? new OracleParameter(":Note", OracleDbType.NVarchar2)
{
Value = DBNull.Value
} : new OracleParameter(":Note", OracleDbType.NVarchar2)
{
Value = model.Note
}
};
return(dbHelper.Execute(sql, parameters));
}
public ActionResult AddRole(FormCollection collection)
{
string name = Request.Form["Name"];
string note = Request.Form["Note"];
string useMember = Request.Form["UseMember"];
MyCreek.Data.Model.Role role = new MyCreek.Data.Model.Role();
if (collection != null)
{
using (System.Transactions.TransactionScope trans = new System.Transactions.TransactionScope())
{
role.ID = Guid.NewGuid();
role.Name = name.Trim();
if (!useMember.IsNullOrEmpty())
{
role.UseMember = useMember;
MyCreek.Platform.UsersRole busersRole = new MyCreek.Platform.UsersRole();
var users = new MyCreek.Platform.Organize().GetAllUsers(useMember);
foreach (var user in users)
{
MyCreek.Data.Model.UsersRole ur = new MyCreek.Data.Model.UsersRole();
ur.IsDefault = true;
ur.MemberID = user.ID;
ur.RoleID = role.ID;
busersRole.Add(ur);
}
}
if (!note.IsNullOrEmpty())
{
role.Note = note.Trim();
}
new MyCreek.Platform.Role().Add(role);
//添加一个根应用
MyCreek.Data.Model.RoleApp roleApp = new MyCreek.Data.Model.RoleApp();
roleApp.ID = Guid.NewGuid();
roleApp.ParentID = Guid.Empty;
roleApp.RoleID = role.ID;
roleApp.Sort = 1;
roleApp.Title = "管理目录";
new MyCreek.Platform.RoleApp().Add(roleApp);
trans.Complete();
ViewBag.Script = "alert('添加成功!');new RoadUI.Window().reloadOpener();new RoadUI.Window().close();";
}
}
return(View(role));
}
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack)
{
string name = Request.Form["Name"];
string note = Request.Form["Note"];
string useMember = Request.Form["UseMember"];
MyCreek.Data.Model.Role role = new MyCreek.Data.Model.Role();
using (System.Transactions.TransactionScope trans = new System.Transactions.TransactionScope())
{
role.ID = Guid.NewGuid();
role.Name = name.Trim();
if (!useMember.IsNullOrEmpty())
{
role.UseMember = useMember;
MyCreek.Platform.UsersRole busersRole = new MyCreek.Platform.UsersRole();
var users = new MyCreek.Platform.Organize().GetAllUsers(useMember);
foreach (var user in users)
{
MyCreek.Data.Model.UsersRole ur = new MyCreek.Data.Model.UsersRole();
ur.IsDefault = true;
ur.MemberID = user.ID;
ur.RoleID = role.ID;
busersRole.Add(ur);
}
}
if (!note.IsNullOrEmpty())
{
role.Note = note.Trim();
}
new MyCreek.Platform.Role().Add(role);
//添加一个根应用
MyCreek.Data.Model.RoleApp roleApp = new MyCreek.Data.Model.RoleApp();
roleApp.ID = Guid.NewGuid();
roleApp.ParentID = Guid.Empty;
roleApp.RoleID = role.ID;
roleApp.Sort = 1;
roleApp.Title = "管理目录";
new MyCreek.Platform.RoleApp().Add(roleApp);
trans.Complete();
Page.ClientScript.RegisterStartupScript(Page.GetType(), "ok", "alert('添加成功!');new RoadUI.Window().reloadOpener();new RoadUI.Window().close();", true);
}
}
}
/// <summary>
/// 将DataRedar转换为List
/// </summary>
private List <MyCreek.Data.Model.Role> DataReaderToList(SqlDataReader dataReader)
{
List <MyCreek.Data.Model.Role> List = new List <MyCreek.Data.Model.Role>();
MyCreek.Data.Model.Role model = null;
while (dataReader.Read())
{
model = new MyCreek.Data.Model.Role();
model.ID = dataReader.GetGuid(0);
model.Name = dataReader.GetString(1);
if (!dataReader.IsDBNull(2))
{
model.UseMember = dataReader.GetString(2);
}
if (!dataReader.IsDBNull(3))
{
model.Note = dataReader.GetString(3);
}
List.Add(model);
}
return(List);
}
/// <summary>
/// 更新
/// </summary>
public int Update(MyCreek.Data.Model.Role model)
{
return(dataRole.Update(model));
}
/// <summary>
/// 新增
/// </summary>
public int Add(MyCreek.Data.Model.Role model)
{
return(dataRole.Add(model));
}
public ActionResult EditRole(FormCollection collection)
{
MyCreek.Platform.Role brole = new MyCreek.Platform.Role();
MyCreek.Data.Model.Role role = null;
string roleID = Request.QueryString["roleid"];
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 MyCreek.Platform.RoleApp().CopyRoleApp(roleGID, tpl.ToGuid());
MyCreek.Platform.Log.Add("复制了模板应用", "源：" + roleID + "复制给：" + tpl, MyCreek.Platform.Log.Types.角色应用);
ViewBag.Script = "alert('复制成功!');";
}
}
if (!Request.Form["Save"].IsNullOrEmpty() && role != null)
{
MyCreek.Platform.UsersRole busersRole = new MyCreek.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 MyCreek.Platform.Organize().GetAllUsers(useMember);
foreach (var user in users)
{
MyCreek.Data.Model.UsersRole ur = new MyCreek.Data.Model.UsersRole();
ur.IsDefault = true;
ur.MemberID = user.ID;
ur.RoleID = role.ID;
busersRole.Add(ur);
}
}
scope.Complete();
}
ViewBag.Script = "alert('保存成功!');new RoadUI.Window().reloadOpener();new RoadUI.Window().close();";
}
if (!Request.Form["Delete"].IsNullOrEmpty())
{
using (System.Transactions.TransactionScope scope = new System.Transactions.TransactionScope())
{
brole.Delete(roleGID);
new MyCreek.Platform.RoleApp().DeleteByRoleID(roleGID);
new MyCreek.Platform.UsersRole().DeleteByRoleID(roleGID);
scope.Complete();
}
MyCreek.Platform.Log.Add("删除的角色其及相关数据", roleID, MyCreek.Platform.Log.Types.角色应用);
ViewBag.Script = "new RoadUI.Window().reloadOpener();new RoadUI.Window().close();";
}
ViewBag.RoleOptions = brole.GetRoleOptions("", roleID);
return(View(role));
}
protected void Page_Load(object sender, EventArgs e)
{
MyCreek.Platform.Role brole = new MyCreek.Platform.Role();
MyCreek.Data.Model.Role role = null;
string roleID = Request.QueryString["roleid"];
Guid roleGID;
string name = string.Empty;
string useMember = string.Empty;
string note = string.Empty;
if (roleID.IsGuid(out roleGID))
{
role = brole.Get(roleGID);
}
if (IsPostBack)
{
if (!Request.Form["Copy"].IsNullOrEmpty())
{
string tpl = Request.Form["ToTpl"];
if (tpl.IsGuid())
{
new MyCreek.Platform.RoleApp().CopyRoleApp(roleGID, tpl.ToGuid());
MyCreek.Platform.Log.Add("复制了模板应用", "源：" + roleID + "复制给：" + tpl, MyCreek.Platform.Log.Types.角色应用);
Page.ClientScript.RegisterStartupScript(Page.GetType(), "ok", "alert('复制成功!');", true);
}
}
if (!Request.Form["Save"].IsNullOrEmpty() && role != null)
{
MyCreek.Platform.UsersRole busersRole = new MyCreek.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 MyCreek.Platform.Organize().GetAllUsers(useMember);
foreach (var user in users)
{
MyCreek.Data.Model.UsersRole ur = new MyCreek.Data.Model.UsersRole();
ur.IsDefault = true;
ur.MemberID = user.ID;
ur.RoleID = role.ID;
busersRole.Add(ur);
}
}
scope.Complete();
}
Page.ClientScript.RegisterStartupScript(Page.GetType(), "ok", "alert('保存成功!');new RoadUI.Window().reloadOpener();new RoadUI.Window().close();", true);
}
if (!Request.Form["Delete"].IsNullOrEmpty())
{
using (System.Transactions.TransactionScope scope = new System.Transactions.TransactionScope())
{
brole.Delete(roleGID);
new MyCreek.Platform.RoleApp().DeleteByRoleID(roleGID);
new MyCreek.Platform.UsersRole().DeleteByRoleID(roleGID);
scope.Complete();
}
MyCreek.Platform.Log.Add("删除的角色其及相关数据", roleID, MyCreek.Platform.Log.Types.角色应用);
Page.ClientScript.RegisterStartupScript(Page.GetType(), "ok", "new RoadUI.Window().reloadOpener();new RoadUI.Window().close();", true);
}
}
if (role != null)
{
this.Name.Value = role.Name;
this.UseMember.Value = role.UseMember;
this.Note.Value = role.Note;
}
this.RoleOptions.Text = brole.GetRoleOptions("", roleID);
}
