private void bindData()
{
if (!int.TryParse(RequestPageSize, out PageSize))
{
PageSize = 20;
}
Entities.QueryLeadsTask query = new Entities.QueryLeadsTask();
int assid = 0;
if (int.TryParse(RequestAssignID, out assid))
{
query.AssignUserID = assid;
}
if (RequestProjectName != "")
{
query.ProjectName = RequestProjectName;
}
int status = 0;
if (int.TryParse(RequestStatus, out status))
{
query.Status = status;
}
int success = 0;
if (int.TryParse(RequestIsSuccess, out success))
{
query.IsSuccess = success;
}
if (RequestBeginDealTime != "")
{
query.BeginDealTime = RequestBeginDealTime;
}
if (RequestEndDealTime != "")
{
query.EndDealTime = RequestEndDealTime;
}
query.LoginID = userID;
if (!string.IsNullOrEmpty(RequestTaskCBeginTime))
{
query.TaskCBeginTime = RequestTaskCBeginTime;
}
if (!string.IsNullOrEmpty(RequestTaskCEndTime))
{
query.TaskCEndTime = RequestTaskCEndTime;
}
if (!string.IsNullOrEmpty(RequestTaskID))
{
query.TaskID = RequestTaskID;
}
if (RequestProvinceID != "-1")
{
int reqProvinceId = -2;
if (int.TryParse(RequestProvinceID, out reqProvinceId))
{
query.ProvinceID = reqProvinceId;
}
}
if (RequestCityID != "-1")
{
int reqCitId = -2;
if (int.TryParse(RequestCityID, out reqCitId))
{
query.CityID = reqCitId;
}
}
if (!string.IsNullOrEmpty(RequestTel))
{
query.Tel = RequestTel;
}
int RecordCount = 0;
Stopwatch stopwatch2 = new Stopwatch();
stopwatch2.Start();
DataTable dt = BLL.LeadsTask.Instance.GetLeadsTask(query, "lt.LastDealTime ASC", BLL.PageCommon.Instance.PageIndex, PageSize, out RecordCount);
stopwatch2.Stop();
BLL.Loger.Log4Net.Info(string.Format("【线索邀约查询Step1——数据库查询耗时】：{0}毫秒", stopwatch2.Elapsed.TotalMilliseconds));
repeaterTableList.DataSource = dt;
repeaterTableList.DataBind();
litPagerDown.Text = BLL.PageCommon.Instance.LinkStringByPost(BLL.Util.GetUrl(), GroupLength, RecordCount, PageSize, BLL.PageCommon.Instance.PageIndex, 1);
}
//获取任务各状态下的数量
private void GetStatusNum(out string msg)
{
msg = string.Empty;
DataTable dt = BLL.Util.GetEnumDataTable(typeof(Entities.LeadsTaskStatus));
dt.Rows.Add("成功", "1");
dt.Rows.Add("失败", "0");
Hashtable ht = new Hashtable();
Entities.QueryLeadsTask query = new Entities.QueryLeadsTask();
query.LoginID = BLL.Util.GetLoginUserID();
int _assignid = 0;
if (int.TryParse(AssignID, out _assignid))
{
query.AssignUserID = _assignid;
}
if (ProjectName != "")
{
query.ProjectName = ProjectName;
}
if (RequestBeginDealTime != "")
{
query.BeginDealTime = RequestBeginDealTime;
}
if (RequestEndDealTime != "")
{
query.EndDealTime = RequestEndDealTime;
}
if (!string.IsNullOrEmpty(RequestTaskCBeginTime))
{
query.TaskCBeginTime = RequestTaskCBeginTime;
}
if (!string.IsNullOrEmpty(RequestTaskCEndTime))
{
query.TaskCEndTime = RequestTaskCEndTime;
}
if (!string.IsNullOrEmpty(RequestTaskID))
{
query.TaskID = RequestTaskID;
}
if (RequestProvinceID != "-1")
{
int reqProvinceId = -2;
if (int.TryParse(RequestProvinceID, out reqProvinceId))
{
query.ProvinceID = reqProvinceId;
}
}
if (RequestCityID != "-1")
{
int reqCitId = -2;
if (int.TryParse(RequestCityID, out reqCitId))
{
query.CityID = reqCitId;
}
}
if (!string.IsNullOrEmpty(RequestTel))
{
query.Tel = RequestTel;
}
DataTable dtCount = BLL.LeadsTask.Instance.GetStatusNum(query);
//拼接起来
for (int i = 0, len = dt.Rows.Count; i < len; i++)
{
DataRow dr = dt.Rows[i];
string count = dtCount.Rows[0][dr["name"].ToString()].ToString();
msg += "'" + dr["name"].ToString() + "':['" + dr["value"].ToString() + "','" + count + "'],";
}
msg = msg.Substring(0, msg.Length - 1);
}
