//获取任务各状态下的数量 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); } }