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