生成的流水号格式为 228+年+月+4位流水号。 1. 月分要求2位 2. 4位流水号,不足4位前补0 /// <summary> /// 取得盘点单号最大的盘点单 /// </summary> /// <returns></returns> public static InventoryCountData GetMaxCountNo(string preStr) { var intTem = from c in WmsDataContext.Instance.InventoryCountDatas where SqlMethods.Like (c.CountNo ,preStr +"%") orderby c.CountNo descending select c; return intTem.FirstOrDefault(); } /// <summary> /// 创建盘点单单号 /// </summary> /// <returns></returns> public static string CreateCountNo() { string day = DateTime.Now.Day >= 10 ? DateTime.Now.Day.ToString() : DateTime.Now.Day.ToString().PadLeft(2,'0'); string temp = "228" + DateTime.Now.Year.ToString() + day; InventoryCountData data = InventoryCountBLL.GetMaxCountNo(temp); if (data != null) { string countNo = data.CountNo; countNo = countNo.Substring(9); countNo = countNo.TrimStart('0'); int count = Convert.ToInt32(countNo) + 1; countNo =count.ToString ().PadLeft(4,'0'); temp = temp + countNo; } else { temp= temp + "0001"; } return temp; }