public int UpdateDone(Update_Done request) { int Result = -1; try { using (var db = DbConnectionFactory.OpenDbConnection("TMS")) { 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); }
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("TMS")) { 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; List <Jmjm4> ResultJmjm4 = null; List <Jmjm4> ResultJmjm4DoneFlag = null; List <Jmje2> ResultJmje2 = null; string strEventCode = ""; string strSqlJmje2 = ""; try { using (var db = DbConnectionFactory.OpenDbConnection("TMS")) { 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); } string strSql = "select (Select EventCode From jmjm3 where jmjm3.jobno=jmjm4.jobno and jmjm3.LineItemNo =jmjm4.JobLineItemNo ) as EventCode,* from jmjm4 where jobno ='" + request.JobNo + "'And JobLineItemNo='" + request.JobLineItemNo + "' And LineItemNo='" + request.LineItemNo + "' and PhoneNumber='" + request.PhoneNumber + "' "; ResultJmjm4 = db.Select <Jmjm4>(strSql); if (ResultJmjm4.Count > 0) { strEventCode = Modfunction.CheckNull(ResultJmjm4[0].EventCode); strSqlJmje2 = "Select InsertNextEventCode ,InsertNextEventGroup From jmje2 Where EventCode='" + strEventCode + "' And LineItemNo in (Select EventLineItemNo From Jmjm4 Where jobno ='" + request.JobNo + "'And JobLineItemNo='" + request.JobLineItemNo + "' And LineItemNo='" + request.LineItemNo + "' )"; ResultJmje2 = db.Select <Jmje2>(strSqlJmje2); if (ResultJmje2.Count > 0) { if (Modfunction.CheckNull(ResultJmje2[0].InsertNextEventCode) == "" && Modfunction.CheckNull(ResultJmje2[0].InsertNextEventGroup) == "") { bool BlnDoneFlag = true; string strJmjm4DoneFlag = "select DoneFlag from jmjm4 where jobno ='" + request.JobNo + "'And JobLineItemNo='" + request.JobLineItemNo + "' and PhoneNumber='" + request.PhoneNumber + "' "; ResultJmjm4DoneFlag = db.Select <Jmjm4>(strJmjm4DoneFlag); if (ResultJmjm4DoneFlag.Count > 0) { for (int i = 0; i < ResultJmjm4DoneFlag.Count; i++) { if (ResultJmjm4DoneFlag[i].DoneFlag == "N") { BlnDoneFlag = false; break; } } if (BlnDoneFlag == true) { string strUpdateStautsCode; strUpdateStautsCode = "Update Jmjm3 Set StatusCode ='CMP' Where JobNo ='" + request.JobNo + "' And LineItemNo ='" + request.JobLineItemNo + "'"; db.ExecuteSql(strUpdateStautsCode); } } } else { if (Modfunction.CheckNull(ResultJmje2[0].InsertNextEventCode).Length > 0) { SaveInsertNextEventCode(Modfunction.CheckNull(ResultJmje2[0].InsertNextEventCode), request.JobLineItemNo, request.JobNo, request.PhoneNumber); } if (Modfunction.CheckNull(ResultJmje2[0].InsertNextEventGroup).Length > 0) { SaveInsertGroupNameEvent(Modfunction.CheckNull(ResultJmje2[0].InsertNextEventGroup), request.JobLineItemNo, request.JobNo, request.PhoneNumber); } string strUpdateStautsCode; strUpdateStautsCode = "Update Jmjm3 Set StatusCode ='CMP' Where JobNo ='" + request.JobNo + "' And LineItemNo ='" + request.JobLineItemNo + "'"; db.ExecuteSql(strUpdateStautsCode); } } } } } catch { throw; } return(Result); }