private void BindGrid()
{
if (tr_detail.Visible)
{
string condition = " 1=1 ";
#region 组织查询条件
//管理片区及所有下属管理片区
if (select_Client.SelectValue == "" && tr_OrganizeCity.SelectValue != "1")
{
Addr_OrganizeCityBLL orgcity = new Addr_OrganizeCityBLL(int.Parse(tr_OrganizeCity.SelectValue));
string orgcitys = orgcity.GetAllChildNodeIDs();
if (orgcitys != "")
{
orgcitys += ",";
}
orgcitys += tr_OrganizeCity.SelectValue;
condition += " AND SVM_Inventory.OrganizeCity IN (" + orgcitys + ")";
}
if (ddl_IsCXP.SelectedValue != "0")
{
condition += " AND MCS_SYS.dbo.UF_Spilt2('MCS_SVM.dbo.SVM_Inventory',SVM_Inventory.ExtPropertys,'IsCXP')=" + ddl_IsCXP.SelectedValue;
}
//会计月条件
condition += " AND SVM_Inventory.AccountMonth BETWEEN " + ddl_BeginMonth.SelectedValue + " AND " + ddl_EndMonth.SelectedValue;
if (select_Client.SelectValue != "")
{
condition += " AND SVM_Inventory.Client = " + select_Client.SelectValue;
}
else
{
condition += " AND CM_Client.ClientType=" + ViewState["ClientType"].ToString();
if ((int)ViewState["ClientType"] == 2 && ViewState["DIClassify"] != null)
{
condition += " AND MCS_SYS.dbo.UF_Spilt(CM_Client.ExtPropertys,'|',7)='" + ViewState["DIClassify"].ToString() + "'";
}
}
if (rbl_ApproveFlag.SelectedValue != "0")
{
condition += " AND SVM_Inventory.ApproveFlag=" + rbl_ApproveFlag.SelectedValue;
}
#endregion
gv_List.ConditionString = condition;
gv_List.BindGrid();
}
else
{
int organizecity = int.Parse(tr_OrganizeCity.SelectValue);
int client = select_Client.SelectValue == "" ? 0 : int.Parse(select_Client.SelectValue);
if (organizecity == 0)
{
organizecity = 1;
}
DataTable dt = SVM_InventoryBLL.GetSummary(organizecity, client, int.Parse(ddl_BeginMonth.SelectedValue), int.Parse(ddl_EndMonth.SelectedValue), int.Parse(ViewState["ClientType"].ToString()));
int _quantity = 0;
decimal _totalvalue = 0;
for (int i = 0; i < dt.Rows.Count; i++)
{
_quantity += (int)dt.Rows[i]["SumQuantity"];
_totalvalue += (decimal)dt.Rows[i]["SumMoney"];
}
DataRow dr = dt.NewRow();
dr["ProductCode"] = "合计";
dr["SumQuantity"] = _quantity;
dr["SumMoney"] = _totalvalue;
dt.Rows.Add(dr);
gv_Summary.DataSource = dt;
gv_Summary.DataBind();
}
}
