/// <summary> /// 将DataRedar转换为List /// </summary> private List <RoadFlow.Data.Model.WorkFlowButtons> DataReaderToList(SqlDataReader dataReader) { List <RoadFlow.Data.Model.WorkFlowButtons> List = new List <RoadFlow.Data.Model.WorkFlowButtons>(); RoadFlow.Data.Model.WorkFlowButtons model = null; while (dataReader.Read()) { model = new RoadFlow.Data.Model.WorkFlowButtons(); model.ID = dataReader.GetGuid(0); model.Title = dataReader.GetString(1); if (!dataReader.IsDBNull(2)) { model.Ico = dataReader.GetString(2); } if (!dataReader.IsDBNull(3)) { model.Script = dataReader.GetString(3); } if (!dataReader.IsDBNull(4)) { model.Note = dataReader.GetString(4); } model.Sort = dataReader.GetInt32(5); List.Add(model); } return(List); }
private List <RoadFlow.Data.Model.WorkFlowButtons> DataReaderToList(MySqlDataReader dataReader) { List <RoadFlow.Data.Model.WorkFlowButtons> workFlowButtonsList = new List <RoadFlow.Data.Model.WorkFlowButtons>(); while (dataReader.Read()) { RoadFlow.Data.Model.WorkFlowButtons workFlowButtons = new RoadFlow.Data.Model.WorkFlowButtons(); workFlowButtons.ID = dataReader.GetString(0).ToGuid(); workFlowButtons.Title = dataReader.GetString(1); if (!dataReader.IsDBNull(2)) { workFlowButtons.Ico = dataReader.GetString(2); } if (!dataReader.IsDBNull(3)) { workFlowButtons.Script = dataReader.GetString(3); } if (!dataReader.IsDBNull(4)) { workFlowButtons.Note = dataReader.GetString(4); } workFlowButtons.Sort = dataReader.GetInt32(5); workFlowButtonsList.Add(workFlowButtons); } return(workFlowButtonsList); }
protected void Page_Load(object sender, EventArgs e) { RoadFlow.Platform.WorkFlowButtons bworkFlowButtons = new RoadFlow.Platform.WorkFlowButtons(); RoadFlow.Data.Model.WorkFlowButtons workFlowButton = null; string id = Request.QueryString["id"]; string title = string.Empty; string ico = string.Empty; string script = string.Empty; string note = string.Empty; Guid buttionID; if (id.IsGuid(out buttionID)) { workFlowButton = bworkFlowButtons.Get(buttionID); } string oldXML = workFlowButton.Serialize(); if (IsPostBack) { title = Request.Form["Title1"]; ico = Request.Form["Ico"]; script = Request.Form["Script"]; note = Request.Form["Note"]; bool isAdd = !id.IsGuid(); if (workFlowButton == null) { workFlowButton = new RoadFlow.Data.Model.WorkFlowButtons(); workFlowButton.ID = Guid.NewGuid(); workFlowButton.Sort = bworkFlowButtons.GetMaxSort(); } workFlowButton.Ico = ico.IsNullOrEmpty() ? null : ico.Trim(); workFlowButton.Note = note.IsNullOrEmpty() ? null : note.Trim(); workFlowButton.Script = script.IsNullOrEmpty() ? null : script; workFlowButton.Title = title.Trim(); if (isAdd) { bworkFlowButtons.Add(workFlowButton); RoadFlow.Platform.Log.Add("添加了流程按钮", workFlowButton.Serialize(), RoadFlow.Platform.Log.Types.流程相关); } else { bworkFlowButtons.Update(workFlowButton); RoadFlow.Platform.Log.Add("修改了流程按钮", "", RoadFlow.Platform.Log.Types.流程相关, oldXML, workFlowButton.Serialize()); } bworkFlowButtons.ClearCache(); Page.ClientScript.RegisterStartupScript(Page.GetType(), "ok", "new RoadUI.Window().reloadOpener();alert('保存成功!');new RoadUI.Window().close();", true); } if (workFlowButton != null) { this.Title1.Value = workFlowButton.Title; this.Ico.Value = workFlowButton.Ico; this.Script.Value = workFlowButton.Script; this.Note.Value = workFlowButton.Note; } }
public ActionResult Edit(FormCollection collection) { RoadFlow.Platform.WorkFlowButtons bworkFlowButtons = new RoadFlow.Platform.WorkFlowButtons(); RoadFlow.Data.Model.WorkFlowButtons workFlowButton = null; string id = Request.QueryString["id"]; string title = string.Empty; string ico = string.Empty; string script = string.Empty; string note = string.Empty; Guid buttionID; if (id.IsGuid(out buttionID)) { workFlowButton = bworkFlowButtons.Get(buttionID); } string oldXML = workFlowButton.Serialize(); if (collection != null) { title = Request.Form["Title"]; ico = Request.Form["Ico"]; script = Request.Form["Script"]; note = Request.Form["Note"]; bool isAdd = !id.IsGuid(); if (workFlowButton == null) { workFlowButton = new RoadFlow.Data.Model.WorkFlowButtons(); workFlowButton.ID = Guid.NewGuid(); workFlowButton.Sort = bworkFlowButtons.GetMaxSort(); } workFlowButton.Ico = ico.IsNullOrEmpty() ? null : ico.Trim(); workFlowButton.Note = note.IsNullOrEmpty() ? null : note.Trim(); workFlowButton.Script = script.IsNullOrEmpty() ? null : script; workFlowButton.Title = title.Trim(); if (isAdd) { bworkFlowButtons.Add(workFlowButton); RoadFlow.Platform.Log.Add("添加了流程按钮", workFlowButton.Serialize(), RoadFlow.Platform.Log.Types.流程相关); } else { bworkFlowButtons.Update(workFlowButton); RoadFlow.Platform.Log.Add("修改了流程按钮", "", RoadFlow.Platform.Log.Types.流程相关, oldXML, workFlowButton.Serialize()); } bworkFlowButtons.ClearCache(); ViewBag.Script = "new RoadUI.Window().reloadOpener();alert('保存成功!');new RoadUI.Window().close();"; } return(View(workFlowButton == null ? new RoadFlow.Data.Model.WorkFlowButtons() : workFlowButton)); }
/// <summary> /// 更新记录 /// </summary> /// <param name="model">RoadFlow.Data.Model.WorkFlowButtons实体类</param> public int Update(RoadFlow.Data.Model.WorkFlowButtons model) { string sql = @"UPDATE WorkFlowButtons SET Title=@Title,Ico=@Ico,Script=@Script,Note=@Note,Sort=@Sort WHERE ID=@ID" ; SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@Title", SqlDbType.NVarChar, 1000) { Value = model.Title }, model.Ico == null ? new SqlParameter("@Ico", SqlDbType.VarChar, 500) { Value = DBNull.Value } : new SqlParameter("@Ico", SqlDbType.VarChar, 500) { Value = model.Ico }, model.Script == null ? new SqlParameter("@Script", SqlDbType.VarChar, -1) { Value = DBNull.Value } : new SqlParameter("@Script", SqlDbType.VarChar, -1) { Value = model.Script }, model.Note == null ? new SqlParameter("@Note", SqlDbType.VarChar, -1) { Value = DBNull.Value } : new SqlParameter("@Note", SqlDbType.VarChar, -1) { Value = model.Note }, 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">RoadFlow.Data.Model.WorkFlowButtons实体类</param> /// <returns>操作所影响的行数</returns> public int Add(RoadFlow.Data.Model.WorkFlowButtons model) { string sql = @"INSERT INTO WorkFlowButtons (ID,Title,Ico,Script,Note,Sort) VALUES(@ID,@Title,@Ico,@Script,@Note,@Sort)" ; SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@ID", SqlDbType.UniqueIdentifier, -1) { Value = model.ID }, new SqlParameter("@Title", SqlDbType.NVarChar, 1000) { Value = model.Title }, model.Ico == null ? new SqlParameter("@Ico", SqlDbType.VarChar, 500) { Value = DBNull.Value } : new SqlParameter("@Ico", SqlDbType.VarChar, 500) { Value = model.Ico }, model.Script == null ? new SqlParameter("@Script", SqlDbType.VarChar, -1) { Value = DBNull.Value } : new SqlParameter("@Script", SqlDbType.VarChar, -1) { Value = model.Script }, model.Note == null ? new SqlParameter("@Note", SqlDbType.VarChar, -1) { Value = DBNull.Value } : new SqlParameter("@Note", SqlDbType.VarChar, -1) { Value = model.Note }, new SqlParameter("@Sort", SqlDbType.Int, -1) { Value = model.Sort } }; return(dbHelper.Execute(sql, parameters)); }
/// <summary> /// 更新记录 /// </summary> /// <param name="model">RoadFlow.Data.Model.WorkFlowButtons实体类</param> public int Update(RoadFlow.Data.Model.WorkFlowButtons model) { string sql = @"UPDATE WorkFlowButtons SET Title=:Title,Ico=:Ico,Script=:Script,Note=:Note,Sort=:Sort WHERE ID=:ID" ; OracleParameter[] parameters = new OracleParameter[] { new OracleParameter(":Title", OracleDbType.NVarchar2, 1000) { Value = model.Title }, model.Ico == null ? new OracleParameter(":Ico", OracleDbType.Varchar2, 500) { Value = DBNull.Value } : new OracleParameter(":Ico", OracleDbType.Varchar2, 500) { Value = model.Ico }, model.Script == null ? new OracleParameter(":Script", OracleDbType.Clob) { Value = DBNull.Value } : new OracleParameter(":Script", OracleDbType.Clob) { Value = model.Script }, model.Note == null ? new OracleParameter(":Note", OracleDbType.Clob) { Value = DBNull.Value } : new OracleParameter(":Note", OracleDbType.Clob) { Value = model.Note }, new OracleParameter(":Sort", OracleDbType.Int32) { Value = model.Sort }, new OracleParameter(":ID", OracleDbType.Varchar2, 40) { Value = model.ID } }; return(dbHelper.Execute(sql, parameters)); }
/// <summary> /// 添加记录 /// </summary> /// <param name="model">RoadFlow.Data.Model.WorkFlowButtons实体类</param> /// <returns>操作所影响的行数</returns> public int Add(RoadFlow.Data.Model.WorkFlowButtons model) { string sql = @"INSERT INTO WorkFlowButtons (ID,Title,Ico,Script,Note,Sort) VALUES(:ID,:Title,:Ico,:Script,:Note,:Sort)" ; OracleParameter[] parameters = new OracleParameter[] { new OracleParameter(":ID", OracleDbType.Varchar2, 40) { Value = model.ID }, new OracleParameter(":Title", OracleDbType.NVarchar2, 1000) { Value = model.Title }, model.Ico == null ? new OracleParameter(":Ico", OracleDbType.Varchar2, 500) { Value = DBNull.Value } : new OracleParameter(":Ico", OracleDbType.Varchar2, 500) { Value = model.Ico }, model.Script == null ? new OracleParameter(":Script", OracleDbType.Clob) { Value = DBNull.Value } : new OracleParameter(":Script", OracleDbType.Clob) { Value = model.Script }, model.Note == null ? new OracleParameter(":Note", OracleDbType.Clob) { Value = DBNull.Value } : new OracleParameter(":Note", OracleDbType.Clob) { Value = model.Note }, new OracleParameter(":Sort", OracleDbType.Int32) { Value = model.Sort } }; return(dbHelper.Execute(sql, parameters)); }
public string Delete() { RoadFlow.Platform.WorkFlowButtons workFlowButtons1 = new RoadFlow.Platform.WorkFlowButtons(); string str1 = this.Request.Form["ids"]; char[] chArray = new char[1] { ',' }; foreach (string str2 in str1.Split(chArray)) { Guid test; if (str2.IsGuid(out test)) { RoadFlow.Data.Model.WorkFlowButtons workFlowButtons2 = workFlowButtons1.Get(test, false); if (workFlowButtons2 != null) { workFlowButtons1.Delete(test); RoadFlow.Platform.Log.Add("删除了流程按钮", workFlowButtons2.Serialize(), RoadFlow.Platform.Log.Types.流程相关, "", "", (RoadFlow.Data.Model.Users)null); } } } workFlowButtons1.ClearCache(); return("删除成功!"); }
public int Update(RoadFlow.Data.Model.WorkFlowButtons model) { string sql = "UPDATE workflowbuttons SET \r\n\t\t\t\tTitle=@Title,Ico=@Ico,Script=@Script,Note=@Note,Sort=@Sort\r\n\t\t\t\tWHERE ID=@ID"; MySqlParameter[] mySqlParameterArray = new MySqlParameter[6]; int index1 = 0; MySqlParameter mySqlParameter1 = new MySqlParameter("@Title", MySqlDbType.Text, -1); mySqlParameter1.Value = (object)model.Title; mySqlParameterArray[index1] = mySqlParameter1; int index2 = 1; MySqlParameter mySqlParameter2; if (model.Ico != null) { MySqlParameter mySqlParameter3 = new MySqlParameter("@Ico", MySqlDbType.Text, -1); mySqlParameter3.Value = (object)model.Ico; mySqlParameter2 = mySqlParameter3; } else { mySqlParameter2 = new MySqlParameter("@Ico", MySqlDbType.Text, -1); mySqlParameter2.Value = (object)DBNull.Value; } mySqlParameterArray[index2] = mySqlParameter2; int index3 = 2; MySqlParameter mySqlParameter4; if (model.Script != null) { MySqlParameter mySqlParameter3 = new MySqlParameter("@Script", MySqlDbType.LongText, -1); mySqlParameter3.Value = (object)model.Script; mySqlParameter4 = mySqlParameter3; } else { mySqlParameter4 = new MySqlParameter("@Script", MySqlDbType.LongText, -1); mySqlParameter4.Value = (object)DBNull.Value; } mySqlParameterArray[index3] = mySqlParameter4; int index4 = 3; MySqlParameter mySqlParameter5; if (model.Note != null) { MySqlParameter mySqlParameter3 = new MySqlParameter("@Note", MySqlDbType.LongText, -1); mySqlParameter3.Value = (object)model.Note; mySqlParameter5 = mySqlParameter3; } else { mySqlParameter5 = new MySqlParameter("@Note", MySqlDbType.LongText, -1); mySqlParameter5.Value = (object)DBNull.Value; } mySqlParameterArray[index4] = mySqlParameter5; int index5 = 4; MySqlParameter mySqlParameter6 = new MySqlParameter("@Sort", MySqlDbType.Int32, 11); mySqlParameter6.Value = (object)model.Sort; mySqlParameterArray[index5] = mySqlParameter6; int index6 = 5; MySqlParameter mySqlParameter7 = new MySqlParameter("@ID", MySqlDbType.VarChar, 36); mySqlParameter7.Value = (object)model.ID; mySqlParameterArray[index6] = mySqlParameter7; MySqlParameter[] parameter = mySqlParameterArray; return(this.dbHelper.Execute(sql, parameter, false)); }
public ActionResult Edit(FormCollection collection) { RoadFlow.Platform.WorkFlowButtons workFlowButtons = new RoadFlow.Platform.WorkFlowButtons(); RoadFlow.Data.Model.WorkFlowButtons model = (RoadFlow.Data.Model.WorkFlowButtons)null; string str1 = this.Request.QueryString["id"]; string empty1 = string.Empty; string empty2 = string.Empty; string empty3 = string.Empty; string empty4 = string.Empty; string empty5 = string.Empty; Guid test; if (str1.IsGuid(out test)) { model = workFlowButtons.Get(test, false); } string oldXML = model.Serialize(); if (collection != null) { string str2 = this.Request.Form["Title"]; string str3 = this.Request.Form["Ico"]; string str4 = this.Request.Form["Script"]; string str5 = this.Request.Form["Note"]; string str6 = this.Request.Form["Sort"]; int num = !str1.IsGuid() ? 1 : 0; if (model == null) { model = new RoadFlow.Data.Model.WorkFlowButtons(); model.ID = Guid.NewGuid(); model.Sort = workFlowButtons.GetMaxSort(); } model.Ico = str3.IsNullOrEmpty() ? (string)null : str3.Trim(); model.Note = str5.IsNullOrEmpty() ? (string)null : str5.Trim(); model.Script = str4.IsNullOrEmpty() ? (string)null : str4; model.Title = str2.Trim(); model.Sort = !str6.IsInt() ? workFlowButtons.GetMaxSort() : str6.ToInt(); if (num != 0) { workFlowButtons.Add(model); RoadFlow.Platform.Log.Add("添加了流程按钮", model.Serialize(), RoadFlow.Platform.Log.Types.流程相关, "", "", (RoadFlow.Data.Model.Users)null); } else { workFlowButtons.Update(model); RoadFlow.Platform.Log.Add("修改了流程按钮", "", RoadFlow.Platform.Log.Types.流程相关, oldXML, model.Serialize(), (RoadFlow.Data.Model.Users)null); } workFlowButtons.ClearCache(); // ISSUE: reference to a compiler-generated field if (WorkFlowButtonsController.\u003C\u003Eo__3.\u003C\u003Ep__0 == null) { // ISSUE: reference to a compiler-generated field WorkFlowButtonsController.\u003C\u003Eo__3.\u003C\u003Ep__0 = CallSite <Func <CallSite, object, string, object> > .Create(Binder.SetMember(CSharpBinderFlags.None, "Script", typeof(WorkFlowButtonsController), (IEnumerable <CSharpArgumentInfo>) new CSharpArgumentInfo[2] { CSharpArgumentInfo.Create(CSharpArgumentInfoFlags.None, (string)null), CSharpArgumentInfo.Create(CSharpArgumentInfoFlags.UseCompileTimeType | CSharpArgumentInfoFlags.Constant, (string)null) })); } // ISSUE: reference to a compiler-generated field // ISSUE: reference to a compiler-generated field object obj = WorkFlowButtonsController.\u003C\u003Eo__3.\u003C\u003Ep__0.Target((CallSite)WorkFlowButtonsController.\u003C\u003Eo__3.\u003C\u003Ep__0, this.ViewBag, "new RoadUI.Window().reloadOpener();alert('保存成功!');new RoadUI.Window().close();"); } if (model == null) { model = new RoadFlow.Data.Model.WorkFlowButtons(); model.Sort = workFlowButtons.GetMaxSort(); } return((ActionResult)this.View((object)model)); }
public int Update(RoadFlow.Data.Model.WorkFlowButtons model) { string sql = "UPDATE WorkFlowButtons SET \r\n\t\t\t\tTitle=@Title,Ico=@Ico,Script=@Script,Note=@Note,Sort=@Sort\r\n\t\t\t\tWHERE ID=@ID"; SqlParameter[] sqlParameterArray = new SqlParameter[6]; int index1 = 0; SqlParameter sqlParameter1 = new SqlParameter("@Title", SqlDbType.NVarChar, 1000); sqlParameter1.Value = (object)model.Title; sqlParameterArray[index1] = sqlParameter1; int index2 = 1; SqlParameter sqlParameter2; if (model.Ico != null) { SqlParameter sqlParameter3 = new SqlParameter("@Ico", SqlDbType.VarChar, 500); sqlParameter3.Value = (object)model.Ico; sqlParameter2 = sqlParameter3; } else { sqlParameter2 = new SqlParameter("@Ico", SqlDbType.VarChar, 500); sqlParameter2.Value = (object)DBNull.Value; } sqlParameterArray[index2] = sqlParameter2; int index3 = 2; SqlParameter sqlParameter4; if (model.Script != null) { SqlParameter sqlParameter3 = new SqlParameter("@Script", SqlDbType.VarChar, -1); sqlParameter3.Value = (object)model.Script; sqlParameter4 = sqlParameter3; } else { sqlParameter4 = new SqlParameter("@Script", SqlDbType.VarChar, -1); sqlParameter4.Value = (object)DBNull.Value; } sqlParameterArray[index3] = sqlParameter4; int index4 = 3; SqlParameter sqlParameter5; if (model.Note != null) { SqlParameter sqlParameter3 = new SqlParameter("@Note", SqlDbType.VarChar, -1); sqlParameter3.Value = (object)model.Note; sqlParameter5 = sqlParameter3; } else { sqlParameter5 = new SqlParameter("@Note", SqlDbType.VarChar, -1); sqlParameter5.Value = (object)DBNull.Value; } sqlParameterArray[index4] = sqlParameter5; int index5 = 4; SqlParameter sqlParameter6 = new SqlParameter("@Sort", SqlDbType.Int, -1); sqlParameter6.Value = (object)model.Sort; sqlParameterArray[index5] = sqlParameter6; int index6 = 5; SqlParameter sqlParameter7 = new SqlParameter("@ID", SqlDbType.UniqueIdentifier, -1); sqlParameter7.Value = (object)model.ID; sqlParameterArray[index6] = sqlParameter7; SqlParameter[] parameter = sqlParameterArray; return(this.dbHelper.Execute(sql, parameter, false)); }
public int Update(RoadFlow.Data.Model.WorkFlowButtons model) { return(this.dataWorkFlowButtons.Update(model)); }
public int Add(RoadFlow.Data.Model.WorkFlowButtons model) { return(this.dataWorkFlowButtons.Add(model)); }
public int Update(RoadFlow.Data.Model.WorkFlowButtons model) { string sql = "UPDATE WorkFlowButtons SET \r\n\t\t\t\tTitle=:Title,Ico=:Ico,Script=:Script,Note=:Note,Sort=:Sort\r\n\t\t\t\tWHERE ID=:ID"; OracleParameter[] oracleParameterArray = new OracleParameter[6]; int index1 = 0; OracleParameter oracleParameter1 = new OracleParameter(":Title", OracleDbType.NVarchar2, 1000); oracleParameter1.Value = (object)model.Title; oracleParameterArray[index1] = oracleParameter1; int index2 = 1; OracleParameter oracleParameter2; if (model.Ico != null) { OracleParameter oracleParameter3 = new OracleParameter(":Ico", OracleDbType.Varchar2, 500); oracleParameter3.Value = (object)model.Ico; oracleParameter2 = oracleParameter3; } else { oracleParameter2 = new OracleParameter(":Ico", OracleDbType.Varchar2, 500); oracleParameter2.Value = (object)DBNull.Value; } oracleParameterArray[index2] = oracleParameter2; int index3 = 2; OracleParameter oracleParameter4; if (model.Script != null) { OracleParameter oracleParameter3 = new OracleParameter(":Script", OracleDbType.Clob); oracleParameter3.Value = (object)model.Script; oracleParameter4 = oracleParameter3; } else { oracleParameter4 = new OracleParameter(":Script", OracleDbType.Clob); oracleParameter4.Value = (object)DBNull.Value; } oracleParameterArray[index3] = oracleParameter4; int index4 = 3; OracleParameter oracleParameter5; if (model.Note != null) { OracleParameter oracleParameter3 = new OracleParameter(":Note", OracleDbType.Clob); oracleParameter3.Value = (object)model.Note; oracleParameter5 = oracleParameter3; } else { oracleParameter5 = new OracleParameter(":Note", OracleDbType.Clob); oracleParameter5.Value = (object)DBNull.Value; } oracleParameterArray[index4] = oracleParameter5; int index5 = 4; OracleParameter oracleParameter6 = new OracleParameter(":Sort", OracleDbType.Int32); oracleParameter6.Value = (object)model.Sort; oracleParameterArray[index5] = oracleParameter6; int index6 = 5; OracleParameter oracleParameter7 = new OracleParameter(":ID", OracleDbType.Varchar2, 40); oracleParameter7.Value = (object)model.ID; oracleParameterArray[index6] = oracleParameter7; OracleParameter[] parameter = oracleParameterArray; return(this.dbHelper.Execute(sql, parameter)); }