/// <summary> /// 库存预警-查询 /// </summary> /// <param name="purOrderNo"></param> /// <param name="supID"></param> /// <param name="updUser"></param> /// <param name="SDate"></param> /// <param name="EDate"></param> /// <param name="pagesize"></param> /// <param name="currentPage"></param> /// <param name="total"></param> /// <returns></returns> public List <vwhinventorywarning> GetWhInventoryWarning(int pagesize, int currentPage, string pdtID, string orderby, string order, out int total) { try { List <vwhinventorywarning> list = new List <vwhinventorywarning>(); var tem = from f in erpsEntities.vwhinventorywarning.AsNoTracking() select f; if (!string.IsNullOrEmpty(pdtID)) { tem = tem.Where(w => w.PdtID.Contains(pdtID)); } if (string.IsNullOrEmpty(orderby) || string.IsNullOrEmpty(order)) // 没有排序信息,直接按预警排序 { tem = tem.OrderBy(o => o.WN1).ThenBy(o => o.WN2).ThenBy(o => o.WN3); } else { string orderPhase = "ASC"; if (order.ToLower() == "descending") { orderPhase = "DESC"; } tem = Tool.SetQueryableOrder(tem, orderby, orderPhase); } total = tem.Count(); tem = tem .Skip(pagesize * (currentPage - 1)) .Take(pagesize); list = tem.ToList(); return(list); } catch (Exception) { throw; } }
public List <v_saleforcast> GetSaleForcast(string CusID, string CusName, string SaleFocaNO, string State, string SDate, string EDate, int pagesize, int currentPage, string orderby, string order, out int total) { try { List <v_saleforcast> list = new List <v_saleforcast>(); var tem = from f in erpsEntities.v_saleforcast.AsNoTracking() select f; if (!string.IsNullOrEmpty(SaleFocaNO)) { tem = tem.Where(w => w.SaleFocaNO.Contains(SaleFocaNO)); } if (!string.IsNullOrEmpty(CusID)) { tem = tem.Where(w => w.CusID.Contains(CusID)); } if (!string.IsNullOrEmpty(CusName)) { tem = tem.Where(w => w.CusName.Contains(CusName)); } if (!string.IsNullOrEmpty(State)) { tem = tem.Where(w => w.State.Contains(State)); } if (!string.IsNullOrEmpty(SDate)) { DateTime date = Convert.ToDateTime(SDate); tem = tem.Where(w => w.CreDate >= date); } if (!string.IsNullOrEmpty(EDate)) { DateTime date = Convert.ToDateTime(EDate); date = date.AddDays(1); tem = tem.Where(w => w.CreDate < date); } if (string.IsNullOrEmpty(orderby) || string.IsNullOrEmpty(order)) // 没有排序信息,直接按预警排序 { tem = tem.OrderByDescending(o => o.CreateDate); } else { string orderPhase = "ASC"; if (order.ToLower() == "descending") { orderPhase = "DESC"; } tem = Tool.SetQueryableOrder(tem, orderby, orderPhase); } total = tem.Count(); tem = tem .Skip(pagesize * (currentPage - 1)) .Take(pagesize); list = tem.ToList(); return(list); } catch (Exception) { throw; } }