/// <summary>
/// 获取布置信息对像
/// </summary>
/// <param name="recordId"></param>
/// <returns></returns>
public PublishRecordContract GetWorkPackage(long recordId)
{
PublishRecordContract model = null;
string sql = "SELECT * from publishRecord WHERE RecordId = @RecordId";
using (var dr = MySqlHelper.ExecuteReader(ReadConnectionString, sql, new MySqlParameter("@RecordId", recordId)))
{
if (dr.Read())
{
model = new PublishRecordContract()
{
RecordId = dr.GetInt64("RecordId"),
ProductId = dr.GetString("ProductId"),
AppId = dr.GetInt32("AppId"),
PackageId = dr.GetInt64("PackageId"),
PackageName = dr.GetString("PackageName"),
PackageType = dr.GetInt32("PackageType"),
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 InsertPublishRecord(PublishRecordContract model)
{
var bulider = new InsertBuilder("publishRecord")
.RegisterField("ProductId", model.ProductId)
.RegisterField("AppId", model.AppId)
.RegisterField("PackageId", model.PackageId)
.RegisterField("PackageName", model.PackageName ?? string.Empty)
.RegisterField("PackageType", model.PackageType)
.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 CreateWorkPackage(PublishRecordContract model)
{
long recordId = 0;
using (var trans = new TransactionScope())
{
//打包
recordId = _publishRecordManager.InsertPublishRecord(model);
//打包资源
foreach (var item in model.workResources)
{
item.RecordId = recordId;
item.IsFull = item.resourceParts.Any();
_publishRecordManager.InsertWorkResource(item);
item.resourceParts.ToList().ForEach(t => t.ContentId = item.ContentId);
}
_publishRecordManager.InsertResourceParts(model.workResources.SelectMany(t => t.resourceParts));
trans.Complete();
}
return(recordId);
}
