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); }