public long InsertContainerNo(Update_Done request) { long Result = -1; try { if (string.IsNullOrEmpty(request.ContainerNo) || request.ContainerNo.Length < 1) { return(Result); } using (var db = DbConnectionFactory.OpenDbConnection()) { Result = db.Scalar <int>( "Select count(*) From Jmjm6 Where Jmjm6.JobNo={0} And jmjm6.ContainerNo={1}", request.JobNo, request.ContainerNo ); if (Result < 1) { int count = db.Scalar <int>( "Select count(*) From Jmjm6 Where Jmjm6.JobNo={0}", request.JobNo ); db.InsertParam <Jmjm6>(new Jmjm6 { JobNo = request.JobNo, LineItemNo = count + 1, ContainerNo = request.ContainerNo }); Result = 0; } else { Result = -1; } } } catch { throw; } return(Result); }
public int UpdateDone(Update_Done request) { int Result = -1; try { using (var db = DbConnectionFactory.OpenDbConnection()) { if (request.DoneDateTime != DateTime.MinValue) { Result = db.Update <Jmjm4>(new { DoneDateTime = request.DoneDateTime, DoneFlag = request.DoneFlag, Remark = request.Remark, ContainerNo = request.ContainerNo }, p => p.JobNo == request.JobNo && p.JobLineItemNo == request.JobLineItemNo && p.LineItemNo == request.LineItemNo); } else { Result = db.Update <Jmjm4>(new { DoneFlag = request.DoneFlag, Remark = request.Remark, ContainerNo = request.ContainerNo }, p => p.JobNo == request.JobNo && p.JobLineItemNo == request.JobLineItemNo && p.LineItemNo == request.LineItemNo); } if (Result > 0) { InsertContainerNo(request); } } } catch { throw; } return(Result); }