public static bool CheckApp(out string msg, string appid = "") { msg = ""; Guid userID = RoadFlow.Platform.Users.CurrentUserID; if (userID.IsEmptyGuid()) { msg = "<script>top.login();</script>"; return(false); } appid = appid.IsNullOrEmpty() ? HttpContext.Current.Request[nameof(appid)] : appid; Guid appGuid; if (!appid.IsGuid(out appGuid)) { return(false); } List <RoadFlow.Data.Model.MenuUser> all1 = new RoadFlow.Platform.MenuUser().GetAll(true); string source; string params1; bool flag = new RoadFlow.Platform.Menu().HasUse(appGuid, userID, all1, out source, out params1, false); if (!flag) { return(false); } string url = HttpContext.Current.Request.ServerVariables["SCRIPT_NAME"].ToString(); if (!url.IsNullOrEmpty()) { url = url.TrimStart('/'); if (!url.IsNullOrEmpty()) { List <RoadFlow.Data.Model.AppLibrarySubPages> all2 = new RoadFlow.Platform.AppLibrarySubPages().GetAll(true).FindAll((Predicate <RoadFlow.Data.Model.AppLibrarySubPages>)(p => p.Address.Contains(url, StringComparison.CurrentCultureIgnoreCase))); if (all2.Count > 0) { foreach (RoadFlow.Data.Model.AppLibrarySubPages appLibrarySubPages in all2) { RoadFlow.Data.Model.AppLibrarySubPages sub = appLibrarySubPages; if (all1.Find((Predicate <RoadFlow.Data.Model.MenuUser>)(p => { if (p.MenuID == appGuid && p.SubPageID == sub.ID) { return(p.Users.Contains(userID.ToString(), StringComparison.CurrentCultureIgnoreCase)); } return(false); })) != null) { return(true); } } return(false); } } } return(flag); }
private List <RoadFlow.Data.Model.AppLibrarySubPages> DataReaderToList(OracleDataReader dataReader) { List <RoadFlow.Data.Model.AppLibrarySubPages> appLibrarySubPagesList = new List <RoadFlow.Data.Model.AppLibrarySubPages>(); while (dataReader.Read()) { RoadFlow.Data.Model.AppLibrarySubPages appLibrarySubPages = new RoadFlow.Data.Model.AppLibrarySubPages(); appLibrarySubPages.ID = dataReader.GetString(0).ToGuid(); appLibrarySubPages.AppLibraryID = dataReader.GetString(1).ToGuid(); appLibrarySubPages.Name = dataReader.GetString(2); appLibrarySubPages.Address = dataReader.GetString(3); if (!dataReader.IsDBNull(4)) { appLibrarySubPages.Ico = dataReader.GetString(4); } appLibrarySubPages.Sort = dataReader.GetInt32(5); if (!dataReader.IsDBNull(6)) { appLibrarySubPages.Note = dataReader.GetString(6); } appLibrarySubPagesList.Add(appLibrarySubPages); } return(appLibrarySubPagesList); }
public int Update(RoadFlow.Data.Model.AppLibrarySubPages model) { string sql = "UPDATE AppLibrarySubPages SET \r\n\t\t\t\tAppLibraryID=:AppLibraryID,Name=:Name,Address=:Address,Ico=:Ico,Sort=:Sort,Note=:Note\r\n\t\t\t\tWHERE ID=:ID"; OracleParameter[] oracleParameterArray = new OracleParameter[7]; int index1 = 0; OracleParameter oracleParameter1 = new OracleParameter(":AppLibraryID", OracleDbType.Varchar2); oracleParameter1.Value = (object)model.AppLibraryID; oracleParameterArray[index1] = oracleParameter1; int index2 = 1; OracleParameter oracleParameter2 = new OracleParameter(":Name", OracleDbType.Varchar2); oracleParameter2.Value = (object)model.Name; oracleParameterArray[index2] = oracleParameter2; int index3 = 2; OracleParameter oracleParameter3 = new OracleParameter(":Address", OracleDbType.Varchar2); oracleParameter3.Value = (object)model.Address; oracleParameterArray[index3] = oracleParameter3; int index4 = 3; OracleParameter oracleParameter4; if (model.Ico != null) { OracleParameter oracleParameter5 = new OracleParameter(":Ico", OracleDbType.Varchar2); oracleParameter5.Value = (object)model.Ico; oracleParameter4 = oracleParameter5; } else { oracleParameter4 = new OracleParameter(":Ico", OracleDbType.Varchar2); oracleParameter4.Value = (object)DBNull.Value; } oracleParameterArray[index4] = oracleParameter4; int index5 = 4; OracleParameter oracleParameter6 = new OracleParameter(":Sort", OracleDbType.Int32); oracleParameter6.Value = (object)model.Sort; oracleParameterArray[index5] = oracleParameter6; int index6 = 5; OracleParameter oracleParameter7; if (model.Note != null) { OracleParameter oracleParameter5 = new OracleParameter(":Note", OracleDbType.Varchar2); oracleParameter5.Value = (object)model.Note; oracleParameter7 = oracleParameter5; } else { oracleParameter7 = new OracleParameter(":Note", OracleDbType.Varchar2); oracleParameter7.Value = (object)DBNull.Value; } oracleParameterArray[index6] = oracleParameter7; int index7 = 6; OracleParameter oracleParameter8 = new OracleParameter(":ID", OracleDbType.Varchar2); oracleParameter8.Value = (object)model.ID; oracleParameterArray[index7] = oracleParameter8; OracleParameter[] parameter = oracleParameterArray; return(this.dbHelper.Execute(sql, parameter)); }
public int Update(RoadFlow.Data.Model.AppLibrarySubPages model) { string sql = "UPDATE AppLibrarySubPages SET \r\n\t\t\t\tAppLibraryID=@AppLibraryID,Name=@Name,Address=@Address,Ico=@Ico,Sort=@Sort,Note=@Note\r\n\t\t\t\tWHERE ID=@ID"; SqlParameter[] sqlParameterArray = new SqlParameter[7]; int index1 = 0; SqlParameter sqlParameter1 = new SqlParameter("@AppLibraryID", SqlDbType.UniqueIdentifier, -1); sqlParameter1.Value = (object)model.AppLibraryID; sqlParameterArray[index1] = sqlParameter1; int index2 = 1; SqlParameter sqlParameter2 = new SqlParameter("@Name", SqlDbType.NVarChar, 1000); sqlParameter2.Value = (object)model.Name; sqlParameterArray[index2] = sqlParameter2; int index3 = 2; SqlParameter sqlParameter3 = new SqlParameter("@Address", SqlDbType.VarChar, 5000); sqlParameter3.Value = (object)model.Address; sqlParameterArray[index3] = sqlParameter3; int index4 = 3; SqlParameter sqlParameter4; if (model.Ico != null) { SqlParameter sqlParameter5 = new SqlParameter("@Ico", SqlDbType.VarChar, 5000); sqlParameter5.Value = (object)model.Ico; sqlParameter4 = sqlParameter5; } else { sqlParameter4 = new SqlParameter("@Ico", SqlDbType.VarChar, 5000); sqlParameter4.Value = (object)DBNull.Value; } sqlParameterArray[index4] = sqlParameter4; int index5 = 4; SqlParameter sqlParameter6 = new SqlParameter("@Sort", SqlDbType.Int, -1); sqlParameter6.Value = (object)model.Sort; sqlParameterArray[index5] = sqlParameter6; int index6 = 5; SqlParameter sqlParameter7; if (model.Note != null) { SqlParameter sqlParameter5 = new SqlParameter("@Note", SqlDbType.NVarChar, 4000); sqlParameter5.Value = (object)model.Note; sqlParameter7 = sqlParameter5; } else { sqlParameter7 = new SqlParameter("@Note", SqlDbType.NVarChar, 4000); sqlParameter7.Value = (object)DBNull.Value; } sqlParameterArray[index6] = sqlParameter7; int index7 = 6; SqlParameter sqlParameter8 = new SqlParameter("@ID", SqlDbType.UniqueIdentifier, -1); sqlParameter8.Value = (object)model.ID; sqlParameterArray[index7] = sqlParameter8; SqlParameter[] parameter = sqlParameterArray; return(this.dbHelper.Execute(sql, parameter, false)); }
public ActionResult SubPageEdit(FormCollection collection) { RoadFlow.Platform.AppLibrarySubPages appLibrarySubPages = new RoadFlow.Platform.AppLibrarySubPages(); RoadFlow.Data.Model.AppLibrarySubPages model1 = (RoadFlow.Data.Model.AppLibrarySubPages)null; string str1 = this.Request.QueryString["subid"]; if (str1.IsGuid()) { model1 = appLibrarySubPages.Get(str1.ToGuid()); } if (collection != null) { string str2 = this.Request.Form["Title"]; string str3 = this.Request.Form["Address"]; bool flag1 = false; if (model1 == null) { model1 = new RoadFlow.Data.Model.AppLibrarySubPages(); flag1 = true; model1.ID = Guid.NewGuid(); model1.AppLibraryID = this.Request.QueryString["id"].ToGuid(); } model1.Name = str2.Trim1(); model1.Address = str3.Trim1(); using (TransactionScope transactionScope = new TransactionScope()) { if (flag1) { appLibrarySubPages.Add(model1); RoadFlow.Platform.Log.Add("添加了子页面", model1.Serialize(), RoadFlow.Platform.Log.Types.菜单权限, "", "", (RoadFlow.Data.Model.Users)null); // ISSUE: reference to a compiler-generated field if (AppLibraryController.\u003C\u003Eo__8.\u003C\u003Ep__0 == null) { // ISSUE: reference to a compiler-generated field AppLibraryController.\u003C\u003Eo__8.\u003C\u003Ep__0 = CallSite <Func <CallSite, object, string, object> > .Create(Binder.SetMember(CSharpBinderFlags.None, "Script", typeof(AppLibraryController), (IEnumerable <CSharpArgumentInfo>) new CSharpArgumentInfo[2] { CSharpArgumentInfo.Create(CSharpArgumentInfoFlags.None, (string)null), CSharpArgumentInfo.Create(CSharpArgumentInfoFlags.UseCompileTimeType, (string)null) })); } // ISSUE: reference to a compiler-generated field // ISSUE: reference to a compiler-generated field object obj = AppLibraryController.\u003C\u003Eo__8.\u003C\u003Ep__0.Target((CallSite)AppLibraryController.\u003C\u003Eo__8.\u003C\u003Ep__0, this.ViewBag, "alert('添加成功!');window.location='SubPages" + this.Request.Url.Query + "';"); } else { appLibrarySubPages.Update(model1); RoadFlow.Platform.Log.Add("修改了子页面", model1.Serialize(), RoadFlow.Platform.Log.Types.菜单权限, "", "", (RoadFlow.Data.Model.Users)null); // ISSUE: reference to a compiler-generated field if (AppLibraryController.\u003C\u003Eo__8.\u003C\u003Ep__1 == null) { // ISSUE: reference to a compiler-generated field AppLibraryController.\u003C\u003Eo__8.\u003C\u003Ep__1 = CallSite <Func <CallSite, object, string, object> > .Create(Binder.SetMember(CSharpBinderFlags.None, "Script", typeof(AppLibraryController), (IEnumerable <CSharpArgumentInfo>) new CSharpArgumentInfo[2] { CSharpArgumentInfo.Create(CSharpArgumentInfoFlags.None, (string)null), CSharpArgumentInfo.Create(CSharpArgumentInfoFlags.UseCompileTimeType, (string)null) })); } // ISSUE: reference to a compiler-generated field // ISSUE: reference to a compiler-generated field object obj = AppLibraryController.\u003C\u003Eo__8.\u003C\u003Ep__1.Target((CallSite)AppLibraryController.\u003C\u003Eo__8.\u003C\u003Ep__1, this.ViewBag, "alert('保存成功!');window.location='SubPages" + this.Request.Url.Query + "';"); } RoadFlow.Platform.AppLibraryButtons1 appLibraryButtons1_1 = new RoadFlow.Platform.AppLibraryButtons1(); string str4 = this.Request.Form["buttonindex"] ?? ""; List <RoadFlow.Data.Model.AppLibraryButtons1> allByAppId = appLibraryButtons1_1.GetAllByAppID(model1.ID); List <RoadFlow.Data.Model.AppLibraryButtons1> appLibraryButtons1List = new List <RoadFlow.Data.Model.AppLibraryButtons1>(); char[] chArray = new char[1] { ',' }; foreach (string str5 in str4.Split(chArray)) { string index = str5; string str6 = this.Request.Form["button_" + index]; string str7 = this.Request.Form["buttonname_" + index]; string str8 = this.Request.Form["buttonevents_" + index]; string str9 = this.Request.Form["buttonico_" + index]; string str10 = this.Request.Form["showtype_" + index]; string str11 = this.Request.Form["buttonsort_" + index]; if (!str7.IsNullOrEmpty() && !str8.IsNullOrEmpty()) { RoadFlow.Data.Model.AppLibraryButtons1 model2 = allByAppId.Find((Predicate <RoadFlow.Data.Model.AppLibraryButtons1>)(p => p.ID == index.ToGuid())); bool flag2 = false; if (model2 == null) { flag2 = true; model2 = new RoadFlow.Data.Model.AppLibraryButtons1(); model2.ID = Guid.NewGuid(); } else { appLibraryButtons1List.Add(model2); } model2.AppLibraryID = model1.ID; if (str6.IsGuid()) { model2.ButtonID = new Guid?(str6.ToGuid()); } model2.Events = str8; model2.Ico = str9; model2.Name = str7.Trim1(); model2.Sort = str11.ToInt(0); model2.ShowType = str10.ToInt(0); model2.Type = 0; if (flag2) { appLibraryButtons1_1.Add(model2); } else { appLibraryButtons1_1.Update(model2); } } } foreach (RoadFlow.Data.Model.AppLibraryButtons1 appLibraryButtons1_2 in allByAppId) { RoadFlow.Data.Model.AppLibraryButtons1 sub1 = appLibraryButtons1_2; if (appLibraryButtons1List.Find((Predicate <RoadFlow.Data.Model.AppLibraryButtons1>)(p => p.ID == sub1.ID)) == null) { appLibraryButtons1_1.Delete(sub1.ID); } } transactionScope.Complete(); appLibraryButtons1_1.ClearCache(); appLibrarySubPages.ClearCache(); } } if (model1 == null) { model1 = new RoadFlow.Data.Model.AppLibrarySubPages(); model1.ID = Guid.Empty; model1.AppLibraryID = this.Request.QueryString["id"].ToGuid(); } return((ActionResult)this.View((object)model1)); }
public ActionResult SubPageEdit(FormCollection collection) { RoadFlow.Platform.AppLibrarySubPages appLibrarySubPages = new RoadFlow.Platform.AppLibrarySubPages(); RoadFlow.Data.Model.AppLibrarySubPages appLibrarySubPages2 = null; string text = base.Request.QueryString["subid"]; if (MyExtensions.IsGuid(text)) { appLibrarySubPages2 = appLibrarySubPages.Get(MyExtensions.ToGuid(text)); } if (collection != null) { string text2 = base.Request.Form["Title"]; string text3 = base.Request.Form["Address"]; bool flag = false; if (appLibrarySubPages2 == null) { appLibrarySubPages2 = new RoadFlow.Data.Model.AppLibrarySubPages(); flag = true; appLibrarySubPages2.ID = Guid.NewGuid(); appLibrarySubPages2.AppLibraryID = MyExtensions.ToGuid(base.Request.QueryString["id"]); } appLibrarySubPages2.Name = MyExtensions.Trim1(text2); appLibrarySubPages2.Address = MyExtensions.Trim1(text3); using (TransactionScope transactionScope = new TransactionScope()) { if (flag) { appLibrarySubPages.Add(appLibrarySubPages2); RoadFlow.Platform.Log.Add("添加了子页面", MyExtensions.Serialize((object)appLibrarySubPages2), RoadFlow.Platform.Log.Types.菜单权限); base.ViewBag.Script = "alert('添加成功!');window.location='SubPages" + base.Request.Url.Query + "';"; } else { appLibrarySubPages.Update(appLibrarySubPages2); RoadFlow.Platform.Log.Add("修改了子页面", MyExtensions.Serialize((object)appLibrarySubPages2), RoadFlow.Platform.Log.Types.菜单权限); base.ViewBag.Script = "alert('保存成功!');window.location='SubPages" + base.Request.Url.Query + "';"; } RoadFlow.Platform.AppLibraryButtons1 appLibraryButtons = new RoadFlow.Platform.AppLibraryButtons1(); string obj = base.Request.Form["buttonindex"] ?? ""; List <RoadFlow.Data.Model.AppLibraryButtons1> allByAppID = appLibraryButtons.GetAllByAppID(appLibrarySubPages2.ID); List <RoadFlow.Data.Model.AppLibraryButtons1> list = new List <RoadFlow.Data.Model.AppLibraryButtons1>(); string[] array = obj.Split(','); foreach (string index in array) { string text4 = base.Request.Form["button_" + index]; string text5 = base.Request.Form["buttonname_" + index]; string text6 = base.Request.Form["buttonevents_" + index]; string ico = base.Request.Form["buttonico_" + index]; string text7 = base.Request.Form["showtype_" + index]; string text8 = base.Request.Form["buttonsort_" + index]; if (!MyExtensions.IsNullOrEmpty(text5) && !MyExtensions.IsNullOrEmpty(text6)) { RoadFlow.Data.Model.AppLibraryButtons1 appLibraryButtons2 = allByAppID.Find((RoadFlow.Data.Model.AppLibraryButtons1 p) => p.ID == MyExtensions.ToGuid(index)); bool flag2 = false; if (appLibraryButtons2 == null) { flag2 = true; appLibraryButtons2 = new RoadFlow.Data.Model.AppLibraryButtons1(); appLibraryButtons2.ID = Guid.NewGuid(); } else { list.Add(appLibraryButtons2); } appLibraryButtons2.AppLibraryID = appLibrarySubPages2.ID; if (MyExtensions.IsGuid(text4)) { appLibraryButtons2.ButtonID = MyExtensions.ToGuid(text4); } appLibraryButtons2.Events = text6; appLibraryButtons2.Ico = ico; appLibraryButtons2.Name = MyExtensions.Trim1(text5); appLibraryButtons2.Sort = MyExtensions.ToInt(text8, 0); appLibraryButtons2.ShowType = MyExtensions.ToInt(text7, 0); appLibraryButtons2.Type = 0; if (flag2) { appLibraryButtons.Add(appLibraryButtons2); } else { appLibraryButtons.Update(appLibraryButtons2); } } } foreach (RoadFlow.Data.Model.AppLibraryButtons1 item in allByAppID) { if (list.Find((RoadFlow.Data.Model.AppLibraryButtons1 p) => p.ID == item.ID) == null) { appLibraryButtons.Delete(item.ID); } } transactionScope.Complete(); appLibraryButtons.ClearCache(); appLibrarySubPages.ClearCache(); } } if (appLibrarySubPages2 == null) { appLibrarySubPages2 = new RoadFlow.Data.Model.AppLibrarySubPages(); appLibrarySubPages2.ID = Guid.Empty; appLibrarySubPages2.AppLibraryID = MyExtensions.ToGuid(base.Request.QueryString["id"]); } return(View(appLibrarySubPages2)); }
public int Update(RoadFlow.Data.Model.AppLibrarySubPages model) { string sql = "UPDATE applibrarysubpages SET \r\n\t\t\t\tAppLibraryID=@AppLibraryID,Name=@Name,Address=@Address,Ico=@Ico,Sort=@Sort,Note=@Note\r\n\t\t\t\tWHERE ID=@ID"; MySqlParameter[] mySqlParameterArray = new MySqlParameter[7]; int index1 = 0; MySqlParameter mySqlParameter1 = new MySqlParameter("@AppLibraryID", MySqlDbType.VarChar, 36); mySqlParameter1.Value = (object)model.AppLibraryID; mySqlParameterArray[index1] = mySqlParameter1; int index2 = 1; MySqlParameter mySqlParameter2 = new MySqlParameter("@Name", MySqlDbType.Text, -1); mySqlParameter2.Value = (object)model.Name; mySqlParameterArray[index2] = mySqlParameter2; int index3 = 2; MySqlParameter mySqlParameter3 = new MySqlParameter("@Address", MySqlDbType.Text, -1); mySqlParameter3.Value = (object)model.Address; mySqlParameterArray[index3] = mySqlParameter3; int index4 = 3; MySqlParameter mySqlParameter4; if (model.Ico != null) { MySqlParameter mySqlParameter5 = new MySqlParameter("@Ico", MySqlDbType.Text, -1); mySqlParameter5.Value = (object)model.Ico; mySqlParameter4 = mySqlParameter5; } else { mySqlParameter4 = new MySqlParameter("@Ico", MySqlDbType.Text, -1); mySqlParameter4.Value = (object)DBNull.Value; } mySqlParameterArray[index4] = mySqlParameter4; int index5 = 4; MySqlParameter mySqlParameter6 = new MySqlParameter("@Sort", MySqlDbType.Int32, 11); mySqlParameter6.Value = (object)model.Sort; mySqlParameterArray[index5] = mySqlParameter6; int index6 = 5; MySqlParameter mySqlParameter7; if (model.Note != null) { MySqlParameter mySqlParameter5 = new MySqlParameter("@Note", MySqlDbType.Text, -1); mySqlParameter5.Value = (object)model.Note; mySqlParameter7 = mySqlParameter5; } else { mySqlParameter7 = new MySqlParameter("@Note", MySqlDbType.Text, -1); mySqlParameter7.Value = (object)DBNull.Value; } mySqlParameterArray[index6] = mySqlParameter7; int index7 = 6; MySqlParameter mySqlParameter8 = new MySqlParameter("@ID", MySqlDbType.VarChar, 36); mySqlParameter8.Value = (object)model.ID; mySqlParameterArray[index7] = mySqlParameter8; MySqlParameter[] parameter = mySqlParameterArray; return(this.dbHelper.Execute(sql, parameter, false)); }
public int Update(RoadFlow.Data.Model.AppLibrarySubPages model) { return(this.dataAppLibrarySubPages.Update(model)); }
public int Add(RoadFlow.Data.Model.AppLibrarySubPages model) { return(this.dataAppLibrarySubPages.Add(model)); }