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