/// <summary> /// 将DataRedar转换为List /// </summary> private List <FoWoSoft.Data.Model.UsersApp> DataReaderToList(SqlDataReader dataReader) { List <FoWoSoft.Data.Model.UsersApp> List = new List <FoWoSoft.Data.Model.UsersApp>(); FoWoSoft.Data.Model.UsersApp model = null; while (dataReader.Read()) { model = new FoWoSoft.Data.Model.UsersApp(); model.ID = dataReader.GetGuid(0); model.UserID = dataReader.GetGuid(1); model.ParentID = dataReader.GetGuid(2); model.RoleID = dataReader.GetGuid(3); if (!dataReader.IsDBNull(4)) { model.AppID = dataReader.GetGuid(4); } if (!dataReader.IsDBNull(5)) { model.Title = dataReader.GetString(5); } if (!dataReader.IsDBNull(6)) { model.Params = dataReader.GetString(6); } if (!dataReader.IsDBNull(7)) { model.Ico = dataReader.GetString(7); } model.Sort = dataReader.GetInt32(8); List.Add(model); } return(List); }
/// <summary> /// 更新记录 /// </summary> /// <param name="model">FoWoSoft.Data.Model.UsersApp实体类</param> public int Update(FoWoSoft.Data.Model.UsersApp model) { string sql = @"UPDATE UsersApp SET UserID=@UserID,ParentID=@ParentID,RoleID=@RoleID,AppID=@AppID,Title=@Title,Params=@Params,Ico=@Ico,Sort=@Sort WHERE ID=@ID" ; SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@UserID", SqlDbType.UniqueIdentifier, -1) { Value = model.UserID }, 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 }, model.Title == null ? new SqlParameter("@Title", SqlDbType.NVarChar, 400) { Value = DBNull.Value } : new SqlParameter("@Title", SqlDbType.NVarChar, 400) { Value = model.Title }, model.Params == null ? new SqlParameter("@Params", SqlDbType.VarChar, 500) { Value = DBNull.Value } : new SqlParameter("@Params", SqlDbType.VarChar, 500) { Value = model.Params }, model.Ico == null ? new SqlParameter("@Ico", SqlDbType.VarChar, 500) { Value = DBNull.Value } : new SqlParameter("@Ico", SqlDbType.VarChar, 500) { Value = model.Ico }, new SqlParameter("@Sort", SqlDbType.Int, -1) { Value = model.Sort }, new SqlParameter("@ID", SqlDbType.UniqueIdentifier, -1) { Value = model.ID } }; return(dbHelper.Execute(sql, parameters)); }
/// <summary> /// 添加记录 /// </summary> /// <param name="model">FoWoSoft.Data.Model.UsersApp实体类</param> /// <returns>操作所影响的行数</returns> public int Add(FoWoSoft.Data.Model.UsersApp model) { string sql = @"INSERT INTO UsersApp (ID,UserID,ParentID,RoleID,AppID,Title,Params,Ico,Sort) VALUES(@ID,@UserID,@ParentID,@RoleID,@AppID,@Title,@Params,@Ico,@Sort)" ; SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@ID", SqlDbType.UniqueIdentifier, -1) { Value = model.ID }, new SqlParameter("@UserID", SqlDbType.UniqueIdentifier, -1) { Value = model.UserID }, 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 }, model.Title == null ? new SqlParameter("@Title", SqlDbType.NVarChar, 400) { Value = DBNull.Value } : new SqlParameter("@Title", SqlDbType.NVarChar, 400) { Value = model.Title }, model.Params == null ? new SqlParameter("@Params", SqlDbType.VarChar, 500) { Value = DBNull.Value } : new SqlParameter("@Params", SqlDbType.VarChar, 500) { Value = model.Params }, model.Ico == null ? new SqlParameter("@Ico", SqlDbType.VarChar, 500) { Value = DBNull.Value } : new SqlParameter("@Ico", SqlDbType.VarChar, 500) { Value = model.Ico }, new SqlParameter("@Sort", SqlDbType.Int, -1) { Value = model.Sort } }; return(dbHelper.Execute(sql, parameters)); }
protected void Page_Load(object sender, EventArgs e) { FoWoSoft.Platform.AppLibrary bappLibrary = new FoWoSoft.Platform.AppLibrary(); FoWoSoft.Platform.UsersApp busersApp = new FoWoSoft.Platform.UsersApp(); FoWoSoft.Platform.RoleApp broleApp = new FoWoSoft.Platform.RoleApp(); FoWoSoft.Data.Model.UsersApp usersApp = null; string id = Request.QueryString["id"]; string userID = Request.QueryString["userid"]; string roleID = Request.QueryString["roleid"]; if (IsPostBack && id.IsGuid() && userID.IsGuid()) { usersApp = busersApp.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"]; FoWoSoft.Data.Model.UsersApp usersApp1 = new FoWoSoft.Data.Model.UsersApp(); usersApp1.ID = Guid.NewGuid(); usersApp1.ParentID = id.ToGuid(); usersApp1.Title = name.Trim(); usersApp1.Sort = broleApp.GetMaxSort(id.ToGuid()); usersApp1.UserID = userID.ToGuid(); usersApp1.RoleID = roleID.IsGuid() ? roleID.ToGuid() : Guid.Empty; if (appid.IsGuid()) { usersApp1.AppID = appid.ToGuid(); } else { usersApp1.AppID = null; } usersApp1.Params = params1.IsNullOrEmpty() ? null : params1.Trim(); if (!ico.IsNullOrEmpty()) { usersApp1.Ico = ico; } busersApp.Add(usersApp1); busersApp.ClearCache(); FoWoSoft.Platform.Log.Add("添加了个人应用", busersApp.Serialize(), FoWoSoft.Platform.Log.Types.角色应用); string refreshID = id; Page.ClientScript.RegisterStartupScript(Page.GetType(), "ok", "alert('添加成功!'); parent.frames[0].reLoad('" + refreshID + "')", true); } } AppTypesOptions = bappLibrary.GetTypeOptions(); }
/// <summary> /// 更新 /// </summary> public int Update(FoWoSoft.Data.Model.UsersApp model) { return(dataUsersApp.Update(model)); }
/// <summary> /// 新增 /// </summary> public int Add(FoWoSoft.Data.Model.UsersApp model) { return(dataUsersApp.Add(model)); }
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"]; FoWoSoft.Platform.AppLibrary bappLibrary = new FoWoSoft.Platform.AppLibrary(); FoWoSoft.Platform.RoleApp broleApp = new FoWoSoft.Platform.RoleApp(); FoWoSoft.Platform.UsersApp buserApp = new FoWoSoft.Platform.UsersApp(); FoWoSoft.Data.Model.UsersApp usersApp = null; string id = Request.QueryString["id"]; Guid appID; if (id.IsGuid(out appID)) { usersApp = buserApp.Get(appID); if (usersApp != null) { name = usersApp.Title; type = usersApp.AppID.HasValue ? bappLibrary.GetTypeByID(usersApp.AppID.Value) : ""; appid = usersApp.AppID.ToString(); params1 = usersApp.Params; ico = usersApp.Ico; ParentID = usersApp.ParentID; } } if (IsPostBack && usersApp != null) { 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 = usersApp.Serialize(); usersApp.Title = name.Trim(); if (appid.IsGuid()) { usersApp.AppID = appid.ToGuid(); } else { usersApp.AppID = null; } usersApp.Params = params1.IsNullOrEmpty() ? null : params1.Trim(); if (!ico.IsNullOrEmpty()) { usersApp.Ico = ico; } else { usersApp.Ico = null; } buserApp.Update(usersApp); buserApp.ClearCache(); FoWoSoft.Platform.Log.Add("修改了个人应用", "", FoWoSoft.Platform.Log.Types.角色应用, oldXML, usersApp.Serialize()); string refreshID = usersApp.ParentID.ToString(); Page.ClientScript.RegisterStartupScript(Page.GetType(), "ok", "alert('保存成功!'); parent.frames[0].reLoad('" + refreshID + "')", true); } if (!Request.Form["Delete"].IsNullOrEmpty()) { int i = buserApp.DeleteAndAllChilds(usersApp.ID); buserApp.ClearCache(); FoWoSoft.Platform.Log.Add("删除了个人应用", usersApp.Serialize(), FoWoSoft.Platform.Log.Types.角色应用); string refreshID = usersApp.ParentID.ToString(); var parent = buserApp.Get(usersApp.ParentID); string page = parent == null ? "Body.aspx" : "Body1.aspx"; Page.ClientScript.RegisterStartupScript(Page.GetType(), "ok", "parent.frames[0].reLoad('" + refreshID + "');window.location='" + page + "?id=" + refreshID + "&appid=" + Request.QueryString["appid"] + "&tabid=" + Request.QueryString["tabid"] + "&userid=" + Request.QueryString["userid"] + "';", true); } } AppID = appid; AppTypesOptions = bappLibrary.GetTypeOptions(type); }