public IActionResult ListPersonal(ListSupportInputModel model) { TASM_SUPPORT_PERSONAL_Da da = new TASM_SUPPORT_PERSONAL_Da(); SqlSugar.PageModel p = new SqlSugar.PageModel(); p.PageIndex = model.pageindex; p.PageSize = model.pagesize; SupprotWatchState state = model.WatchState; SupprotWatchType type = model.WatchType; List <PersonalSupportListModel> list = da.ListByWhere(string.Empty, ref p, type, state, model.Uuid); return(SuccessResultList(list, p)); }
public List <SupportModel> ListByWhere(string keyword, ref PageModel p, SupprotWatchType watchType, SupprotWatchState state, int?watchId, string order = "SID") { string sql = @"SELECT T.*, TR.USER_ID CREATORID, TR.USER_NAME CREATORNAME, TU.USER_ID CONDUCTORID, TU.USER_NAME CONDUCTORNAME, TP.PID PROJECTID, TP.NAME PROJECTNAME, TP.CODE PROJECTCODE, TM.NAME MACHINENAME, TM.SERIAL MACHINESERIAL FROM TASM_SUPPORT T LEFT JOIN TASM_USER TR ON TR.USER_ID = T.CREATOR LEFT JOIN TASM_USER TU ON TU.USER_ID = T.CONDUCTOR LEFT JOIN TASM_PROJECT TP ON TP.PID = T.PROJECT LEFT JOIN TASM_MACHINE TM ON TM.MID = T.MID WHERE 1 = 1 "; var configParms = new List <SugarParameter>(); if (watchType == SupprotWatchType.创建人) { sql += " and t.creator=:watchId "; configParms.Add(new SugarParameter("watchId", watchId.Value)); } if (watchType == SupprotWatchType.处理人) { sql += " and t.conductor=:watchId "; configParms.Add(new SugarParameter("watchId", watchId.Value)); } if (state != SupprotWatchState.全部) { sql += " and t.state= " + (int)state; } if (!string.IsNullOrEmpty(keyword)) { sql += " and (t.CODE like '%" + keyword + "%' or t.CONTENT like '%" + keyword + "%' or TR.USER_NAME like '%" + keyword + "%' or TU.USER_NAME like '%" + keyword + "%' or TP.NAME like '%" + keyword + "%') "; } int totalCount = 0; int totalPage = 0; List <SupportModel> list = Db.SqlQueryable <SupportModel>(sql) .OrderBy(s => s.SID, OrderByType.Desc) .AddParameters(configParms) .ToPageList(p.PageIndex, p.PageSize, ref totalCount, ref totalPage); p.PageCount = totalCount; return(list); }
public List <PersonalSupportListModel> ListByWhere(string keyword, ref PageModel p, SupprotWatchType watchType, SupprotWatchState state, int Uuid) { string sql = @" SELECT T.STATUS PSTATUS, T.ID ID, T.CID CID, T.DID DID, T.CREATETIME PCREATETIME, T.TID TID, TS.SID, TS.TITLE, TS.CONTENT, TS.CREATOR, TS.TYPE, TS.SEVERITY, TS.FINDATE, TS.CONDUCTOR, TS.PROJECT, TS.STATUS STATUS, TS.CREATETIME, TS.MEMBERID, TS.STATE, TS.MID, TS.CODE, TR.USER_ID CREATORID, TR.USER_NAME CREATORNAME, TU.USER_ID CONDUCTORID, TU.USER_NAME CONDUCTORNAME, TP.PID PROJECTID, TP.NAME PROJECTNAME, TP.CODE PROJECTCODE, TM.NAME MACHINENAME, TM.SERIAL MACHINESERIAL FROM TASM_SUPPORT_PERSONAL T LEFT JOIN TASM_SUPPORT TS ON T.SID = TS.SID LEFT JOIN TASM_USER TR ON TR.USER_ID = TS.CREATOR LEFT JOIN TASM_USER TU ON TU.USER_ID = TS.CONDUCTOR LEFT JOIN TASM_PROJECT TP ON TP.PID = TS.PROJECT LEFT JOIN TASM_MACHINE TM ON TM.MID = TS.MID where 1=1 "; var configParms = new List <SugarParameter>(); if (watchType == SupprotWatchType.创建人) { sql += " and T.CID =:watchId "; configParms.Add(new SugarParameter("watchId", Uuid)); } if (watchType == SupprotWatchType.处理人) { sql += " and T.DID =:watchId "; configParms.Add(new SugarParameter("watchId", Uuid)); } if (state != SupprotWatchState.全部) { sql += " and T.STATUS= " + (int)state; } int totalCount = 0; int totalPage = 0; List <PersonalSupportListModel> list = Db.SqlQueryable <PersonalSupportListModel>(sql) .OrderBy(s => s.SID, OrderByType.Desc) .AddParameters(configParms) .ToPageList(p.PageIndex, p.PageSize, ref totalCount, ref totalPage); p.PageCount = totalCount; return(list); }