/// <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); }