public Result UpdatePurchase([FromQuery] string ids, string pIds)
{
try
{
var purchases = new List <int>();
var idList = ids.IsNullOrEmpty() ? new List <int>() : ids.Split(",").Select(int.Parse);
var pIdList = pIds.IsNullOrEmpty() ? new List <int>() : pIds.Split(",").Select(int.Parse);
string sql;
if (idList.Any())
{
sql = "SELECT PurchaseId FROM `material_purchase_item` WHERE ErpId IN @idList AND `MarkedDelete` = 0";
purchases.AddRange(ServerConfig.ApiDb.Query <int>(sql, new { idList }));
}
if (pIdList.Any())
{
sql = "SELECT Id FROM `material_purchase` WHERE ErpId IN @pIdList AND `MarkedDelete` = 0";
purchases.AddRange(ServerConfig.ApiDb.Query <int>(sql, new { pIdList }));
}
if (purchases.Any())
{
HMaterialHelper.ErpPurchaseFunc(purchases);
}
}
catch (Exception e)
{
Log.Error($"{ids?.Join() ?? ""}|{pIds?.Join() ?? ""}, {e}");
return(Result.GenError <Result>(Error.Fail));
}
return(Result.GenError <Result>(Error.Success));
}
public Result PutMaterialPurchase([FromBody] IEnumerable <MaterialPurchase> materialPurchases)
{
if (materialPurchases == null || !materialPurchases.Any())
{
return(Result.GenError <Result>(Error.MaterialPurchaseNotExist));
}
var ids = materialPurchases.Select(x => x.Id);
var oldMaterialPurchases = MaterialPurchaseHelper.Instance.GetByIds <MaterialPurchase>(ids);
if (oldMaterialPurchases == null || !oldMaterialPurchases.Any() || oldMaterialPurchases.Count() != materialPurchases.Count())
{
return(Result.GenError <Result>(Error.MaterialPurchaseNotExist));
}
if (oldMaterialPurchases.Any(x => x.State != MaterialPurchaseStateEnum.订单完成))
{
return(Result.GenError <Result>(Error.MaterialPurchaseSateError));
}
var markedDateTime = DateTime.Now;
foreach (var purchase in oldMaterialPurchases)
{
purchase.MarkedDateTime = markedDateTime;
purchase.State = MaterialPurchaseStateEnum.开始采购;
}
MaterialPurchaseHelper.Instance.Update(oldMaterialPurchases);
HMaterialHelper.ErpPurchaseFunc(ids);
return(Result.GenError <Result>(Error.Success));
}