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