예제 #1
0
        public void SaveInvoice()
        {
            StringBuilder sbQry = new StringBuilder();
            clsDB         oDB   = new clsDB();

            try
            {
                oDB.Connect();
                oDB.BeginTran();
                foreach (Item ItemObj in this.ItemObject)
                {
                    sbQry.AppendLine("Insert Into Invoice(TinNo,PanNo,BillNo,InvoiceDate,InvoiceDateTime,Address,PoNo");
                    sbQry.AppendLine(",ItemDesc,Qty,Rate,Amount,Vat,GrandTotalWords)  Values('" + TinNo + "','" + PanNo + "'");
                    sbQry.AppendLine(",'" + BillNo + "','" + DateTime.Now.ToString("dd-MMM-yyyy") + "',Getdate(),'" + Address + "'");
                    sbQry.AppendLine(",'" + PoNo + "','" + ItemObj.ItemDesc + "'," + ItemObj.ItemQty + "," + ItemObj.Rate + "," + ItemObj.Amount + ",'" + Vat + "','" + GrandTotalInWords + "')");
                    oDB.ExecuteNonQuery(sbQry.ToString());
                    sbQry.Length = 0;
                }
                oDB.CommitTran();
            }
            catch (Exception ex)
            {
                oDB.RollBackTran();
                throw ex;
            }
            finally
            {
                sbQry = null;
                oDB.DisConnect();
                oDB = null;
            }
        }