/// <summary>
/// 分页获取获取工作信息表datatable
/// </summary>
/// <param name="pageindex">当前页数</param>
/// <param name="pagesize">每页显示条数</param>
/// <param name="orderby">排序方式</param>
/// <param name="pageCount">总页数</param>
/// <param name="recordCount">总记录数</param>
/// <returns></returns>
public DataTable GetDataTable(int pageindex, int pagesize, WhereClip where, OrderByClip orderby, ref int pageCount, ref int recordCount)
{
WhereClip appendwhere = new WhereClip();
appendwhere.Append(" (HandSequence is null or HandSequence= (select max(HandSequence) from WorkHandLog where [WorkID]=[WorkInfo].[ID]))");
return(Dal.From <WorkInfo>().Join <ShebeiInfo>(ShebeiInfo._.ID == WorkInfo._.SbID)
.Join <WorkHandLog>(WorkInfo._.ID == WorkHandLog._.WorkID && appendwhere, JoinType.leftJoin)
.Select(WorkInfo._.ID.All, WorkHandLog._.HandResult, WorkHandLog._.HandDate, ShebeiInfo._.Code, ShebeiInfo._.Name, ShebeiInfo._.GuiGe, WorkHandLog._.ChuliYj)
.Where(where).OrderBy(orderby).ToDataTable(pagesize, pageindex, ref pageCount, ref recordCount));
}
/// <summary>
/// 分页获取获取工作信息表datatable
/// </summary>
/// <param name="pageindex">当前页数</param>
/// <param name="pagesize">每页显示条数</param>
/// <param name="orderby">排序方式</param>
/// <param name="pageCount">总页数</param>
/// <param name="recordCount">总记录数</param>
/// <returns></returns>
public DataTable GetDataTable(int pageindex, int pagesize, string UserId, WhereClip where, OrderByClip orderby, ref int pageCount, ref int recordCount)
{
WhereClip wherenew = new WhereClip();
if (!string.IsNullOrEmpty(UserId))
{
string[] s = UserId.Split(';');
if (s[1] == "2")
{
wherenew = wherenew && WorkHandLog._.Uper == new Guid(s[0]);
}
else
{
wherenew = wherenew && WorkHandLog._.DownEr == new Guid(s[0]);
}
}
if (WhereClip.IsNullOrEmpty(where))
{
where = wherenew;
}
else
{
where = where && wherenew;
}
if (WhereClip.IsNullOrEmpty(where))
{
where.Append(@" (handsequence is null or handsequence = (select max(handsequence) from [WorkHandLog] b where [WorkInfo].[ID] = b.[WorkID])) ");
}
else
{
where.Append(@" and (handsequence is null or handsequence = (select max(handsequence) from [WorkHandLog] b where [WorkInfo].[ID] = b.[WorkID]) )");
}
return(Dal.From <WorkInfo>().Join <ShebeiInfo>(ShebeiInfo._.ID == WorkInfo._.SbID)
.Join <WorkHandLog>(WorkInfo._.ID == WorkHandLog._.WorkID, JoinType.leftJoin)
.Select(WorkInfo._.ID.All, ShebeiInfo._.Code, ShebeiInfo._.Name, ShebeiInfo._.GuiGe)
.Where(where).OrderBy(orderby).ToDataTable(pagesize, pageindex, ref pageCount, ref recordCount));
}
/// <summary>
/// 根据条件获取待办任务
/// </summary>
/// <param name="p"></param>
/// <param name="pageSize"></param>
/// <param name="where"></param>
/// <param name="orderByClip"></param>
/// <param name="count"></param>
/// <param name="recordCount"></param>
/// <returns></returns>
public DataTable GetDaiBanDataTable(int pageindex, int pagesize, WhereClip where, OrderByClip orderby, ref int pageCount, ref int recordCount)
{
WhereClip appendwhere = new WhereClip();
appendwhere.Append(" ( HandSequence= (select max(HandSequence) from WorkHandLog where [WorkID]=[WorkInfo].[ID]))");
return Dal.From<WorkHandLog>().Join<WorkInfo>(WorkInfo._.ID == WorkHandLog._.WorkID && appendwhere, JoinType.leftJoin)
.Join<ShebeiInfo>(ShebeiInfo._.ID == WorkInfo._.SbID, JoinType.leftJoin)
.Where(where && ShebeiInfo._.State != "正常").OrderBy(orderby)
.Select(WorkHandLog._.ID.All,
WorkInfo._.SbID, WorkInfo._.Address, WorkInfo._.ChuLiYiJian
, WorkInfo._.CreaterName, WorkInfo._.CurrentUser, WorkInfo._.Guzhang, WorkInfo._.GuZhangXx
, WorkInfo._.Note, WorkInfo._.PlanTime, WorkInfo._.RealTime, WorkInfo._.Status
, WorkInfo._.Tel, WorkInfo._.City, WorkInfo._.Xian, WorkInfo._.Zhen
, ShebeiInfo._.Code, ShebeiInfo._.Name, ShebeiInfo._.GuiGe, ShebeiInfo._.Note.Alias("SheBeiNote"))
.ToDataTable(pagesize, pageindex, ref pageCount, ref recordCount);
}
/// <summary>
/// 根据条件获取我的派工任务
/// </summary>
/// <param name="p"></param>
/// <param name="pageSize"></param>
/// <param name="where"></param>
/// <param name="orderByClip"></param>
/// <param name="count"></param>
/// <param name="recordCount"></param>
/// <returns></returns>
public DataTable GetMyPaiGongDataTable(int pageindex, int pagesize, WhereClip where, OrderByClip orderby, ref int pageCount, ref int recordCount)
{
WhereClip appendwhere = new WhereClip();
appendwhere.Append(" ( HandSequence= (select max(HandSequence) from WorkHandLog where [WorkID]=[WorkInfo].[ID]))");
return(Dal.From <WorkHandLog>().Join <WorkInfo>(WorkInfo._.ID == WorkHandLog._.WorkID && appendwhere, JoinType.leftJoin)
.Join <ShebeiInfo>(ShebeiInfo._.ID == WorkInfo._.SbID, JoinType.leftJoin)
.Where(where).OrderBy(orderby)
.Select(WorkHandLog._.ID.All,
WorkInfo._.SbID, WorkInfo._.Address, WorkInfo._.ChuLiYiJian
, WorkInfo._.CreaterName, WorkInfo._.CurrentUser, WorkInfo._.GuZhangXx
, WorkInfo._.Note, WorkInfo._.PlanTime, WorkInfo._.RealTime, WorkInfo._.Status
, WorkInfo._.Tel, WorkInfo._.City, WorkInfo._.Xian, WorkInfo._.Zhen
, ShebeiInfo._.Code, ShebeiInfo._.Name, ShebeiInfo._.GuiGe, ShebeiInfo._.Note.Alias("SheBeiNote"))
.ToDataTable(pagesize, pageindex, ref pageCount, ref recordCount));
}
public DataTable GetWorkHandType(string sbid, string type)
{
WhereClip appendwhere = new WhereClip();
appendwhere.Append(" ( HandSequence= (select max(HandSequence) from WorkHandLog where [WorkID]=[WorkInfo].[ID]))");
return(Dal.From <WorkHandLog>().Join <WorkInfo>(WorkHandLog._.WorkID == WorkInfo._.ID)
.Join <ShebeiInfo>(WorkInfo._.SbID == ShebeiInfo._.ID)
.Select(WorkHandLog._.ID, ShebeiInfo._.Code.Alias("设备编号"), ShebeiInfo._.Name.Alias("设备名称"),
WorkHandLog._.HandDate.Alias("处理日期"), WorkHandLog._.UpName.Alias("处理人")
, WorkInfo._.CreateDate.Alias("上报时间"), WorkInfo._.CreaterName.Alias("上报人")
, WorkInfo._.GuZhangXx.Alias("故障信息"), WorkHandLog._.ChuliYj.Alias("处理信息")
)
.Where(ShebeiInfo._.ID == sbid && WorkHandLog._.HandType == int.Parse(type) && appendwhere)
.OrderBy(WorkHandLog._.HandDate.Desc)
.ToDataTable());
}
/// <summary>
/// 分页获取获取工作信息表datatable
/// </summary>
/// <param name="pageindex">当前页数</param>
/// <param name="pagesize">每页显示条数</param>
/// <param name="orderby">排序方式</param>
/// <param name="pageCount">总页数</param>
/// <param name="recordCount">总记录数</param>
/// <returns></returns>
public DataTable GetDataTable(int pageindex, int pagesize, string UserId, WhereClip where, OrderByClip orderby, ref int pageCount, ref int recordCount)
{
WhereClip wherenew = new WhereClip();
if (!string.IsNullOrEmpty(UserId))
{
string[] s = UserId.Split(';');
if (s[1] == "2")
{
wherenew = wherenew && WorkHandLog._.Uper == new Guid(s[0]);
}
else
{
wherenew = wherenew && WorkHandLog._.DownEr == new Guid(s[0]);
}
}
if (WhereClip.IsNullOrEmpty(where))
{
where = wherenew;
}
else
{
where = where && wherenew;
}
if (WhereClip.IsNullOrEmpty(where))
{
where.Append(@" (handsequence is null or handsequence = (select max(handsequence) from [WorkHandLog] b where [WorkInfo].[ID] = b.[WorkID])) ");
}
else
{
where.Append(@" and (handsequence is null or handsequence = (select max(handsequence) from [WorkHandLog] b where [WorkInfo].[ID] = b.[WorkID]) )");
}
return Dal.From<WorkInfo>().Join<ShebeiInfo>(ShebeiInfo._.ID == WorkInfo._.SbID)
.Join<WorkHandLog>(WorkInfo._.ID == WorkHandLog._.WorkID, JoinType.leftJoin)
.Select(WorkInfo._.ID.All, ShebeiInfo._.Code, ShebeiInfo._.Name, ShebeiInfo._.GuiGe)
.Where(where).OrderBy(orderby).ToDataTable(pagesize, pageindex, ref pageCount, ref recordCount);
}
public DataTable GetWorkHandType(string sbid, string type)
{
WhereClip appendwhere = new WhereClip();
appendwhere.Append(" ( HandSequence= (select max(HandSequence) from WorkHandLog where [WorkID]=[WorkInfo].[ID]))");
return Dal.From<WorkHandLog>().Join<WorkInfo>(WorkHandLog._.WorkID == WorkInfo._.ID)
.Join<ShebeiInfo>(WorkInfo._.SbID == ShebeiInfo._.ID)
.Select(WorkHandLog._.ID,ShebeiInfo._.Code.Alias("设备编号"), ShebeiInfo._.Name.Alias("设备名称"),
WorkHandLog._.HandDate.Alias("处理日期"), WorkHandLog._.UpName.Alias("处理人")
, WorkInfo._.CreateDate.Alias("上报时间"), WorkInfo._.CreaterName.Alias("上报人")
, WorkInfo._.GuZhangXx.Alias("故障信息"), WorkHandLog._.ChuliYj.Alias("处理信息")
)
.Where(ShebeiInfo._.ID == sbid && WorkHandLog._.HandType == int.Parse(type) && appendwhere)
.OrderBy(WorkHandLog._.HandDate.Desc)
.ToDataTable();
}
/// <summary>
/// 分页获取获取工作信息表datatable
/// </summary>
/// <param name="pageindex">当前页数</param>
/// <param name="pagesize">每页显示条数</param>
/// <param name="orderby">排序方式</param>
/// <param name="pageCount">总页数</param>
/// <param name="recordCount">总记录数</param>
/// <returns></returns>
public DataTable GetDataTable(int pageindex, int pagesize, WhereClip where, OrderByClip orderby, ref int pageCount, ref int recordCount)
{
WhereClip appendwhere = new WhereClip();
appendwhere.Append(" (HandSequence is null or HandSequence= (select max(HandSequence) from WorkHandLog where [WorkID]=[WorkInfo].[ID]))");
return Dal.From<WorkInfo>().Join<ShebeiInfo>(ShebeiInfo._.ID == WorkInfo._.SbID)
.Join<WorkHandLog>(WorkInfo._.ID == WorkHandLog._.WorkID && appendwhere, JoinType.leftJoin)
.Select(WorkInfo._.ID.All, WorkHandLog._.HandResult,WorkHandLog._.HandDate, ShebeiInfo._.Code, ShebeiInfo._.Name, ShebeiInfo._.GuiGe, WorkHandLog._.ChuliYj)
.Where(where).OrderBy(orderby).ToDataTable(pagesize, pageindex, ref pageCount, ref recordCount);
}
