public string generateOrderNumber() { string result = ""; var year = DateTime.Now.Year; var month = DateTime.Now.Month; var data = _ctx.runningNumber.Where(f => f.Year == year && f.RunningMonth == month).FirstOrDefault(); if (data == null) { data = new RunningNumber(); data.Year = year; data.RunningMonth = month; data.Prefix = "ODR"; data.CurrentNo = 1; _ctx.runningNumber.Add(data); _ctx.SaveChanges(); result = $"{data.Year}/{data.RunningMonth}/{data.Prefix}/{data.CurrentNo.ToString().PadLeft(4,'0')}"; } else { data.CurrentNo++; _ctx.runningNumber.Update(data); _ctx.SaveChanges(); result = $"{data.Year}/{data.RunningMonth}/{data.Prefix}/{data.CurrentNo.ToString().PadLeft(4,'0')}"; } return(result); }
public string NextId(string key) { RunningNumber num = LoadUnique(key); runNbrTba.UpdateNextId(num.NextId + 1, DateTime.Now, key); return(num.ToString(true)); }
public static dynamic GetTSObject(RunningNumber dynObject) { if (dynObject is null) { return(null); } return(dynObject.teklaObject); }
public RunningNumber CreateReceivingRunningNumber(int month, int year) { var runNumber = new RunningNumber(); runNumber.Month = month; runNumber.Year = year; runNumber.FormCode = "RCV"; runNumber.Prefix = runNumber.FormCode; runNumber.CurrentNo = 1; context.RunningNumbers.InsertOnSubmit(runNumber); context.SubmitChanges(); return(runNumber); }
private RunningNumber CreateInvoiceNo() { var runNo = new RunningNumber(); runNo.Month = 0; runNo.Year = DateTime.Today.Year; runNo.EntityCode = INVOICE_ENTITY; runNo.Prefix = "INV"; runNo.CurrentNo = 1; runNo.ChangedWhen = DateTime.Now; runNo.ChangedWho = principal.Identity.Name; repository.Add(runNo); return(runNo); }
private RunningNumber CreateConfirmationLetterNo() { var runNo = new RunningNumber(); runNo.Month = 0; runNo.Year = DateTime.Today.Year; runNo.EntityCode = CONFIRMATION_LETTER_ENTITY; runNo.Prefix = "COL"; runNo.CurrentNo = 1; runNo.ChangedWhen = DateTime.Now; runNo.ChangedWho = principal.Identity.Name; repository.Add(runNo); return(runNo); }
private RunningNumber CreateCustomerRunningNumber() { var runNo = new RunningNumber(); runNo.Month = DateTime.Today.Month; runNo.Year = DateTime.Today.Year; runNo.EntityCode = CUSTOMER_ENTITY; runNo.Prefix = "CUS"; runNo.CurrentNo = 1; runNo.ChangedWhen = DateTime.Now; runNo.ChangedWho = principal.Identity.Name; repository.Add(runNo); return(runNo); }
public RunningNumber LoadUnique(string key) { try { RunningNumber item = new RunningNumber(); DataTable tb = runNbrTba.GetDataByKey(key); if (tb.Rows.Count != 0) { item = (RunningNumber)QueryForObject(tb.Rows[0], typeof(RunningNumber)); return(item); } return(null); } catch { return(null); } }
public void CreateRunningNumber(string key, RunningNumberMask mask) { var sn = new RunningNumber(key, mask); repository.Save(sn); }
public object QueryForObject(DataRow row, Type t) { if (t == typeof(RunningNumber)) { RunningNumber item = new RunningNumber(); try { item.Key = Convert.ToString(row["DocKey"]); } catch { } try { item.Prefix = Convert.ToString(row["DocPrefix"]); } catch { } try { item.LenYearPrefix = Convert.ToInt32(row["YearNbrPrefix"]); } catch { } try { item.LenMonthPrefix = Convert.ToInt32(row["MonthNbrPrefix"]); } catch { } try { item.LenDayPrefix = Convert.ToInt32(row["DayNbrPrefix"]); } catch { } try { item.LenRunId = Convert.ToInt32(row["FormatNbr"]); } catch { } try { item.NextId = Convert.ToInt32(row["NextId"]); } catch { } try { item.ActiveDate = Convert.ToDateTime(row["ActiveDate"]); } catch { } try { item.Date = Convert.ToDateTime(row["CurDate"]); } catch { } try { item.Remark = Convert.ToString(row["Remark"]); } catch { } try { item.ResetOption = Convert.ToString(row["ResetOption"]); } catch { } return(item); } else { return(null); } }