/// <summary> /// 将DataRedar转换为List /// </summary> private List <BizProcess.Data.Model.WorkFlowButtons> DataReaderToList(MySqlDataReader dataReader) { List <BizProcess.Data.Model.WorkFlowButtons> List = new List <BizProcess.Data.Model.WorkFlowButtons>(); BizProcess.Data.Model.WorkFlowButtons model = null; while (dataReader.Read()) { model = new BizProcess.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); }
public ActionResult Edit(FormCollection collection) { BizProcess.Platform.WorkFlowButtons bworkFlowButtons = new BizProcess.Platform.WorkFlowButtons(); BizProcess.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 BizProcess.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); BizProcess.Platform.Log.Add("添加了流程按钮", workFlowButton.Serialize(), BizProcess.Platform.Log.Types.流程相关); } else { bworkFlowButtons.Update(workFlowButton); BizProcess.Platform.Log.Add("修改了流程按钮", "", BizProcess.Platform.Log.Types.流程相关, oldXML, workFlowButton.Serialize()); } bworkFlowButtons.ClearCache(); ViewBag.Script = "new BPUI.Window().reloadOpener();alert('保存成功!');new BPUI.Window().close();"; } return(View(workFlowButton == null ? new BizProcess.Data.Model.WorkFlowButtons() : workFlowButton)); }
/// <summary> /// 更新记录 /// </summary> /// <param name="model">BizProcess.Data.Model.WorkFlowButtons实体类</param> public int Update(BizProcess.Data.Model.WorkFlowButtons model) { string sql = @"UPDATE WorkFlowButtons SET Title=@Title,Ico=@Ico,Script=@Script,Note=@Note,Sort=@Sort WHERE ID=@ID" ; MySqlParameter[] parameters = new MySqlParameter[] { new MySqlParameter("@Title", MySqlDbType.VarChar, 500) { Value = model.Title }, model.Ico == null ? new MySqlParameter("@Ico", MySqlDbType.VarChar, 500) { Value = DBNull.Value } : new MySqlParameter("@Ico", MySqlDbType.VarChar, 500) { Value = model.Ico }, model.Script == null ? new MySqlParameter("@Script", MySqlDbType.VarChar, -1) { Value = DBNull.Value } : new MySqlParameter("@Script", MySqlDbType.VarChar, -1) { Value = model.Script }, model.Note == null ? new MySqlParameter("@Note", MySqlDbType.VarChar, -1) { Value = DBNull.Value } : new MySqlParameter("@Note", MySqlDbType.VarChar, -1) { Value = model.Note }, new MySqlParameter("@Sort", MySqlDbType.Int32, -1) { Value = model.Sort }, new MySqlParameter("@ID", MySqlDbType.VarChar, -1) { Value = model.ID } }; return(dbHelper.Execute(sql, parameters)); }
/// <summary> /// 添加记录 /// </summary> /// <param name="model">BizProcess.Data.Model.WorkFlowButtons实体类</param> /// <returns>操作所影响的行数</returns> public int Add(BizProcess.Data.Model.WorkFlowButtons model) { string sql = @"INSERT INTO WorkFlowButtons (ID,Title,Ico,Script,Note,Sort) VALUES(@ID,@Title,@Ico,@Script,@Note,@Sort)" ; MySqlParameter[] parameters = new MySqlParameter[] { new MySqlParameter("@ID", MySqlDbType.VarChar, -1) { Value = model.ID }, new MySqlParameter("@Title", MySqlDbType.VarChar, 500) { Value = model.Title }, model.Ico == null ? new MySqlParameter("@Ico", MySqlDbType.VarChar, 500) { Value = DBNull.Value } : new MySqlParameter("@Ico", MySqlDbType.VarChar, 500) { Value = model.Ico }, model.Script == null ? new MySqlParameter("@Script", MySqlDbType.VarChar, -1) { Value = DBNull.Value } : new MySqlParameter("@Script", MySqlDbType.VarChar, -1) { Value = model.Script }, model.Note == null ? new MySqlParameter("@Note", MySqlDbType.Text, -1) { Value = DBNull.Value } : new MySqlParameter("@Note", MySqlDbType.Text, -1) { Value = model.Note }, new MySqlParameter("@Sort", MySqlDbType.Int32, -1) { Value = model.Sort } }; return(dbHelper.Execute(sql, parameters)); }
/// <summary> /// 更新记录 /// </summary> /// <param name="model">BizProcess.Data.Model.WorkFlowButtons实体类</param> public int Update(BizProcess.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.Char, 36) { Value = model.ID } }; return(dbHelper.Execute(sql, parameters)); }
/// <summary> /// 添加记录 /// </summary> /// <param name="model">BizProcess.Data.Model.WorkFlowButtons实体类</param> /// <returns>操作所影响的行数</returns> public int Add(BizProcess.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.Char, 36) { 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)); }
/// <summary> /// 更新 /// </summary> public int Update(BizProcess.Data.Model.WorkFlowButtons model) { return(dataWorkFlowButtons.Update(model)); }
/// <summary> /// 新增 /// </summary> public int Add(BizProcess.Data.Model.WorkFlowButtons model) { return(dataWorkFlowButtons.Add(model)); }