protected void bt_Refresh_Click(object sender, EventArgs e)
{
string orgcitys = "";
if (tr_OrganizeCity.SelectValue != "0")
{
Addr_OrganizeCityBLL orgcity = new Addr_OrganizeCityBLL(int.Parse(tr_OrganizeCity.SelectValue), true);
orgcitys = orgcity.GetAllChildNodeIDs();
if (orgcitys != "") orgcitys += ",";
orgcitys += tr_OrganizeCity.SelectValue;
}
else
{
MessageBox.Show(this, "请选择要查询的管理片区!");
return;
}
ReportParameter[] _parms = {
new ReportParameter("OrganizeCitys", orgcitys),
new ReportParameter("BeginMonth", ddl_BeginMonth.SelectedValue),
new ReportParameter("EndMonth", ddl_EndMonth.SelectedValue)
};
ReportViewer1.ServerReport.ReportServerCredentials = new MCSReportServerCredentials();
ReportViewer1.ServerReport.ReportPath = ViewState["ReportPath"].ToString();
ReportViewer1.ServerReport.ReportServerUrl = new Uri(ViewState["ReportServerUrl"].ToString());
ReportViewer1.ServerReport.SetParameters(_parms);
// ReportViewer1.ServerReport.Refresh();
}
private void BindGrid()
{
string condition = "PM_Salary.State<8 AND PM_Salary.AccountMonth=PM_SalaryDataObject.AccountMonth AND PM_SalaryDataObject.AccountMonth Between " + ddl_BeginMonth.SelectedValue + " AND " + ddl_EndMonth.SelectedValue;
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;
condition += " AND PM_SalaryDetail.Promotor IN (SELECT ID FROM MCS_Promotor.dbo.PM_Promotor Where OrganizeCity in(" + orgcitys + ") )";
}
if (ddl_PMClassify.SelectedValue != "0")
{
condition += " AND MCS_SYS.dbo.UF_Spilt(MCS_Promotor.dbo.PM_Promotor.ExtPropertys,'|',19)=" + ddl_PMClassify.SelectedValue;
}
if (cb_OnlyDisplayZero.Checked)
{
condition += " AND PM_SalaryDetail.Bonus=0";
}
if (select_promotor.SelectValue != "")
{
condition += " AND PM_SalaryDetail.Promotor=" + select_promotor.SelectValue;
}
gv_List.ConditionString = condition;
gv_List.BindGrid();
MatrixTable.GridViewMatric(gv_List);
}
private void BindGrid()
{
string condition = "1=1";
#region 组织查询条件
if (chb_ToOrganizecityChild.Checked)
{
Addr_OrganizeCityBLL orgcity = new Addr_OrganizeCityBLL(int.Parse(tr_OrganizeCity.SelectValue));
string orgcitys = orgcity.GetAllChildNodeIDs();
if (orgcitys != "") orgcitys += ",";
orgcitys += tr_OrganizeCity.SelectValue;
condition += " AND PDT_StandardPrice.OrganizeCity IN (" + orgcitys + ")";
}
else
{
condition += " AND PDT_StandardPrice.OrganizeCity=" + tr_OrganizeCity.SelectValue;
}
#endregion
//if (MCSTabControl1.SelectedIndex == 0)
//{
// condition += " AND PDT_StandardPrice.ActiveFlag=1 AND PDT_StandardPrice.ApproveFlag=1";
//}
//else
//{
// condition += " AND (PDT_StandardPrice.ActiveFlag=2 OR PDT_StandardPrice.ApproveFlag=2)";
//}
condition += " AND PDT_StandardPrice.ActiveFlag=1 AND PDT_StandardPrice.ApproveFlag=1";
gv_List.ConditionString = condition;
gv_List.BindGrid();
}
private void BindGrid()
{
string condition = " CarNo LIKE '%" + tbx_CarNo.Text + "%' ";
#region 判断当前可查询的管理片区范围
if (tr_OrganizeCity.SelectValue != "1")
{
string orgcitys = "";
Addr_OrganizeCityBLL orgcity = new Addr_OrganizeCityBLL(int.Parse(tr_OrganizeCity.SelectValue), true);
orgcitys = orgcity.GetAllChildNodeIDs();
if (orgcitys != "")
{
orgcitys += ",";
}
orgcitys += tr_OrganizeCity.SelectValue;
if (orgcitys != "")
{
condition += " AND Car_CarList.OrganizeCity IN (" + orgcitys + ") ";
}
}
#endregion
gv_List.ConditionString = condition;
gv_List.BindGrid();
}
private void BindGrid()
{
string condition = " 1=1 ";
#region 组织查询条件
if (string.IsNullOrEmpty(tr_OrganizeCity.SelectValue) && tr_OrganizeCity.SelectValue != "0")
{
//管理片区及所有下属管理片区
Addr_OrganizeCityBLL orgcity = new Addr_OrganizeCityBLL(int.Parse(tr_OrganizeCity.SelectValue));
string orgcitys = orgcity.GetAllChildNodeIDs();
if (orgcitys != "") orgcitys += ",";
orgcitys += tr_OrganizeCity.SelectValue;
condition += " AND ORD_OrderDelivery.OrganizeCity IN (" + orgcitys + ")";
}
//会计月条件
condition += " AND ORD_OrderDelivery.AccountMonth = " + ddl_Month.SelectedValue;
//申请单号
if (tbx_SheetCode.Text != "")
{
condition += " AND ORD_OrderDelivery.SheetCode like '%" + tbx_SheetCode.Text + "%'";
}
//审批状态
if (ddl_State.SelectedValue != "0")
{
condition += " AND ORD_OrderDelivery.State = " + ddl_State.SelectedValue;
}
#endregion
// gv_List.ConditionString = condition;
gv_List.BindGrid();
}
protected void bt_Refresh_Click(object sender, EventArgs e)
{
string orgcitys = "";
if (tr_OrganizeCity.SelectValue != "0")
{
Addr_OrganizeCityBLL orgcity = new Addr_OrganizeCityBLL(int.Parse(tr_OrganizeCity.SelectValue), true);
orgcitys = orgcity.GetAllChildNodeIDs();
if (orgcitys != "")
{
orgcitys += ",";
}
orgcitys += tr_OrganizeCity.SelectValue;
}
else
{
MessageBox.Show(this, "请选择要查询的管理片区!");
return;
}
ReportParameter[] _parms =
{
new ReportParameter("OrganizeCitys", orgcitys),
new ReportParameter("BeginMonth", ddl_BeginMonth.SelectedValue),
new ReportParameter("EndMonth", ddl_EndMonth.SelectedValue)
};
ReportViewer1.ServerReport.ReportServerCredentials = new MCSReportServerCredentials();
ReportViewer1.ServerReport.ReportPath = ViewState["ReportPath"].ToString();
ReportViewer1.ServerReport.ReportServerUrl = new Uri(ViewState["ReportServerUrl"].ToString());
ReportViewer1.ServerReport.SetParameters(_parms);
// ReportViewer1.ServerReport.Refresh();
}
public void BindGrid()
{
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 (orgcitys != "") condition += " AND OrganizeCity IN (" + orgcitys + ")";
}
if (tr_Position.SelectValue != "1")
{
Org_PositionBLL org_position = new Org_PositionBLL(int.Parse(tr_Position.SelectValue));
string positions = org_position.GetAllChildPosition();
if (positions != "") positions += ",";
positions += tr_Position.SelectValue;
if (positions != "") condition += " AND Position IN (" + positions + ")";
}
#endregion
gv_List.BindGrid(Org_StaffNumberLimitBLL.GetModelList(condition));
}
private void BindGrid()
{
int month = int.Parse(ddl_Month.SelectedValue);
int organizecity = int.Parse(tr_OrganizeCity.SelectValue);
string condition = " AccountMonth=" + month.ToString();
if (ddl_ApproveFlag.SelectedValue != "0")
{
condition += " And ApproveFlag =" + ddl_ApproveFlag.SelectedValue;
}
if (organizecity > 1)
{
Addr_OrganizeCityBLL orgcity = new Addr_OrganizeCityBLL(organizecity);
string orgcitys = orgcity.GetAllChildNodeIDs();
if (orgcitys != "")
{
orgcitys += ",";
}
orgcitys += tr_OrganizeCity.SelectValue;
condition += " AND OrganizeCity IN (" + orgcitys + ")";
}
gv_List.ConditionString = condition;
gv_List.BindGrid();
}
private void BindGrid()
{
string ConditionStr = " FNA_BudgetTransferApply.AccountMonth = " + ddl_Month.SelectedValue;
#region 判断当前可查询管理片区的范围
string orgcitys = "";
if (tr_OrganizeCity.SelectValue != "0" && tr_OrganizeCity.SelectValue != "1")
{
Addr_OrganizeCityBLL orgcity = new Addr_OrganizeCityBLL(int.Parse(tr_OrganizeCity.SelectValue), true);
orgcitys = orgcity.GetAllChildNodeIDs();
if (orgcitys != "")
{
orgcitys += ",";
}
orgcitys += tr_OrganizeCity.SelectValue;
if (orgcitys != "")
{
ConditionStr += " AND FNA_BudgetTransferApply.ToOrganizeCity IN (" + orgcitys + ")";
}
}
#endregion
gv_List.ConditionString = ConditionStr;
gv_List.BindGrid();
}
private void BindGrid()
{
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;
condition += " AND FNA_StaffSalary.OrganizeCity IN (" + orgcitys + ")";
}
//会计月条件
condition += " AND FNA_StaffSalary.AccountMonth Between " + ddl_BeginMonth.SelectedValue;
condition += " AND " + ddl_EndMonth.SelectedValue;
//审批状态
if (ddl_State.SelectedValue != "0")
{
condition += " AND FNA_StaffSalary.State = " + ddl_State.SelectedValue;
}
#endregion
gv_List.ConditionString = condition;
gv_List.BindGrid();
}
private void BindGrid()
{
string condition = "SVM_ClientSalesTarget.AccountMonth=" + ddl_AccountMonth.SelectedValue;
#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;
condition += " AND SVM_ClientSalesTarget.OrganizeCity IN (" + orgcitys + ")";
}
if (select_client.SelectValue != "")
{
condition += " AND SVM_ClientSalesTarget.Client=" + select_client.SelectValue;
}
#endregion
gv_List.ConditionString = condition;
gv_List.BindGrid();
}
private void BindGrid()
{
ddl_PositionType.SelectedValue = "0";
txt_BounsBase.Text = "0";
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;
condition += " AND FNA_StaffBonusBase.OrganizeCity IN (" + orgcitys + ")";
}
if (ddl_PositionType.SelectedIndex != 0)
{
condition += "AND FNA_StaffBonusBase.PositionType=" + ddl_PositionType.Text.Trim();
}
#endregion
gvList.ConditionString = condition;
gvList.BindGrid();
}
private void BindGrid()
{
string ConditionStr = " 1 = 1 ";
#region 判断当前可查询管理片区的范围
string orgcitys = "";
if (tr_OrganizeCity.SelectValue != "0" && tr_OrganizeCity.SelectValue != "1")
{
Addr_OrganizeCityBLL orgcity = new Addr_OrganizeCityBLL(int.Parse(tr_OrganizeCity.SelectValue), true);
orgcitys = orgcity.GetAllChildNodeIDs();
if (orgcitys != "")
{
orgcitys += ",";
}
orgcitys += tr_OrganizeCity.SelectValue;
if (orgcitys != "")
{
ConditionStr += " AND dbo.CM_PropertyInTelephone.OrganizeCity IN (" + orgcitys + ")";
}
}
#endregion
gv_List.ConditionString = ConditionStr;
gv_List.BindGrid();
}
private void BindGrid()
{
string condtion = "1=1";
if (select_Client.SelectValue != "")
{
condtion += " AND SVM_ClientSalesTarget.Client=" + select_Client.SelectValue;
}
if (ddl_Month.SelectedValue != "")
{
condtion += " AND SVM_ClientSalesTarget.AccountMonth=" + ddl_Month.SelectedValue;
}
string orgcitys = "";
if (tr_OrganizeCity.SelectValue != "1")
{
Addr_OrganizeCityBLL orgcity = new Addr_OrganizeCityBLL(int.Parse(tr_OrganizeCity.SelectValue), true);
orgcitys = orgcity.GetAllChildNodeIDs();
if (orgcitys != "")
{
orgcitys += ",";
}
orgcitys += tr_OrganizeCity.SelectValue;
if (orgcitys != "")
{
condtion += " AND SVM_ClientSalesTarget.OrganizeCity IN (" + orgcitys + ")";
}
}
gv_List.ConditionString = condtion;
gv_List.OrderFields = "CM_Client_OrganizeCity3,CM_Client_OrganizeCity4";
gv_List.BindGrid();
}
private void BindGrid()
{
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;
condition += " AND CM_Client.OrganizeCity IN (" + orgcitys + ")";
}
//会计月条件
condition += " AND CM_KPI.AccountMonth BETWEEN " + ddl_BeginMonth.SelectedValue + " AND " + ddl_EndMonth.SelectedValue;
if (select_Client.SelectValue != "")
{
condition += " AND CM_KPI.Client = " + select_Client.SelectValue;
}
else
{
condition += " AND CM_Client.ClientType=" + ViewState["ClientType"].ToString();
}
#endregion
gv_List.ConditionString = condition;
gv_List.BindGrid();
}
private void BindGrid()
{
FNA_StaffBounsLevelDetailBLL.Init(int.Parse(ddl_Quarter.SelectedValue), (int)Session["UserID"]);
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;
condition += " AND FNA_StaffBounsLevelDetail.OrganizeCity IN (" + orgcitys + ")";
}
if (ddl_Quarter.SelectedValue != "0")
{
condition += " AND FNA_StaffBounsLevelDetail.AccountQuarter=" + ddl_Quarter.SelectedValue.Trim();
}
#endregion
gvList.ConditionString = condition;
gvList.BindGrid();
}
private void BindGrid()
{
string condition = " 1 = 1 ";
//管理片区及所有下属管理片区
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 (rbl_Flag.SelectedValue == "0")
{
condition += " AND FNA_BudgetTransfer.FromOrganizeCity IN (" + orgcitys + ")";
}
else
{
condition += " AND FNA_BudgetTransfer.ToOrganizeCity IN (" + orgcitys + ")";
}
}
condition += " AND FNA_BudgetTransfer.InsertTime Between '" + tbx_BeginDate.Text + "' AND DateAdd(day,1,'" + tbx_EndDate.Text + "')";
gv_List.ConditionString = condition;
gv_List.BindGrid();
}
public void BindData()
{
string condition = "";
DateTime dtBegin = DateTime.Parse(this.tbx_begin.Text);
DateTime dtEnd = DateTime.Parse(this.tbx_end.Text).AddDays(1);
condition = "HR_ZhaoPinApply.InsertTime BETWEEN '" + dtBegin.ToString("yyyy-MM-dd") + "' AND '" + dtEnd.ToString("yyyy-MM-dd") + "' ";
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;
condition += " AND HR_ZhaoPinApply.OrganizeCity IN (" + orgcitys + ")";
}
if (tr_Position.SelectValue != "0")
{
condition += " AND HR_ZhaoPinApply.sqgw =" + tr_Position.SelectValue;
}
//Response.Write(condition);
gv_List.ConditionString = condition;
gv_List.BindGrid();
}
private string GetCondition()
{
string ConditionStr = "";
ConditionStr = " CSO_OfferBalance.AccountMonth = " + ddl_AccountMonth.SelectedValue;
#region 判断当前可查询的范围
string orgcitys = "";
if (tr_OrganizeCity.SelectValue != "0" && tr_OrganizeCity.SelectValue != "1")
{
Addr_OrganizeCityBLL orgcity = new Addr_OrganizeCityBLL(int.Parse(tr_OrganizeCity.SelectValue), true);
orgcitys = orgcity.GetAllChildNodeIDs();
if (orgcitys != "")
{
orgcitys += ",";
}
orgcitys += tr_OrganizeCity.SelectValue;
if (orgcitys != "")
{
ConditionStr += " AND CSO_OfferBalance.OrganizeCity IN (" + orgcitys + ")";
}
}
#endregion
//if (select_Staff.SelectValue != "" && select_Staff.SelectValue != "0")
//{
// ConditionStr += " AND (CSO_OfferBalance.InsertStaff=" + select_Staff.SelectValue + " OR ISNULL(CSO_OfferBalance.InsertStaff,1)=1)";
//}
return(ConditionStr);
}
private void BindGrid()
{
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;
condition += " AND FNA_StaffSalary.OrganizeCity IN (" + orgcitys + ")";
}
//会计月条件
condition += " AND FNA_StaffSalary.AccountMonth Between " + ddl_BeginMonth.SelectedValue;
condition += " AND " + ddl_EndMonth.SelectedValue;
//审批状态
if (ddl_State.SelectedValue != "0")
{
condition += " AND FNA_StaffSalary.State = " + ddl_State.SelectedValue;
}
#endregion
gv_List.ConditionString = condition;
gv_List.BindGrid();
}
public void BindDate()
{
string ConditionStr = "";
string orgcitys = "";
#region 判断当前可查询的范围
if (tr_OrganizeCity.SelectValue != "1")
{
Addr_OrganizeCityBLL orgcity = new Addr_OrganizeCityBLL(int.Parse(tr_OrganizeCity.SelectValue));
orgcitys = orgcity.GetAllChildNodeIDs();
if (orgcitys != "")
{
orgcitys += ",";
}
orgcitys += tr_OrganizeCity.SelectValue;
if (orgcitys != "")
{
ConditionStr += " MCS_Promotor.dbo.PM_SalaryLevel.OrganizeCity IN (" + orgcitys + ")";
}
}
#endregion
gv_List.ConditionString = ConditionStr;
gv_List.BindGrid();
}
private void BindGrid()
{
string condition = " FNA_ClientPaymentInfo.PayDate BETWEEN '" + tbx_begin.Text + "' AND DateAdd(day,1,'" + tbx_end.Text + "')";
#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;
condition += " AND CM_Client.OrganizeCity IN (" + orgcitys + ")";
}
if (rbl_ApproveFlag.SelectedValue != "0")
{
condition += " And FNA_ClientPaymentInfo.ApproveFlag =" + rbl_ApproveFlag.SelectedValue;
}
if (select_Client.SelectValue != "")
{
condition += " AND FNA_ClientPaymentInfo.Client = " + select_Client.SelectValue;
}
#endregion
gv_List.ConditionString = condition;
gv_List.BindGrid();
}
private void BindGrid()
{
string condition = "1=1";
#region 组织查询条件
if (chb_ToOrganizecityChild.Checked)
{
Addr_OrganizeCityBLL orgcity = new Addr_OrganizeCityBLL(int.Parse(tr_OrganizeCity.SelectValue));
string orgcitys = orgcity.GetAllChildNodeIDs();
if (orgcitys != "")
{
orgcitys += ",";
}
orgcitys += tr_OrganizeCity.SelectValue;
condition += " AND PDT_StandardPrice.OrganizeCity IN (" + orgcitys + ")";
}
else
{
condition += " AND PDT_StandardPrice.OrganizeCity=" + tr_OrganizeCity.SelectValue;
}
#endregion
//if (MCSTabControl1.SelectedIndex == 0)
//{
// condition += " AND PDT_StandardPrice.ActiveFlag=1 AND PDT_StandardPrice.ApproveFlag=1";
//}
//else
//{
// condition += " AND (PDT_StandardPrice.ActiveFlag=2 OR PDT_StandardPrice.ApproveFlag=2)";
//}
condition += " AND PDT_StandardPrice.ActiveFlag=1 AND PDT_StandardPrice.ApproveFlag=1";
gv_List.ConditionString = condition;
gv_List.BindGrid();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
ViewState["Type"] = Request.QueryString["Type"] == null ? 0 : int.Parse(Request.QueryString["Type"]); //客户类型，1:公司仓库 2：经销商 3：终端门店
#region 设置页面Title
if ((int)ViewState["Type"] == 1)
lb_PageTitle.Text = "办事处出货查询";
else if ((int)ViewState["Type"] == 2)
lb_PageTitle.Text = "经销商出货查询";
else if ((int)ViewState["Type"] == 3)
lb_PageTitle.Text = "零售商销量查询";
else if ((int)ViewState["Type"] == 4)
lb_PageTitle.Text = "办事处进货查询";
#endregion
AdvancedSearch1.ExtCondition = "SVM_SalesVolume.Type=" + ViewState["Type"].ToString();
#region 判断当前可查询的范围
Org_StaffBLL staff = new Org_StaffBLL((int)Session["UserID"], true);
if (staff.Model.OrganizeCity > 1)
{
Addr_OrganizeCityBLL orgcity = new Addr_OrganizeCityBLL(staff.Model.OrganizeCity, true);
string orgcitys = orgcity.GetAllChildNodeIDs();
if (orgcitys != "") orgcitys += ",";
orgcitys += staff.Model.OrganizeCity.ToString();
AdvancedSearch1.ExtCondition += " AND SVM_SalesVolume.OrganizeCity IN (" + orgcitys + ")";
}
#endregion
}
}
private void BindGrid()
{
if (tr_OrganizeCity.SelectValue != "1")
{
string orgcitys = "";
Addr_OrganizeCityBLL orgcity = new Addr_OrganizeCityBLL(int.Parse(tr_OrganizeCity.SelectValue));
orgcitys = orgcity.GetAllChildNodeIDs();
if (orgcitys != "")
{
orgcitys += ",";
}
orgcitys += tr_OrganizeCity.SelectValue;
string condition = " FNA_FeeWriteOff.OrganizeCity in (" + orgcitys + ") ";
condition += " AND FNA_FeeWriteOff.AccountMonth =" + ddl_BeginMonth.SelectedValue;
if (ddl_State.SelectedValue != "0")
{
condition += " AND FNA_FeeWriteOff.State=" + ddl_State.SelectedValue;
}
if (select_Client.SelectValue != "")
{
condition += " AND FNA_FeeWriteOff.InsteadPayClient=" + select_Client.SelectValue;
}
gv_List.ConditionString = condition;
gv_List.BindGrid();
}
}
private void BindGrid()
{
string condition = "AccountMonth=" + ddl_Month.SelectedValue;
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;
condition += " AND CM_Client.OrganizeCity IN (" + orgcitys + ")";
}
if (select_Client.SelectValue != "")
{
condition += " AND Client=" + select_Client.SelectValue;
}
if (ddl_Brand.SelectedValue != "0")
{
condition += " AND Brand=" + ddl_Brand.SelectedValue;
}
if (ddl_GiftClassify.SelectedValue != "0")
{
condition += " AND ORD_GiftApplyAmount.Classify=" + ddl_GiftClassify.SelectedValue;
}
gv_List.ConditionString = condition + " ORDER BY CM_Client.FullName,ORD_GiftApplyAmount.Brand,ORD_GiftApplyAmount.Classify";
gv_List.BindGrid();
if (ViewState["PageIndex"] != null)
{
gv_List.PageIndex = (int)ViewState["PageIndex"];
}
}
public void BindData()
{
string condition = "";
DateTime dtBegin = DateTime.Parse(this.tbx_begin.Text);
DateTime dtEnd = DateTime.Parse(this.tbx_end.Text).AddDays(1);
condition = "HR_ZhaoPinApply.InsertTime BETWEEN '" + dtBegin.ToString("yyyy-MM-dd") + "' AND '" + dtEnd.ToString("yyyy-MM-dd") + "' ";
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;
condition += " AND HR_ZhaoPinApply.OrganizeCity IN (" + orgcitys + ")";
}
if (tr_Position.SelectValue != "0")
{
condition += " AND HR_ZhaoPinApply.sqgw =" + tr_Position.SelectValue;
}
//Response.Write(condition);
gv_List.ConditionString = condition;
gv_List.BindGrid();
}
private void BindRelateActivity()
{
DateTime JournalDate = DateTime.Parse(tbx_begindate.Text);
int OrganizeCity = new Org_StaffBLL((int)Session["UserID"], true).Model.OrganizeCity;
string ConditionStr = "PlanBeginDate BETWEEN '" + JournalDate.AddDays(-15).ToString("yyyy-MM-dd") + "' AND '"
+ JournalDate.AddDays(15).ToString("yyyy-MM-dd") + "' ";
if (OrganizeCity != 1)
{
Addr_OrganizeCityBLL orgcity = new Addr_OrganizeCityBLL(OrganizeCity, true);
string orgcitys = orgcity.GetAllChildNodeIDs();
if (orgcitys != "")
{
orgcitys += ",";
}
orgcitys += OrganizeCity.ToString();
if (orgcitys != "")
{
ConditionStr += " AND OrganizeCity IN (" + orgcitys + ") ";
}
}
//if(ddl_RelateActivity!=null)
//{
//ddl_RelateActivity.DataSource = CAT_ActivityBLL.GetModelList(ConditionStr);
//ddl_RelateActivity.DataBind();
//ddl_RelateActivity.Items.Insert(0, new ListItem("请选择您参与举办的活动...", "0"));
//ddl_RelateActivity_SelectedIndexChanged(null, null);
//}
}
private void BindGrid()
{
string condition = " PM_Promotor.Dimission=1 AND PM_Promotor.ApproveFlag=1 ";
if (tbx_Condition.Text != string.Empty)
{
condition += " AND " + ddl_SearchType.SelectedValue + " Like '%" + this.tbx_Condition.Text.Trim() + "%'";
}
#region 判断当前可查询的范围
string orgcitys = "";
if (tr_OrganizeCity.SelectValue != "0" && tr_OrganizeCity.SelectValue != "1")
{
Addr_OrganizeCityBLL orgcity = new Addr_OrganizeCityBLL(int.Parse(tr_OrganizeCity.SelectValue));
orgcitys = orgcity.GetAllChildNodeIDs();
if (orgcitys != "")
{
orgcitys += ",";
}
orgcitys += tr_OrganizeCity.SelectValue;
condition += " AND PM_Promotor.OrganizeCity IN (" + orgcitys + ")";
}
#endregion
if (Request.QueryString["ExtCondition"] != null)
{
condition += " AND (" + Request.QueryString["ExtCondition"] + ")";
}
gv_List.ConditionString = condition;
gv_List.BindGrid();
}
private void BindGrid()
{
int client = 0, month = 0;
int.TryParse(select_Client.SelectValue, out client);
int.TryParse(ddl_AccountMonth.SelectedValue, out month);
int feetype = ConfigHelper.GetConfigInt("CSOCostType"); //营养教育费用类型
int feeaccounttitle = ConfigHelper.GetConfigInt("CSOOfferFeeACTitle"); //营养教育新客费科目
string condition = "";
if (client > 0)
{
condition = string.Format(@"ApplyID IN (SELECT ID FROM MCS_FNA.dbo.FNA_FeeApply WHERE AccountMonth={0} AND Client={1}
AND FeeType={2} AND State=3) AND AccountTitle={3}",
month, client, feetype, feeaccounttitle);
}
else
{
#region 判断当前可查询的范围
string orgcitys = "";
if (tr_OrganizeCity.SelectValue != "0" && tr_OrganizeCity.SelectValue != "1")
{
Addr_OrganizeCityBLL orgcity = new Addr_OrganizeCityBLL(int.Parse(tr_OrganizeCity.SelectValue), true);
orgcitys = orgcity.GetAllChildNodeIDs();
if (orgcitys != "")
{
orgcitys += ",";
}
orgcitys += tr_OrganizeCity.SelectValue;
if (orgcitys != "")
{
condition = string.Format(@"ApplyID IN (SELECT ID FROM MCS_FNA.dbo.FNA_FeeApply WHERE AccountMonth={0} AND OrganizeCity IN {1}
AND FeeType={2} AND State=3) AND AccountTitle={3}",
month, orgcitys, feetype, feeaccounttitle);
}
}
else
{
condition = string.Format(@"ApplyID IN (SELECT ID FROM MCS_FNA.dbo.FNA_FeeApply WHERE AccountMonth={0}
AND FeeType={1} AND State=3) AND AccountTitle={2}",
month, feetype, feeaccounttitle);
}
#endregion
}
if (rbl_Flag.SelectedValue == "Y")
{
condition += " AND MCS_SYS.dbo.UF_Spilt2('MCS_FNA.dbo.FNA_FeeApplyDetail',FNA_FeeApplyDetail.ExtPropertys,'BankVoucherNo')<>'' ";
}
else if (rbl_Flag.SelectedValue == "N")
{
condition += " AND MCS_SYS.dbo.UF_Spilt2('MCS_FNA.dbo.FNA_FeeApplyDetail',FNA_FeeApplyDetail.ExtPropertys,'BankVoucherNo')='' ";
}
gv_List.BindGrid(new FNA_FeeApplyBLL().GetDetail(condition));
}
private void BindGrid()
{
DateTime dtBegin = DateTime.Parse(tbx_begin.Text);
DateTime dtEnd = DateTime.Parse(tbx_end.Text).AddDays(1);
DataTable dt;
if (MCSTabControl1.SelectedIndex == 0)
{
dt = EWF_Task_InviteConsultBLL.GetNeedConsult((int)Session["UserID"]);
tbx_begin.Enabled = false;
tbx_end.Enabled = false;
}
else
{
dt = EWF_Task_InviteConsultBLL.GetHasConsult((int)Session["UserID"], dtBegin, dtEnd);
tbx_begin.Enabled = true;
tbx_end.Enabled = true;
}
string condition = " 1 = 1 ";
if (ddl_App.SelectedValue != "0")
{
condition += " AND App = '" + ddl_App.SelectedValue + "'";
}
if (tbx_MessageSubject.Text != "")
{
condition += " AND (Title like '%" + tbx_MessageSubject.Text + "%' OR MessageSubject like '%" + tbx_MessageSubject.Text + "%')";
}
#region 判断当前可查询的范围
string orgcitys = "";
if (tr_OrganizeCity.SelectValue != "1" && tr_OrganizeCity.SelectValue != "0")
{
Addr_OrganizeCityBLL orgcity = new Addr_OrganizeCityBLL(int.Parse(tr_OrganizeCity.SelectValue), true);
orgcitys = orgcity.GetAllChildNodeIDs();
if (orgcitys != "")
{
orgcitys += ",";
}
orgcitys += tr_OrganizeCity.SelectValue;
condition += " AND OrganizeCity IN (" + orgcitys + ")";
}
#endregion
if (tbx_InitiatorStaffName.Text != "")
{
condition += " AND ApplyStaffName LIKE '%" + tbx_InitiatorStaffName.Text + "%'";
}
dt.DefaultView.RowFilter = condition;
dt.DefaultView.Sort = " TaskID desc ";
gv_List.DataSource = dt.DefaultView;
gv_List.TotalRecordCount = dt.DefaultView.Count;
gv_List.PageIndex = (int)ViewState["PageIndex"];
gv_List.DataBind();
}
private void BindGrid()
{
DateTime dt_begin = DateTime.Parse(tbx_begindate.Text);
DateTime dt_end = DateTime.Parse(tbx_enddate.Text);
string ConditionStr = "WT_WorkTime.WorkDate between '" + dt_begin.ToString("yyyy-MM-dd") + "' And '" + dt_end.ToString("yyyy-MM-dd") + " 23:59:59' ";
//if (ddl_JournalType.SelectedValue != "0")
//{
// ConditionStr += " AND JN_Journal.JournalType=" + ddl_JournalType.SelectedValue;
//}
if (MCSTabControl1.SelectedTabItem.Value == "0")
{
td_SelectStaff.Visible = false;
td_OrganizeCity.Visible = false;
//bt_Add.Enabled = true;
ConditionStr += " AND WT_WorkTime.Staff=" + Session["UserID"].ToString();
}
else
{
td_SelectStaff.Visible = true;
td_OrganizeCity.Visible = true;
//bt_Add.Enabled = false;
if (!string.IsNullOrEmpty(select_Staff.SelectValue))
{
ConditionStr += " AND WT_WorkTime.Staff=" + select_Staff.SelectValue;
}
else if (tr_OrganizeCity.Visible && tr_OrganizeCity.SelectValue != "0")
{
#region 判断当前可查询的范围
string orgcitys = "";
Addr_OrganizeCityBLL orgcity = new Addr_OrganizeCityBLL(int.Parse(tr_OrganizeCity.SelectValue), true);
orgcitys = orgcity.GetAllChildNodeIDs();
if (orgcitys != "")
{
orgcitys += ",";
}
orgcitys += tr_OrganizeCity.SelectValue;
if (orgcitys != "")
{
ConditionStr += " AND WT_WorkTime.OrganizeCity IN (" + orgcitys + ") ";
}
#endregion
}
else
{
MessageBox.Show(this, "请选择要查询的管理片区或员工！");
return;
}
}
ConditionStr += " Order by WT_WorkTime.WorkDate desc";
gv_List.ConditionString = ConditionStr;
gv_List.BindGrid();
}
private void BindGrid()
{
string ConditionStr = " CM_Client.ClientType = 2 ";
if (tbx_Condition.Text.Trim() != "")
{
ConditionStr += " AND " + ddl_SearchType.SelectedValue + " LIKE '%" + this.tbx_Condition.Text.Trim() + "%'";
}
string orgcitys = "";
#region 判断当前可查询的范围
if ((int)Session["OwnerType"] != 3 && tr_OrganizeCity.SelectValue != "1")
{
Addr_OrganizeCityBLL orgcity = new Addr_OrganizeCityBLL(int.Parse(tr_OrganizeCity.SelectValue));
orgcitys = orgcity.GetAllChildNodeIDs();
if (orgcitys != "")
{
orgcitys += ",";
}
orgcitys += tr_OrganizeCity.SelectValue;
if (orgcitys != "")
{
ConditionStr += " AND (CM_ClientManufactInfo.OrganizeCity IN (" + orgcitys +
") OR CM_ClientManufactInfo.ClientManager = " + Session["UserID"].ToString() + ")";
}
}
#endregion
if ((int)Session["OwnerType"] == 2)
{
ConditionStr += " AND (CM_Client.OwnerType=2 AND CM_Client.OwnerClient=" + Session["Manufacturer"].ToString() + ")";
}
if (ddl_State.SelectedValue != "0")
{
ConditionStr += " And CM_ClientManufactInfo.State =" + ddl_State.SelectedValue;
}
if (ddl_ApproveFlag.SelectedValue != "0")
{
ConditionStr += " AND CM_ClientManufactInfo.ApproveFlag =" + ddl_ApproveFlag.SelectedValue;
}
#region 获取当前员工的关联经销商
#endregion
if (ViewState["PageIndex"] != null)
{
gv_List.PageIndex = Int32.Parse(ViewState["PageIndex"].ToString());
}
gv_List.ConditionString = ConditionStr;
gv_List.BindGrid();
}
private string GetCondition()
{
#region 组织查询条件
string ConditionStr = "CAT_Activity.State = " + MCSTabControl1.SelectedTabItem.Value;
ConditionStr += " AND " + ddl_SelectDateMethod.SelectedValue + " BETWEEN '" + tbx_begin.Text + "' AND '" + tbx_end.Text + " 23:59:59' ";
#region 判断当前可查询管理片区的范围
string orgcitys = "";
if (tr_OrganizeCity.SelectValue != "0" && tr_OrganizeCity.SelectValue != "1")
{
Addr_OrganizeCityBLL orgcity = new Addr_OrganizeCityBLL(int.Parse(tr_OrganizeCity.SelectValue), true);
orgcitys = orgcity.GetAllChildNodeIDs();
if (orgcitys != "")
{
orgcitys += ",";
}
orgcitys += tr_OrganizeCity.SelectValue;
if (orgcitys != "")
{
ConditionStr += " AND CAT_Activity.OrganizeCity IN (" + orgcitys + ")";
}
}
#endregion
//活动主题
if (tbx_Topic.Text.Trim() != "")
{
ConditionStr += " AND CAT_Activity.Topic like '%" + this.tbx_Topic.Text.Trim() + "%' ";
}
//活动分类
if (ddl_Classify.SelectedValue != "0")
{
ConditionStr += " AND CAT_Activity.Classify =" + ddl_Classify.SelectedValue;
}
//录入人员
if (select_Staff.SelectValue != "")
{
ConditionStr += " AND CAT_Activity.InsertStaff IN (" + select_Staff.SelectValue + ")";
}
//举办客户
if (select_Client.SelectValue != "")
{
ConditionStr += " AND CAT_Activity.StageClient = " + select_Client.SelectValue;
}
return(ConditionStr);
#endregion
}
private void BindOrderApplyCanDelivery()
{
string condition = "";
#region 组织查询条件
if (string.IsNullOrEmpty(tr_OrganizeCity.SelectValue) || tr_OrganizeCity.SelectValue == "0")
{
MessageBox.Show(this, "必须选择管理片区");
return;
}
else
{
Addr_OrganizeCityBLL orgcity = new Addr_OrganizeCityBLL(int.Parse(tr_OrganizeCity.SelectValue), true);
string orgcitys = orgcity.GetAllChildNodeIDs();
if (orgcitys != "")
{
orgcitys += ",";
}
orgcitys += tr_OrganizeCity.SelectValue;
condition = " ORD_OrderApply.OrganizeCity IN (" + orgcitys + ")";
}
if (select_Client.SelectValue != "" && select_Client.SelectValue != "0")
{
condition += " AND ORD_OrderApply.Client=" + select_Client.SelectValue;
}
if (tbx_SheetCode.Text != "")
{
condition += " AND ORD_OrderApply.SheetCode like '%" + tbx_SheetCode.Text + "%'";
}
#region 排除已选中到发放列表中的产品
string applydetailids = "";
ListTable <ORD_OrderDeliveryDetail> _details = ViewState["Details"] as ListTable <ORD_OrderDeliveryDetail>;
foreach (ORD_OrderDeliveryDetail item in _details.GetListItem())
{
applydetailids += item.ApplyDetailID.ToString() + ",";
}
if (applydetailids != "")
{
applydetailids = applydetailids.Substring(0, applydetailids.Length - 1);
condition += " AND ORD_OrderApplyDetail.ID not in (" + applydetailids + ")";
}
#endregion
#endregion
gv_OrderAplyList.ConditionString = condition;
gv_OrderAplyList.BindGrid();
bNoDelivery = true;
}
private void BindGrid()
{
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;
condition += " AND FNA_FeeWriteOff.OrganizeCity IN (" + orgcitys + ")";
}
//会计月条件
condition += " AND FNA_FeeWriteOff.AccountMonth BETWEEN " + ddl_Month.SelectedValue + " AND " + ddl_EndMonth.SelectedValue;
//申请单号
if (tbx_SheetCode.Text != "")
{
condition += " AND FNA_FeeWriteOff.SheetCode like '%" + tbx_SheetCode.Text + "%'";
}
//费用类型
if (ddl_FeeType.SelectedValue != "0")
{
condition += " AND FNA_FeeWriteOff.FeeType = " + ddl_FeeType.SelectedValue;
}
if (!Right_Assign_BLL.GetAccessRight((string)Session["UserName"], 4703, "Browse"))
{
//无查看营养教育费用权限
condition += " AND ISNULL(FNA_FeeWriteOff.FeeType,0) <> " + ConfigHelper.GetConfigInt("CSOCostType").ToString();
}
//审批状态
if (ddl_State.SelectedValue != "0")
{
condition += " AND FNA_FeeWriteOff.State = " + ddl_State.SelectedValue;
}
if (select_Client.SelectValue != "")
{
condition += " AND FNA_FeeWriteOff.InsteadPayClient=" + select_Client.SelectValue;
}
#endregion
gv_List.ConditionString = condition;
gv_List.BindGrid();
}
private void BindGrid()
{
AC_AccountMonth month = new AC_AccountMonthBLL(int.Parse(ddl_AccountMonth.SelectedValue)).Model;
int monthdays = month.EndDate.Subtract(month.BeginDate).Days + 1;
ViewState["monthdays"] = monthdays;
string condition = "FNA_StaffSalaryDataObject.AccountMonth=" + ddl_AccountMonth.SelectedValue;
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;
condition += " AND MCS_SYS.dbo.Org_Staff.OrganizeCity in(" + orgcitys + ") ";
}
if (MCSTabControl1.SelectedIndex == 0)
{
condition += " AND FNA_StaffSalaryDataObject.Position=210";
}
else
{
condition += " AND FNA_StaffSalaryDataObject.Position!=210";
}
if (select_Staff.SelectValue != "")
{
condition += " AND MCS_SYS.dbo.Org_Staff.ID=" + select_Staff.SelectValue;
}
if (ddl_ApproveFlag.SelectedValue != "0")
{
condition += " AND FNA_StaffSalaryDataObject.ApproveFlag=" + ddl_ApproveFlag.SelectedValue;
}
gv_List.ConditionString = condition + " Order By Org_Staff_OrganizeCity2,Org_Staff_OrganizeCity3,Org_Staff_OrganizeCity4,Org_Staff_RealName";
gv_List.BindGrid();
chk_Header.Checked = false;
if (MCSTabControl1.SelectedIndex == 0)
{
gv_List.Columns[gv_List.Columns.Count - 4].Visible =
gv_List.Columns[gv_List.Columns.Count - 3].Visible =
gv_List.Columns[gv_List.Columns.Count - 2].Visible = true;
}
else
{
gv_List.Columns[gv_List.Columns.Count - 4].Visible =
gv_List.Columns[gv_List.Columns.Count - 3].Visible =
gv_List.Columns[gv_List.Columns.Count - 2].Visible = false;
}
gv_List.BindGrid();
ddl_AccountMonth_SelectedIndexChanged(null, null);
}
protected void bt_Refresh_Click(object sender, EventArgs e)
{
string orgcitys = "";
if (tr_OrganizeCity.SelectValue != "0")
{
Addr_OrganizeCityBLL orgcity = new Addr_OrganizeCityBLL(int.Parse(tr_OrganizeCity.SelectValue), true);
orgcitys = orgcity.GetAllChildNodeIDs();
if (orgcitys != "") orgcitys += ",";
orgcitys += tr_OrganizeCity.SelectValue;
}
else
{
MessageBox.Show(this, "请选择要查询的管理片区!");
return;
}
ReportViewer1.ServerReport.ReportServerCredentials = new MCSReportServerCredentials();
ReportViewer1.ServerReport.ReportPath = ViewState["ReportPath"].ToString();
ReportViewer1.ServerReport.ReportServerUrl = new Uri(ViewState["ReportServerUrl"].ToString());
if (ReportViewer1.ServerReport.GetParameters().Count == 3)
{
int staff = 0;
int position = new Org_StaffBLL((int)Session["UserID"]).Model.Position;
string remark = new Org_PositionBLL(position).Model.Remark;
if (remark != null && remark.Contains("OnlyViewSelfReport"))
{
staff = (int)Session["UserID"];
}
ReportParameter[] _parms = {
new ReportParameter("OrganizeCitys", orgcitys),
new ReportParameter("Month", ddl_Month.SelectedValue),
new ReportParameter("Staff",staff.ToString())
};
ReportViewer1.ServerReport.SetParameters(_parms);
}
else
{
ReportParameter[] _parms = {
new ReportParameter("OrganizeCitys", orgcitys),
new ReportParameter("Month", ddl_Month.SelectedValue)
};
ReportViewer1.ServerReport.SetParameters(_parms);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
#region 判断当前可查询的范围
Org_StaffBLL staff = new Org_StaffBLL((int)Session["UserID"], true);
if (staff.Model.OrganizeCity > 1 && staff.GetStaffOrganizeCity().Select("ID = 1").Length==0)
{
Addr_OrganizeCityBLL orgcity = new Addr_OrganizeCityBLL(staff.Model.OrganizeCity, true);
string orgcitys = orgcity.GetAllChildNodeIDs();
if (orgcitys != "") orgcitys += ",";
orgcitys += staff.Model.OrganizeCity.ToString();
AdvancedSearch1.ExtCondition = " MCS_CM.dbo.CM_Client.OrganizeCity IN (" + orgcitys + ") AND MCS_CM.dbo.CM_Client.ClientType=3";
}
#endregion
AdvancedSearch1.DataKeyNames = new string[] { "CM_Client_ID" };
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
#region 判断当前可查询的范围
Org_StaffBLL staff = new Org_StaffBLL((int)Session["UserID"], true);
if (staff.Model.OrganizeCity >1)
{
Addr_OrganizeCityBLL orgcity = new Addr_OrganizeCityBLL(staff.Model.OrganizeCity, true);
string orgcitys = orgcity.GetAllChildNodeIDs();
if (orgcitys != "") orgcitys += ",";
orgcitys += staff.Model.OrganizeCity.ToString();
as_uc_Journal.ExtCondition = " MCS_OA.dbo.JN_Journal.OrganizeCity IN (" + orgcitys + ") order by MCS_OA.dbo.JN_Journal.InsertTime desc";
}
#endregion
as_uc_Journal.DataKeyNames = new string[] { "JN_Journal_ID" };
}
}
public void BindDate()
{
string ConditionStr = "";
string orgcitys = "";
#region 判断当前可查询的范围
if (tr_OrganizeCity.SelectValue != "1")
{
Addr_OrganizeCityBLL orgcity = new Addr_OrganizeCityBLL(int.Parse(tr_OrganizeCity.SelectValue));
orgcitys = orgcity.GetAllChildNodeIDs();
if (orgcitys != "") orgcitys += ",";
orgcitys += tr_OrganizeCity.SelectValue;
if (orgcitys != "") ConditionStr += " MCS_Promotor.dbo.PM_SalaryLevel.OrganizeCity IN (" + orgcitys + ")";
}
#endregion
gv_List.ConditionString = ConditionStr;
gv_List.BindGrid();
}
private void BindGrid()
{
string condition = " CarNo LIKE '%" + tbx_CarNo.Text + "%' ";
#region 判断当前可查询的管理片区范围
if (tr_OrganizeCity.SelectValue != "1")
{
string orgcitys = "";
Addr_OrganizeCityBLL orgcity = new Addr_OrganizeCityBLL(int.Parse(tr_OrganizeCity.SelectValue), true);
orgcitys = orgcity.GetAllChildNodeIDs();
if (orgcitys != "") orgcitys += ",";
orgcitys += tr_OrganizeCity.SelectValue;
if (orgcitys != "") condition += " AND Car_CarList.OrganizeCity IN (" + orgcitys + ") ";
}
#endregion
gv_List.ConditionString = condition;
gv_List.BindGrid();
}
private void BindGrid()
{
string ConditionStr = " FNA_BudgetTransferApply.AccountMonth = " + ddl_Month.SelectedValue;
#region 判断当前可查询管理片区的范围
string orgcitys = "";
if (tr_OrganizeCity.SelectValue != "0" && tr_OrganizeCity.SelectValue != "1")
{
Addr_OrganizeCityBLL orgcity = new Addr_OrganizeCityBLL(int.Parse(tr_OrganizeCity.SelectValue), true);
orgcitys = orgcity.GetAllChildNodeIDs();
if (orgcitys != "") orgcitys += ",";
orgcitys += tr_OrganizeCity.SelectValue;
if (orgcitys != "") ConditionStr += " AND FNA_BudgetTransferApply.ToOrganizeCity IN (" + orgcitys + ")";
}
#endregion
gv_List.ConditionString = ConditionStr;
gv_List.BindGrid();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
#region 判断当前可查询的范围
Org_StaffBLL staff = new Org_StaffBLL((int)Session["UserID"], true);
if (staff.Model.OrganizeCity > 1 && staff.GetStaffOrganizeCity().Select("ID = 1").Length == 0)
{
Addr_OrganizeCityBLL orgcity = new Addr_OrganizeCityBLL(staff.Model.OrganizeCity, true);
string orgcitys = orgcity.GetAllChildNodeIDs();
if (orgcitys != "") orgcitys += ",";
orgcitys += staff.Model.OrganizeCity.ToString();
as_uc_promotor.ExtCondition = " MCS_Promotor.dbo.PM_Promotor.OrganizeCity IN (" + orgcitys + ")";
}
#endregion
as_uc_promotor.DataKeyNames = new string[] { "PM_Promotor_ID" };
}
}
private void BindGrid()
{
string ConditionStr = " 1 = 1 ";
#region 判断当前可查询管理片区的范围
string orgcitys = "";
if (tr_OrganizeCity.SelectValue != "0" && tr_OrganizeCity.SelectValue != "1")
{
Addr_OrganizeCityBLL orgcity = new Addr_OrganizeCityBLL(int.Parse(tr_OrganizeCity.SelectValue), true);
orgcitys = orgcity.GetAllChildNodeIDs();
if (orgcitys != "") orgcitys += ",";
orgcitys += tr_OrganizeCity.SelectValue;
if (orgcitys != "") ConditionStr += " AND dbo.CM_PropertyInTelephone.OrganizeCity IN (" + orgcitys + ")";
}
#endregion
gv_List.ConditionString = ConditionStr;
gv_List.BindGrid();
}
private void BindGrid()
{
string condition = " 1 = 1 ";
//管理片区及所有下属管理片区
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 (rbl_Flag.SelectedValue == "0")
condition += " AND FNA_BudgetTransfer.FromOrganizeCity IN (" + orgcitys + ")";
else
condition += " AND FNA_BudgetTransfer.ToOrganizeCity IN (" + orgcitys + ")";
}
condition += " AND FNA_BudgetTransfer.InsertTime Between '" + tbx_BeginDate.Text + "' AND DateAdd(day,1,'" + tbx_EndDate.Text + "')";
gv_List.ConditionString = condition;
gv_List.BindGrid();
}
private void BindGrid()
{
string condition = "SVM_ClientSalesTarget.AccountMonth=" + ddl_AccountMonth.SelectedValue;
#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;
condition += " AND SVM_ClientSalesTarget.OrganizeCity IN (" + orgcitys + ")";
}
if (select_client.SelectValue != "")
{
condition += " AND SVM_ClientSalesTarget.Client=" + select_client.SelectValue;
}
#endregion
gv_List.ConditionString = condition;
gv_List.BindGrid();
}
//为控件ddl_RMSAccountEnabled赋值
//protected void ddl_RMSAccountEnabled_Select()
//{
// DropDownList ddl_IsRMSClient = pl_detail.FindControl("CM_Client_IsRMSClient") as DropDownList;
// DropDownList ddl_RMSAccountEnabled = pl_detail.FindControl("CM_Client_RMSAccountEnabled") as DropDownList;
// TextBox tb_RMSCloseDate = pl_detail.FindControl("CM_Client_RMSCloseDate") as TextBox;
// //请选择和已关闭状态下，积分状态启用否选项都为“否”
// if (ddl_IsRMSClient.SelectedValue == "3")//准备启动
// {
// ddl_RMSAccountEnabled.SelectedValue = "1";
// }
// else if (ddl_IsRMSClient.SelectedValue == "2")
// {
// ddl_RMSAccountEnabled.SelectedValue = "2";
// }
//}
//protected void ddl_IsRMSClient_SelectedIndexChanged(object sender, EventArgs e)
//{
// this.ddl_RMSAccountEnabled_Select();
//}
private void tbx_FullName_TextChanged(object sender, EventArgs e)
{
Org_Staff staff = new Org_StaffBLL((int)Session["UserID"]).Model;
string orgcitys = "";
string ConditionStr = "FullName like '%" + ((TextBox)sender).Text.Trim() + "%'";
string clients = "";
#region 判断当前可查询的范围
if (staff.OrganizeCity != 1)
{
Addr_OrganizeCityBLL orgcity = new Addr_OrganizeCityBLL(staff.OrganizeCity, true);
orgcitys = orgcity.GetAllChildNodeIDs();
if (orgcitys != "") orgcitys += ",";
orgcitys += staff.OrganizeCity;
if (orgcitys != "") ConditionStr += " AND CM_Client.OrganizeCity IN (" + orgcitys + ")";
}
#endregion
if (ViewState["ClientID"] != null)
{
ConditionStr = ConditionStr + " AND ID!=" + ViewState["ClientID"].ToString();
}
IList<CM_Client> clientList = CM_ClientBLL.GetModelList(ConditionStr);
foreach (CM_Client client in clientList)
{
clients += client.FullName + "、";
}
if (!string.IsNullOrEmpty(clients))
{
MessageBox.Show(this, "该门店名称与已有【" + clients.Substring(0, clients.Length - 1) + "】出现相同或相似，请确认是有重复！");
}
}
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 flag = int.Parse(ddl_Flag.SelectedValue);
#region 判断是否可以审批通过
string[] allowdays = Addr_OrganizeCityParamBLL.GetValueByType(1, 7).Replace(" ", "").Split(new char[] { ',', '，', ';', '；' });
string date = DateTime.Now.Day.ToString();
if (allowdays.Contains(date))
{
bt_Approve.Enabled = false;
bt_Approve.ToolTip = "每月21-25号不可对进销存审批通过！";
}
#endregion
if (new Addr_OrganizeCityBLL(organizecity).Model.Level >= 2
&& month == AC_AccountMonthBLL.GetMonthByDate(DateTime.Today.AddDays(-10)))
{
if ((int)ViewState["ClientType"] == 3 && (int)ViewState["Type"] == 2)
{
DataTable dtFillDataProgress = Org_StaffBLL.GetFillDataProgress((int)Session["UserID"], true);
DataRow[] rows;
if (flag == 1)
rows = dtFillDataProgress.Select("ItemCode='006'");
else
rows = dtFillDataProgress.Select("ItemCode='012'");
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_SalesVolumeBLL.GetSummaryTotal(organizecity, month, (int)ViewState["ClientType"], flag, level, state, (int)ViewState["Type"], (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 if (MCSTabControl1.SelectedIndex == 1)
{
if (organizecity == 1 || new Addr_OrganizeCityBLL(organizecity).Model.Level < 2)
{
MessageBox.Show(this, "按客户及SKU查询时，不能按总部及大区级别查询!");
return;
}
DataTable dt_summary = SVM_SalesVolumeBLL.GetSummaryTotal2(organizecity, month, (int)ViewState["ClientType"], flag, state, (int)ViewState["Type"], (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 = " SVM_SalesVolume.AccountMonth=" + ddl_Month.SelectedValue;
IList<CM_Client> cmlist = new List<CM_Client>();
if (organizecity > 1)
{
Addr_OrganizeCityBLL orgcity = new Addr_OrganizeCityBLL(organizecity);
string orgcitys = orgcity.GetAllChildNodeIDs();
if (orgcitys != "") orgcitys += ",";
orgcitys += tr_OrganizeCity.SelectValue;
cmlist = CM_ClientBLL.GetModelList("OrganizeCity IN (" + orgcitys + ") AND ActiveFlag=1 AND CM_Client.ClientType=" + ViewState["ClientType"].ToString());
if (CM_ClientBLL.GetModelList("OrganizeCity IN (" + orgcitys + ") AND ActiveFlag=1 AND CM_Client.ClientType=" + ViewState["ClientType"].ToString()).Count != 0)
{
condition += " AND SVM_SalesVolume.OrganizeCity IN (" + orgcitys + ")";
}
}
condition += ddl_Flag.SelectedValue == "1" ? " AND SVM_SalesVolume.Flag<6" : " AND SVM_SalesVolume.Flag>6";
AC_AccountMonthBLL _monthbll = new AC_AccountMonthBLL(month);
if (ViewState["ClientType"] != null)
{
switch ((int)ViewState["ClientType"])
{
case 2:
if ((int)ViewState["Type"] == 1)
{
condition += " AND SVM_SalesVolume.Client IN( Select ID FROM MCS_CM.dbo.CM_Client Where ClientType=2 AND MCS_SYS.dbo.UF_Spilt2('MCS_CM.dbo.CM_Client',CM_Client.ExtPropertys,'DIClassify')='2'";
}
else
{
condition += " AND SVM_SalesVolume.Supplier IN( Select ID FROM MCS_CM.dbo.CM_Client Where ClientType=2";
}
break;
case 3:
condition += (int)ViewState["Type"] == 1 ? " AND SVM_SalesVolume.Client IN" : " AND SVM_SalesVolume.Supplier IN";
condition += "( Select ID FROM MCS_CM.dbo.CM_Client Where ClientType=3 ";
break;
}
if (cmlist.Count == 0)
{
condition += " AND CM_Client.ClientManager=" + Session["UserID"].ToString();
}
condition += " AND ApproveFlag=1 AND OpenTime<='" + _monthbll.Model.EndDate + "'AND ISNULL(CloseTime,GETDATE())>='" + _monthbll.Model.BeginDate + "')";
}
switch (ddl_State.SelectedValue)
{
case "1":
condition += "AND SVM_SalesVolume.ApproveFlag=2 AND MCS_SYS.dbo.UF_Spilt2('MCS_SVM.dbo.SVM_SalesVolume',SVM_SalesVolume.ExtPropertys,'SubmitFlag')='2'";
break;
case "2":
condition += "AND SVM_SalesVolume.ApproveFlag=2 AND MCS_SYS.dbo.UF_Spilt2('MCS_SVM.dbo.SVM_SalesVolume',SVM_SalesVolume.ExtPropertys,'SubmitFlag')='1'";
break;
case "3":
condition += " AND SVM_SalesVolume.ApproveFlag=1";
break;
}
gv_List.ConditionString = condition;
gv_List.BindGrid();
}
}
/// <summary>
/// 获取当前用户可管辖的TDP
/// </summary>
/// <param name="User"></param>
/// <returns></returns>
private static IList<CM_Client> GetManagerTDPByStaff(UserInfo User)
{
if (User.OwnerType == 3)
{
//TDP员工
return CM_ClientBLL.GetModelList("ID=" + User.ClientID);
}
else
{
//公司员工
string ConditionStr = "ClientType = 2 AND CM_Client.ID IN (SELECT Client FROM dbo.CM_ClientManufactInfo WHERE State = 1 ";
//获取员工管理的区域
if (User.OrganizeCity > 1)
{
Addr_OrganizeCityBLL orgcity = new Addr_OrganizeCityBLL(User.OrganizeCity, true);
string orgcitys = orgcity.GetAllChildNodeIDs();
if (orgcitys != "") orgcitys += ",";
orgcitys += User.OrganizeCity.ToString();
if (orgcitys != "") ConditionStr += " AND OrganizeCity IN (" + orgcitys + ")";
}
ConditionStr += ")";
return CM_ClientBLL.GetModelList(ConditionStr);
}
}
private void BindGrid()
{
AC_AccountMonth month = new AC_AccountMonthBLL(int.Parse(ddl_AccountMonth.SelectedValue)).Model;
int monthdays = month.EndDate.Subtract(month.BeginDate).Days + 1;
ViewState["monthdays"] = monthdays;
string condition = "FNA_StaffSalaryDataObject.AccountMonth=" + ddl_AccountMonth.SelectedValue;
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;
condition += " AND MCS_SYS.dbo.Org_Staff.OrganizeCity in(" + orgcitys + ") ";
}
if (select_Staff.SelectValue != "")
{
condition += " AND MCS_SYS.dbo.Org_Staff.ID=" + select_Staff.SelectValue;
}
if (rbl_ApproveFlag.SelectedValue != "0")
{
condition += " AND FNA_StaffSalaryDataObject.SubmitFlag=" + rbl_ApproveFlag.SelectedValue;
}
if (MCSTabControl1.SelectedIndex == 0)
{
condition += " AND FNA_StaffSalaryDataObject.Position=210";
}
else
{
condition += " AND FNA_StaffSalaryDataObject.Position!=210";
}
gv_List.ConditionString = condition +" ORDER BY MCS_SYS.dbo.UF_GetSuperOrganizeCityByLevel02(Org_Staff.OrganizeCity,3),MCS_SYS.dbo.UF_GetSuperOrganizeCityByLevel02(Org_Staff.OrganizeCity,4)";
gv_List.BindGrid();
}
private void BindGrid()
{
string condition = " FNA_ClientPaymentForcast.PayDate BETWEEN '" + tbx_begin.Text + "' AND DateAdd(day,1,'" + tbx_end.Text + "')";
#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;
condition += " AND CM_Client.OrganizeCity IN (" + orgcitys + ")";
}
if (rbl_ApproveFlag.SelectedValue != "0")
{
condition += " And FNA_ClientPaymentForcast.ApproveFlag =" + rbl_ApproveFlag.SelectedValue;
}
if (select_Client.SelectValue != "")
{
condition += " AND FNA_ClientPaymentForcast.Client = " + select_Client.SelectValue;
}
#endregion
gv_List.ConditionString = condition;
gv_List.BindGrid();
}
private void BindGrid()
{
int month = int.Parse(ddl_AccountMonth.SelectedValue);
int organizecity = int.Parse(tr_OrganizeCity.SelectValue);
int level = int.Parse(ddl_Level.SelectedValue);
int state = int.Parse(ddl_State.SelectedValue);
decimal _cost = 0;
decimal.TryParse(tbx_ApplyCost.Text, out _cost);
if (MCSTabControl1.SelectedIndex == 0)
{
DataTable dtSummary = CSO_OfferBalanceBLL.Summary(month, organizecity, level, state, (int)Session["UserID"]);
#region 矩阵化数据表，扩展表数据列
dtSummary.Columns.Add(new DataColumn("ID", Type.GetType("System.Int32")));
if (level < 10)
{
foreach (DataRow row in dtSummary.Rows)
{
row["ID"] = row["OrganizeCity"];
}
dtSummary = MatrixTable.Matrix(dtSummary, new string[] { "ID", "管理片区名称" },
new string[] { "结算标准", "派发品牌", "派发产品" }, new string[] { "有效名单", "支付费用" }, false, true);
}
else if (level == 10)
{
//按经销商查看
#region 将经销商的ID赋至表ID列
foreach (DataRow row in dtSummary.Rows)
{
row["ID"] = row["经销商ID"] == DBNull.Value ? 0 : row["经销商ID"];
row["经销商名称"] = row["经销商名称"] == DBNull.Value ? "无" : row["经销商名称"];
}
#endregion
dtSummary = MatrixTable.Matrix(dtSummary, new string[] { "ID", "管理片区名称", "经销商名称" },
new string[] { "结算标准", "派发品牌", "派发产品" }, new string[] { "有效名单", "支付费用" }, false, true);
}
else if (level == 20)
{
//按医生查看
#region 将医生的ID赋至表ID列
foreach (DataRow row in dtSummary.Rows)
{
row["ID"] = row["VIPID"] == DBNull.Value ? 0 : row["VIPID"];
row["VIP姓名"] = row["VIP姓名"] == DBNull.Value ? "无" : row["VIP姓名"];
}
#endregion
dtSummary = MatrixTable.Matrix(dtSummary, new string[] { "ID", "管理片区名称", "经销商名称", "VIP姓名" },
new string[] { "结算标准", "派发品牌", "派发产品" }, new string[] { "有效名单", "支付费用" }, false, true);
}
#endregion
if (dtSummary != null && dtSummary.Rows.Count > 0)
{
dtSummary = MatrixTable.ColumnSummaryTotal(dtSummary, new int[] { 1 }, new string[] { "有效名单", "支付费用" });
#region 增加本月新客数
string thismonthnewclientcount = "Convert([3.新客标准→小计→→有效名单], 'System.Int32')";
if (dtSummary.Columns.Contains("4.3段新客标准→小计→→有效名单"))
thismonthnewclientcount += " + Convert([4.3段新客标准→小计→→有效名单], 'System.Int32')";
string thismonthnewclientfee = "Convert([3.新客标准→小计→→支付费用], 'System.Decimal')";
if (dtSummary.Columns.Contains("4.3段新客标准→小计→→支付费用"))
thismonthnewclientfee += " + Convert([4.3段新客标准→小计→→支付费用], 'System.Decimal')";
dtSummary.Columns.Add(new DataColumn("本月新客户数", Type.GetType("System.Int32"), thismonthnewclientcount));
dtSummary.Columns.Add(new DataColumn("本月新客户费", Type.GetType("System.Decimal"), thismonthnewclientfee));
#endregion
#region 获取上月新客
dtSummary.Columns.Add(new DataColumn("上月新客数", Type.GetType("System.Int32")));
dtSummary.Columns.Add(new DataColumn("上月新客费", Type.GetType("System.Decimal")));
string ids = "";
foreach (DataRow row in dtSummary.Rows)
{
ids += row["ID"].ToString() + ",";
}
if (ids.EndsWith(",")) ids = ids.Substring(0, ids.Length - 1);
DataTable dtPreMonth = null;
if (level < 10)
dtPreMonth = CSO_OfferBalanceBLL.GetNewClientAmountAndFee_ByMonthAndOrganzieCity(month - 1, ids);
else if (level == 10)
dtPreMonth = CSO_OfferBalanceBLL.GetNewClientAmountAndFee_ByMonthAndDistributors(month - 1, ids);
else if (level == 20)
dtPreMonth = CSO_OfferBalanceBLL.GetNewClientAmountAndFee_ByMonthAndDoctors(month - 1, ids);
if (dtPreMonth != null)
{
foreach (DataRow row in dtSummary.Rows)
{
DataRow[] selectedrows = dtPreMonth.Select("ID=" + row["ID"].ToString());
if (selectedrows.Length > 0)
{
row["上月新客数"] = (int)selectedrows[0]["EffectiveAmount"];
row["上月新客费"] = (decimal)selectedrows[0]["PayFee"];
}
else
{
row["上月新客数"] = 0;
row["上月新客费"] = 0;
}
}
}
#region 增加上月新增增长比较
dtSummary.Columns.Add("较上月新客增长量", Type.GetType("System.Int32"), "CONVERT([本月新客户数],'System.Int32') - [上月新客数]");
dtSummary.Columns.Add("较上月新客增长率(%)", Type.GetType("System.String"),
"IIF([上月新客数]=0,'-',CONVERT(CONVERT((CONVERT([本月新客户数],'System.Int32') - [上月新客数])*100/[上月新客数],'System.Int32'),'System.String'))+'%'");
#endregion
#endregion
#region 按金额条件过滤
if (_cost != 0)
{
switch (ddl_ComparerField.SelectedValue)
{
case "1":
dtSummary.DefaultView.RowFilter = "[1.派样185标准→小计→→有效名单]" + ddl_ApplyCostOP.SelectedValue + _cost;
break;
case "2":
dtSummary.DefaultView.RowFilter = "[2.派样400标准→小计→→有效名单]" + ddl_ApplyCostOP.SelectedValue + _cost;
break;
case "3":
dtSummary.DefaultView.RowFilter = "[本月新客户数]" + ddl_ApplyCostOP.SelectedValue + _cost;
break;
case "4":
dtSummary.DefaultView.RowFilter = "[合计→支付费用]" + ddl_ApplyCostOP.SelectedValue + _cost;
break;
case "5":
dtSummary.DefaultView.RowFilter = "[较上月新客增长量]" + ddl_ApplyCostOP.SelectedValue + _cost;
break;
case "6":
dtSummary.DefaultView.RowFilter = "上月新客数>0 AND (([较上月新客增长量]*100/[上月新客数])" + ddl_ApplyCostOP.SelectedValue + _cost + ")";
break;
default:
break;
}
dtSummary = dtSummary.DefaultView.ToTable();
}
#endregion
#region 增加合计行
List<string> valuecolumns = new List<string>();
valuecolumns.Add("ID");
valuecolumns.Add("上月新客数");
valuecolumns.Add("上月新客费");
foreach (DataColumn c in dtSummary.Columns)
{
if (c.ColumnName.Contains("→")) valuecolumns.Add(c.ColumnName);
}
MatrixTable.TableAddSummaryRow(dtSummary, "管理片区名称", valuecolumns.ToArray());
#endregion
}
gv_List.DataSource = dtSummary;
gv_List.BindGrid();
if (dtSummary.Columns.Count >= 24)
gv_List.Width = new Unit(dtSummary.Columns.Count * 55);
else
gv_List.Width = new Unit(100, UnitType.Percentage);
MatrixTable.GridViewMatric(gv_List);
}
else
{
#region 组织明细记录的查询条件
string condition = "CSO_OfferBalance.AccountMonth=" + month.ToString();
//管理片区及所有下属管理片区
if (tr_OrganizeCity.SelectValue == "0")
{
#region 绑定用户可管辖的管理片区
Org_StaffBLL staff = new Org_StaffBLL((int)Session["UserID"]);
tr_OrganizeCity.DataSource = staff.GetStaffOrganizeCity();
if (tr_OrganizeCity.DataSource.Select("ID = 1").Length > 0)
{
tr_OrganizeCity.RootValue = "0";
tr_OrganizeCity.SelectValue = "1";
}
else
{
tr_OrganizeCity.RootValue = new Addr_OrganizeCityBLL(staff.Model.OrganizeCity).Model.SuperID.ToString();
tr_OrganizeCity.SelectValue = staff.Model.OrganizeCity.ToString();
}
if ((int)ViewState["OrganizeCity"] > 0)
{
tr_OrganizeCity.SelectValue = ViewState["OrganizeCity"].ToString();
}
#endregion
}
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;
condition += " AND CSO_OfferBalance.OrganizeCity IN (" + orgcitys + ")";
}
//审批状态
if (ddl_State.SelectedValue == "0")
condition += " AND CSO_OfferBalance.State IN (2,3) ";
else if (ddl_State.SelectedValue == "1")
condition +=
@" AND CSO_OfferBalance.State = 2 AND CSO_OfferBalance.ApproveTask IN
(SELECT EWF_Task_Job.Task FROM [192.168.8.82].MCS_EWF.dbo.EWF_Task_JobDecision INNER JOIN
[192.168.8.82].MCS_EWF.dbo.EWF_Task_Job ON EWF_Task_JobDecision.Job = EWF_Task_Job.ID
WHERE EWF_Task_JobDecision.RecipientStaff=" + Session["UserID"].ToString() + @" AND
EWF_Task_JobDecision.DecisionResult=1 and EWF_Task_Job.Status=3)";
else if (ddl_State.SelectedValue == "2")
condition += " AND CSO_OfferBalance.State = 3 ";
else if (ddl_State.SelectedValue == "3")
{
AC_AccountMonth m = new AC_AccountMonthBLL(month).Model;
condition +=
@" AND CSO_OfferBalance.State IN (2,3) AND CSO_OfferBalance.ApproveTask IN
(SELECT EWF_Task_Job.Task FROM [192.168.8.82].MCS_EWF.dbo.EWF_Task_JobDecision INNER JOIN
[192.168.8.82].MCS_EWF.dbo.EWF_Task_Job ON EWF_Task_JobDecision.Job = EWF_Task_Job.ID
WHERE EWF_Task_JobDecision.RecipientStaff=" + Session["UserID"].ToString() + @" AND
EWF_Task_JobDecision.DecisionResult IN(2,5,6) AND
EWF_Task_JobDecision.DecisionTime BETWEEN DATEADD(month,-1,'" + m.BeginDate.ToString("yyyy-MM-dd") + @"') AND
DATEADD(month,3,'" + m.BeginDate.ToString("yyyy-MM-dd") + @"'))";
}
#endregion
gv_ListDetail.ConditionString = condition;
gv_ListDetail.BindGrid();
}
if (gv_List.Rows.Count > 0 || gv_ListDetail.Rows.Count > 0)
{
btn_Approve.Enabled = state == 1;
btn_UnApprove.Enabled = state == 1;
}
else
{
btn_Approve.Enabled = false;
btn_UnApprove.Enabled = false;
}
}
private void BindGrid()
{
string ConditionStr = " FNA_BudgetExtraApply.AccountMonth = " + ddl_Month.SelectedValue;
if (!string.IsNullOrEmpty(tbx_SheetCode.Text))
{
ConditionStr += " and MCS_SYS.dbo.UF_Spilt(FNA_BudgetExtraApply.ExtPropertys,'|',2)='" + tbx_SheetCode.Text + "'";
}
if (!string.IsNullOrEmpty(Select_InsertStaff.SelectValue))
{
ConditionStr += " and FNA_BudgetExtraApply.InsertStaff=" + Select_InsertStaff.SelectValue;
}
if (ddl_FeeType.SelectedValue != "0")
{
ConditionStr += " and FeeType=" + ddl_FeeType.SelectedValue;
}
if (ddl_ExtraType.SelectedValue != "0")
{
ConditionStr += " and MCS_SYS.dbo.UF_Spilt(FNA_BudgetExtraApply.ExtPropertys,'|',1)='" + ddl_ExtraType.SelectedValue + "'";
}
#region 判断当前可查询管理片区的范围
string orgcitys = "";
if (tr_OrganizeCity.SelectValue != "0" && tr_OrganizeCity.SelectValue != "1")
{
Addr_OrganizeCityBLL orgcity = new Addr_OrganizeCityBLL(int.Parse(tr_OrganizeCity.SelectValue), true);
orgcitys = orgcity.GetAllChildNodeIDs();
if (orgcitys != "") orgcitys += ",";
orgcitys += tr_OrganizeCity.SelectValue;
if (orgcitys != "") ConditionStr += " AND FNA_BudgetExtraApply.OrganizeCity IN (" + orgcitys + ")";
}
#endregion
gv_List.ConditionString = ConditionStr;
gv_List.BindGrid();
}
private void BindGrid()
{
string ConditionStr = " CM_Client.ClientType = 2 ";
if (tbx_Condition.Text.Trim() != "")
ConditionStr += " AND " + ddl_SearchType.SelectedValue + " LIKE '%" + this.tbx_Condition.Text.Trim() + "%'";
string orgcitys = "";
#region 判断当前可查询的范围
if ((int)Session["OwnerType"] != 3 && tr_OrganizeCity.SelectValue != "1")
{
Addr_OrganizeCityBLL orgcity = new Addr_OrganizeCityBLL(int.Parse(tr_OrganizeCity.SelectValue));
orgcitys = orgcity.GetAllChildNodeIDs();
if (orgcitys != "") orgcitys += ",";
orgcitys += tr_OrganizeCity.SelectValue;
if (orgcitys != "") ConditionStr += " AND (CM_ClientManufactInfo.OrganizeCity IN (" + orgcitys +
") OR CM_ClientManufactInfo.ClientManager = " + Session["UserID"].ToString() + ")";
}
#endregion
if ((int)Session["OwnerType"] == 2)
{
ConditionStr += " AND (CM_Client.OwnerType=2 AND CM_Client.OwnerClient=" + Session["Manufacturer"].ToString() + ")";
}
if (ddl_State.SelectedValue != "0")
{
ConditionStr += " And CM_ClientManufactInfo.State =" + ddl_State.SelectedValue;
}
if (ddl_ApproveFlag.SelectedValue != "0")
{
ConditionStr += " AND CM_ClientManufactInfo.ApproveFlag =" + ddl_ApproveFlag.SelectedValue;
}
#region 获取当前员工的关联经销商
#endregion
if (ViewState["PageIndex"] != null)
{
gv_List.PageIndex = Int32.Parse(ViewState["PageIndex"].ToString());
}
gv_List.ConditionString = ConditionStr;
gv_List.BindGrid();
}
private void BindGrid()
{
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;
condition += " AND ORD_OrderDelivery.OrganizeCity IN (" + orgcitys + ")";
}
//会计月条件
condition += " AND ORD_OrderDelivery.AccountMonth BETWEEN " + ddl_BeginMonth.SelectedValue + " AND " + ddl_EndMonth.SelectedValue;
//申请单号
if (tbx_SheetCode.Text != "")
{
condition += " AND ORD_OrderDelivery.SheetCode like '%" + tbx_SheetCode.Text + "%'";
}
//审批状态
if (ddl_State.SelectedValue != "0")
{
condition += " AND ORD_OrderDelivery.State = " + ddl_State.SelectedValue;
}
if (select_Client.SelectValue != "")
{
condition += " AND ORD_OrderDelivery.Client=" + select_Client.SelectValue;
}
if (rbl_ApproveFlag.SelectedValue != "0")
{
condition += " AND ORD_OrderDelivery.ApproveFlag=" + rbl_ApproveFlag.SelectedValue;
}
#endregion
gv_List.ConditionString = condition + "Order By ORD_OrderDelivery.AccountMonth DESC";
gv_List.BindGrid();
//Response.Write(condition);
}
private void DoApprove(int State, string Remark)
{
if (tbx_ApplyCost.Text != "0")
{
BindGrid();
MessageBox.Show(this, "批量审批时，不可以设定申请金额条件，请将单笔申请金额设为0再批量审批!");
return;
}
#region 组织明细记录的查询条件
//会计月条件
string condition = " CSO_OfferBalance.AccountMonth= " + ddl_AccountMonth.SelectedValue;
//管理片区
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;
condition += " AND CSO_OfferBalance.OrganizeCity IN (" + orgcitys + ")";
}
//审批状态
if (ddl_State.SelectedValue == "1")
condition +=
@" AND CSO_OfferBalance.State = 2 AND CSO_OfferBalance.ApproveTask IN
(SELECT EWF_Task_Job.Task FROM MCS_EWF.dbo.EWF_Task_JobDecision INNER JOIN
MCS_EWF.dbo.EWF_Task_Job ON EWF_Task_JobDecision.Job = EWF_Task_Job.ID
WHERE EWF_Task_JobDecision.RecipientStaff=" + Session["UserID"].ToString() + @" AND
EWF_Task_JobDecision.DecisionResult=1 and EWF_Task_Job.Status=3)";
#endregion
IList<CSO_OfferBalance> list = CSO_OfferBalanceBLL.GetModelList(condition);
foreach (CSO_OfferBalance apply in list)
{
DoApproveTask(apply.ApproveTask, State, Remark);
}
BindGrid();
MessageBox.Show(this, "审批成功！");
}
private void BindGrid()
{
string condition = "";
if (MCSTabControl1.SelectedIndex == 0)
{
tb_condition.Visible = false;
bt_Add.Enabled = false;
bt_Remove.Enabled = true;
gv_List.Visible = true;
gv_WorkPlanDetailList.Visible = false;
condition = "FNA_EvectionRoute.WriteOffID=" + ViewState["WriteOffID"].ToString();
gv_List.ConditionString = condition;
gv_List.BindGrid();
}
else if (MCSTabControl1.SelectedIndex == 1)
{
tb_condition.Visible = true;
bt_Add.Enabled = true;
bt_Remove.Enabled = false;
gv_List.Visible = true;
gv_WorkPlanDetailList.Visible = false;
condition = "FNA_EvectionRoute.BeginDate BETWEEN '" + tbx_begin.Text + "' AND '" + tbx_end.Text + " 23:59' ";
condition += " AND FNA_EvectionRoute.WriteOffID IS NULL AND FNA_EvectionRoute.InsertStaff=" + Session["UserID"].ToString();
#region 组织查询条件
if (select_Staff.SelectValue != "")
{
condition += "AND FNA_EvectionRoute.RelateStaff = " + select_Staff.SelectValue;
}
else 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;
condition += " AND FNA_EvectionRoute.RelateStaff IN (SELECT MCS_SYS.dbo.Org_Staff WHERE OrganizeCity IN (" + orgcitys + "))";
}
#endregion
gv_List.ConditionString = condition;
gv_List.BindGrid();
}
else
{
tb_condition.Visible = true;
bt_Add.Enabled = false;
bt_Remove.Enabled = false;
gv_List.Visible = false;
gv_WorkPlanDetailList.Visible = true;
condition = "JN_WorkingPlan.State=3 AND JN_WorkingPlan.Staff=" + select_Staff.SelectValue +
" AND JN_WorkingPlanDetail.BeginTime<'" + tbx_end.Text + "' AND JN_WorkingPlanDetail.EndTime>='" + tbx_begin.Text +
"' AND (MCS_SYS.dbo.UF_Spilt(JN_WorkingPlanDetail.ExtPropertys,'|',1)>'0' OR MCS_SYS.dbo.UF_Spilt(JN_WorkingPlanDetail.ExtPropertys,'|',2)>'0')";
gv_WorkPlanDetailList.ConditionString = condition;
gv_WorkPlanDetailList.BindGrid();
}
}
private void BindGrid()
{
DateTime dtBegin = DateTime.Parse(tbx_begin.Text);
DateTime dtEnd = DateTime.Parse(tbx_end.Text).AddDays(1);
DataTable dt;
if (MCSTabControl1.SelectedIndex == 0)
{
dt = EWF_Task_InviteConsultBLL.GetNeedConsult((int)Session["UserID"]);
tbx_begin.Enabled = false;
tbx_end.Enabled = false;
}
else
{
dt = EWF_Task_InviteConsultBLL.GetHasConsult((int)Session["UserID"], dtBegin, dtEnd);
tbx_begin.Enabled = true;
tbx_end.Enabled = true;
}
string condition = " 1 = 1 ";
if (ddl_App.SelectedValue != "0")
{
condition += " AND App = '" + ddl_App.SelectedValue + "'";
}
if (tbx_MessageSubject.Text != "")
{
condition += " AND (Title like '%" + tbx_MessageSubject.Text + "%' OR MessageSubject like '%" + tbx_MessageSubject.Text + "%')";
}
#region 判断当前可查询的范围
string orgcitys = "";
if (tr_OrganizeCity.SelectValue != "1" && tr_OrganizeCity.SelectValue != "0")
{
Addr_OrganizeCityBLL orgcity = new Addr_OrganizeCityBLL(int.Parse(tr_OrganizeCity.SelectValue), true);
orgcitys = orgcity.GetAllChildNodeIDs();
if (orgcitys != "") orgcitys += ",";
orgcitys += tr_OrganizeCity.SelectValue;
condition += " AND OrganizeCity IN (" + orgcitys + ")";
}
#endregion
if (tbx_InitiatorStaffName.Text != "")
{
condition += " AND ApplyStaffName LIKE '%" + tbx_InitiatorStaffName.Text + "%'";
}
dt.DefaultView.RowFilter = condition;
dt.DefaultView.Sort = " TaskID desc ";
gv_List.DataSource = dt.DefaultView;
gv_List.TotalRecordCount = dt.DefaultView.Count;
gv_List.PageIndex = (int)ViewState["PageIndex"];
gv_List.DataBind();
}
private void BindGrid()
{
string condition = " 1=1 ";
#region 组织查询条件
if ((int)ViewState["Publish"] != 0)
{
tbl_Condition.Visible = false;
tbl_Condition_title.Visible = false;
condition = " ORD_OrderApply.PublishID = " + ViewState["Publish"].ToString();
}
else
{
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;
condition += " AND ORD_OrderApply.OrganizeCity IN (" + orgcitys + ")";
}
//会计月条件
condition += " AND ORD_OrderApply.AccountMonth = " + ddl_Month.SelectedValue;
//申请单号
if (tbx_SheetCode.Text != "")
{
condition += " AND ORD_OrderApply.SheetCode like '%" + tbx_SheetCode.Text + "%'";
}
if (ddl_ProductType.SelectedValue != "0")
{
condition += " AND MCS_SYS.dbo.UF_Spilt(ORD_OrderApply.ExtPropertys,'|',4)=" + ddl_ProductType.SelectedValue;
}
if (ddl_Brand.SelectedValue != "0")
{
condition += " AND MCS_SYS.dbo.UF_Spilt(ORD_OrderApply.ExtPropertys,'|',5)=" + ddl_Brand.SelectedValue;
}
//定单类型
if (ddl_Type.SelectedValue != "0")
{
condition += " AND ORD_OrderApply.Type = " + ddl_Type.SelectedValue;
}
//审批状态
if (ddl_State.SelectedValue != "0")
{
condition += " AND ORD_OrderApply.State = " + ddl_State.SelectedValue;
}
}
#endregion
gv_List.ConditionString = condition;
gv_List.BindGrid();
}