//绑定记录总数 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); } }
//根据账单号查询账单明细记录总数 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); } }