public ActionResult ButtionsEdit(FormCollection collection) { RoadFlow.Data.Model.AppLibraryButtons appLibraryButtons = null; RoadFlow.Platform.AppLibraryButtons appLibraryButtons2 = new RoadFlow.Platform.AppLibraryButtons(); string str = base.Request.QueryString["butid"]; if (str.IsGuid()) { appLibraryButtons = appLibraryButtons2.Get(str.ToGuid()); } if (collection != null) { string str2 = base.Request.Form["Name"]; string events = base.Request.Form["Events"]; string ico = base.Request.Form["Ico"]; string note = base.Request.Form["Note"]; string str3 = base.Request.Form["Sort"]; bool flag = false; string oldXML = string.Empty; if (appLibraryButtons == null) { flag = true; appLibraryButtons = new RoadFlow.Data.Model.AppLibraryButtons(); appLibraryButtons.ID = Guid.NewGuid(); } else { oldXML = appLibraryButtons.Serialize(); } appLibraryButtons.Name = str2.Trim1(); appLibraryButtons.Events = events; appLibraryButtons.Ico = ico; appLibraryButtons.Note = note; appLibraryButtons.Sort = str3.ToInt(); if (flag) { appLibraryButtons2.Add(appLibraryButtons); RoadFlow.Platform.Log.Add("添加了按钮", appLibraryButtons.Serialize(), RoadFlow.Platform.Log.Types.系统管理); } else { appLibraryButtons2.Update(appLibraryButtons); RoadFlow.Platform.Log.Add("修改了按钮", appLibraryButtons.Serialize(), RoadFlow.Platform.Log.Types.系统管理, oldXML); } base.ViewBag.Script = "alert('保存成功!');new RoadUI.Window().getOpenerWindow().query();new RoadUI.Window().close();"; } string text = "&appid=" + base.Request.QueryString["appid"] + "&tabid=" + base.Request.QueryString["tabid"] + "&title="; base.ViewBag.Query = text; if (appLibraryButtons == null) { appLibraryButtons = new RoadFlow.Data.Model.AppLibraryButtons(); appLibraryButtons.Sort = appLibraryButtons2.GetMaxSort(); } return(View(appLibraryButtons)); }
public string ButtionsDelete() { RoadFlow.Platform.AppLibraryButtons appLibraryButtons = new RoadFlow.Platform.AppLibraryButtons(); string[] array = (base.Request.Form["ids"] ?? "").Split(','); foreach (string str in array) { RoadFlow.Data.Model.AppLibraryButtons appLibraryButtons2 = appLibraryButtons.Get(str.ToGuid()); if (appLibraryButtons2 != null) { appLibraryButtons.Delete(appLibraryButtons2.ID); RoadFlow.Platform.Log.Add("删除了按钮", appLibraryButtons2.Serialize(), RoadFlow.Platform.Log.Types.系统管理); } } return("删除成功!"); }
public int Update(RoadFlow.Data.Model.AppLibraryButtons model) { string sql = "UPDATE AppLibraryButtons SET \r\n\t\t\t\tName=@Name,Events=@Events,Ico=@Ico,Sort=@Sort,Note=@Note\r\n\t\t\t\tWHERE ID=@ID"; SqlParameter[] parameter = new SqlParameter[6] { new SqlParameter("@Name", SqlDbType.NVarChar, 100) { Value = model.Name }, new SqlParameter("@Events", SqlDbType.VarChar, 5000) { Value = model.Events }, (model.Ico == null) ? new SqlParameter("@Ico", SqlDbType.VarChar, 5000) { Value = DBNull.Value } : new SqlParameter("@Ico", SqlDbType.VarChar, 5000) { Value = model.Ico }, new SqlParameter("@Sort", SqlDbType.Int, -1) { Value = model.Sort }, (model.Note == null) ? new SqlParameter("@Note", SqlDbType.NVarChar, 1000) { Value = DBNull.Value } : new SqlParameter("@Note", SqlDbType.NVarChar, 1000) { Value = model.Note }, new SqlParameter("@ID", SqlDbType.UniqueIdentifier, -1) { Value = model.ID } }; return(dbHelper.Execute(sql, parameter)); }
public int Add(RoadFlow.Data.Model.AppLibraryButtons model) { string sql = "INSERT INTO AppLibraryButtons\r\n\t\t\t\t(ID,Name,Events,Ico,Sort,Note) \r\n\t\t\t\tVALUES(@ID,@Name,@Events,@Ico,@Sort,@Note)"; SqlParameter[] parameter = new SqlParameter[6] { new SqlParameter("@ID", SqlDbType.UniqueIdentifier, -1) { Value = model.ID }, new SqlParameter("@Name", SqlDbType.NVarChar, 100) { Value = model.Name }, new SqlParameter("@Events", SqlDbType.VarChar, 5000) { Value = model.Events }, (model.Ico == null) ? new SqlParameter("@Ico", SqlDbType.VarChar, 5000) { Value = DBNull.Value } : new SqlParameter("@Ico", SqlDbType.VarChar, 5000) { Value = model.Ico }, new SqlParameter("@Sort", SqlDbType.Int, -1) { Value = model.Sort }, (model.Note == null) ? new SqlParameter("@Note", SqlDbType.NVarChar, 1000) { Value = DBNull.Value } : new SqlParameter("@Note", SqlDbType.NVarChar, 1000) { Value = model.Note } }; return(dbHelper.Execute(sql, parameter)); }
private List <RoadFlow.Data.Model.AppLibraryButtons> DataReaderToList(OracleDataReader dataReader) { List <RoadFlow.Data.Model.AppLibraryButtons> list = new List <RoadFlow.Data.Model.AppLibraryButtons>(); RoadFlow.Data.Model.AppLibraryButtons appLibraryButtons = null; while (((DbDataReader)dataReader).Read()) { appLibraryButtons = new RoadFlow.Data.Model.AppLibraryButtons(); appLibraryButtons.ID = ((DbDataReader)dataReader).GetString(0).ToGuid(); appLibraryButtons.Name = ((DbDataReader)dataReader).GetString(1); appLibraryButtons.Events = ((DbDataReader)dataReader).GetString(2); if (!((DbDataReader)dataReader).IsDBNull(3)) { appLibraryButtons.Ico = ((DbDataReader)dataReader).GetString(3); } appLibraryButtons.Sort = ((DbDataReader)dataReader).GetInt32(4); if (!((DbDataReader)dataReader).IsDBNull(5)) { appLibraryButtons.Note = ((DbDataReader)dataReader).GetString(5); } list.Add(appLibraryButtons); } return(list); }
private List <RoadFlow.Data.Model.AppLibraryButtons> DataReaderToList(SqlDataReader dataReader) { List <RoadFlow.Data.Model.AppLibraryButtons> list = new List <RoadFlow.Data.Model.AppLibraryButtons>(); RoadFlow.Data.Model.AppLibraryButtons appLibraryButtons = null; while (dataReader.Read()) { appLibraryButtons = new RoadFlow.Data.Model.AppLibraryButtons(); appLibraryButtons.ID = dataReader.GetGuid(0); appLibraryButtons.Name = dataReader.GetString(1); appLibraryButtons.Events = dataReader.GetString(2); if (!dataReader.IsDBNull(3)) { appLibraryButtons.Ico = dataReader.GetString(3); } appLibraryButtons.Sort = dataReader.GetInt32(4); if (!dataReader.IsDBNull(5)) { appLibraryButtons.Note = dataReader.GetString(5); } list.Add(appLibraryButtons); } return(list); }
public int Update(RoadFlow.Data.Model.AppLibraryButtons model) { //IL_0015: Unknown result type (might be due to invalid IL or missing references) //IL_001a: Unknown result type (might be due to invalid IL or missing references) //IL_0026: Expected O, but got Unknown //IL_0027: Expected O, but got Unknown //IL_0030: Unknown result type (might be due to invalid IL or missing references) //IL_0035: Unknown result type (might be due to invalid IL or missing references) //IL_0041: Expected O, but got Unknown //IL_0042: Expected O, but got Unknown //IL_0053: Unknown result type (might be due to invalid IL or missing references) //IL_0058: Unknown result type (might be due to invalid IL or missing references) //IL_0064: Expected O, but got Unknown //IL_006d: Unknown result type (might be due to invalid IL or missing references) //IL_0072: Unknown result type (might be due to invalid IL or missing references) //IL_007d: Expected O, but got Unknown //IL_007e: Expected O, but got Unknown //IL_0087: Unknown result type (might be due to invalid IL or missing references) //IL_008c: Unknown result type (might be due to invalid IL or missing references) //IL_009d: Expected O, but got Unknown //IL_009e: Expected O, but got Unknown //IL_00af: Unknown result type (might be due to invalid IL or missing references) //IL_00b4: Unknown result type (might be due to invalid IL or missing references) //IL_00c0: Expected O, but got Unknown //IL_00c9: Unknown result type (might be due to invalid IL or missing references) //IL_00ce: Unknown result type (might be due to invalid IL or missing references) //IL_00d9: Expected O, but got Unknown //IL_00da: Expected O, but got Unknown //IL_00e3: Unknown result type (might be due to invalid IL or missing references) //IL_00e8: Unknown result type (might be due to invalid IL or missing references) //IL_00f9: Expected O, but got Unknown //IL_00fa: Expected O, but got Unknown string sql = "UPDATE AppLibraryButtons SET \r\n\t\t\t\tName=:Name,Events=:Events,Ico=:Ico,Sort=:Sort,Note=:Note\r\n\t\t\t\tWHERE ID=:ID"; OracleParameter[] obj = new OracleParameter[6]; OracleParameter val = new OracleParameter(":Name", 126); ((DbParameter)val).Value = model.Name; obj[0] = val; OracleParameter val2 = new OracleParameter(":Events", 126); ((DbParameter)val2).Value = model.Events; obj[1] = val2; _003F val3; if (model.Ico != null) { val3 = new OracleParameter(":Ico", 126); ((DbParameter)val3).Value = model.Ico; } else { val3 = new OracleParameter(":Ico", 126); ((DbParameter)val3).Value = DBNull.Value; } obj[2] = val3; OracleParameter val4 = new OracleParameter(":Sort", 112); ((DbParameter)val4).Value = model.Sort; obj[3] = val4; _003F val5; if (model.Note != null) { val5 = new OracleParameter(":Note", 126); ((DbParameter)val5).Value = model.Note; } else { val5 = new OracleParameter(":Note", 126); ((DbParameter)val5).Value = DBNull.Value; } obj[4] = val5; OracleParameter val6 = new OracleParameter(":ID", 126); ((DbParameter)val6).Value = model.ID; obj[5] = val6; OracleParameter[] parameter = (OracleParameter[])obj; return(dbHelper.Execute(sql, parameter)); }
public int Add(RoadFlow.Data.Model.AppLibraryButtons model) { //IL_0015: Unknown result type (might be due to invalid IL or missing references) //IL_001a: Unknown result type (might be due to invalid IL or missing references) //IL_002b: Expected O, but got Unknown //IL_002c: Expected O, but got Unknown //IL_0035: Unknown result type (might be due to invalid IL or missing references) //IL_003a: Unknown result type (might be due to invalid IL or missing references) //IL_0046: Expected O, but got Unknown //IL_0047: Expected O, but got Unknown //IL_0050: Unknown result type (might be due to invalid IL or missing references) //IL_0055: Unknown result type (might be due to invalid IL or missing references) //IL_0061: Expected O, but got Unknown //IL_0062: Expected O, but got Unknown //IL_0073: Unknown result type (might be due to invalid IL or missing references) //IL_0078: Unknown result type (might be due to invalid IL or missing references) //IL_0084: Expected O, but got Unknown //IL_008d: Unknown result type (might be due to invalid IL or missing references) //IL_0092: Unknown result type (might be due to invalid IL or missing references) //IL_009d: Expected O, but got Unknown //IL_009e: Expected O, but got Unknown //IL_00a7: Unknown result type (might be due to invalid IL or missing references) //IL_00ac: Unknown result type (might be due to invalid IL or missing references) //IL_00bd: Expected O, but got Unknown //IL_00be: Expected O, but got Unknown //IL_00cf: Unknown result type (might be due to invalid IL or missing references) //IL_00d4: Unknown result type (might be due to invalid IL or missing references) //IL_00e0: Expected O, but got Unknown //IL_00e9: Unknown result type (might be due to invalid IL or missing references) //IL_00ee: Unknown result type (might be due to invalid IL or missing references) //IL_00f9: Expected O, but got Unknown //IL_00fa: Expected O, but got Unknown string sql = "INSERT INTO AppLibraryButtons\r\n\t\t\t\t(ID,Name,Events,Ico,Sort,Note) \r\n\t\t\t\tVALUES(:ID,:Name,:Events,:Ico,:Sort,:Note)"; OracleParameter[] obj = new OracleParameter[6]; OracleParameter val = new OracleParameter(":ID", 126); ((DbParameter)val).Value = model.ID; obj[0] = val; OracleParameter val2 = new OracleParameter(":Name", 126); ((DbParameter)val2).Value = model.Name; obj[1] = val2; OracleParameter val3 = new OracleParameter(":Events", 126); ((DbParameter)val3).Value = model.Events; obj[2] = val3; _003F val4; if (model.Ico != null) { val4 = new OracleParameter(":Ico", 126); ((DbParameter)val4).Value = model.Ico; } else { val4 = new OracleParameter(":Ico", 126); ((DbParameter)val4).Value = DBNull.Value; } obj[3] = val4; OracleParameter val5 = new OracleParameter(":Sort", 112); ((DbParameter)val5).Value = model.Sort; obj[4] = val5; _003F val6; if (model.Note != null) { val6 = new OracleParameter(":Note", 126); ((DbParameter)val6).Value = model.Note; } else { val6 = new OracleParameter(":Note", 126); ((DbParameter)val6).Value = DBNull.Value; } obj[5] = val6; OracleParameter[] parameter = (OracleParameter[])obj; return(dbHelper.Execute(sql, parameter)); }
public int Update(RoadFlow.Data.Model.AppLibraryButtons model) { return(dataAppLibraryButtons.Update(model)); }
public int Add(RoadFlow.Data.Model.AppLibraryButtons model) { return(dataAppLibraryButtons.Add(model)); }