private void BindData()
{
DataTable dt = PBM_DeliveryBLL.GetNeedDeliverySummary((DateTime)ViewState["PreArrivalDate_BeginDate"], (DateTime)ViewState["PreArrivalDate_EndDate"],
(int)Session["OwnerClient"], (int)ViewState["SupplierWareHouse"],
(int)ViewState["SalesMan"], (int)ViewState["DeliveryMan"]);
#region 求合计行
int q_t = 0, q_p = 0;
decimal w = 0, a = 0;
foreach (DataRow row in dt.Rows)
{
q_t += (int)row["Quantity_T"];
q_p += (int)row["Quantity_P"];
a += (decimal)row["Amount"];
w += (decimal)row["Weight"];
}
DataRow dr = dt.NewRow();
dr["ProductName"] = "合计";
dr["Quantity_T"] = q_t;
dr["Packagint_T"] = "件";
dr["Quantity_P"] = q_p;
dr["Packagint_P"] = "散";
dr["Amount"] = a;
dr["Weight"] = w;
dt.Rows.Add(dr);
#endregion
ViewState["DataTable"] = dt;
//获取分页数量
int totlaItem = dt.Rows.Count;
int pageNum = (totlaItem / PRINTPAGESIZE) + (totlaItem % PRINTPAGESIZE == 0 ? 0 : 1);
ViewState["TotalPageCount"] = pageNum;
int[] intTemp = new int[pageNum];
for (int i = 0; i < pageNum; i++)
{
intTemp[i] = i;
}
Repeater1.DataSource = intTemp;
Repeater1.DataBind();
}
private void BindGrid()
{
gv_Summary.Visible = false;
gv_List.Visible = false;
bt_SummaryPrint.Visible = false;
bt_DetailPrint.Visible = false;
bt_BatConfirm.Enabled = false;
if (MCSTabControl1.SelectedIndex == 0)
{
DataTable dt = PBM_DeliveryBLL.GetNeedDeliverySummary(DateTime.Parse(tbx_begin.Text), DateTime.Parse(tbx_end.Text),
(int)Session["OwnerClient"], int.Parse(ddl_SupplierWareHouse.SelectedValue),
int.Parse(ddl_Salesman.SelectedValue), int.Parse(ddl_DeliveryMan.SelectedValue));
#region 求合计行
int q_t = 0, q_p = 0;
decimal w = 0, a = 0;
foreach (DataRow row in dt.Rows)
{
q_t += (int)row["Quantity_T"];
q_p += (int)row["Quantity_P"];
a += (decimal)row["Amount"];
w += (decimal)row["Weight"];
}
DataRow dr = dt.NewRow();
dr["ProductName"] = "合计";
dr["Quantity_T"] = q_t;
dr["Packagint_T"] = "件";
dr["Quantity_P"] = q_p;
dr["Packagint_P"] = "散";
dr["Amount"] = a;
dr["Weight"] = w;
dt.Rows.Add(dr);
#endregion
gv_Summary.DataSource = dt;
gv_Summary.DataBind();
gv_Summary.Visible = true;
bt_SummaryPrint.Visible = true;
bt_SummaryPrint.OnClientClick = "javascript:window.open('" + string.Format("DeliveryListHasAssign_Print.aspx?PreArrivalDate_BeginDate={0}&PreArrivalDate_EndDate={1}&SupplierWareHouse={2}&SalesMan={3}&DeliveryMan={4}",
tbx_begin.Text, tbx_end.Text, ddl_SupplierWareHouse.SelectedValue, ddl_Salesman.SelectedValue, ddl_DeliveryMan.SelectedValue) + "');";
}
else
{
string condition = GetFindCondition();
gv_List.ConditionString = condition;
gv_List.BindGrid();
gv_List.Visible = true;
IList <PBM_Delivery> lists = PBM_DeliveryBLL.GetModelList(condition);
string ids = "";
foreach (PBM_Delivery item in lists)
{
ids += item.ID.ToString() + ",";
}
if (ids.EndsWith(","))
{
ids = ids.Substring(0, ids.Length - 1);
}
bt_BatConfirm.Enabled = true;
bt_DetailPrint.Visible = true;
bt_DetailPrint.OnClientClick = "javascript:window.open('../Delivery/SaleOut/SaleOutDetail_Print.aspx?ID=" + ids + "');";
}
}
