/// <summary> /// 更新 /// </summary> public int Update(MyCreek.Data.Model.UsersRole model) { int i = dataUsersRole.Update(model); ClearCache(); return(i); }
/// <summary> /// 将DataRedar转换为List /// </summary> private List <MyCreek.Data.Model.UsersRole> DataReaderToList(SqlDataReader dataReader) { List <MyCreek.Data.Model.UsersRole> List = new List <MyCreek.Data.Model.UsersRole>(); MyCreek.Data.Model.UsersRole model = null; while (dataReader.Read()) { model = new MyCreek.Data.Model.UsersRole(); model.MemberID = dataReader.GetGuid(0); model.RoleID = dataReader.GetGuid(1); model.IsDefault = dataReader.GetBoolean(2); List.Add(model); } return(List); }
/// <summary> /// 将DataRedar转换为List /// </summary> private List <MyCreek.Data.Model.UsersRole> DataReaderToList(OracleDataReader dataReader) { List <MyCreek.Data.Model.UsersRole> List = new List <MyCreek.Data.Model.UsersRole>(); MyCreek.Data.Model.UsersRole model = null; while (dataReader.Read()) { model = new MyCreek.Data.Model.UsersRole(); model.MemberID = dataReader.GetString(0).ToGuid(); model.RoleID = dataReader.GetString(1).ToGuid(); model.IsDefault = 1 == dataReader.GetInt32(2); List.Add(model); } return(List); }
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> /// 更新记录 /// </summary> /// <param name="model">MyCreek.Data.Model.UsersRole实体类</param> public int Update(MyCreek.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">MyCreek.Data.Model.UsersRole实体类</param> /// <returns>操作所影响的行数</returns> public int Add(MyCreek.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)); }
/// <summary> /// 更新记录 /// </summary> /// <param name="model">MyCreek.Data.Model.UsersRole实体类</param> public int Update(MyCreek.Data.Model.UsersRole model) { string sql = @"UPDATE UsersRole SET IsDefault=:IsDefault WHERE MemberID=:MemberID and RoleID=:RoleID" ; OracleParameter[] parameters = new OracleParameter[] { new OracleParameter(":IsDefault", OracleDbType.Int32) { Value = model.IsDefault }, new OracleParameter(":MemberID", OracleDbType.Varchar2, 40) { Value = model.MemberID }, new OracleParameter(":RoleID", OracleDbType.Varchar2, 40) { Value = model.RoleID } }; return(dbHelper.Execute(sql, parameters)); }
/// <summary> /// 添加记录 /// </summary> /// <param name="model">MyCreek.Data.Model.UsersRole实体类</param> /// <returns>操作所影响的行数</returns> public int Add(MyCreek.Data.Model.UsersRole model) { string sql = @"INSERT INTO UsersRole (MemberID,RoleID,IsDefault) VALUES(:MemberID,:RoleID,:IsDefault)" ; OracleParameter[] parameters = new OracleParameter[] { new OracleParameter(":MemberID", OracleDbType.Varchar2, 40) { Value = model.MemberID }, new OracleParameter(":RoleID", OracleDbType.Varchar2, 40) { Value = model.RoleID }, new OracleParameter(":IsDefault", OracleDbType.Int32) { Value = model.IsDefault } }; return(dbHelper.Execute(sql, parameters)); }
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); }