public static int SaveTireStockWhite(string pids)
{
var result = -99;
using (var dbHelper = new Tuhu.Component.Common.SqlDbHelper(ConnectionHelper.GetDecryptConn("Gungnir")))
{
dbHelper.BeginTransaction();
foreach (var pid in pids.Split(';'))
{
var isUpdate = DalStockoutStatus.FetchPidStatus(dbHelper, pid);
if (isUpdate)
{
result = DalStockoutStatus.UpdateWhite(dbHelper, pid);
}
else
{
result = DalStockoutStatus.InsertWhite(dbHelper, pid);
}
if (result <= 0)
{
dbHelper.Rollback();
return(result);
}
}
dbHelper.Commit();
return(1);
}
}
public static IEnumerable <ShowStatusModel> GetShowStatusByPids(List <string> pids)
{
var data = DalStockoutStatus.GetStockoutStatusByPids(pids);
var result = new List <ShowStatusModel>();
foreach (var item in data)
{
var Status = 0;
var val = new ShowStatusModel()
{
PID = item.PID
};
if (!item.OnSale)
{
Status = 3;
}
else if (!item.IsShow)
{
Status = 3;
}
else if (item.Status)
{
Status = 1;
}
else if (item.Stuckout)
{
Status = 2;
}
else if (item.SystemStuckout != "有货")
{
Status = 2;
}
else
{
Status = 1;
}
val.ShowStatus = Status;
result.Add(val);
}
return(result);
}
public static List <RegionStockModel> SelectRegionStockList(RegionStockRequest model, PagerModel pager) => DalStockoutStatus.SelectRegionStockList(model, pager);
public static int RemoveWhite(string pid)
{
return(DalStockoutStatus.RemoveWhite(pid));
}
public static IEnumerable <StockoutStatusWhiteModel> SelectWhiteList(WhiteRequest model, PagerModel pager) => DalStockoutStatus.SelectWhiteList(model, pager);
public static IEnumerable <StockoutStatusModel> SelectList(StockoutStatusRequest request, PagerModel pager) => DalStockoutStatus.SelectList(request, pager);
