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
}
