public Response <bool> goWork(List <StaffWorkInfo> model)
{
Response <bool> rsp = new Response <bool>();
List <StaffOnlie> entity = new List <StaffOnlie>();
List <StaffOnlineHis> entity_his = new List <StaffOnlineHis>();
foreach (var item in model)
{
StaffOnlie obj = new StaffOnlie();
StaffOnlineHis obj_his = new StaffOnlineHis();
obj.empNo = item.empno;
obj.empName = item.empname;
obj.line = item.line;
obj.online_time = DateTime.Now;
obj.shift_no = item.shift;
obj.old_line = item.line;
obj.work_date = DateTime.Now.ToString("yyyy-MM-dd");
obj.Status_flag = "0";
obj_his.empNo = item.empno;
obj_his.line = item.line;
obj_his.work_date = DateTime.Now.ToString("yyyy-MM-dd");
entity.Add(obj);
entity_his.Add(obj_his);
}
List <KeyValuePair <string, object> > cmd = new List <KeyValuePair <string, object> >();
try
{
string sql = @"insert into mfg_onlinewip
(work_date, empNo, empName, line, Status_flag, online_time, shift_no, old_line)
VALUES (@work_date, @empNo, @empName, @line, @Status_flag, @online_time, @shift_no, @old_line)";
string sql_his = "insert into mfg_onlinehistory(work_date, empNo, empName, line, Status_flag, online_time, offline_time, offline_Mark, shift_no, ligang_time, huigang_time, ligang_mark, old_line, new_line, new_line_time) (select work_date, empNo, empName, line, Status_flag, online_time, offline_time, offline_Mark, shift_no, ligang_time, huigang_time, ligang_mark, old_line, new_line, new_line_time from mfg_onlinewip where work_date=@work_date and line=@line and empNo=@empno ) ";
cmd.Add(new KeyValuePair <string, object>(sql, entity));
cmd.Add(new KeyValuePair <string, object>(sql_his, entity_his));
rsp.data = DapperRepository.Execute(cmd);
if (!rsp.data)
{
rsp.flag = 0;
}
}
catch (Exception ex)
{
rsp.flag = 0;
rsp.msg = ex.Message.ToString();
}
return(rsp);
}
//回岗
public Response <bool> returnpost(List <StaffWorkInfo> model)
{
Response <bool> rsp = new Response <bool>();
List <StaffOnlie> entity = new List <StaffOnlie>();
List <StaffOnlineHis> entity_his = new List <StaffOnlineHis>();
List <OffWorkDetail> offWorkDetails = new List <OffWorkDetail>();
foreach (var item in model)
{
StaffOnlie obj = new StaffOnlie();
StaffOnlineHis obj_his = new StaffOnlineHis();
OffWorkDetail offwork = new OffWorkDetail();
obj.empNo = item.empno;
obj.empName = item.empname;
obj.line = item.new_line;
obj.shift_no = item.shift;
obj.online_time = DateTime.Now;
obj.huigang_time = DateTime.Now;
obj.old_line = item.line;
obj.work_date = DateTime.Now.ToString("yyyy-MM-dd");
obj.Status_flag = "0";
obj_his.empNo = item.empno;
obj_his.line = item.new_line;
obj_his.work_date = DateTime.Now.ToString("yyyy-MM-dd");
offwork.emp_no = item.empno;
offwork.work_date = DateTime.Now.ToString("yyyy-MM-dd");
offwork.ligang_time = item.ligang_time;
offwork.huigang_time = DateTime.Now;
offwork.ligang_time_length = DateTime.Now.Subtract(item.ligang_time).TotalSeconds;
offwork.shift_no = item.shift;
entity.Add(obj);
entity_his.Add(obj_his);
offWorkDetails.Add(offwork);
}
List <KeyValuePair <string, object> > cmd = new List <KeyValuePair <string, object> >();
try
{
string sql = @"update mfg_onlinewip set huigang_time=@huigang_time,Status_flag=@Status_flag
where work_date=@work_date and empNo=@empNo and line=@old_line ";
string sql_his = "insert into mfg_onlinehistory(work_date, empNo, empName, line, Status_flag, online_time, offline_time, offline_Mark, shift_no, ligang_time, huigang_time, ligang_mark, old_line, new_line, new_line_time) (select work_date, empNo, empName, line, Status_flag, online_time, offline_time, offline_Mark, shift_no, ligang_time, huigang_time, ligang_mark, old_line, new_line, new_line_time from mfg_onlinewip where work_date=@work_date and line=@line and empNo=@empno ) ";
string sql_record = @"INSERT into mfg_ligang_total(emp_no, work_date, ligang_ci, ligang_time, huigang_time, ligang_time_length, shift_no) VALUES
(@emp_no, @work_date, @ligang_ci, @ligang_time, @huigang_time, @ligang_time_length, @shift_no)";
cmd.Add(new KeyValuePair <string, object>(sql, entity));
cmd.Add(new KeyValuePair <string, object>(sql_his, entity_his));
cmd.Add(new KeyValuePair <string, object>(sql_record, offWorkDetails));
rsp.data = DapperRepository.Execute(cmd);
if (!rsp.data)
{
rsp.flag = 0;
}
}
catch (Exception ex)
{
rsp.flag = 0;
rsp.msg = ex.Message.ToString();
}
return(rsp);
}
