/// <summary> /// 得到一个对象实体 /// </summary> public Entities.OrderTask GetOrderTask(long TaskID) { QueryOrderTask query = new QueryOrderTask(); query.TaskID = TaskID; DataTable dt = new DataTable(); int count = 0; dt = GetOrderTask(query, string.Empty, 1, 1, out count); if (count > 0) { return(LoadSingleOrderTask(dt.Rows[0])); } else { return(null); } }
/// <summary> /// 是否存在该记录 /// </summary> public bool IsExistsByTaskID(long TaskID) { QueryOrderTask query = new QueryOrderTask(); query.TaskID = TaskID; DataTable dt = new DataTable(); int count = 0; dt = GetOrderTask(query, string.Empty, 1, 1, out count); if (count > 0) { return(true); } else { return(false); } }
/// <summary> /// 按照查询条件查询 /// </summary> /// <param name="query">查询条件</param> /// <param name="order">排序</param> /// <param name="currentPage">页号,-1不分页</param> /// <param name="pageSize">每页记录数</param> /// <param name="totalCount">总行数</param> /// <returns>集合</returns> public DataTable GetOrderTask(QueryOrderTask query, string order, int currentPage, int pageSize, out int totalCount) { string where = string.Empty; #region 条件 if (query.TaskID != Constant.INT_INVALID_VALUE) { where += " AND TaskID=" + query.TaskID.ToString(); } if (query.Source != Constant.INT_INVALID_VALUE) { where += " AND Source=" + query.Source.ToString(); } if (query.TaskStatus != Constant.INT_INVALID_VALUE) { where += " AND TaskStatus=" + query.TaskStatus.ToString(); } if (query.RelationID != Constant.INT_INVALID_VALUE) { where += " AND RelationID=" + query.RelationID.ToString(); } if (query.BGID != Constant.INT_INVALID_VALUE) { where += " AND BGID=" + query.BGID.ToString(); } if (query.AssignUserID != Constant.INT_INVALID_VALUE) { where += " AND AssignUserID=" + query.AssignUserID.ToString(); } if (query.UserName != Constant.STRING_INVALID_VALUE) { where += " AND UserName like '%" + StringHelper.SqlFilter(query.UserName) + "%'"; } if (query.Status != Constant.INT_INVALID_VALUE) { where += " AND Status=" + query.Status.ToString(); } #endregion DataSet ds; SqlParameter[] parameters = { new SqlParameter("@where", SqlDbType.NVarChar, 4000), new SqlParameter("@order", SqlDbType.NVarChar, 200), new SqlParameter("@pagesize", SqlDbType.Int, 4), new SqlParameter("@indexpage", SqlDbType.Int, 4), new SqlParameter("@totalRecorder", SqlDbType.Int, 4) }; parameters[0].Value = where; parameters[1].Value = order; parameters[2].Value = pageSize; parameters[3].Value = currentPage; parameters[4].Direction = ParameterDirection.Output; ds = SqlHelper.ExecuteDataset(CONNECTIONSTRINGS, CommandType.StoredProcedure, P_ORDERTASK_SELECT, parameters); totalCount = (int)(parameters[4].Value); return(ds.Tables[0]); }
//add by qizq 2012-9-25 无主订单任务列表 /// <summary> /// 按照查询条件查询 /// </summary> /// <param name="query">查询条件</param> /// <param name="order">排序</param> /// <param name="currentPage">页号,-1不分页</param> /// <param name="pageSize">每页记录数</param> /// <param name="totalCount">总行数</param> /// <returns>集合</returns> public DataTable GetOrderTaskList(QueryOrderTask query, string order, int currentPage, int pageSize, out int totalCount, int userid) { string where = string.Empty; #region 条件 if (query.TaskID != Constant.INT_INVALID_VALUE) { where += " AND a.TaskID=" + StringHelper.SqlFilter(query.TaskID.ToString()); } if (query.Source != Constant.INT_INVALID_VALUE) { where += " AND a.Source=" + StringHelper.SqlFilter(query.Source.ToString()); } if (query.TaskStatus != Constant.INT_INVALID_VALUE) { where += " AND a.TaskStatus=" + StringHelper.SqlFilter(query.TaskStatus.ToString()); } if (query.RelationID != Constant.INT_INVALID_VALUE) { where += " AND a.RelationID=" + StringHelper.SqlFilter(query.RelationID.ToString()); } if (query.BGID != Constant.INT_INVALID_VALUE) { where += " AND a.BGID=" + StringHelper.SqlFilter(query.BGID.ToString()); } if (query.AssignUserID != Constant.INT_INVALID_VALUE) { where += " AND a.AssignUserID=" + StringHelper.SqlFilter(query.AssignUserID.ToString()); } if (query.UserName != Constant.STRING_INVALID_VALUE) { where += " AND a.UserName like '%" + StringHelper.SqlFilter(query.UserName) + "%'"; } if (query.Status != Constant.INT_INVALID_VALUE) { where += " AND a.Status=" + StringHelper.SqlFilter(query.Status.ToString()); } if (query.YpOrderID != Constant.INT_INVALID_VALUE) { where += " and ((a.source=2 and b.yporderid=" + query.YpOrderID + ") or (a.source=1 and c.yporderid=" + query.YpOrderID + ") or (a.source=3 and c.yporderid=" + query.YpOrderID + "))"; } if (!string.IsNullOrEmpty(query.Area)) { where += " and ((a.source=2 and b.AreaID='" + query.Area + "') or (a.source=1 and c.AreaID='" + query.Area + "') or (a.source=3 and c.AreaID='" + query.Area + "'))"; } if (query.ProvinceID != Constant.INT_INVALID_VALUE) { where += " and ((a.source=2 and b.ProvinceID='" + query.ProvinceID + "') or (a.source=1 and c.ProvinceID='" + query.ProvinceID + "') or (a.source=3 and c.ProvinceID='" + query.ProvinceID + "'))"; } if (query.CityID != Constant.INT_INVALID_VALUE) { where += " and ((a.source=2 and b.CityID='" + query.CityID + "') or (a.source=1 and c.CityID='" + query.CityID + "') or (a.source=3 and c.CityID='" + query.CityID + "'))"; } //由于OrderCreateTime 是smallDatetime类型的所以如果查某天数据列如 2月1号的要写成 >='2013-2-1 00:00:000' and <'2013-2-2 00:00:000' if (query.CreateTimeBegin != Constant.DATE_INVALID_VALUE && query.CreateTimeEnd != Constant.DATE_INVALID_VALUE) { DateTime endtime = Convert.ToDateTime(query.CreateTimeEnd); if (endtime.Hour == 23 && endtime.Minute == 59) { endtime = endtime.AddHours(-23); endtime = endtime.AddMinutes(-59); endtime = endtime.AddSeconds(-endtime.Second); endtime = endtime.AddDays(1); } where += " and ((a.source=2 and (b.OrderCreateTime>='" + query.CreateTimeBegin + "' and b.OrderCreateTime<'" + endtime + "')) or (a.source=1 and (c.OrderCreateTime>='" + query.CreateTimeBegin + "' and c.OrderCreateTime<'" + endtime + "')) or (a.source=3 and (c.OrderCreateTime>='" + query.CreateTimeBegin + "' and c.OrderCreateTime<'" + endtime + "')))"; } if (query.SubmitTimeBegin != Constant.DATE_INVALID_VALUE && query.SubmitTimeEnd != Constant.DATE_INVALID_VALUE) { where += " and (a.submittime>='" + Convert.ToDateTime(query.SubmitTimeBegin).ToShortDateString() + " 0:00:000' and a.submittime<='" + Convert.ToDateTime(query.SubmitTimeEnd).ToShortDateString() + " 23:59:59')"; } if (query.TypeStr != Constant.STRING_INVALID_VALUE) { if (query.TypeStr.IndexOf(',') > 0) { where += " and ("; for (int i = 0; i < Util.SqlFilterByInCondition(query.TypeStr).Split(',').Length; i++) { where += " a.Source='" + Util.SqlFilterByInCondition(query.TypeStr).Split(',')[i] + "' or"; } where = where.Substring(0, where.Length - 3); where += ")"; } else { where += " and a.source='" + query.TypeStr + "'"; } } //add by qizq 2013-7-18加任务类型,0是无主订单,不等于0是免费订单 if (query.TaskType != Constant.STRING_INVALID_VALUE) { if (query.TaskType.IndexOf(',') > 0) { } else { if (query.TaskType == "0") { where += " and a.DealerID=0"; } else { where += " and a.DealerID!=0"; } } } // if (query.IsSelectdMsmemberstr != Constant.STRING_INVALID_VALUE) { if (query.IsSelectdMsmemberstr.IndexOf(',') > 0) { where += " and ( a.isselectDMSMember='" + Util.SqlFilterByInCondition(query.IsSelectdMsmemberstr).Split(',')[0] + "' or (a.isselectDMSMember='" + query.IsSelectdMsmemberstr.Split(',')[1] + "'"; if (query.NoDealerReasonID != Constant.INT_INVALID_VALUE) { where += " and a.NoDealerReasonID=" + query.NoDealerReasonID + ""; } where += "))"; } else { where += " and a.isselectDMSMember='" + Util.SqlFilterByInCondition(query.IsSelectdMsmemberstr) + "'"; if (query.NoDealerReasonID != Constant.INT_INVALID_VALUE) { where += " and a.NoDealerReasonID=" + query.NoDealerReasonID + ""; } } } if (query.StatuStr != Constant.STRING_INVALID_VALUE) { if (query.StatuStr.IndexOf(',') > 0) { where += " and ("; for (int i = 0; i < Util.SqlFilterByInCondition(query.StatuStr).Split(',').Length; i++) { where += " a.TaskStatus='" + Util.SqlFilterByInCondition(query.StatuStr).Split(',')[i] + "' or"; } where = where.Substring(0, where.Length - 3); where += ")"; } else { where += " and a.TaskStatus='" + StringHelper.SqlFilter(query.StatuStr) + "'"; } } //判断当前人是否有全部数据权限 int RightType = (int)Dal.UserDataRigth.Instance.GetUserDataRigth(userid).RightType; //如果没有 if (RightType != 2) { //取当前人所对应的数据权限组 Entities.QueryUserGroupDataRigth QueryUserGroupDataRigth = new Entities.QueryUserGroupDataRigth(); QueryUserGroupDataRigth.UserID = userid; int totcount = 0; DataTable dtUserGroupDataRigth = Dal.UserGroupDataRigth.Instance.GetUserGroupDataRigth(QueryUserGroupDataRigth, "", 1, 100000, out totcount); string Rolename = string.Empty; if (dtUserGroupDataRigth != null && dtUserGroupDataRigth.Rows.Count > 0) { where += " and ("; for (int i = 0; i < dtUserGroupDataRigth.Rows.Count; i++) { //本人 if (dtUserGroupDataRigth.Rows[i]["RightType"].ToString() == "1") { where += "(a.BGID='" + dtUserGroupDataRigth.Rows[i]["BGID"].ToString() + "' and a.assignuserid='" + userid + "') or"; } //本组 else { where += "(a.BGID='" + dtUserGroupDataRigth.Rows[i]["BGID"].ToString() + "') or"; } } where = where.Substring(0, where.Length - 3); where += ")"; } } #endregion DataSet ds; SqlParameter[] parameters = { new SqlParameter("@where", SqlDbType.NVarChar, 40000), new SqlParameter("@order", SqlDbType.NVarChar, 200), new SqlParameter("@pagesize", SqlDbType.Int, 4), new SqlParameter("@indexpage", SqlDbType.Int, 4), new SqlParameter("@totalRecorder", SqlDbType.Int, 4) }; parameters[0].Value = where; parameters[1].Value = order; parameters[2].Value = pageSize; parameters[3].Value = currentPage; parameters[4].Direction = ParameterDirection.Output; ds = SqlHelper.ExecuteDataset(CONNECTIONSTRINGS, CommandType.StoredProcedure, P_ORDERTASK_MANAGE, parameters); totalCount = (int)(parameters[4].Value); return(ds.Tables[0]); }
private void BindData() { //string fields = Entities.CustHistoryInfo.SelectFieldStr; //QueryCustHistoryInfo query = BLL.CustHistoryInfo.Instance.GetQueryModel(RequestTaskID, RequestCustName, RequestBeginTime, RequestEndTime, // RequestConsultID, RequestQuestionType, RequestQuestionQuality, RequestIsComplaint, RequestProcessStatus, RequestStatus); //DataTable dt = BLL.CustHistoryInfo.Instance.GetCustHistoryInfo(query, "chi.CreateTime desc", BLL.PageCommon.Instance.PageIndex, PageSize, fields, out RecordCount); //repeaterTableList.DataSource = dt; //repeaterTableList.DataBind(); try { if (!int.TryParse(RequestPageSize, out PageSize)) { PageSize = 20; } DateTime dateVal = new DateTime(); Entities.QueryOrderTask query = new QueryOrderTask(); if (!string.IsNullOrEmpty(RequestCustName)) { query.UserName = RequestCustName; } if (!string.IsNullOrEmpty(RequestTaskID)) { query.TaskID = Convert.ToInt32(RequestTaskID); } if (!string.IsNullOrEmpty(RequestYpOrderID)) { query.YpOrderID = Convert.ToInt32(RequestYpOrderID); } if (!string.IsNullOrEmpty(RequestDealPerson) && RequestDealPerson != "-1") { query.AssignUserID = Convert.ToInt32(RequestDealPerson); } if (!string.IsNullOrEmpty(RequestOrderType)) { query.TypeStr = RequestOrderType; } if (!string.IsNullOrEmpty(RequestIsDealerHave)) { query.IsSelectdMsmemberstr = RequestIsDealerHave; } if (!string.IsNullOrEmpty(RequestTaskStatus)) { query.StatuStr = RequestTaskStatus; } if (!string.IsNullOrEmpty(RequestCreatBeginTime) && DateTime.TryParse(RequestCreatBeginTime, out dateVal)) { query.CreateTimeBegin = dateVal; } if (!string.IsNullOrEmpty(RequestCreatEndTime) && DateTime.TryParse(RequestCreatEndTime, out dateVal)) { query.CreateTimeEnd = dateVal; } if (!string.IsNullOrEmpty(RequestSubBeginTime) && DateTime.TryParse(RequestSubBeginTime, out dateVal)) { query.SubmitTimeBegin = dateVal; } if (!string.IsNullOrEmpty(RequestSubEndTime) && DateTime.TryParse(RequestSubEndTime, out dateVal)) { query.SubmitTimeEnd = dateVal; } if (!string.IsNullOrEmpty(Reason) && Reason != "-1") { query.NoDealerReasonID = Convert.ToInt32(Reason); } if (!string.IsNullOrEmpty(ddlArea) && ddlArea != "-1") { query.Area = ddlArea; } if (!string.IsNullOrEmpty(ProvinceID) && ProvinceID != "-1") { query.ProvinceID = Convert.ToInt32(ProvinceID); } if (!string.IsNullOrEmpty(CityID) && CityID != "-1") { query.CityID = Convert.ToInt32(CityID); } //任务类型,0是无主订单,不等于0是免费订单 if (!string.IsNullOrEmpty(TaskType)) { query.TaskType = TaskType; } DataTable dt = BLL.OrderTask.Instance.GetOrderTaskList(query, "case a.source when 2 then b.OrderCreateTime when 1 then c.OrderCreateTime when 3 then c.OrderCreateTime end desc", 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); } catch (Exception ex) { } }
//add by qizq 2012-9-25 无主订单任务列表 /// <summary> /// 按照查询条件查询 /// </summary> /// <param name="query">查询条件</param> /// <param name="order">排序</param> /// <param name="currentPage">页号,-1不分页</param> /// <param name="pageSize">每页记录数</param> /// <param name="totalCount">总行数</param> /// <returns>集合</returns> public DataTable GetOrderTaskList(QueryOrderTask query, string order, int currentPage, int pageSize, out int totalCount) { int userid = BLL.Util.GetLoginUserID(); return(Dal.OrderTask.Instance.GetOrderTaskList(query, order, currentPage, pageSize, out totalCount, userid)); }
/// <summary> /// 按照查询条件查询 /// </summary> /// <param name="query">查询条件</param> /// <param name="order">排序</param> /// <param name="currentPage">页号,-1不分页</param> /// <param name="pageSize">每页记录数</param> /// <param name="totalCount">总行数</param> /// <returns>集合</returns> public DataTable GetOrderTask(QueryOrderTask query, string order, int currentPage, int pageSize, out int totalCount) { return(Dal.OrderTask.Instance.GetOrderTask(query, order, currentPage, pageSize, out totalCount)); }