//Constructor public FilterComplain_Validation(FilterComplain_DetailVM poViewModel) { oViewModel = poViewModel; } //End public FilterCPAR_Validation()
} //End public Complain_DetailVM getData_create() public List <Complain_LogbookVM> getDatalist_logbookprint(FilterComplain_DetailVM poViewModel = null) { List <Complain_LogbookVM> vReturn; using (var db = new DBMAINContext()) { var oQRY = from tb in db.Complain_infos select new Complain_LogbookVM { RSEQNO = tb.RSEQNO, RUID = tb.RUID, DTA_STS = tb.DTA_STS, COMPLAIN_STS = tb.COMPLAIN_STS, //COMPLAIN_STS_ID = tb.COMPLAIN_STS_ID, COMPLAIN_STS_NM = tb.COMPLAIN_STS_NM, COMPLAIN_ID = tb.COMPLAIN_ID, //COMPLAIN_NM = tb.COMPLAIN_NM, //COMPLAIN_TYPE = tb.COMPLAIN_TYPE, //COMPLAIN_TYPE_ID = tb.COMPLAIN_TYPE_ID, //COMPLAIN_TYPE_NM = tb.COMPLAIN_TYPE_NM, //COMPLAIN_SUBTYPE = tb.COMPLAIN_SUBTYPE, DESCRIPTION = tb.DESCRIPTION, SOLUTION = tb.SOLUTION, ISSUED_DT = tb.ISSUED_DT, RESPONSE_DT = tb.RESPONSE_DT, TARGET_DT = tb.TARGET_DT, RECIPIENT_RUID = tb.RECIPIENT_RUID, RECIPIENT_NM = tb.RECIPIENT_NM, RECIPIENT_DEPTRUID = tb.RECIPIENT_DEPTRUID, //RECIPIENT_DEPTID = tb.RECIPIENT_DEPTID, RECIPIENT_DEPTNM = tb.RECIPIENT_DEPTNM, PIC_RUID = tb.PIC_RUID, PIC_NM = tb.PIC_NM, PIC_DEPTRUID = tb.PIC_DEPTRUID, //PIC_DEPTID = tb.PIC_DEPTID, PIC_DEPTNM = tb.PIC_DEPTNM, PROJ_RUID = tb.PROJ_RUID, PROJ_ID = tb.PROJ_ID, PROJ_NM = tb.PROJ_NM, PROJ_STS = tb.PROJ_STS, //PROJ_STS_ID = tb.PROJ_STS_ID, PROJ_STS_NM = tb.PROJ_STS_NM, //CLIENT_RUID = tb.CLIENT_RUID, //IS_CPAR = tb.IS_CPAR }; if ((poViewModel.Complain_DT1 != null) && (poViewModel.Complain_DT2 != null)) { oQRY = oQRY.Where(fld => fld.ISSUED_DT >= poViewModel.Complain_DT1 && fld.ISSUED_DT <= poViewModel.Complain_DT2); } //Access Control if ((this.sROLE_RUID != valFLAG.FLAG_ROLE_SYSADMIN) && (this.sROLE_RUID != valFLAG.FLAG_ROLE_PJXADMIN)) { oQRY = oQRY.Where(fld => fld.RECIPIENT_RUID == sRES_RUID || fld.PIC_DEPTRUID == sDEPT_RUID); } //End if ((this.sROLE_RUID != valFLAG.FLAG_ROLE_SYSADMIN) && vReturn = oQRY.OrderBy(fld => fld.RSEQNO).ToList(); } //End using (var = new DbContext()) return(vReturn); } //End public List<CPAR_ListVM> getDatalist_logbook(string id = null)