//在线调岗位 public Response <bool> tranpost(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.new_line; obj.shift_no = item.shift; obj.online_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"); entity.Add(obj); entity_his.Add(obj_his); } List <KeyValuePair <string, object> > cmd = new List <KeyValuePair <string, object> >(); try { string sql = @"update mfg_onlinewip set line=@line,old_line=@old_line,new_line=@new_line,new_line_time=@new_line_time 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 ) "; 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); }