/// <summary>
/// 根据商品SysNo获取商品批号和历史备注
/// </summary>
/// <param name="productSysNo"></param>
/// <returns></returns>
public static ProductBatchManagementInfo GetProductBatchManagementInfo(int productSysNo)
{
DataCommand cmd = DataCommandManager.GetDataCommand("GetProductBatchManagementInfo");
cmd.SetParameterValue("@ProductSysNo", productSysNo);
var result = cmd.ExecuteEntity <ProductBatchManagementInfo>();
if (result != null)
{
result.Logs = GetProductBatchManagementLogByBatchManagementSysNo(result.SysNo.Value);
foreach (var item in result.Logs)
{
result.Notes += item.InDate.ToString() + "," + item.InUser + "," + item.Note;
}
}
else
{
result = new ProductBatchManagementInfo();
result.ProductSysNo = productSysNo;
result.IsBatch = false;
result.IsCollectBatchNo = false;
result.CollectType = 0;
}
return(result);
}
public void UpdateIsBatch(ProductBatchManagementInfo batchManagementInfo)
{
DataCommand cmd = DataCommandManager.GetDataCommand("UpdateProductBatchManagementInfo");
cmd.SetParameterValue(batchManagementInfo);
cmd.SetParameterValue("@IsBatch", batchManagementInfo.IsBatch.Value ? "Y" : "N");
cmd.SetParameterValue("@IsCollectBatchNo", batchManagementInfo.IsCollectBatchNo.Value ? "Y" : "N");
cmd.SetParameterValueAsCurrentUserAcct("@UserAcct");
//cmd.SetParameterValue("@CompanyCode","8601");
//cmd.SetParameterValue("@LanguageCode","zh-CN");
//cmd.SetParameterValue("@StoreCompanyCode","8601");
cmd.ExecuteNonQuery();
}
/// <summary>
/// 更新商品批号
/// </summary>
/// <param name="batchManagementInfo"></param>
public static void UpdateIsBatch(ProductBatchManagementInfo batchManagementInfo)
{
DataCommand cmd = DataCommandManager.GetDataCommand("UpdateProductBatchManagementInfo");
//cmd.SetParameterValue(batchManagementInfo);
cmd.SetParameterValue("@IsBatch", batchManagementInfo.IsBatch.Value ? "Y" : "N");
cmd.SetParameterValue("@ProductSysNo", batchManagementInfo.ProductSysNo);
cmd.SetParameterValue("@CollectType", batchManagementInfo.CollectType == CollectDateType.ExpiredDate ? "E" : "P");
cmd.SetParameterValue("@IsCollectBatchNo", batchManagementInfo.IsCollectBatchNo.Value ? "Y" : "N");
cmd.SetParameterValue("@MinReceiptDays", batchManagementInfo.MinReceiptDays);
cmd.SetParameterValue("@MaxDeliveryDays", batchManagementInfo.MaxDeliveryDays);
cmd.SetParameterValue("@GuaranteePeriodYear", batchManagementInfo.GuaranteePeriodYear);
cmd.SetParameterValue("@GuaranteePeriodMonth", batchManagementInfo.GuaranteePeriodMonth);
cmd.SetParameterValue("@GuaranteePeriodDay", batchManagementInfo.GuaranteePeriodDay);
cmd.SetParameterValue("@EidtUser", batchManagementInfo.EidtUser);
cmd.ExecuteNonQuery();
}
public ProductBatchManagementInfo UpdateIsBatch(ProductBatchManagementInfo batchManagementInfo)
{
using (var scope = TransactionScopeFactory.CreateTransactionScope())
{
productExtDA.UpdateIsBatch(batchManagementInfo);
var batch = productExtDA.GetProductBatchManagementInfo(batchManagementInfo.ProductSysNo.Value);
if (!string.IsNullOrEmpty(batchManagementInfo.Note) && batchManagementInfo.IsBatch.Value)
{
var log = new ProductBatchManagementInfoLog {
Note = batchManagementInfo.Note, BatchManagementSysNo = batch.SysNo
};
productExtDA.InsertProductBatchManagementLog(log);
}
scope.Complete();
}
return(productExtDA.GetProductBatchManagementInfo(batchManagementInfo.ProductSysNo.Value));
}
public virtual ProductBatchManagementInfo UpdateIsBatch(ProductBatchManagementInfo productExtInfo)
{
return(ObjectFactory <ProductExtAppService> .Instance.UpdateIsBatch(productExtInfo));
}
public ProductBatchManagementInfo UpdateIsBatch(ProductBatchManagementInfo extInfo)
{
return(ObjectFactory <ProductExtProcessor> .Instance.UpdateIsBatch(extInfo));
}
