/// <summary> /// 更新记录 /// </summary> /// <param name="model">Data.Model.WorkFlowArchives实体类</param> public int Update(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">Data.Model.WorkFlowArchives实体类</param> /// <returns>操作所影响的行数</returns> public int Add(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> /// 将DataRedar转换为List /// </summary> private List <Data.Model.WorkFlowArchives> DataReaderToList(SqlDataReader dataReader) { List <Data.Model.WorkFlowArchives> List = new List <Data.Model.WorkFlowArchives>(); Data.Model.WorkFlowArchives model = null; while (dataReader.Read()) { model = new 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(Data.Model.WorkFlowArchives model) { return(dataWorkFlowArchives.Update(model)); }
/// <summary> /// 新增 /// </summary> public int Add(Data.Model.WorkFlowArchives model) { return(dataWorkFlowArchives.Add(model)); }