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