private void BindGrid()
{
int month = int.Parse(ddl_Month.SelectedValue);
int organizecity = int.Parse(tr_OrganizeCity.SelectValue);
int level = int.Parse(ddl_Level.SelectedValue);
int state = int.Parse(ddl_State.SelectedValue);
int iscxp = int.Parse(ddl_IsCXP.SelectedValue);
if (new Addr_OrganizeCityBLL(organizecity).Model.Level >= 2 &&
month == AC_AccountMonthBLL.GetMonthByDate(DateTime.Today.AddDays(-10)))
{
if ((int)ViewState["ClientType"] == 3)
{
DataTable dtFillDataProgress = Org_StaffBLL.GetFillDataProgress((int)Session["UserID"], true);
DataRow[] rows;
if (iscxp == 1)
{
rows = dtFillDataProgress.Select("ItemCode='013'");
}
else
{
rows = dtFillDataProgress.Select("ItemCode='007'");
}
if (rows.Length > 0)
{
int ItemTargetCount = (int)rows[0]["ItemTargetCount"];
int ItemCompleteCount = (int)rows[0]["ItemCompleteCount"];
if (ItemTargetCount > ItemCompleteCount)
{
MessageBox.Show(this, "对不起，还有" + (ItemTargetCount - ItemCompleteCount).ToString() +
"家门店库存尚未录入,无法提交或审核!具体请查看桌面填报进度表.");
bt_Approve.Enabled = false;
bt_Submit.Enabled = false;
}
}
}
}
if (MCSTabControl1.SelectedIndex == 0)
{
DataTable dt_summary = SVM_InventoryBLL.GetSummaryTotal(organizecity, month, (int)ViewState["ClientType"], level, state, iscxp, (int)Session["UserID"]);
dt_summary = MatrixTable.Matrix(dt_summary, new string[] { "管理片区名称" }, new string[] { "品牌", "段位" }, "金额", true, true);
gv_Summary.DataSource = dt_summary;
gv_Summary.DataBind();
MatrixTable.GridViewMatric(gv_Summary);
if (dt_summary.Columns.Count >= 24)
{
gv_Summary.Width = new Unit(dt_summary.Columns.Count * 60);
}
else
{
gv_Summary.Width = new Unit(100, UnitType.Percentage);
}
}
else
{
string condition = " 1=1 ";
#region 组织查询条件
//管理片区及所有下属管理片区
if (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;
if (CM_ClientBLL.GetModelList("OrganizeCity IN (" + orgcitys + ") AND ActiveFlag=1 AND CM_Client.ClientType=" + ViewState["ClientType"].ToString()).Count != 0)
{
condition += " AND SVM_Inventory.OrganizeCity IN (" + orgcitys + ")";
}
else
{
condition += " AND CM_Client.ClientManager=" + Session["UserID"].ToString();
}
}
condition += " AND MCS_SYS.dbo.UF_Spilt2('MCS_SVM.dbo.SVM_Inventory',SVM_Inventory.ExtPropertys,'IsCXP')=" + ddl_IsCXP.SelectedValue;
//会计月条件
condition += " AND SVM_Inventory.AccountMonth =" + ddl_Month.SelectedValue;
condition += " AND CM_Client.ClientType=" + ViewState["ClientType"].ToString();
switch (ddl_State.SelectedValue)
{
case "1":
condition += " AND SVM_Inventory.ApproveFlag=2 AND MCS_SYS.dbo.UF_Spilt2('MCS_SVM.dbo.SVM_Inventory',SVM_Inventory.ExtPropertys,'SubmitFlag')='2'";
break;
case "2":
condition += " AND SVM_Inventory.ApproveFlag=2 AND MCS_SYS.dbo.UF_Spilt2('MCS_SVM.dbo.SVM_Inventory',SVM_Inventory.ExtPropertys,'SubmitFlag')='1'";
break;
case "3":
condition += " AND SVM_Inventory.ApproveFlag=1";
break;
}
#endregion
gv_List.ConditionString = condition;
gv_List.BindGrid();
}
}
