/// <summary>
/// 获取布置信息对像
/// </summary>
/// <param name="recordId"></param>
/// <returns></returns>
public WorkFilePackageContract GetWorkFilePackage(long recordId)
{
//var builder = new SelectBuilder("SELECT * from workfilepackage")
// .RegisterEqualClause("RecordId", recordId);
//return AdoProvide.ExecuteReader(ReadConnectionString, builder, reader => EntityHelper.GetEntity<WorkFilePackageContract>(reader)).FirstOrDefault();
string sql = "SELECT * from workfilepackage WHERE RecordId = @RecordId";
WorkFilePackageContract model = null;
using (var dr = MySqlHelper.ExecuteReader(ReadConnectionString, sql, new MySqlParameter("@RecordId", recordId)))
{
if (dr.Read())
{
model = new WorkFilePackageContract()
{
RecordId = dr.GetInt64("RecordId"),
FilePackageName = dr.GetString("FilePackageName"),
FilePackageType = dr.GetInt32("FilePackageType"),
UserId = dr.GetInt32("UserId"),
UserName = dr.GetString("UserName"),
CreateDate = dr.GetDateTime("CreateDate"),
Status = dr.GetInt32("Status")
};
}
}
return(model);
}
/// <summary>
/// 添加资源打包布置总表
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public long InsertWorkFilePackage(WorkFilePackageContract model)
{
var bulider = new InsertBuilder("workfilepackage")
.RegisterField("RecordId", model.RecordId)
.RegisterField("FilePackageName", model.FilePackageName)
.RegisterField("FilePackageType", model.FilePackageType)
.RegisterField("UserId", model.UserId)
.RegisterField("UserName", model.UserName ?? string.Empty)
.RegisterField("CreateDate", model.CreateDate)
.RegisterField("Status", model.Status);
return(AdoProvide.ExecuteScalar <long>(WriteConnectionString, bulider));
}
/// <summary>
/// 创建作业附件包
/// </summary>
public long CreateWorkFilePackage(WorkFilePackageContract model)
{
if (null == model || !model.WorkFileResources.Any())
{
throw new ArgumentNullException("附件资源包为null或者附件资源包中不包含任何附件");
}
long recordId = 0;
using (var trans = new TransactionScope())
{
model.CreateDate = DateTime.Now;
//打包
recordId = _workFilePackageManager.InsertWorkFilePackage(model);
_workFilePackageManager.InsertWorkFileResources(model.WorkFileResources, recordId);
trans.Complete();
}
return(recordId);
}
