예제 #1
0
        //根据账单号查询账单明细记录总数
        private void BindBillDetailCount(string billheadid)
        {
            try
            {
                Hashtable ht = GetDetailSqlWhere(billheadid);
                gvDetail.RecordCount = billdetailService.SelectBilldetailListCount("Receive", ht);
                IList <Billdetail> detailList = billdetailService.GetBilldetailStatisticsByOrdernum("Receive", ht);
                string             msg        = "";
                if (detailList.Count > 0)
                {
                    gvDetail.SelectedRowIndexArray = new int[] { 0 };

                    msg  = " 订单数目:" + detailList.Count;
                    msg += "  标准金额:" + detailList.Sum(c => c.Standardprice);
                    msg += "  分点金额:" + detailList.Sum(c => c.Groupprice);
                    msg += "  应收金额:" + detailList.Sum(c => c.Contractprice);
                    msg += "  实收金额:" + detailList.Sum(c => c.Finalprice);
                }
                tbxMsg.Text = msg;
            }
            catch (Exception ex)
            {
                MessageBoxShow(ex.Message);
            }
        }
예제 #2
0
        //绑定记录总数
        private void BindDataCount()
        {
            try
            {
                Hashtable ht = (Hashtable)ViewState["sqlWhere"];
                gvList.RecordCount = billdetailService.SelectBilldetailListCount("PrepareOut", ht);
                IList <Billdetail> detailList = billdetailService.GetBilldetailStatisticsByOrdernum("PrepareOut", ht);

                string msg = "";
                if (detailList.Count > 0)
                {
                    gvList.SelectedRowIndexArray = new int[] { 0 };
                    msg  = " 订单数目:" + detailList.Count;
                    msg += " 标准金额:" + detailList.Sum(c => c.Standardprice);
                    msg += " 分点金额:" + detailList.Sum(c => c.Groupprice);
                    msg += " 应收金额:" + detailList.Sum(c => c.Contractprice);
                    msg += " 实收金额:" + detailList.Sum(c => c.Finalprice);
                }
                tbxMsg.Text = msg;
            }
            catch (Exception ex)
            {
                MessageBoxShow(ex.Message, MessageBoxIcon.Error);
            }
        }