/// <summary> /// 将DataRedar转换为List /// </summary> private List <MyCreek.Data.Model.WorkFlowDelegation> DataReaderToList(OracleDataReader dataReader) { List <MyCreek.Data.Model.WorkFlowDelegation> List = new List <MyCreek.Data.Model.WorkFlowDelegation>(); MyCreek.Data.Model.WorkFlowDelegation model = null; while (dataReader.Read()) { model = new MyCreek.Data.Model.WorkFlowDelegation(); model.ID = dataReader.GetString(0).ToGuid(); model.UserID = dataReader.GetString(1).ToGuid(); model.StartTime = dataReader.GetDateTime(2); model.EndTime = dataReader.GetDateTime(3); if (!dataReader.IsDBNull(4)) { model.FlowID = dataReader.GetString(4).ToGuid(); } model.ToUserID = dataReader.GetString(5).ToGuid(); model.WriteTime = dataReader.GetDateTime(6); if (!dataReader.IsDBNull(7)) { model.Note = dataReader.GetString(7); } List.Add(model); } return(List); }
/// <summary> /// 更新记录 /// </summary> /// <param name="model">MyCreek.Data.Model.WorkFlowDelegation实体类</param> public int Update(MyCreek.Data.Model.WorkFlowDelegation model) { string sql = @"UPDATE WorkFlowDelegation SET UserID=:UserID,StartTime=:StartTime,EndTime=:EndTime,FlowID=:FlowID,ToUserID=:ToUserID,WriteTime=:WriteTime,Note=:Note WHERE ID=:ID" ; OracleParameter[] parameters = new OracleParameter[] { new OracleParameter(":UserID", OracleDbType.Varchar2, 40) { Value = model.UserID }, new OracleParameter(":StartTime", OracleDbType.Date, 8) { Value = model.StartTime }, new OracleParameter(":EndTime", OracleDbType.Date, 8) { Value = model.EndTime }, model.FlowID == null ? new OracleParameter(":FlowID", OracleDbType.Varchar2, 40) { Value = DBNull.Value } : new OracleParameter(":FlowID", OracleDbType.Varchar2, 40) { Value = model.FlowID }, new OracleParameter(":ToUserID", OracleDbType.Varchar2, 40) { Value = model.ToUserID }, new OracleParameter(":WriteTime", OracleDbType.Date, 8) { Value = model.WriteTime }, model.Note == null ? new OracleParameter(":Note", OracleDbType.NVarchar2, 8000) { Value = DBNull.Value } : new OracleParameter(":Note", OracleDbType.NVarchar2, 8000) { Value = model.Note }, new OracleParameter(":ID", OracleDbType.Varchar2, 40) { Value = model.ID } }; return(dbHelper.Execute(sql, parameters)); }
/// <summary> /// 添加记录 /// </summary> /// <param name="model">MyCreek.Data.Model.WorkFlowDelegation实体类</param> /// <returns>操作所影响的行数</returns> public int Add(MyCreek.Data.Model.WorkFlowDelegation model) { string sql = @"INSERT INTO WorkFlowDelegation (ID,UserID,StartTime,EndTime,FlowID,ToUserID,WriteTime,Note) VALUES(:ID,:UserID,:StartTime,:EndTime,:FlowID,:ToUserID,:WriteTime,:Note)" ; OracleParameter[] parameters = new OracleParameter[] { new OracleParameter(":ID", OracleDbType.Varchar2, 40) { Value = model.ID }, new OracleParameter(":UserID", OracleDbType.Varchar2, 40) { Value = model.UserID }, new OracleParameter(":StartTime", OracleDbType.Date, 8) { Value = model.StartTime }, new OracleParameter(":EndTime", OracleDbType.Date, 8) { Value = model.EndTime }, model.FlowID == null ? new OracleParameter(":FlowID", OracleDbType.Varchar2, 40) { Value = DBNull.Value } : new OracleParameter(":FlowID", OracleDbType.Varchar2, 40) { Value = model.FlowID }, new OracleParameter(":ToUserID", OracleDbType.Varchar2, 40) { Value = model.ToUserID }, new OracleParameter(":WriteTime", OracleDbType.Date, 8) { Value = model.WriteTime }, model.Note == null ? new OracleParameter(":Note", OracleDbType.NVarchar2, 8000) { Value = DBNull.Value } : new OracleParameter(":Note", OracleDbType.NVarchar2, 8000) { Value = model.Note } }; return(dbHelper.Execute(sql, parameters)); }
/// <summary> /// 更新记录 /// </summary> /// <param name="model">MyCreek.Data.Model.WorkFlowDelegation实体类</param> public int Update(MyCreek.Data.Model.WorkFlowDelegation model) { string sql = @"UPDATE WorkFlowDelegation SET UserID=@UserID,StartTime=@StartTime,EndTime=@EndTime,FlowID=@FlowID,ToUserID=@ToUserID,WriteTime=@WriteTime,Note=@Note WHERE ID=@ID" ; SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@UserID", SqlDbType.UniqueIdentifier, -1) { Value = model.UserID }, new SqlParameter("@StartTime", SqlDbType.DateTime, 8) { Value = model.StartTime }, new SqlParameter("@EndTime", SqlDbType.DateTime, 8) { Value = model.EndTime }, model.FlowID == null ? new SqlParameter("@FlowID", SqlDbType.UniqueIdentifier, -1) { Value = DBNull.Value } : new SqlParameter("@FlowID", SqlDbType.UniqueIdentifier, -1) { Value = model.FlowID }, new SqlParameter("@ToUserID", SqlDbType.UniqueIdentifier, -1) { Value = model.ToUserID }, new SqlParameter("@WriteTime", SqlDbType.DateTime, 8) { Value = model.WriteTime }, model.Note == null ? new SqlParameter("@Note", SqlDbType.NVarChar, 8000) { Value = DBNull.Value } : new SqlParameter("@Note", SqlDbType.NVarChar, 8000) { Value = model.Note }, new SqlParameter("@ID", SqlDbType.UniqueIdentifier, -1) { Value = model.ID } }; return(dbHelper.Execute(sql, parameters)); }
/// <summary> /// 添加记录 /// </summary> /// <param name="model">MyCreek.Data.Model.WorkFlowDelegation实体类</param> /// <returns>操作所影响的行数</returns> public int Add(MyCreek.Data.Model.WorkFlowDelegation model) { string sql = @"INSERT INTO WorkFlowDelegation (ID,UserID,StartTime,EndTime,FlowID,ToUserID,WriteTime,Note) VALUES(@ID,@UserID,@StartTime,@EndTime,@FlowID,@ToUserID,@WriteTime,@Note)" ; SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@ID", SqlDbType.UniqueIdentifier, -1) { Value = model.ID }, new SqlParameter("@UserID", SqlDbType.UniqueIdentifier, -1) { Value = model.UserID }, new SqlParameter("@StartTime", SqlDbType.DateTime, 8) { Value = model.StartTime }, new SqlParameter("@EndTime", SqlDbType.DateTime, 8) { Value = model.EndTime }, model.FlowID == null ? new SqlParameter("@FlowID", SqlDbType.UniqueIdentifier, -1) { Value = DBNull.Value } : new SqlParameter("@FlowID", SqlDbType.UniqueIdentifier, -1) { Value = model.FlowID }, new SqlParameter("@ToUserID", SqlDbType.UniqueIdentifier, -1) { Value = model.ToUserID }, new SqlParameter("@WriteTime", SqlDbType.DateTime, 8) { Value = model.WriteTime }, model.Note == null ? new SqlParameter("@Note", SqlDbType.NVarChar, 8000) { Value = DBNull.Value } : new SqlParameter("@Note", SqlDbType.NVarChar, 8000) { Value = model.Note } }; return(dbHelper.Execute(sql, parameters)); }
public ActionResult Edit(FormCollection collection) { MyCreek.Platform.WorkFlowDelegation bworkFlowDelegation = new MyCreek.Platform.WorkFlowDelegation(); MyCreek.Data.Model.WorkFlowDelegation workFlowDelegation = null; string id = Request.QueryString["id"]; string UserID = string.Empty; string ToUserID = string.Empty; string StartTime = string.Empty; string EndTime = string.Empty; string FlowID = string.Empty; string Note = string.Empty; bool isOneSelf = "1" == Request.QueryString["isoneself"]; Guid delegationID; if (id.IsGuid(out delegationID)) { workFlowDelegation = bworkFlowDelegation.Get(delegationID); if (workFlowDelegation != null) { FlowID = workFlowDelegation.FlowID.ToString(); } } string oldXML = workFlowDelegation.Serialize(); if (collection != null) { UserID = Request.Form["UserID"]; ToUserID = Request.Form["ToUserID"]; StartTime = Request.Form["StartTime"]; EndTime = Request.Form["EndTime"]; FlowID = Request.Form["FlowID"]; Note = Request.Form["Note"]; bool isAdd = !id.IsGuid(); if (workFlowDelegation == null) { workFlowDelegation = new MyCreek.Data.Model.WorkFlowDelegation(); workFlowDelegation.ID = Guid.NewGuid(); } workFlowDelegation.UserID = isOneSelf ? MyCreek.Platform.Users.CurrentUserID : MyCreek.Platform.Users.RemovePrefix(UserID).ToGuid(); workFlowDelegation.EndTime = EndTime.ToDateTime(); if (FlowID.IsGuid()) { workFlowDelegation.FlowID = FlowID.ToGuid(); } workFlowDelegation.Note = Note.IsNullOrEmpty() ? null : Note; workFlowDelegation.StartTime = StartTime.ToDateTime(); workFlowDelegation.ToUserID = MyCreek.Platform.Users.RemovePrefix(ToUserID).ToGuid(); workFlowDelegation.WriteTime = MyCreek.Utility.DateTimeNew.Now; if (isAdd) { bworkFlowDelegation.Add(workFlowDelegation); MyCreek.Platform.Log.Add("添加了工作委托", workFlowDelegation.Serialize(), MyCreek.Platform.Log.Types.流程相关); } else { bworkFlowDelegation.Update(workFlowDelegation); MyCreek.Platform.Log.Add("修改了工作委托", "", MyCreek.Platform.Log.Types.流程相关, oldXML, workFlowDelegation.Serialize()); } bworkFlowDelegation.RefreshCache(); ViewBag.Script = "alert('保存成功!');new RoadUI.Window().reloadOpener();new RoadUI.Window().close();"; } ViewBag.FlowOptions = new MyCreek.Platform.WorkFlow().GetOptions(FlowID); return(View(workFlowDelegation == null ? new MyCreek.Data.Model.WorkFlowDelegation() { UserID = MyCreek.Platform.Users.CurrentUserID } : workFlowDelegation)); }
protected void Page_Load(object sender, EventArgs e) { string id = Request.QueryString["id"]; string UserID = string.Empty; string ToUserID = string.Empty; string StartTime = string.Empty; string EndTime = string.Empty; string FlowID = string.Empty; string Note = string.Empty; isOneSelf = "1" == Request.QueryString["isoneself"]; Guid delegationID; if (id.IsGuid(out delegationID)) { workFlowDelegation = bworkFlowDelegation.Get(delegationID); if (workFlowDelegation != null) { FlowID = workFlowDelegation.FlowID.ToString(); } } string oldXML = workFlowDelegation.Serialize(); if (IsPostBack) { UserID = Request.Form["UserID"]; ToUserID = Request.Form["ToUserID"]; StartTime = Request.Form["StartTime"]; EndTime = Request.Form["EndTime"]; FlowID = Request.Form["FlowID"]; Note = Request.Form["Note"]; bool isAdd = !id.IsGuid(); if (workFlowDelegation == null) { workFlowDelegation = new MyCreek.Data.Model.WorkFlowDelegation(); workFlowDelegation.ID = Guid.NewGuid(); } workFlowDelegation.UserID = isOneSelf ? MyCreek.Platform.Users.CurrentUserID : MyCreek.Platform.Users.RemovePrefix(UserID).ToGuid(); workFlowDelegation.EndTime = EndTime.ToDateTime(); if (FlowID.IsGuid()) { workFlowDelegation.FlowID = FlowID.ToGuid(); } workFlowDelegation.Note = Note.IsNullOrEmpty() ? null : Note; workFlowDelegation.StartTime = StartTime.ToDateTime(); workFlowDelegation.ToUserID = MyCreek.Platform.Users.RemovePrefix(ToUserID).ToGuid(); workFlowDelegation.WriteTime = MyCreek.Utility.DateTimeNew.Now; if (isAdd) { bworkFlowDelegation.Add(workFlowDelegation); MyCreek.Platform.Log.Add("添加了工作委托", workFlowDelegation.Serialize(), MyCreek.Platform.Log.Types.流程相关); } else { bworkFlowDelegation.Update(workFlowDelegation); MyCreek.Platform.Log.Add("修改了工作委托", "", MyCreek.Platform.Log.Types.流程相关, oldXML, workFlowDelegation.Serialize()); } bworkFlowDelegation.RefreshCache(); Page.ClientScript.RegisterStartupScript(Page.GetType(), "ok", "alert('保存成功!');new RoadUI.Window().reloadOpener();new RoadUI.Window().close();", true); } FlowOptions = new MyCreek.Platform.WorkFlow().GetOptions(FlowID); if (workFlowDelegation == null) { workFlowDelegation = new MyCreek.Data.Model.WorkFlowDelegation(); } }