/// <summary> /// 获取当天最大单号 /// </summary> /// <param name="date"></param> /// <returns></returns> public object GetTodayMax(string date, int currency, string sup = null) { var prices = service.IQueryable(t => t.purNo.Contains(date)).OrderByDescending(t => t.purNo); int maxNum = 0000; int todayNum = 0, supNum = 0; string purNo = ""; if (prices.Count() > 0) { foreach (var p in prices) { var num = Convert.ToInt32(p.purNo.Remove(0, 6)); if (num > todayNum) { todayNum = num;//当天最大单号 } } var purSup = prices.Where(s => s.purSup.Equals(sup)); if (purSup.Count() > 0) { foreach (var p in purSup) { var num = Convert.ToInt32(p.purNo.Remove(0, 6)); if (num > supNum) { supNum = num;//同一供应商当天最大单号 purNo = p.purNo; } } var purList = service.IQueryable(s => s.purSup.Equals(sup) && s.purNo.Equals(purNo)).ToList(); if (purList.Count < 5) { maxNum = supNum - 1; } else { maxNum = todayNum; } foreach (var pur in purList) { var price = new PriceApp().GetFormJson(pur.priNO); if (price.currency.Value != currency) { maxNum = todayNum; } if (pur.prtTag == "T")//一旦有打印过 采购单号加一 { maxNum = todayNum; } } } else { maxNum = todayNum; } } return(maxNum); }
/// <summary> /// 获取当天最大单号 /// </summary> /// <param name="date"></param> /// <returns></returns> public object GetTodayMax(string date, string po, int currency, string sup = null, string dep = null) { try { var prices = service.IQueryable(t => t.billNo.Contains(po) && t.billNo.Contains(date)); int maxNum = 0000; int todayNum = 0, supNum = 0; string billNo = ""; if (prices.Count() > 0) { foreach (var p in prices) { var num = Convert.ToInt32(p.billNo.Remove(0, 6)); if (num > todayNum) { todayNum = num;//当天最大单号 } } var purSup = prices.Where(s => s.purSup.Equals(sup)); if (purSup.Count() > 0) { foreach (var p in purSup) { var num = Convert.ToInt32(p.billNo.Remove(0, 6)); if (num > supNum) { supNum = num;//同一供应商当天最大单号 billNo = p.billNo; } } var purList = service.IQueryable(s => s.purSup.Equals(sup) && s.billNo.Equals(billNo)).ToList(); if (purList.Count < 5) { maxNum = supNum - 1; } else { maxNum = todayNum; } foreach (var pur in purList) { var apply = new ApplyBillApp().GetForm(pur.fromID); if (pur.billNo.Contains("PP")) { var bill = new BillApp().GetForm(pur.fromID); apply = new ApplyBillApp().GetForm(bill.fromID); } var price = new PriceApp().GetFormJson(apply.priNO); if (price.currency.Value != currency)//币别不同 单号加一 { maxNum = todayNum; } if (pur.prtTag == "T")//一旦有打印过 采购单号加一 { maxNum = todayNum; } if (!string.IsNullOrEmpty(dep)) { if (!apply.appDep.Equals(dep)) { maxNum = todayNum;//领用单部门不同 单号加一 } } } } else { maxNum = todayNum; } } return(maxNum); } catch (Exception ex) { throw; } }