Example #1
0
        public static string GetSupplierReturnCode()
        {
            BuySupplierreturnDT suppReturnDT = new BuySupplierreturnDT();
            string    mmyy         = getMMyy();
            DataTable invoiceTable = suppReturnDT.GetByCond("Code like 'XT" + mmyy + "%'", " Code DESC");
            string    prefix       = "XT" + mmyy;
            string    suffix       = "0001";

            if (invoiceTable != null && invoiceTable.Rows.Count > 0)
            {
                suffix = getSuffix(invoiceTable.Rows[0]["Code"].ToString());
            }
            return(prefix + suffix);
        }
 void SaveSuppReceipt(int receiptId, string invReceiptJson, SqlTransaction tran)
 {
     try
     {
         BuySupplierreturnDT invDT = new BuySupplierreturnDT();
         List <FinSupplierreturnReceiptContract> suppReceipts = JsonConvert.DeserializeObject <List <FinSupplierreturnReceiptContract> >(invReceiptJson);
         foreach (FinSupplierreturnReceiptContract suppReceipt in suppReceipts)
         {
             suppReceipt.Receiptid = receiptId;
             invDT.Update(new string[] { " TotalDebt" }, new string[] { " TotalDebt-" + suppReceipt.Total }, " ID=" + suppReceipt.Supplierreturnid);
             suppReturnDT.Insert(suppReceipt, tran);
         }
     }
     catch (Exception e)
     {
         throw e;
     }
 }