/// <summary> /// 将DataRedar转换为List /// </summary> private List <BizProcess.Data.Model.WorkFlowTask> DataReaderToList(MySqlDataReader dataReader) { List <BizProcess.Data.Model.WorkFlowTask> List = new List <BizProcess.Data.Model.WorkFlowTask>(); BizProcess.Data.Model.WorkFlowTask model = null; while (dataReader.Read()) { model = new BizProcess.Data.Model.WorkFlowTask(); model.ID = dataReader.GetGuid(0); model.PrevID = dataReader.GetGuid(1); model.PrevStepID = dataReader.GetGuid(2); model.FlowID = dataReader.GetGuid(3); model.StepID = dataReader.GetGuid(4); model.StepName = dataReader.GetString(5); model.InstanceID = dataReader.GetString(6); model.GroupID = dataReader.GetGuid(7); model.Type = dataReader.GetInt32(8); model.Title = dataReader.GetString(9); model.SenderID = dataReader.GetGuid(10); model.SenderName = dataReader.GetString(11); model.SenderTime = dataReader.GetDateTime(12); model.ReceiveID = dataReader.GetGuid(13); model.ReceiveName = dataReader.GetString(14); model.ReceiveTime = dataReader.GetDateTime(15); if (!dataReader.IsDBNull(16)) { model.OpenTime = dataReader.GetDateTime(16); } if (!dataReader.IsDBNull(17)) { model.CompletedTime = dataReader.GetDateTime(17); } if (!dataReader.IsDBNull(18)) { model.CompletedTime1 = dataReader.GetDateTime(18); } if (!dataReader.IsDBNull(19)) { model.Comment = dataReader.GetString(19); } if (!dataReader.IsDBNull(20)) { model.IsSign = dataReader.GetInt32(20); } model.Status = dataReader.GetInt32(21); if (!dataReader.IsDBNull(22)) { model.Note = dataReader.GetString(22); } model.Sort = dataReader.GetInt32(23); Guid newGuid; if (Guid.TryParse(dataReader.GetString(24), out newGuid)) { model.SubFlowGroupID = newGuid; } List.Add(model); } return(List); }
/// <summary> /// 添加记录 /// </summary> /// <param name="model">BizProcess.Data.Model.WorkFlowTask实体类</param> /// <returns>操作所影响的行数</returns> public int Add(BizProcess.Data.Model.WorkFlowTask model) { string sql = @"INSERT INTO WorkFlowTask (ID,PrevID,PrevStepID,FlowID,StepID,StepName,InstanceID,GroupID,Type,Title,SenderID,SenderName,SenderTime,ReceiveID,ReceiveName,ReceiveTime,OpenTime,CompletedTime,CompletedTime1,Comment,IsSign,Status,Note,Sort,SubFlowGroupID) VALUES(@ID,@PrevID,@PrevStepID,@FlowID,@StepID,@StepName,@InstanceID,@GroupID,@Type,@Title,@SenderID,@SenderName,@SenderTime,@ReceiveID,@ReceiveName,@ReceiveTime,@OpenTime,@CompletedTime,@CompletedTime1,@Comment,@IsSign,@Status,@Note,@Sort,@SubFlowGroupID)" ; SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@ID", SqlDbType.UniqueIdentifier, -1) { Value = model.ID }, new SqlParameter("@PrevID", SqlDbType.UniqueIdentifier, -1) { Value = model.PrevID }, new SqlParameter("@PrevStepID", SqlDbType.UniqueIdentifier, -1) { Value = model.PrevStepID }, new SqlParameter("@FlowID", SqlDbType.UniqueIdentifier, -1) { Value = model.FlowID }, new SqlParameter("@StepID", SqlDbType.UniqueIdentifier, -1) { Value = model.StepID }, new SqlParameter("@StepName", SqlDbType.NVarChar, 1000) { Value = model.StepName }, new SqlParameter("@InstanceID", SqlDbType.VarChar, 50) { Value = model.InstanceID }, new SqlParameter("@GroupID", SqlDbType.UniqueIdentifier, -1) { Value = model.GroupID }, new SqlParameter("@Type", SqlDbType.Int, -1) { Value = model.Type }, new SqlParameter("@Title", SqlDbType.NVarChar, 4000) { Value = model.Title }, new SqlParameter("@SenderID", SqlDbType.UniqueIdentifier, -1) { Value = model.SenderID }, new SqlParameter("@SenderName", SqlDbType.NVarChar, 100) { Value = model.SenderName }, new SqlParameter("@SenderTime", SqlDbType.DateTime, 8) { Value = model.SenderTime }, new SqlParameter("@ReceiveID", SqlDbType.UniqueIdentifier, -1) { Value = model.ReceiveID }, new SqlParameter("@ReceiveName", SqlDbType.NVarChar, 100) { Value = model.ReceiveName }, new SqlParameter("@ReceiveTime", SqlDbType.DateTime, 8) { Value = model.ReceiveTime }, model.OpenTime == null ? new SqlParameter("@OpenTime", SqlDbType.DateTime, 8) { Value = DBNull.Value } : new SqlParameter("@OpenTime", SqlDbType.DateTime, 8) { Value = model.OpenTime }, model.CompletedTime == null ? new SqlParameter("@CompletedTime", SqlDbType.DateTime, 8) { Value = DBNull.Value } : new SqlParameter("@CompletedTime", SqlDbType.DateTime, 8) { Value = model.CompletedTime }, model.CompletedTime1 == null ? new SqlParameter("@CompletedTime1", SqlDbType.DateTime, 8) { Value = DBNull.Value } : new SqlParameter("@CompletedTime1", SqlDbType.DateTime, 8) { Value = model.CompletedTime1 }, model.Comment == null ? new SqlParameter("@Comment", SqlDbType.VarChar, -1) { Value = DBNull.Value } : new SqlParameter("@Comment", SqlDbType.VarChar, -1) { Value = model.Comment }, model.IsSign == null ? new SqlParameter("@IsSign", SqlDbType.Int, -1) { Value = DBNull.Value } : new SqlParameter("@IsSign", SqlDbType.Int, -1) { Value = model.IsSign }, new SqlParameter("@Status", SqlDbType.Int, -1) { Value = model.Status }, model.Note == null ? new SqlParameter("@Note", SqlDbType.NVarChar, -1) { Value = DBNull.Value } : new SqlParameter("@Note", SqlDbType.NVarChar, -1) { Value = model.Note }, new SqlParameter("@Sort", SqlDbType.Int, -1) { Value = model.Sort }, model.SubFlowGroupID == null ? new SqlParameter("@SubFlowGroupID", SqlDbType.UniqueIdentifier, -1) { Value = DBNull.Value } : new SqlParameter("@SubFlowGroupID", SqlDbType.UniqueIdentifier, -1) { Value = model.SubFlowGroupID } }; return(dbHelper.Execute(sql, parameters)); }
/// <summary> /// 更新记录 /// </summary> /// <param name="model">BizProcess.Data.Model.WorkFlowTask实体类</param> public int Update(BizProcess.Data.Model.WorkFlowTask model) { string sql = @"UPDATE WorkFlowTask SET PrevID=@PrevID,PrevStepID=@PrevStepID,FlowID=@FlowID,StepID=@StepID,StepName=@StepName,InstanceID=@InstanceID,GroupID=@GroupID,Type=@Type,Title=@Title,SenderID=@SenderID,SenderName=@SenderName,SenderTime=@SenderTime,ReceiveID=@ReceiveID,ReceiveName=@ReceiveName,ReceiveTime=@ReceiveTime,OpenTime=@OpenTime,CompletedTime=@CompletedTime,CompletedTime1=@CompletedTime1,Comment=@Comment,IsSign=@IsSign,Status=@Status,Note=@Note,Sort=@Sort,SubFlowGroupID=@SubFlowGroupID WHERE ID=@ID" ; MySqlParameter[] parameters = new MySqlParameter[] { new MySqlParameter("@PrevID", MySqlDbType.VarChar, -1) { Value = model.PrevID }, new MySqlParameter("@PrevStepID", MySqlDbType.VarChar, -1) { Value = model.PrevStepID }, new MySqlParameter("@FlowID", MySqlDbType.VarChar, -1) { Value = model.FlowID }, new MySqlParameter("@StepID", MySqlDbType.VarChar, -1) { Value = model.StepID }, new MySqlParameter("@StepName", MySqlDbType.VarChar, 500) { Value = model.StepName }, new MySqlParameter("@InstanceID", MySqlDbType.VarChar, 50) { Value = model.InstanceID }, new MySqlParameter("@GroupID", MySqlDbType.VarChar, -1) { Value = model.GroupID }, new MySqlParameter("@Type", MySqlDbType.Int32, -1) { Value = model.Type }, new MySqlParameter("@Title", MySqlDbType.VarChar, 2000) { Value = model.Title }, new MySqlParameter("@SenderID", MySqlDbType.VarChar, -1) { Value = model.SenderID }, new MySqlParameter("@SenderName", MySqlDbType.VarChar, 50) { Value = model.SenderName }, new MySqlParameter("@SenderTime", MySqlDbType.DateTime, 8) { Value = model.SenderTime }, new MySqlParameter("@ReceiveID", MySqlDbType.VarChar, -1) { Value = model.ReceiveID }, new MySqlParameter("@ReceiveName", MySqlDbType.VarChar, 50) { Value = model.ReceiveName }, new MySqlParameter("@ReceiveTime", MySqlDbType.DateTime, 8) { Value = model.ReceiveTime }, model.OpenTime == null ? new MySqlParameter("@OpenTime", MySqlDbType.DateTime, 8) { Value = DBNull.Value } : new MySqlParameter("@OpenTime", MySqlDbType.DateTime, 8) { Value = model.OpenTime }, model.CompletedTime == null ? new MySqlParameter("@CompletedTime", MySqlDbType.DateTime, 8) { Value = DBNull.Value } : new MySqlParameter("@CompletedTime", MySqlDbType.DateTime, 8) { Value = model.CompletedTime }, model.CompletedTime1 == null ? new MySqlParameter("@CompletedTime1", MySqlDbType.DateTime, 8) { Value = DBNull.Value } : new MySqlParameter("@CompletedTime1", MySqlDbType.DateTime, 8) { Value = model.CompletedTime1 }, model.Comment == null ? new MySqlParameter("@Comment", MySqlDbType.Text, -1) { Value = DBNull.Value } : new MySqlParameter("@Comment", MySqlDbType.Text, -1) { Value = model.Comment }, model.IsSign == null ? new MySqlParameter("@IsSign", MySqlDbType.Int32, -1) { Value = DBNull.Value } : new MySqlParameter("@IsSign", MySqlDbType.Int32, -1) { Value = model.IsSign }, new MySqlParameter("@Status", MySqlDbType.Int32, -1) { Value = model.Status }, 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 }, model.SubFlowGroupID == null ? new MySqlParameter("@SubFlowGroupID", MySqlDbType.VarChar, -1) { Value = DBNull.Value } : new MySqlParameter("@SubFlowGroupID", MySqlDbType.VarChar, -1) { Value = model.SubFlowGroupID }, new MySqlParameter("@ID", MySqlDbType.VarChar, -1) { Value = model.ID } }; return(dbHelper.Execute(sql, parameters)); }
/// <summary> /// 添加记录 /// </summary> /// <param name="model">BizProcess.Data.Model.WorkFlowTask实体类</param> /// <returns>操作所影响的行数</returns> public int Add(BizProcess.Data.Model.WorkFlowTask model) { string sql = @"INSERT INTO WorkFlowTask (ID,PrevID,PrevStepID,FlowID,StepID,StepName,InstanceID,GroupID,Type,Title,SenderID,SenderName,SenderTime,ReceiveID,ReceiveName,ReceiveTime,OpenTime,CompletedTime,CompletedTime1,Comment,IsSign,Status,Note,Sort,SubFlowGroupID) VALUES(:ID,:PrevID,:PrevStepID,:FlowID,:StepID,:StepName,:InstanceID,:GroupID,:Type,:Title,:SenderID,:SenderName,:SenderTime,:ReceiveID,:ReceiveName,:ReceiveTime,:OpenTime,:CompletedTime,:CompletedTime1,:Comment,:IsSign,:Status,:Note,:Sort,:SubFlowGroupID)" ; OracleParameter[] parameters = new OracleParameter[] { new OracleParameter(":ID", OracleDbType.Char, 36) { Value = model.ID }, new OracleParameter(":PrevID", OracleDbType.Char, 36) { Value = model.PrevID }, new OracleParameter(":PrevStepID", OracleDbType.Char, 36) { Value = model.PrevStepID }, new OracleParameter(":FlowID", OracleDbType.Char, 36) { Value = model.FlowID }, new OracleParameter(":StepID", OracleDbType.Char, 36) { Value = model.StepID }, new OracleParameter(":StepName", OracleDbType.NVarchar2, 1000) { Value = model.StepName }, new OracleParameter(":InstanceID", OracleDbType.Varchar2, 50) { Value = model.InstanceID }, new OracleParameter(":GroupID", OracleDbType.Char, 36) { Value = model.GroupID }, new OracleParameter(":Type", OracleDbType.Int32) { Value = model.Type }, new OracleParameter(":Title", OracleDbType.NVarchar2, 4000) { Value = model.Title }, new OracleParameter(":SenderID", OracleDbType.Char, 36) { Value = model.SenderID }, new OracleParameter(":SenderName", OracleDbType.NVarchar2, 100) { Value = model.SenderName }, new OracleParameter(":SenderTime", OracleDbType.Date) { Value = model.SenderTime }, new OracleParameter(":ReceiveID", OracleDbType.Char, 36) { Value = model.ReceiveID }, new OracleParameter(":ReceiveName", OracleDbType.NVarchar2, 100) { Value = model.ReceiveName }, new OracleParameter(":ReceiveTime", OracleDbType.Date) { Value = model.ReceiveTime }, model.OpenTime == null ? new OracleParameter(":OpenTime", OracleDbType.Date) { Value = DBNull.Value } : new OracleParameter(":OpenTime", OracleDbType.Date) { Value = model.OpenTime }, model.CompletedTime == null ? new OracleParameter(":CompletedTime", OracleDbType.Date) { Value = DBNull.Value } : new OracleParameter(":CompletedTime", OracleDbType.Date) { Value = model.CompletedTime }, model.CompletedTime1 == null ? new OracleParameter(":CompletedTime1", OracleDbType.Date) { Value = DBNull.Value } : new OracleParameter(":CompletedTime1", OracleDbType.Date) { Value = model.CompletedTime1 }, model.Comment == null ? new OracleParameter(":Comment", OracleDbType.Clob) { Value = DBNull.Value } : new OracleParameter(":Comment", OracleDbType.Clob) { Value = model.Comment }, model.IsSign == null ? new OracleParameter(":IsSign", OracleDbType.Int32) { Value = DBNull.Value } : new OracleParameter(":IsSign", OracleDbType.Int32) { Value = model.IsSign }, new OracleParameter(":Status", OracleDbType.Int32) { Value = model.Status }, model.Note == null ? new OracleParameter(":Note", OracleDbType.NClob) { Value = DBNull.Value } : new OracleParameter(":Note", OracleDbType.NClob) { Value = model.Note }, new OracleParameter(":Sort", OracleDbType.Int32) { Value = model.Sort }, model.SubFlowGroupID == null ? new OracleParameter(":SubFlowGroupID", OracleDbType.Char, 36) { Value = DBNull.Value } : new OracleParameter(":SubFlowGroupID", OracleDbType.Char, 36) { Value = model.SubFlowGroupID } }; return(dbHelper.Execute(sql, parameters)); }