public string GetBillNoTemp(int billNoId) { string billNo = ""; var sysBillNOEntity = _sysBillNo.SingleAsNoTracking(b => b.id == billNoId); string currentDate = _getSysDateTimeService.GetSysDateTime().ToString("yyyyMMdd"); if (sysBillNOEntity.HasValue) { //获取最大流水号 int maxNo = 0; SysBillNo sysBillNo = sysBillNOEntity.Entity; if (sysBillNo.max_date == null || sysBillNo.max_date != currentDate || sysBillNo.max_no == null) { maxNo = 1; } else { maxNo = sysBillNo.max_no.Value + 1; } //设置单据编号 billNo = sysBillNo.prefix.Trim() + currentDate + maxNo.ToString().PadLeft(sysBillNo.num_bit, '0'); } return(billNo); }
//根据系统system 和前缀 prefix 取得单据编号ID public int GetBillNoID(string billNoSystem, string billNoPrefix) { int billNoID = 0; //var sysBillNOEntity = _sysBillNo.SingleAsNoTracking(d => d.system == billNoSystem && d.prefix == billNoPrefix); var sysBillNOEntity = _sysBillNo.Single(d => d.system == billNoSystem && d.prefix == billNoPrefix); if (sysBillNOEntity.HasValue) { SysBillNo sysBillNo = sysBillNOEntity.Entity; billNoID = sysBillNo.id; } return(billNoID); }