/// <summary> /// 将DataRedar转换为List /// </summary> private List <BizProcess.Data.Model.UsersApp> DataReaderToList(OracleDataReader dataReader) { List <BizProcess.Data.Model.UsersApp> List = new List <BizProcess.Data.Model.UsersApp>(); BizProcess.Data.Model.UsersApp model = null; while (dataReader.Read()) { model = new BizProcess.Data.Model.UsersApp(); model.ID = dataReader.GetString(0).ToGuid(); model.UserID = dataReader.GetString(1).ToGuid(); model.ParentID = dataReader.GetString(2).ToGuid(); model.RoleID = dataReader.GetString(3).ToGuid(); if (!dataReader.IsDBNull(4)) { model.AppID = dataReader.GetString(4).ToGuid(); } 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">BizProcess.Data.Model.UsersApp实体类</param> public int Update(BizProcess.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" ; OracleParameter[] parameters = new OracleParameter[] { new OracleParameter(":UserID", OracleDbType.Char, 36) { Value = model.UserID }, new OracleParameter(":ParentID", OracleDbType.Char, 36) { Value = model.ParentID }, new OracleParameter(":RoleID", OracleDbType.Char, 36) { Value = model.RoleID }, model.AppID == null ? new OracleParameter(":AppID", OracleDbType.Char, 36) { Value = DBNull.Value } : new OracleParameter(":AppID", OracleDbType.Char, 36) { Value = model.AppID }, model.Title == null ? new OracleParameter(":Title", OracleDbType.NVarchar2, 400) { Value = DBNull.Value } : new OracleParameter(":Title", OracleDbType.NVarchar2, 400) { Value = model.Title }, model.Params == null ? new OracleParameter(":Params", OracleDbType.Varchar2, 500) { Value = DBNull.Value } : new OracleParameter(":Params", OracleDbType.Varchar2, 500) { Value = model.Params }, model.Ico == null ? new OracleParameter(":Ico", OracleDbType.Varchar2, 500) { Value = DBNull.Value } : new OracleParameter(":Ico", OracleDbType.Varchar2, 500) { Value = model.Ico }, new OracleParameter(":Sort", OracleDbType.Int32) { Value = model.Sort }, new OracleParameter(":ID", OracleDbType.Char, 36) { Value = model.ID } }; return(dbHelper.Execute(sql, parameters)); }
/// <summary> /// 添加记录 /// </summary> /// <param name="model">BizProcess.Data.Model.UsersApp实体类</param> /// <returns>操作所影响的行数</returns> public int Add(BizProcess.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)" ; OracleParameter[] parameters = new OracleParameter[] { new OracleParameter(":ID", OracleDbType.Char, 36) { Value = model.ID }, new OracleParameter(":UserID", OracleDbType.Char, 36) { Value = model.UserID }, new OracleParameter(":ParentID", OracleDbType.Char, 36) { Value = model.ParentID }, new OracleParameter(":RoleID", OracleDbType.Char, 36) { Value = model.RoleID }, model.AppID == null ? new OracleParameter(":AppID", OracleDbType.Char, 36) { Value = DBNull.Value } : new OracleParameter(":AppID", OracleDbType.Char, 36) { Value = model.AppID }, model.Title == null ? new OracleParameter(":Title", OracleDbType.NVarchar2, 400) { Value = DBNull.Value } : new OracleParameter(":Title", OracleDbType.NVarchar2, 400) { Value = model.Title }, model.Params == null ? new OracleParameter(":Params", OracleDbType.Varchar2, 500) { Value = DBNull.Value } : new OracleParameter(":Params", OracleDbType.Varchar2, 500) { Value = model.Params }, model.Ico == null ? new OracleParameter(":Ico", OracleDbType.Varchar2, 500) { Value = DBNull.Value } : new OracleParameter(":Ico", OracleDbType.Varchar2, 500) { Value = model.Ico }, new OracleParameter(":Sort", OracleDbType.Int32) { Value = model.Sort } }; return(dbHelper.Execute(sql, parameters)); }
/// <summary> /// 更新记录 /// </summary> /// <param name="model">BizProcess.Data.Model.UsersApp实体类</param> public int Update(BizProcess.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" ; MySqlParameter[] parameters = new MySqlParameter[] { new MySqlParameter("@UserID", MySqlDbType.VarChar, 36) { Value = model.UserID }, new MySqlParameter("@ParentID", MySqlDbType.VarChar, 36) { Value = model.ParentID }, new MySqlParameter("@RoleID", MySqlDbType.VarChar, 36) { Value = model.RoleID }, model.AppID == null ? new MySqlParameter("@AppID", MySqlDbType.VarChar, 36) { Value = DBNull.Value } : new MySqlParameter("@AppID", MySqlDbType.VarChar, 36) { Value = model.AppID }, model.Title == null ? new MySqlParameter("@Title", MySqlDbType.VarChar, 200) { Value = DBNull.Value } : new MySqlParameter("@Title", MySqlDbType.VarChar, 200) { Value = model.Title }, model.Params == null ? new MySqlParameter("@Params", MySqlDbType.VarChar, 500) { Value = DBNull.Value } : new MySqlParameter("@Params", MySqlDbType.VarChar, 500) { Value = model.Params }, model.Ico == null ? new MySqlParameter("@Ico", MySqlDbType.VarChar, 500) { Value = DBNull.Value } : new MySqlParameter("@Ico", MySqlDbType.VarChar, 500) { Value = model.Ico }, new MySqlParameter("@Sort", MySqlDbType.Int32, -1) { Value = model.Sort }, new MySqlParameter("@ID", MySqlDbType.VarChar, 36) { Value = model.ID } }; return(dbHelper.Execute(sql, parameters)); }
/// <summary> /// 添加记录 /// </summary> /// <param name="model">BizProcess.Data.Model.UsersApp实体类</param> /// <returns>操作所影响的行数</returns> public int Add(BizProcess.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)" ; MySqlParameter[] parameters = new MySqlParameter[] { new MySqlParameter("@ID", MySqlDbType.VarChar, 36) { Value = model.ID }, new MySqlParameter("@UserID", MySqlDbType.VarChar, 36) { Value = model.UserID }, new MySqlParameter("@ParentID", MySqlDbType.VarChar, 36) { Value = model.ParentID }, new MySqlParameter("@RoleID", MySqlDbType.VarChar, 36) { Value = model.RoleID }, model.AppID == null ? new MySqlParameter("@AppID", MySqlDbType.VarChar, 36) { Value = DBNull.Value } : new MySqlParameter("@AppID", MySqlDbType.VarChar, 36) { Value = model.AppID }, model.Title == null ? new MySqlParameter("@Title", MySqlDbType.VarChar, 200) { Value = DBNull.Value } : new MySqlParameter("@Title", MySqlDbType.VarChar, 200) { Value = model.Title }, model.Params == null ? new MySqlParameter("@Params", MySqlDbType.VarChar, 500) { Value = DBNull.Value } : new MySqlParameter("@Params", MySqlDbType.VarChar, 500) { Value = model.Params }, model.Ico == null ? new MySqlParameter("@Ico", MySqlDbType.VarChar, 500) { Value = DBNull.Value } : new MySqlParameter("@Ico", MySqlDbType.VarChar, 500) { Value = model.Ico }, new MySqlParameter("@Sort", MySqlDbType.Int32, -1) { Value = model.Sort } }; return(dbHelper.Execute(sql, parameters)); }
public ActionResult AddApp(FormCollection collection) { BizProcess.Platform.AppLibrary bappLibrary = new BizProcess.Platform.AppLibrary(); BizProcess.Platform.UsersApp busersApp = new BizProcess.Platform.UsersApp(); BizProcess.Platform.RoleApp broleApp = new BizProcess.Platform.RoleApp(); BizProcess.Data.Model.UsersApp usersApp = null; string id = Request.QueryString["id"]; string userID = Request.QueryString["userid"]; string roleID = Request.QueryString["roleid"]; if (collection != null && 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"]; BizProcess.Data.Model.UsersApp usersApp1 = new BizProcess.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(); BizProcess.Platform.Log.Add("添加了个人应用", busersApp.Serialize(), BizProcess.Platform.Log.Types.角色应用); string refreshID = id; ViewBag.Script = "alert('添加成功!'); parent.frames[0].reLoad('" + refreshID + "')"; } } ViewBag.AppTypesOptions = bappLibrary.GetTypeOptions(); return(View()); }
/// <summary> /// 更新 /// </summary> public int Update(BizProcess.Data.Model.UsersApp model) { return(dataUsersApp.Update(model)); }
/// <summary> /// 新增 /// </summary> public int Add(BizProcess.Data.Model.UsersApp model) { return(dataUsersApp.Add(model)); }
public ActionResult Body1(FormCollection collection) { BizProcess.Platform.AppLibrary bappLibrary = new BizProcess.Platform.AppLibrary(); BizProcess.Platform.RoleApp broleApp = new BizProcess.Platform.RoleApp(); BizProcess.Platform.UsersApp buserApp = new BizProcess.Platform.UsersApp(); BizProcess.Data.Model.UsersApp usersApp = 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)) { 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; } } if (collection != null && 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(); BizProcess.Platform.Log.Add("修改了个人应用", "", BizProcess.Platform.Log.Types.角色应用, oldXML, usersApp.Serialize()); string refreshID = usersApp.ParentID.ToString(); ViewBag.Script = "alert('保存成功!'); parent.frames[0].reLoad('" + refreshID + "')"; } if (!Request.Form["Delete"].IsNullOrEmpty()) { int i = buserApp.DeleteAndAllChilds(usersApp.ID); buserApp.ClearCache(); BizProcess.Platform.Log.Add("删除了个人应用", usersApp.Serialize(), BizProcess.Platform.Log.Types.角色应用); string refreshID = usersApp.ParentID.ToString(); var parent = buserApp.Get(usersApp.ParentID); string page = parent == null ? "Body" : "Body1"; ViewBag.Script = "parent.frames[0].reLoad('" + refreshID + "');window.location='" + page + "?id=" + refreshID + "&appid=" + Request.QueryString["appid"] + "&tabid=" + Request.QueryString["tabid"] + "&userid=" + Request.QueryString["userid"] + "';"; } } ViewBag.AppID = appid; ViewBag.AppTypesOptions = bappLibrary.GetTypeOptions(type); return(View(usersApp == null ? new BizProcess.Data.Model.UsersApp() : usersApp)); }