private void bindData()
{
YanFa.Crm2009.Entities.YJKDemand.YJKDemandQuery query = new YanFa.Crm2009.Entities.YJKDemand.YJKDemandQuery();
if (RequestProvince != "")
{
query.CustProvinceID = RequestProvince;
}
if (RequestCity != "")
{
query.CustCityID = RequestCity;
}
if (RequestCounty != "")
{
query.CustCountyID = RequestCounty;
}
if (RequestCustName != "")
{
query.CustName = RequestCustName;
}
if (RequestArea != "")
{
query.CustDepartment = RequestArea;
}
if (RequestKeFuName != "")
{
query.KeFuName = RequestKeFuName;
}
//过滤撤销状态
query.Where = "and YJKDemandInfo.Status <>" + (int)BitAuto.YanFa.Crm2009.Entities.YJKDemandStatus.Revoke;
int RecordCount = 0;
DataTable dt = YanFa.Crm2009.BLL.YJKDemandBLL.Instance.GetCustDemandInfo(query, "", 1, 10000, out RecordCount, BLL.Util.GetLoginUserID());
DataTable dtNew = new DataTable();
string[] arr = new string[5] {
"客户名称", "需求总数量", "集客中需求量", "负责客服", "负责销售"
};
for (int i = 0; i < arr.Length; i++)
{
dtNew.Columns.Add(arr[i]);
}
for (int i = 0; i < dt.Rows.Count; i++)
{
DataRow dr = dtNew.NewRow();
dr["客户名称"] = dt.Rows[i]["CustName"];
dr["需求总数量"] = dt.Rows[i]["CountNum"].ToString();
dr["集客中需求量"] = dt.Rows[i]["Countjkz"].ToString();
dr["负责客服"] = dt.Rows[i]["KeFuName"];
dr["负责销售"] = dt.Rows[i]["SaleName"];
dtNew.Rows.Add(dr);
}
BLL.Util.ExportToCSV("客户分配导出信息", dtNew, false);
}
private void bindData()
{
YanFa.Crm2009.Entities.YJKDemand.YJKDemandQuery query = new YanFa.Crm2009.Entities.YJKDemand.YJKDemandQuery();
if (RequestProvince != "")
{
query.CustProvinceID = RequestProvince;
}
if (RequestCity != "")
{
query.CustCityID = RequestCity;
}
if (RequestCounty != "")
{
query.CustCountyID = RequestCounty;
}
if (RequestCustName != "")
{
query.CustName = RequestCustName;
}
if (RequestArea != "")
{
query.CustDepartment = RequestArea;
}
if (RequestKeFuName != "")
{
query.KeFuName = RequestKeFuName;
}
//过滤撤销状态
query.Where = "and YJKDemandInfo.Status <>" + (int)BitAuto.YanFa.Crm2009.Entities.YJKDemandStatus.Revoke;
int RecordCount = 0;
DataTable dt = YanFa.Crm2009.BLL.YJKDemandBLL.Instance.GetCustDemandInfo(query, "", BLL.PageCommon.Instance.PageIndex, PageSize, out RecordCount, userID);
repeaterTableList.DataSource = dt;
repeaterTableList.DataBind();
litPagerDown.Text = BLL.PageCommon.Instance.LinkStringByPost(BLL.Util.GetUrl(), GroupLength, RecordCount, PageSize, BLL.PageCommon.Instance.PageIndex, 1);
}
