//获取任务各状态下的数量
private void GetStatusNum(out string msg)
{
msg = string.Empty;
//DataTable dt = BLL.Util.GetEnumDataTable(typeof(Entities.YTGActivityTaskStatus));
DataTable dt = new DataTable();
dt.Columns.Add("name");
dt.Columns.Add("value");
dt.Rows.Add("待分配", "1");
dt.Rows.Add("待处理", "2");
dt.Rows.Add("处理中", "3");
dt.Rows.Add("已处理", "4");
dt.Rows.Add("已结束", "5");
dt.Rows.Add("成功", "1");
dt.Rows.Add("失败", "0");
Hashtable ht = new Hashtable();
Entities.QueryYTGActivityTaskInfo query = new Entities.QueryYTGActivityTaskInfo();
query.LoginID = Convert.ToInt32(loginUser); //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;
}
DataTable dtCount = BLL.YTGActivityTask.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);
}
private void bindData()
{
if (!int.TryParse(RequestPageSize, out PageSize))
{
PageSize = PageSize;
}
var query = new Entities.QueryYTGActivityTaskInfo();
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;
}
int RecordCount = 0;
DataTable dt = BLL.YTGActivityTask.Instance.GetYTGTask(query, "lt.CreateTime ASC", BLL.PageCommon.Instance.PageIndex, PageSize, out RecordCount);
repeaterTableList.DataSource = dt;
repeaterTableList.DataBind();
litPagerDown.Text = BLL.PageCommon.Instance.LinkStringByPost(BLL.Util.GetUrl(), GroupLength, RecordCount, PageSize, BLL.PageCommon.Instance.PageIndex, 1);
}
/// 根据status分组，获取各状态下数量
/// <summary>
/// 根据status分组，获取各状态下数量
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public DataTable GetStatusNum(Entities.QueryYTGActivityTaskInfo query)
{
return(Dal.YTGActivityTask.Instance.GetStatusNum(query));
}
//根据status分组，获取各状态下数量
public DataTable GetStatusNum(Entities.QueryYTGActivityTaskInfo query)
{
string where = string.Empty;
#region 数据权限判断
if (query.LoginID != Constant.INT_INVALID_VALUE)
{
where = Dal.UserGroupDataRigth.Instance.GetSqlRightstr("pf", "lt", "BGID", "AssignUserID", query.LoginID);
}
#endregion
if (query.AssignUserID != Constant.INT_INVALID_VALUE)
{
where += " and AssignUserID=" + query.AssignUserID;
}
if (query.ProjectName != Constant.STRING_INVALID_VALUE)
{
where += " and pf.Name LIKE '%" + StringHelper.SqlFilter(query.ProjectName.ToString()) + "%'";
}
if (!string.IsNullOrEmpty(query.TaskCBeginTime))
{
where += " and lt.CreateTime>='" + StringHelper.SqlFilter(query.TaskCBeginTime) + " 0:0:0'";
}
if (!string.IsNullOrEmpty(query.TaskCEndTime))
{
where += " and lt.CreateTime<='" + StringHelper.SqlFilter(query.TaskCEndTime) + " 23:59:59'";
}
if (query.TaskID != Constant.STRING_INVALID_VALUE)
{
where += " and lt.TaskID='" + StringHelper.SqlFilter(query.TaskID) + "'";
}
string sqlStr = @"SELECT
ISNULL(SUM(CASE WHEN lt.Status = 1 THEN 1
ELSE 0
END), 0) AS '待分配' ,
ISNULL(SUM(CASE WHEN lt.Status = 2 THEN 1
ELSE 0
END), 0) AS '待处理' ,
ISNULL(SUM(CASE WHEN lt.Status = 3 THEN 1
ELSE 0
END), 0) AS '处理中' ,
ISNULL(SUM(CASE WHEN lt.Status = 4 THEN 1
ELSE 0
END), 0) AS '已处理' ,
ISNULL(SUM(CASE WHEN lt.Status = 5 THEN 1
ELSE 0
END), 0) AS '已结束' ,
ISNULL(SUM(CASE WHEN lt.status = 4 AND lt.IsSuccess = 1 THEN 1
ELSE 0
END), 0) AS '成功' ,
ISNULL(SUM(CASE WHEN lt.status = 4 AND lt.IsSuccess = 0 THEN 1
ELSE 0
END), 0) AS '失败'
FROM dbo.YTGActivityTask lt
LEFT JOIN dbo.ProjectInfo pf ON lt.ProjectID = pf.ProjectID
WHERE 1 = 1 " + where;
DataSet ds = new DataSet();
ds = SqlHelper.ExecuteDataset(CONNECTIONSTRINGS, CommandType.Text, sqlStr);
if (ds != null && ds.Tables.Count > 0)
{
return(ds.Tables[0]);
}
else
{
return(null);
}
}