private void BindGrid() { DateTime dtbegin, dtend; int salesman, deliveryman; DateTime.TryParse(tbx_begin.Text, out dtbegin); DateTime.TryParse(tbx_end.Text, out dtend); int.TryParse(ddl_SalesMan.SelectedValue, out salesman); int.TryParse(ddl_DeliveryMan.SelectedValue, out deliveryman); if (gv_List_Product.Visible) { DataTable dt = PBM_DeliveryBLL.GetDeliverySummary_ByProduct((int)Session["OwnerClient"], salesman, deliveryman, 0, dtbegin, dtend); int _quantity_t = 0, _quantity_p = 0; decimal _amount = 0; foreach (DataRow dr in dt.Rows) { _quantity_t += (int)dr["Quantity_T"]; _quantity_p += (int)dr["Quantity_P"]; _amount += (decimal)dr["TotalAmount"]; } DataRow row = dt.NewRow(); row["ProductName"] = "合计"; row["Quantity_T"] = _quantity_t; row["Quantity_P"] = _quantity_p; row["TotalAmount"] = _amount; dt.Rows.Add(row); gv_List_Product.DataSource = dt; gv_List_Product.DataBind(); } else if (gv_List_Client.Visible) { DataTable dt = PBM_DeliveryBLL.GetDeliverySummary_ByClient((int)Session["OwnerClient"], salesman, deliveryman, 0, dtbegin, dtend); gv_List_Client.DataSource = dt; gv_List_Client.DataBind(); } else if (gv_PayInfoSummary.Visible) { DataTable dt = PBM_DeliveryBLL.GetPayInfoSummary((int)Session["OwnerClient"], salesman, deliveryman, dtbegin, dtend); gv_PayInfoSummary.DataSource = dt; gv_PayInfoSummary.DataBind(); gv_PayInfoSummary.Visible = true; } else if (gv_PayInfoDetail.Visible) { DataTable dt = PBM_DeliveryBLL.GetPayInfoDetail((int)Session["OwnerClient"], salesman, deliveryman, dtbegin, dtend); dt = MatrixTable.Matrix(dt, new string[] { "SheetCode", "ClientName", "DeliveryManName" }, "PayModeName", "Amount"); dt.Columns["SheetCode"].ColumnName = "单号"; dt.Columns["ClientName"].ColumnName = "客户"; dt.Columns["DeliveryManName"].ColumnName = "送货人"; gv_PayInfoDetail.DataSource = dt; gv_PayInfoDetail.DataBind(); } }