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