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();
}
}
