Ejemplo n.º 1
0
        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);
        }
Ejemplo n.º 2
0
    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);
        }
Ejemplo n.º 5
0
        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);
        }
Ejemplo n.º 6
0
        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);
        }
Ejemplo n.º 7
0
        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);
        }
Ejemplo n.º 8
0
 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);
        }
Ejemplo n.º 10
0
    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);
        }
    }