/// <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));
}
