public Response <List <StaffWorkInfo> > getOnlieInfo(StaffOnlieModel model) { Response <List <StaffWorkInfo> > rsp = new Response <List <StaffWorkInfo> >(); try { model.line = getUserLine(model.user); string sql = @"select a.WorkID empno, a.WorkerName empname ,a.PostName job,a.line ,a.shift_no shift , b.Status_flag from m_auxiliary_manpower a LEFT JOIN (select * from mfg_onlinewip where work_date=@work_date ) b on a.WorkID=b.empNo where b.empNo is NULL and a.line=@line and a.IsEnabled='Y' "; if (model.status == 1) { sql = @"select a.empNo ,a.empName ,b.PostName job , a.Status_flag from mfg_onlinewip a ,m_auxiliary_manpower b where a.line=@line and a.work_date=@work_date and a.line=b.line and a.empNo=b.WorkID"; } rsp.data = DapperRepository.Query <StaffWorkInfo>(sql, new { line = model.line, shift = model.shift, work_date = model.workdate }); } catch (Exception ex) { rsp.flag = 0; rsp.msg = ex.Message.ToString(); } return(rsp); }
public Response <List <StaffWorkInfo> > getpostinfo(StaffOnlieModel model) { Response <List <StaffWorkInfo> > rsp = new Response <List <StaffWorkInfo> >(); try { model.line = getUserLine(model.user); string sql = @"select a.empNo ,a.empName ,CASE when a.old_line is null then a.line else a.old_line end source_line ,a.line,a.shift_no,a.Status_flag,b.postname job from mfg_onlinewip a ,m_auxiliary_manpower b where a.line=b.line and a.empNo=b.WorkID and a.line=@line and a.work_date=@work_date and a.Status_flag ='0' "; if (model.status == 1) { sql = @"select a.empNo ,a.empName ,a.line,a.shift_no,a.Status_flag,a.ligang_mark,a.ligang_time,b.postname job from mfg_onlinewip a ,m_auxiliary_manpower b where a.line=b.line and a.empNo=b.WorkID and a.line=@line and a.work_date=@work_date and a.Status_flag ='1'"; } rsp.data = DapperRepository.Query <StaffWorkInfo>(sql, new { line = model.line, shift = model.shift, work_date = model.workdate }); } catch (Exception ex) { rsp.flag = 0; rsp.msg = ex.Message.ToString(); } return(rsp); }
public Response <List <StaffWorkInfo> > getpostinfo(StaffOnlieModel model) { Response <List <StaffWorkInfo> > rsp = new Response <List <StaffWorkInfo> >(); rsp = _service.getpostinfo(model); return(rsp); }