/// <summary> /// 添加记录 /// </summary> /// <param name="model">MyCreek.Data.Model.WorkFlowArchives实体类</param> /// <returns>操作所影响的行数</returns> public int Add(MyCreek.Data.Model.WorkFlowArchives model) { string sql = @"INSERT INTO WorkFlowArchives (ID,FlowID,StepID,FlowName,StepName,TaskID,GroupID,InstanceID,Title,Contents,Comments,WriteTime) VALUES(@ID,@FlowID,@StepID,@FlowName,@StepName,@TaskID,@GroupID,@InstanceID,@Title,@Contents,@Comments,@WriteTime)" ; SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@ID", SqlDbType.UniqueIdentifier, -1) { Value = model.ID }, new SqlParameter("@FlowID", SqlDbType.UniqueIdentifier, -1) { Value = model.FlowID }, new SqlParameter("@StepID", SqlDbType.UniqueIdentifier, -1) { Value = model.StepID }, new SqlParameter("@FlowName", SqlDbType.NVarChar, 1000) { Value = model.FlowName }, new SqlParameter("@StepName", SqlDbType.NVarChar, 1000) { Value = model.StepName }, new SqlParameter("@TaskID", SqlDbType.UniqueIdentifier, -1) { Value = model.TaskID }, new SqlParameter("@GroupID", SqlDbType.UniqueIdentifier, -1) { Value = model.GroupID }, new SqlParameter("@InstanceID", SqlDbType.VarChar, 500) { Value = model.InstanceID }, new SqlParameter("@Title", SqlDbType.NVarChar, 8000) { Value = model.Title }, new SqlParameter("@Contents", SqlDbType.Text, -1) { Value = model.Contents }, new SqlParameter("@Comments", SqlDbType.Text, -1) { Value = model.Comments }, new SqlParameter("@WriteTime", SqlDbType.DateTime, 8) { Value = model.WriteTime } }; return(dbHelper.Execute(sql, parameters)); }
/// <summary> /// 更新记录 /// </summary> /// <param name="model">MyCreek.Data.Model.WorkFlowArchives实体类</param> public int Update(MyCreek.Data.Model.WorkFlowArchives model) { string sql = @"UPDATE WorkFlowArchives SET FlowID=@FlowID,StepID=@StepID,FlowName=@FlowName,StepName=@StepName,TaskID=@TaskID,GroupID=@GroupID,InstanceID=@InstanceID,Title=@Title,Contents=@Contents,Comments=@Comments,WriteTime=@WriteTime WHERE ID=@ID" ; SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@FlowID", SqlDbType.UniqueIdentifier, -1) { Value = model.FlowID }, new SqlParameter("@StepID", SqlDbType.UniqueIdentifier, -1) { Value = model.StepID }, new SqlParameter("@FlowName", SqlDbType.NVarChar, 1000) { Value = model.FlowName }, new SqlParameter("@StepName", SqlDbType.NVarChar, 1000) { Value = model.StepName }, new SqlParameter("@TaskID", SqlDbType.UniqueIdentifier, -1) { Value = model.TaskID }, new SqlParameter("@GroupID", SqlDbType.UniqueIdentifier, -1) { Value = model.GroupID }, new SqlParameter("@InstanceID", SqlDbType.VarChar, 500) { Value = model.InstanceID }, new SqlParameter("@Title", SqlDbType.NVarChar, 8000) { Value = model.Title }, new SqlParameter("@Contents", SqlDbType.Text, -1) { Value = model.Contents }, new SqlParameter("@Comments", SqlDbType.Text, -1) { Value = model.Comments }, new SqlParameter("@WriteTime", SqlDbType.DateTime, 8) { Value = model.WriteTime }, new SqlParameter("@ID", SqlDbType.UniqueIdentifier, -1) { Value = model.ID } }; return(dbHelper.Execute(sql, parameters)); }
/// <summary> /// 更新记录 /// </summary> /// <param name="model">MyCreek.Data.Model.WorkFlowArchives实体类</param> public int Update(MyCreek.Data.Model.WorkFlowArchives model) { string sql = @"UPDATE WorkFlowArchives SET FlowID=:FlowID,StepID=:StepID,FlowName=:FlowName,StepName=:StepName,TaskID=:TaskID,GroupID=:GroupID,InstanceID=:InstanceID,Title=:Title,Contents=:Contents,Comments=:Comments,WriteTime=:WriteTime WHERE ID=:ID" ; OracleParameter[] parameters = new OracleParameter[] { new OracleParameter(":FlowID", OracleDbType.Varchar2, 40) { Value = model.FlowID }, new OracleParameter(":StepID", OracleDbType.Varchar2, 40) { Value = model.StepID }, new OracleParameter(":FlowName", OracleDbType.NVarchar2, 1000) { Value = model.FlowName }, new OracleParameter(":StepName", OracleDbType.NVarchar2, 1000) { Value = model.StepName }, new OracleParameter(":TaskID", OracleDbType.Varchar2, 40) { Value = model.TaskID }, new OracleParameter(":GroupID", OracleDbType.Varchar2, 40) { Value = model.GroupID }, new OracleParameter(":InstanceID", OracleDbType.Varchar2, 500) { Value = model.InstanceID }, new OracleParameter(":Title", OracleDbType.NVarchar2, 8000) { Value = model.Title }, new OracleParameter(":Contents", OracleDbType.Clob) { Value = model.Contents }, new OracleParameter(":Comments", OracleDbType.Clob) { Value = model.Comments }, new OracleParameter(":WriteTime", OracleDbType.Date, 8) { Value = model.WriteTime }, new OracleParameter(":ID", OracleDbType.Varchar2, 40) { Value = model.ID } }; return(dbHelper.Execute(sql, parameters)); }
/// <summary> /// 添加记录 /// </summary> /// <param name="model">MyCreek.Data.Model.WorkFlowArchives实体类</param> /// <returns>操作所影响的行数</returns> public int Add(MyCreek.Data.Model.WorkFlowArchives model) { string sql = @"INSERT INTO WorkFlowArchives (ID,FlowID,StepID,FlowName,StepName,TaskID,GroupID,InstanceID,Title,Contents,Comments,WriteTime) VALUES(:ID,:FlowID,:StepID,:FlowName,:StepName,:TaskID,:GroupID,:InstanceID,:Title,:Contents,:Comments,:WriteTime)" ; OracleParameter[] parameters = new OracleParameter[] { new OracleParameter(":ID", OracleDbType.Varchar2, 40) { Value = model.ID }, new OracleParameter(":FlowID", OracleDbType.Varchar2, 40) { Value = model.FlowID }, new OracleParameter(":StepID", OracleDbType.Varchar2, 40) { Value = model.StepID }, new OracleParameter(":FlowName", OracleDbType.NVarchar2, 1000) { Value = model.FlowName }, new OracleParameter(":StepName", OracleDbType.NVarchar2, 1000) { Value = model.StepName }, new OracleParameter(":TaskID", OracleDbType.Varchar2, 40) { Value = model.TaskID }, new OracleParameter(":GroupID", OracleDbType.Varchar2, 40) { Value = model.GroupID }, new OracleParameter(":InstanceID", OracleDbType.Varchar2, 500) { Value = model.InstanceID }, new OracleParameter(":Title", OracleDbType.NVarchar2, 8000) { Value = model.Title }, new OracleParameter(":Contents", OracleDbType.Clob) { Value = model.Contents }, new OracleParameter(":Comments", OracleDbType.Clob) { Value = model.Comments }, new OracleParameter(":WriteTime", OracleDbType.Date, 8) { Value = model.WriteTime } }; return(dbHelper.Execute(sql, parameters)); }
/// <summary> /// 将DataRedar转换为List /// </summary> private List <MyCreek.Data.Model.WorkFlowArchives> DataReaderToList(SqlDataReader dataReader) { List <MyCreek.Data.Model.WorkFlowArchives> List = new List <MyCreek.Data.Model.WorkFlowArchives>(); MyCreek.Data.Model.WorkFlowArchives model = null; while (dataReader.Read()) { model = new MyCreek.Data.Model.WorkFlowArchives(); model.ID = dataReader.GetGuid(0); model.FlowID = dataReader.GetGuid(1); model.StepID = dataReader.GetGuid(2); model.FlowName = dataReader.GetString(3); model.StepName = dataReader.GetString(4); model.TaskID = dataReader.GetGuid(5); model.GroupID = dataReader.GetGuid(6); model.InstanceID = dataReader.GetString(7); model.Title = dataReader.GetString(8); model.Contents = dataReader.GetString(9); model.Comments = dataReader.GetString(10); model.WriteTime = dataReader.GetDateTime(11); List.Add(model); } return(List); }
/// <summary> /// 更新 /// </summary> public int Update(MyCreek.Data.Model.WorkFlowArchives model) { return(dataWorkFlowArchives.Update(model)); }
/// <summary> /// 新增 /// </summary> public int Add(MyCreek.Data.Model.WorkFlowArchives model) { return(dataWorkFlowArchives.Add(model)); }