public string GetNewId() { string sequencekey = this.GetInvoiceKind().ToLower(); int sequenceval = SequenceManager.GetCurrentVal(sequencekey) + 1; return(string.Format("{0}{1:d4}", System.DateTime.Now.ToString("yyyyMMdd"), sequenceval)); }
public string GetNewId() { string sequencekey = "CBOM"; SequenceManager.Increment(sequencekey); int sequenceval = SequenceManager.GetCurrentVal(sequencekey); return(string.Format("{0}{1:d5}", sequencekey, sequenceval)); }
private void RecursiveId(ref string str, string sequencekey) { if (this.ExistsId(str)) { SequenceManager.Increment(sequencekey); int sequenceval = SequenceManager.GetCurrentVal(sequencekey) + 1; str = string.Format("{0}{1:d6}", sequencekey, sequenceval); this.RecursiveId(ref str, sequencekey); } }
public string GetNewId() { // this.Validate(product); string sequencekey = "customer"; // SequenceManager.Increment(sequencekey); // string str= // SequenceManager.IncrementVal(sequencekey,); int sequenceval = SequenceManager.GetCurrentVal(sequencekey) + 1; return(string.Format("{0}{1:d5}", "C", sequenceval)); }
//public IList<Model.Supplier> Select(string SupplierStart, string SupplierEnd, DateTime dateStart, DateTime dateEnd) //{ // return accessor.Select( SupplierStart, SupplierEnd, dateStart, dateEnd); //} //protected override string GetInvoiceKind() //{ // return "Supplier"; //} //protected override string GetSettingId() //{ // return "CompanyNumberRuleOfSUPPLIER"; //} public string GetNewId(Model.SupplierCategory supplierCategory) { // this.Validate(product); string sequencekey = supplierCategory.Id; // SequenceManager.Increment(sequencekey); // string str= // SequenceManager.IncrementVal(sequencekey,); string a = "suppliercategory" + sequencekey; int sequenceval = SequenceManager.GetCurrentVal(a) + 1; return(string.Format("{0}{1:d4}", sequencekey, sequenceval)); }
public static string GetEmployeeNewId() { DateTime datetime = DateTime.Now; string invoiceKind = "emp"; string rule = null; rule = Settings.Get("EmployeeNumberRule"); if (string.IsNullOrEmpty(rule)) { return(string.Empty); } string sequencekey_y = string.Format("{0}-y-{1}", invoiceKind, datetime.Year); string sequencekey_m = string.Format("{0}-m-{1}-{2}", invoiceKind, datetime.Year, datetime.Month); string sequencekey_d = string.Format("{0}-d-{1}", invoiceKind, datetime.ToString("yyyy-MM-dd")); string sequencekey = invoiceKind; if (rule.IndexOf("{D2}") >= 0) { sequencekey = sequencekey_d; } else if (rule.IndexOf("{M2}") >= 0) { sequencekey = sequencekey_m; } else if (rule.IndexOf("{Y2}") >= 0 || rule.IndexOf("{Y4}") >= 0) { sequencekey = sequencekey_y; } else { sequencekey = invoiceKind; } int sequenceval = SequenceManager.GetCurrentVal(sequencekey); sequenceval++; string d2 = string.Format("{0:d2}", datetime.Day); string m2 = string.Format("{0:d2}", datetime.Month); string y2 = string.Format("{0:d2}", datetime.Year); string y4 = string.Format("{0:d4}", datetime.Year); string n4 = string.Format("{0:d5}", sequenceval); string Id = rule.Replace("{D2}", d2).Replace("{M2}", m2).Replace("{Y2}", y2).Replace("{Y4}", y4).Replace("{N}", n4); return(Id); }
public string GetNewId(Model.ProductCategory productCategory) { // this.Validate(product); if (productCategory == null) { return(string.Empty); } string sequencekey = productCategory.Id; //SequenceManager.Increment(sequencekey); // SequenceManager.Increment(sequencekey); // string str= // SequenceManager.IncrementVal(sequencekey,); int sequenceval = SequenceManager.GetCurrentVal(sequencekey) + 1; return(string.Format("{0}{1:d6}", sequencekey, sequenceval)); }
public string GetIdSimple(DateTime dt) { string settingId = this.GetSettingId(); string invoiceKind = this.GetInvoiceKind().ToLower(); DateTime datetime = dt; if (string.IsNullOrEmpty(invoiceKind) || string.IsNullOrEmpty(settingId)) { return(string.Empty); } string rule = Settings.Get(settingId); if (string.IsNullOrEmpty(rule)) { return(string.Empty); } string sequencekey_d = string.Format("{0}-d-{1}", invoiceKind, datetime.ToString("yyyy-MM-dd")); string sequencekey = sequencekey_d; int sequenceval = SequenceManager.GetCurrentVal(sequencekey); int a = sequenceval; sequenceval++; string d2 = string.Format("{0:d2}", datetime.Day); string m2 = string.Format("{0:d2}", datetime.Month); string y2 = string.Format("{0:d2}", datetime.Year).Substring(2, 2); string y4 = string.Format("{0:d4}", datetime.Year); string n1 = string.Format("{0:d1}", sequenceval); string n2 = string.Format("{0:d2}", sequenceval); string n3 = string.Format("{0:d3}", sequenceval); string n4 = string.Format("{0:d4}", sequenceval); return(rule.Replace("{D2}", d2).Replace("{M2}", m2).Replace("{Y2}", y2).Replace("{Y4}", y4).Replace("{N}", n4).Replace("{N1}", n1).Replace("{N2}", n2).Replace("{N3}", n3).Replace("{N4}", n4)); }
protected string GetEntityId(DateTime dt) { string settingId = this.GetSettingId(); string invoiceKind = this.GetInvoiceKind().ToLower(); datetime = dt; if (string.IsNullOrEmpty(invoiceKind) || string.IsNullOrEmpty(settingId)) { return(string.Empty); } string rule = Settings.Get(settingId); if (string.IsNullOrEmpty(rule)) { return(string.Empty); } string sequencekey_y = string.Format("{0}-y-{1}", invoiceKind, datetime.Year); string sequencekey_m = string.Format("{0}-m-{1}-{2}", invoiceKind, datetime.Year, datetime.Month); string sequencekey_d = string.Format("{0}-d-{1}", invoiceKind, datetime.ToString("yyyy-MM-dd")); string sequencekey = invoiceKind; if (rule.IndexOf("{D2}") >= 0) { sequencekey = sequencekey_d; } else if (rule.IndexOf("{M2}") >= 0) { sequencekey = sequencekey_m; } else if (rule.IndexOf("{Y2}") >= 0 || rule.IndexOf("{Y4}") >= 0) { sequencekey = sequencekey_y; } else { sequencekey = invoiceKind; } int sequenceval = SequenceManager.GetCurrentVal(sequencekey); int a = sequenceval; sequenceval++; string d2 = string.Format("{0:d2}", datetime.Day); string m2 = string.Format("{0:d2}", datetime.Month); string y2 = string.Format("{0:d2}", datetime.Year); string y4 = string.Format("{0:d4}", datetime.Year); string n4 = string.Format("{0:d4}", (int)sequenceval); string n1 = string.Format("{0:d1}", sequenceval); string n2 = string.Format("{0:d2}", sequenceval); string n3 = string.Format("{0:d3}", sequenceval); string n5 = string.Format("{0:d5}", sequenceval); string n6 = string.Format("{0:d6}", sequenceval); string n7 = string.Format("{0:d7}", sequenceval); string n8 = string.Format("{0:d8}", sequenceval); string n9 = string.Format("{0:d9}", sequenceval); string n10 = string.Format("{0:d10}", sequenceval); return(rule.Replace("{D2}", d2).Replace("{M2}", m2).Replace("{Y2}", y2).Replace("{Y4}", y4).Replace("{N}", n4).Replace("{N1}", n1).Replace("{N2}", n2).Replace("{N3}", n3).Replace("{N4}", n4).Replace("{N5}", n5).Replace("{N6}", n6).Replace("{N7}", n7).Replace("{N8}", n8).Replace("{N9}", n9).Replace("{N10}", n10)); }
/// <summary> /// 获取连续Id,比如说20200909001,20200909002,删除001后,再新增还是001 /// </summary> /// <returns></returns> public string GetConsecutiveId(DateTime dt) { string settingId = this.GetSettingId(); string invoiceKind = this.GetInvoiceKind().ToLower(); DateTime datetime = dt; if (string.IsNullOrEmpty(invoiceKind) || string.IsNullOrEmpty(settingId)) { return(string.Empty); } string rule = Settings.Get(settingId); if (string.IsNullOrEmpty(rule)) { return(string.Empty); } string sequencekey_y = string.Format("{0}-y-{1}", invoiceKind, datetime.Year); string sequencekey_m = string.Format("{0}-m-{1}-{2}", invoiceKind, datetime.Year, datetime.Month); string sequencekey_d = string.Format("{0}-d-{1}", invoiceKind, datetime.ToString("yyyy-MM-dd")); string sequencekey = invoiceKind; if (rule.IndexOf("{D2}") >= 0) { sequencekey = sequencekey_d; } else if (rule.IndexOf("{M2}") >= 0) { sequencekey = sequencekey_m; } else if (rule.IndexOf("{Y2}") >= 0 || rule.IndexOf("{Y4}") >= 0) { sequencekey = sequencekey_y; } else { sequencekey = invoiceKind; } string d2 = string.Format("{0:d2}", datetime.Day); string m2 = string.Format("{0:d2}", datetime.Month); string y2 = string.Format("{0:d2}", datetime.Year); string y4 = string.Format("{0:d4}", datetime.Year); Func <int, string> getId = (sequenceval) => { string n1 = string.Format("{0:d1}", sequenceval); string n2 = string.Format("{0:d2}", sequenceval); string n3 = string.Format("{0:d3}", sequenceval); string n4 = string.Format("{0:d4}", sequenceval); string n5 = string.Format("{0:d5}", sequenceval); string n6 = string.Format("{0:d6}", sequenceval); string n7 = string.Format("{0:d7}", sequenceval); string n8 = string.Format("{0:d8}", sequenceval); string n9 = string.Format("{0:d9}", sequenceval); string n10 = string.Format("{0:d10}", sequenceval); return(rule.Replace("{D2}", d2).Replace("{M2}", m2).Replace("{Y2}", y2).Replace("{Y4}", y4).Replace("{N}", n4).Replace("{N1}", n1).Replace("{N2}", n2).Replace("{N3}", n3).Replace("{N4}", n4).Replace("{N5}", n5).Replace("{N6}", n6).Replace("{N7}", n7).Replace("{N8}", n8).Replace("{N9}", n9).Replace("{N10}", n10)); }; //int sequenceval = 1; int currentVal = SequenceManager.GetCurrentVal(sequencekey); //sequenceval++; string id = ""; for (int i = 1; i <= currentVal; i++) { id = getId(i); if (!IsExistsId(id)) { return(id); } } id = getId(++currentVal); return(id); }
private int isUpdate = 0; //如果执行过修改 为1; // private static readonly DA.IInvoiceZSDetailAccessor invoiceZSDetailAccessor = (DA.IInvoiceZSDetailAccessor)Accessors.Get("InvoiceZSDetailAccessor"); public string GetNewId(DateTime datetime) { string invoiceKind = this.GetInvoiceKind().ToLower(); string rule = Settings.Get("InvoiceNumberRuleOf" + invoiceKind.ToUpper()); if (string.IsNullOrEmpty(rule)) { return(string.Empty); } string sequencekey_y = string.Format("{0}-y-{1}", invoiceKind, datetime.Year); string sequencekey_m = string.Format("{0}-m-{1}-{2}", invoiceKind, datetime.Year, datetime.Month); string sequencekey_d = string.Format("{0}-d-{1}", invoiceKind, datetime.ToString("yyyy-MM-dd")); //SequenceManager.Increment(sequencekey_y); //SequenceManager.Increment(sequencekey_m); //SequenceManager.Increment(sequencekey_d); string sequencekey = invoiceKind; if (rule.IndexOf("{D2}") >= 0) { sequencekey = sequencekey_d; } else if (rule.IndexOf("{M2}") >= 0) { sequencekey = sequencekey_m; } else if (rule.IndexOf("{Y2}") >= 0 || rule.IndexOf("{Y4}") >= 0) { sequencekey = sequencekey_y; } else { sequencekey = invoiceKind; } int sequenceval = SequenceManager.GetCurrentVal(sequencekey); sequenceval++; string d2 = string.Format("{0:d2}", datetime.Day); string m2 = string.Format("{0:d2}", datetime.Month); string y2 = string.Format("{0:d2}", datetime.Year); string y4 = string.Format("{0:d4}", datetime.Year); string n4 = string.Format("{0:d4}", sequenceval); string n1 = string.Format("{0:d1}", sequenceval); string n2 = string.Format("{0:d2}", sequenceval); string n3 = string.Format("{0:d3}", sequenceval); string n5 = string.Format("{0:d5}", sequenceval); string n6 = string.Format("{0:d6}", sequenceval); string n7 = string.Format("{0:d7}", sequenceval); string n8 = string.Format("{0:d8}", sequenceval); string n9 = string.Format("{0:d9}", sequenceval); string n10 = string.Format("{0:d10}", sequenceval); //if(rule.IndexOf("{N}") >= 0 || rule.IndexOf("{N1}") >= 0 || rule.IndexOf("{N2}") >= 0 || rule.IndexOf("{N3}") >= 0 || rule.IndexOf("{N4}") >= 0 || rule.IndexOf("{N5}") >= 0 || rule.IndexOf("{N6}") >= 0 || rule.IndexOf("{N7}") >= 0 || rule.IndexOf("{N8}") >= 0 || rule.IndexOf("{N9}") >= 0 || rule.IndexOf("{N10}") >= 10 ) return(rule.Replace("{D2}", d2).Replace("{M2}", m2).Replace("{Y2}", y2).Replace("{Y4}", y4).Replace("{N}", n4).Replace("{N1}", n1).Replace("{N2}", n2).Replace("{N3}", n3).Replace("{N4}", n4).Replace("{N5}", n5).Replace("{N6}", n6).Replace("{N7}", n7).Replace("{N8}", n8).Replace("{N9}", n9).Replace("{N10}", n10)); //else }