/// <summary> /// 将DataRedar转换为List /// </summary> private List <RoadFlow.Data.Model.RoleApp> DataReaderToList(OracleDataReader dataReader) { List <RoadFlow.Data.Model.RoleApp> List = new List <RoadFlow.Data.Model.RoleApp>(); RoadFlow.Data.Model.RoleApp model = null; while (dataReader.Read()) { model = new RoadFlow.Data.Model.RoleApp(); model.ID = dataReader.GetString(0).ToGuid(); model.ParentID = dataReader.GetString(1).ToGuid(); model.RoleID = dataReader.GetString(2).ToGuid(); if (!dataReader.IsDBNull(3)) { model.AppID = dataReader.GetString(3).ToGuid(); } model.Title = dataReader.GetString(4); if (!dataReader.IsDBNull(5)) { model.Params = dataReader.GetString(5); } model.Sort = dataReader.GetInt32(6); if (!dataReader.IsDBNull(7)) { model.Ico = dataReader.GetString(7); } model.Type = dataReader.GetInt32(8); List.Add(model); } return(List); }
public ActionResult Body() { RoadFlow.Platform.AppLibraryBLL bappLibrary = new RoadFlow.Platform.AppLibraryBLL(); RoadFlow.Platform.RoleApp broleApp = new RoadFlow.Platform.RoleApp(); RoadFlow.Data.Model.RoleApp roleApp = null; string id = Request.QueryString["id"]; string name = string.Empty; string type = string.Empty; string appid = string.Empty; string params1 = string.Empty; string ico = string.Empty; Guid appID; if (id.IsGuid(out appID)) { roleApp = broleApp.Get(appID); if (roleApp != null) { name = roleApp.Title; type = roleApp.AppID.HasValue ? bappLibrary.GetTypeByID(roleApp.AppID.Value) : ""; appid = roleApp.AppID.ToString(); params1 = roleApp.Params; ico = roleApp.Ico; } } if (roleApp == null) { roleApp = new RoadFlow.Data.Model.RoleApp(); } ViewBag.AppID = appid; ViewBag.AppTypesOptions = bappLibrary.GetTypeOptions(type); return(View(roleApp)); }
/// <summary> /// 更新记录 /// </summary> /// <param name="model">RoadFlow.Data.Model.RoleApp实体类</param> public int Update(RoadFlow.Data.Model.RoleApp model) { string sql = @"UPDATE RoleApp SET ParentID=:ParentID,RoleID=:RoleID,AppID=:AppID,Title=:Title,Params=:Params,Sort=:Sort,Ico=:Ico,Type=:Type WHERE ID=:ID" ; OracleParameter[] parameters = new OracleParameter[] { new OracleParameter(":ParentID", OracleDbType.Varchar2, 40) { Value = model.ParentID }, new OracleParameter(":RoleID", OracleDbType.Varchar2, 40) { Value = model.RoleID }, model.AppID == null ? new OracleParameter(":AppID", OracleDbType.Varchar2, 40) { Value = DBNull.Value } : new OracleParameter(":AppID", OracleDbType.Varchar2, 40) { Value = model.AppID }, new OracleParameter(":Title", OracleDbType.NVarchar2, 400) { Value = model.Title }, model.Params == null ? new OracleParameter(":Params", OracleDbType.Clob) { Value = DBNull.Value } : new OracleParameter(":Params", OracleDbType.Clob) { Value = model.Params }, new OracleParameter(":Sort", OracleDbType.Int32) { Value = model.Sort }, model.Ico == null ? new OracleParameter(":Ico", OracleDbType.Varchar2, 200) { Value = DBNull.Value } : new OracleParameter(":Ico", OracleDbType.Varchar2, 200) { Value = model.Ico }, new OracleParameter(":Type", OracleDbType.Int32) { Value = model.Type }, new OracleParameter(":ID", OracleDbType.Varchar2, 40) { Value = model.ID } }; return(dbHelper.Execute(sql, parameters)); }
/// <summary> /// 添加记录 /// </summary> /// <param name="model">RoadFlow.Data.Model.RoleApp实体类</param> /// <returns>操作所影响的行数</returns> public int Add(RoadFlow.Data.Model.RoleApp model) { string sql = @"INSERT INTO RoleApp (ID,ParentID,RoleID,AppID,Title,Params,Sort,Ico,Type) VALUES(:ID,:ParentID,:RoleID,:AppID,:Title,:Params,:Sort,:Ico,:Type)" ; OracleParameter[] parameters = new OracleParameter[] { new OracleParameter(":ID", OracleDbType.Varchar2, 40) { Value = model.ID }, new OracleParameter(":ParentID", OracleDbType.Varchar2, 40) { Value = model.ParentID }, new OracleParameter(":RoleID", OracleDbType.Varchar2, 40) { Value = model.RoleID }, model.AppID == null ? new OracleParameter(":AppID", OracleDbType.Varchar2, 40) { Value = DBNull.Value } : new OracleParameter(":AppID", OracleDbType.Varchar2, 40) { Value = model.AppID }, new OracleParameter(":Title", OracleDbType.NVarchar2, 400) { Value = model.Title }, model.Params == null ? new OracleParameter(":Params", OracleDbType.Clob) { Value = DBNull.Value } : new OracleParameter(":Params", OracleDbType.Clob) { Value = model.Params }, new OracleParameter(":Sort", OracleDbType.Int32) { Value = model.Sort }, model.Ico == null ? new OracleParameter(":Ico", OracleDbType.Varchar2, 200) { Value = DBNull.Value } : new OracleParameter(":Ico", OracleDbType.Varchar2, 200) { Value = model.Ico }, new OracleParameter(":Type", OracleDbType.Int32) { Value = model.Type } }; return(dbHelper.Execute(sql, parameters)); }
/// <summary> /// 更新记录 /// </summary> /// <param name="model">RoadFlow.Data.Model.RoleApp实体类</param> public int Update(RoadFlow.Data.Model.RoleApp model) { string sql = @"UPDATE RoleApp SET ParentID=@ParentID,RoleID=@RoleID,AppID=@AppID,Title=@Title,Params=@Params,Sort=@Sort,Ico=@Ico,Type=@Type WHERE ID=@ID" ; SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@ParentID", SqlDbType.UniqueIdentifier, -1) { Value = model.ParentID }, new SqlParameter("@RoleID", SqlDbType.UniqueIdentifier, -1) { Value = model.RoleID }, model.AppID == null ? new SqlParameter("@AppID", SqlDbType.UniqueIdentifier, -1) { Value = DBNull.Value } : new SqlParameter("@AppID", SqlDbType.UniqueIdentifier, -1) { Value = model.AppID }, new SqlParameter("@Title", SqlDbType.NVarChar, 400) { Value = model.Title }, model.Params == null ? new SqlParameter("@Params", SqlDbType.VarChar, -1) { Value = DBNull.Value } : new SqlParameter("@Params", SqlDbType.VarChar, -1) { Value = model.Params }, new SqlParameter("@Sort", SqlDbType.Int, -1) { Value = model.Sort }, model.Ico == null ? new SqlParameter("@Ico", SqlDbType.VarChar, 200) { Value = DBNull.Value } : new SqlParameter("@Ico", SqlDbType.VarChar, 200) { Value = model.Ico }, new SqlParameter("@Type", SqlDbType.Int, -1) { Value = model.Type }, new SqlParameter("@ID", SqlDbType.UniqueIdentifier, -1) { Value = model.ID } }; return(dbHelper.Execute(sql, parameters)); }
/// <summary> /// 添加记录 /// </summary> /// <param name="model">RoadFlow.Data.Model.RoleApp实体类</param> /// <returns>操作所影响的行数</returns> public int Add(RoadFlow.Data.Model.RoleApp model) { string sql = @"INSERT INTO RoleApp (ID,ParentID,RoleID,AppID,Title,Params,Sort,Ico,Type) VALUES(@ID,@ParentID,@RoleID,@AppID,@Title,@Params,@Sort,@Ico,@Type)" ; SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@ID", SqlDbType.UniqueIdentifier, -1) { Value = model.ID }, new SqlParameter("@ParentID", SqlDbType.UniqueIdentifier, -1) { Value = model.ParentID }, new SqlParameter("@RoleID", SqlDbType.UniqueIdentifier, -1) { Value = model.RoleID }, model.AppID == null ? new SqlParameter("@AppID", SqlDbType.UniqueIdentifier, -1) { Value = DBNull.Value } : new SqlParameter("@AppID", SqlDbType.UniqueIdentifier, -1) { Value = model.AppID }, new SqlParameter("@Title", SqlDbType.NVarChar, 400) { Value = model.Title }, model.Params == null ? new SqlParameter("@Params", SqlDbType.VarChar, -1) { Value = DBNull.Value } : new SqlParameter("@Params", SqlDbType.VarChar, -1) { Value = model.Params }, new SqlParameter("@Sort", SqlDbType.Int, -1) { Value = model.Sort }, model.Ico == null ? new SqlParameter("@Ico", SqlDbType.VarChar, 200) { Value = DBNull.Value } : new SqlParameter("@Ico", SqlDbType.VarChar, 200) { Value = model.Ico }, new SqlParameter("@Type", SqlDbType.Int, -1) { Value = model.Type } }; return(dbHelper.Execute(sql, parameters)); }
public ActionResult AddApp(FormCollection collection) { RoadFlow.Platform.AppLibraryBLL bappLibrary = new RoadFlow.Platform.AppLibraryBLL(); RoadFlow.Platform.RoleApp broleApp = new RoadFlow.Platform.RoleApp(); RoadFlow.Data.Model.RoleApp roleApp = null; string id = Request.QueryString["id"]; if (collection != null) { roleApp = broleApp.Get(id.Convert <Guid>()); if (!Request.Form["Save"].IsNullOrEmpty()) { string name = Request.Form["Name"]; string type = Request.Form["Type"]; string appid = Request.Form["AppID"]; string params1 = Request.Form["Params"]; string ico = Request.Form["Ico"]; RoadFlow.Data.Model.RoleApp roleApp1 = new RoadFlow.Data.Model.RoleApp(); roleApp1.ID = Guid.NewGuid(); roleApp1.ParentID = id.Convert <Guid>(); roleApp1.RoleID = roleApp.RoleID; roleApp1.Title = name.Trim(); roleApp1.ParentID = roleApp.ID; roleApp1.Sort = broleApp.GetMaxSort(roleApp.ID); roleApp1.Type = 0; if (appid.IsGuid()) { roleApp1.AppID = appid.Convert <Guid>(); } else { roleApp1.AppID = null; } roleApp1.Params = params1.IsNullOrEmpty() ? null : params1.Trim(); if (!ico.IsNullOrEmpty()) { roleApp1.Ico = ico; } broleApp.Add(roleApp1); broleApp.ClearAllDataTableCache(); RoadFlow.Platform.Log.Add("添加了应用模板", roleApp1.Serialize(), RoadFlow.Platform.Log.Types.角色应用); string refreshID = id; ViewBag.Script = "alert('添加成功');parent.frames[0].reLoad('" + refreshID + "');"; } } ViewBag.AppTypesOptions = bappLibrary.GetTypeOptions(); return(View()); }
protected void Page_Load(object sender, EventArgs e) { RoadFlow.Platform.AppLibrary bappLibrary = new RoadFlow.Platform.AppLibrary(); RoadFlow.Platform.RoleApp broleApp = new RoadFlow.Platform.RoleApp(); RoadFlow.Data.Model.RoleApp roleApp = null; string id = Request.QueryString["id"]; if (IsPostBack) { roleApp = broleApp.Get(id.ToGuid()); if (!Request.Form["Save"].IsNullOrEmpty()) { string name = Request.Form["Name"]; string type = Request.Form["Type"]; string appid = Request.Form["AppID"]; string params1 = Request.Form["Params"]; string ico = Request.Form["Ico"]; RoadFlow.Data.Model.RoleApp roleApp1 = new RoadFlow.Data.Model.RoleApp(); roleApp1.ID = Guid.NewGuid(); roleApp1.ParentID = id.ToGuid(); roleApp1.RoleID = roleApp.RoleID; roleApp1.Title = name.Trim(); roleApp1.ParentID = roleApp.ID; roleApp1.Sort = broleApp.GetMaxSort(roleApp.ID); roleApp1.Type = 0; if (appid.IsGuid()) { roleApp1.AppID = appid.ToGuid(); } else { roleApp1.AppID = null; } roleApp1.Params = params1.IsNullOrEmpty() ? null : params1.Trim(); if (!ico.IsNullOrEmpty()) { roleApp1.Ico = ico; } broleApp.Add(roleApp1); broleApp.ClearAllDataTableCache(); RoadFlow.Platform.Log.Add("添加了应用模板", roleApp1.Serialize(), RoadFlow.Platform.Log.Types.角色应用); string refreshID = id; Page.ClientScript.RegisterStartupScript(Page.GetType(), "ok", "alert('添加成功');parent.frames[0].reLoad('" + refreshID + "');", true); } } this.AppTypesOptions.Text = bappLibrary.GetTypeOptions(); }
public ActionResult AddRole(FormCollection collection) { string name = Request.Form["Name"]; string note = Request.Form["Note"]; string useMember = Request.Form["UseMember"]; RoadFlow.Data.Model.Role role = new RoadFlow.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; RoadFlow.Platform.UsersRole busersRole = new RoadFlow.Platform.UsersRole(); var users = new RoadFlow.Platform.Organize().GetAllUsers(useMember); foreach (var user in users) { RoadFlow.Data.Model.UsersRole ur = new RoadFlow.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 RoadFlow.Platform.Role().Add(role); //添加一个根应用 RoadFlow.Data.Model.RoleApp roleApp = new RoadFlow.Data.Model.RoleApp(); roleApp.ID = Guid.NewGuid(); roleApp.ParentID = Guid.Empty; roleApp.RoleID = role.ID; roleApp.Sort = 1; roleApp.Title = "管理目录"; new RoadFlow.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"]; RoadFlow.Data.Model.Role role = new RoadFlow.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; RoadFlow.Platform.UsersRole busersRole = new RoadFlow.Platform.UsersRole(); var users = new RoadFlow.Platform.Organize().GetAllUsers(useMember); foreach (var user in users) { RoadFlow.Data.Model.UsersRole ur = new RoadFlow.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 RoadFlow.Platform.Role().Add(role); //添加一个根应用 RoadFlow.Data.Model.RoleApp roleApp = new RoadFlow.Data.Model.RoleApp(); roleApp.ID = Guid.NewGuid(); roleApp.ParentID = Guid.Empty; roleApp.RoleID = role.ID; roleApp.Sort = 1; roleApp.Title = "管理目录"; new RoadFlow.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="userID"></param> /// <param name="parentID">上级ID</param> /// <param name="appList"></param> public void AppendUserApps(Guid userID, Guid parentID, List <RoadFlow.Data.Model.RoleApp> appList) { var userApps = GetUserDataRows(userID); foreach (var userApp in userApps) { if (userApp["ParentID"].ToString().ToGuid() == parentID) { RoadFlow.Data.Model.RoleApp app = new RoadFlow.Data.Model.RoleApp(); app.ID = userApp["ID"].ToString().ToGuid(); app.AppID = userApp["AppID"].ToString().ToGuid(); app.Ico = userApp["Ico"].ToString(); app.Params = userApp["Params"].ToString(); app.ParentID = userApp["ParentID"].ToString().ToGuid(); app.RoleID = userApp["RoleID"].ToString().ToGuid(); app.Sort = userApp["Sort"].ToString().ToInt(); app.Title = userApp["Title"].ToString(); app.Type = 1; appList.Add(app); } } }
protected void Page_Load(object sender, EventArgs e) { query = "&id=" + Request.QueryString["id"] + "&appid=" + Request.QueryString["appid"] + "&roleid=" + Request.QueryString["roleid"] + "&userid=" + Request.QueryString["userid"]; string id = Request.QueryString["id"]; Guid appID; if (id.IsGuid(out appID)) { roleApp = broleApp.Get(appID); if (roleApp != null) { name = roleApp.Title; type = roleApp.AppID.HasValue ? bappLibrary.GetTypeByID(roleApp.AppID.Value) : ""; appid = roleApp.AppID.ToString(); params1 = roleApp.Params; ico = roleApp.Ico; parentID = roleApp.ParentID; } } AppID = appid; AppTypesOptions = bappLibrary.GetTypeOptions(type); }
public ActionResult Body(FormCollection collection) { RoadFlow.Platform.AppLibraryBLL bappLibrary = new RoadFlow.Platform.AppLibraryBLL(); RoadFlow.Platform.RoleApp broleApp = new RoadFlow.Platform.RoleApp(); RoadFlow.Data.Model.RoleApp roleApp = null; string id = Request.QueryString["id"]; string name = string.Empty; string type = string.Empty; string appid = string.Empty; string params1 = string.Empty; string ico = string.Empty; Guid appID; if (id.IsGuid(out appID)) { roleApp = broleApp.Get(appID); } if (!Request.Form["Save"].IsNullOrEmpty()) { name = Request.Form["Name"]; type = Request.Form["Type"]; appid = Request.Form["AppID"]; params1 = Request.Form["Params"]; ico = Request.Form["Ico"]; string oldXML = roleApp.Serialize(); roleApp.Title = name.Trim(); if (appid.IsGuid()) { roleApp.AppID = appid.Convert <Guid>(); } else { roleApp.AppID = null; } roleApp.Params = params1.IsNullOrEmpty() ? null : params1.Trim(); if (!ico.IsNullOrEmpty()) { roleApp.Ico = ico; } else { roleApp.Ico = null; } broleApp.Update(roleApp); broleApp.ClearAllDataTableCache(); RoadFlow.Platform.Log.Add("修改了应用模板", "", RoadFlow.Platform.Log.Types.角色应用, oldXML, roleApp.Serialize()); string refreshID = roleApp.ParentID == Guid.Empty ? roleApp.ID.ToString() : roleApp.ParentID.ToString(); ViewBag.Script = "parent.frames[0].reLoad('" + refreshID + "');alert('保存成功!');"; } if (!Request.Form["Delete"].IsNullOrEmpty()) { int i = broleApp.DeleteAndAllChilds(roleApp.ID); broleApp.ClearAllDataTableCache(); RoadFlow.Platform.Log.Add("删除了模板及其所有下级共" + i.ToString() + "项", roleApp.Serialize(), RoadFlow.Platform.Log.Types.角色应用); string refreshID = roleApp.ParentID == Guid.Empty ? roleApp.ID.ToString() : roleApp.ParentID.ToString(); ViewBag.Script = "parent.frames[0].reLoad('" + refreshID + "');window.location='Body?id=" + refreshID + "&appid=" + Request.QueryString["appid"] + "&tabid=" + Request.QueryString["tabid"] + "';"; } if (roleApp != null && roleApp.AppID.HasValue) { var app = new RoadFlow.Platform.AppLibraryBLL().Get(roleApp.AppID.Value); if (app != null) { type = app.Type.ToString(); } } ViewBag.AppTypesOptions = bappLibrary.GetTypeOptions(type); ViewBag.AppID = roleApp.AppID.ToString(); return(View(roleApp)); }
protected void Page_Load(object sender, EventArgs e) { RoadFlow.Platform.AppLibrary bappLibrary = new RoadFlow.Platform.AppLibrary(); RoadFlow.Platform.RoleApp broleApp = new RoadFlow.Platform.RoleApp(); string id = Request.QueryString["id"]; string name = string.Empty; string type = string.Empty; string appid = string.Empty; string params1 = string.Empty; string ico = string.Empty; Guid appID; if (id.IsGuid(out appID)) { roleApp = broleApp.Get(appID); } if (IsPostBack) { if (!Request.Form["Save"].IsNullOrEmpty()) { name = Request.Form["Name"]; type = Request.Form["Type"]; appid = Request.Form["AppID"]; params1 = Request.Form["Params"]; ico = Request.Form["Ico"]; string oldXML = roleApp.Serialize(); roleApp.Title = name.Trim(); if (appid.IsGuid()) { roleApp.AppID = appid.ToGuid(); } else { roleApp.AppID = null; } roleApp.Params = params1.IsNullOrEmpty() ? null : params1.Trim(); if (!ico.IsNullOrEmpty()) { roleApp.Ico = ico; } else { roleApp.Ico = null; } broleApp.Update(roleApp); broleApp.ClearAllDataTableCache(); RoadFlow.Platform.Log.Add("修改了应用模板", "", RoadFlow.Platform.Log.Types.角色应用, oldXML, roleApp.Serialize()); string refreshID = roleApp.ParentID == Guid.Empty ? roleApp.ID.ToString() : roleApp.ParentID.ToString(); Page.ClientScript.RegisterStartupScript(Page.GetType(), "ok", "parent.frames[0].reLoad('" + refreshID + "');alert('保存成功!');", true); } if (!Request.Form["Delete"].IsNullOrEmpty()) { int i = broleApp.DeleteAndAllChilds(roleApp.ID); broleApp.ClearAllDataTableCache(); RoadFlow.Platform.Log.Add("删除了模板及其所有下级共" + i.ToString() + "项", roleApp.Serialize(), RoadFlow.Platform.Log.Types.角色应用); string refreshID = roleApp.ParentID == Guid.Empty ? roleApp.ID.ToString() : roleApp.ParentID.ToString(); Page.ClientScript.RegisterStartupScript(Page.GetType(), "ok", "parent.frames[0].reLoad('" + refreshID + "');window.location='Body.aspx?id=" + refreshID + "&appid=" + Request.QueryString["appid"] + "&tabid=" + Request.QueryString["tabid"] + "';", true); } } if (roleApp != null && roleApp.AppID.HasValue) { var app = new RoadFlow.Platform.AppLibrary().Get(roleApp.AppID.Value); if (app != null) { type = app.Type.ToString(); } } if (roleApp != null) { this.Name.Value = roleApp.Title; this.Params.Value = roleApp.Params; this.Ico.Value = roleApp.Ico; } this.AppTypesOptions.Text = bappLibrary.GetTypeOptions(type); AppID = roleApp.AppID.ToString(); }
/// <summary> /// 更新 /// </summary> public int Update(RoadFlow.Data.Model.RoleApp model) { return(dataRoleApp.Update(model)); }
/// <summary> /// 新增 /// </summary> public int Add(RoadFlow.Data.Model.RoleApp model) { return(dataRoleApp.Add(model)); }