Пример #1
0
        public DataTable GetTableData(string strPartyName, string strBillNo, string strBOENo)
        {
            DataTable dt = new DataTable();
            tblGetTableDataTableAdapter adp = new tblGetTableDataTableAdapter();

            dt = adp.GetTableData(strPartyName, Convert.ToInt32(strBillNo), strBOENo);
            return(dt);
        }
Пример #2
0
        public double GetTotal(string strPartyName, string strBillNo, string strBOENo)
        {
            tblGetTableDataTableAdapter adp = new tblGetTableDataTableAdapter();
            double total = 0;

            foreach (var x in adp.GetTableData(strPartyName, Convert.ToInt32(strBillNo), strBOENo))
            {
                total += x.monTotalPrice;
            }

            Int64 amount_int = (Int64)total;
            Int64 amount_dec = (Int64)Math.Round((total - (double)(amount_int)) * 100);

            total = amount_int + ((double)(amount_dec) / 100);

            return(total);
        }