/// <summary> /// 添加记录 /// </summary> /// <param name="model">BizProcess.Data.Model.Role实体类</param> /// <returns>操作所影响的行数</returns> public int Add(BizProcess.Data.Model.Role model) { string sql = @"INSERT INTO Role (ID,Name,UseMember,Note) VALUES(@ID,@Name,@UseMember,@Note)" ; MySqlParameter[] parameters = new MySqlParameter[] { new MySqlParameter("@ID", MySqlDbType.VarChar, 36) { Value = model.ID }, new MySqlParameter("@Name", MySqlDbType.VarChar, 200) { Value = model.Name }, model.UseMember == null ? new MySqlParameter("@UseMember", MySqlDbType.Text, -1) { Value = DBNull.Value } : new MySqlParameter("@UseMember", MySqlDbType.Text, -1) { Value = model.UseMember }, model.Note == null ? new MySqlParameter("@Note", MySqlDbType.Text, -1) { Value = DBNull.Value } : new MySqlParameter("@Note", MySqlDbType.Text, -1) { Value = model.Note } }; return(dbHelper.Execute(sql, parameters)); }
/// <summary> /// 更新记录 /// </summary> /// <param name="model">BizProcess.Data.Model.Role实体类</param> public int Update(BizProcess.Data.Model.Role model) { string sql = @"UPDATE Role SET Name=@Name,UseMember=@UseMember,Note=@Note WHERE ID=@ID" ; MySqlParameter[] parameters = new MySqlParameter[] { new MySqlParameter("@Name", MySqlDbType.VarChar, 200) { Value = model.Name }, model.UseMember == null ? new MySqlParameter("@UseMember", MySqlDbType.Text, -1) { Value = DBNull.Value } : new MySqlParameter("@UseMember", MySqlDbType.Text, -1) { Value = model.UseMember }, model.Note == null ? new MySqlParameter("@Note", MySqlDbType.Text, -1) { Value = DBNull.Value } : new MySqlParameter("@Note", MySqlDbType.Text, -1) { Value = model.Note }, new MySqlParameter("@ID", MySqlDbType.VarChar, 36) { Value = model.ID } }; return(dbHelper.Execute(sql, parameters)); }
/// <summary> /// 更新记录 /// </summary> /// <param name="model">BizProcess.Data.Model.Role实体类</param> public int Update(BizProcess.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.NClob) { Value = DBNull.Value } : new OracleParameter(":Note", OracleDbType.NClob) { Value = model.Note }, new OracleParameter(":ID", OracleDbType.Char, 36) { Value = model.ID } }; return(dbHelper.Execute(sql, parameters)); }
/// <summary> /// 添加记录 /// </summary> /// <param name="model">BizProcess.Data.Model.Role实体类</param> /// <returns>操作所影响的行数</returns> public int Add(BizProcess.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.Char, 36) { 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.NClob) { Value = DBNull.Value } : new OracleParameter(":Note", OracleDbType.NClob) { 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"]; BizProcess.Data.Model.Role role = new BizProcess.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; BizProcess.Platform.UsersRole busersRole = new BizProcess.Platform.UsersRole(); var users = new BizProcess.Platform.Organize().GetAllUsers(useMember); foreach (var user in users) { BizProcess.Data.Model.UsersRole ur = new BizProcess.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 BizProcess.Platform.Role().Add(role); //添加一个根应用 BizProcess.Data.Model.RoleApp roleApp = new BizProcess.Data.Model.RoleApp(); roleApp.ID = Guid.NewGuid(); roleApp.ParentID = Guid.Empty; roleApp.RoleID = role.ID; roleApp.Sort = 1; roleApp.Title = "管理目录"; new BizProcess.Platform.RoleApp().Add(roleApp); trans.Complete(); ViewBag.Script = "alert('添加成功!');new BPUI.Window().reloadOpener();new BPUI.Window().close();"; } } return(View(role)); }
/// <summary> /// 将DataRedar转换为List /// </summary> private List <BizProcess.Data.Model.Role> DataReaderToList(MySqlDataReader dataReader) { List <BizProcess.Data.Model.Role> List = new List <BizProcess.Data.Model.Role>(); BizProcess.Data.Model.Role model = null; while (dataReader.Read()) { model = new BizProcess.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(BizProcess.Data.Model.Role model) { return(dataRole.Update(model)); }
/// <summary> /// 新增 /// </summary> public int Add(BizProcess.Data.Model.Role model) { return(dataRole.Add(model)); }
public ActionResult EditRole(FormCollection collection) { BizProcess.Platform.Role brole = new BizProcess.Platform.Role(); BizProcess.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 BizProcess.Platform.RoleApp().CopyRoleApp(roleGID, tpl.ToGuid()); BizProcess.Platform.Log.Add("复制了模板应用", "源:" + roleID + "复制给:" + tpl, BizProcess.Platform.Log.Types.角色应用); ViewBag.Script = "alert('复制成功!');"; } } if (!Request.Form["Save"].IsNullOrEmpty() && role != null) { BizProcess.Platform.UsersRole busersRole = new BizProcess.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 BizProcess.Platform.Organize().GetAllUsers(useMember); foreach (var user in users) { BizProcess.Data.Model.UsersRole ur = new BizProcess.Data.Model.UsersRole(); ur.IsDefault = true; ur.MemberID = user.ID; ur.RoleID = role.ID; busersRole.Add(ur); } } scope.Complete(); } ViewBag.Script = "alert('保存成功!');new BPUI.Window().reloadOpener();new BPUI.Window().close();"; } if (!Request.Form["Delete"].IsNullOrEmpty()) { using (System.Transactions.TransactionScope scope = new System.Transactions.TransactionScope()) { brole.Delete(roleGID); new BizProcess.Platform.RoleApp().DeleteByRoleID(roleGID); new BizProcess.Platform.UsersRole().DeleteByRoleID(roleGID); scope.Complete(); } BizProcess.Platform.Log.Add("删除的角色其及相关数据", roleID, BizProcess.Platform.Log.Types.角色应用); ViewBag.Script = "new BPUI.Window().reloadOpener();new BPUI.Window().close();"; } ViewBag.RoleOptions = brole.GetRoleOptions("", roleID); return(View(role)); }