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