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; } }