public int ConfirmAll_Jmjm1(Jmjm request) { int Result = -1; try { using (var db = DbConnectionFactory.OpenDbConnection()) { if (request.confirmAllString != null && request.confirmAllString != "") { JArray ja = (JArray)JsonConvert.DeserializeObject(request.confirmAllString); if (ja != null) { for (int i = 0; i < ja.Count(); i++) { string strJobNo = ""; string strActualArrivalDate = ""; string strDeliveryDate = ""; if (ja[i]["JobNo"] != null || ja[i]["JobNo"].ToString() != "") { strJobNo = ja[i]["JobNo"].ToString(); } strActualArrivalDate = ja[i]["ActualArrivalDate"].ToString(); strDeliveryDate = ja[i]["DeliveryDate"].ToString(); if (strJobNo != "") { if (strActualArrivalDate != "") { db.Update("Jmjm3", " DateTime = '" + Modfunction.SQLSafe(strActualArrivalDate) + "'", " JobNo='" + strJobNo + "' and Description = 'ACTUAL ARRIVAL DATE'"); } if (strDeliveryDate != "") { db.Update("Jmjm1", " DeliveryDateTime = '" + Modfunction.SQLSafe(strDeliveryDate) + "'", " JobNo='" + strJobNo + "'"); } } } Result = 1; } } } } catch { throw; } return(Result); }
public List <Jmjm1> Get_Jmjm1_List(Jmjm request) { List <Jmjm1> Result = null; try { using (var db = DbConnectionFactory.OpenDbConnection("TMS")) { string strSql = ""; string strWhere = " Where (DeliveryDateTime >= getdate() " + " or DeliveryDateTime is null) " + " And ModuleCode='AE' " + " And DeliveryAgentCode is not null And DeliveryAgentCode !='' And DeliveryAgentCode ='" + request.DeliveryAgentCode + "' "; strSql = " select JobNo, DeliveryAgentCode,CONVERT(varchar(16), ETA, 20) as ETA , Pcs, AwbBlNo, '' as UpdatedFlag," + " (select isnull(aeaw1.ConsigneeAddress1,'') + isnull(aeaw1.ConsigneeAddress2,'') + isnull(ConsigneeAddress3,'') +isnull(aeaw1.ConsigneeAddress4,'') from aeaw1 where aeaw1.JobNo=jmjm1.JobNo ) as Address," + " ConsigneeName ,CONVERT(varchar(16), (select top 1 Jmjm3.DateTime from jmjm3 where Jmjm3.JobNo=Jmjm1.JobNo and Jmjm3.Description = 'ACTUAL ARRIVAL DATE' order by Jmjm3.lineItemNo desc ), 20) as ActualArrivalDate, " + " CONVERT(varchar(16),DeliveryDateTime, 20) as DeliveryDate " + " from jmjm1 " + strWhere + " "; Result = db.Select <Jmjm1>(strSql); } } catch { throw; } return(Result); }
public int ConfirmAll_Jmjm1(Jmjm request) { int Result = -1; try { using (var db = DbConnectionFactory.OpenDbConnection()) { if (request.confirmAllString != null && request.confirmAllString != "") { JArray ja = (JArray)JsonConvert.DeserializeObject(request.confirmAllString); if (ja != null) { for (int i = 0; i < ja.Count(); i++) { string strJobNo = ""; string strActualArrivalDate = ""; string strDeliveryDate = ""; if (ja[i]["JobNo"] != null || ja[i]["JobNo"].ToString() != "") { strJobNo = ja[i]["JobNo"].ToString(); } strActualArrivalDate = ja[i]["ActualArrivalDate"].ToString(); strDeliveryDate = ja[i]["DeliveryDate"].ToString(); if (strJobNo != "") { if (strActualArrivalDate != "") { int count = db.Scalar <int>("Select Count(JobNo) from Jmjm3 where JobNo='" + Modfunction.SQLSafe(strJobNo) + "' and Description = 'ACTUAL ARRIVAL DATE'"); if (count > 0) { db.Update("Jmjm3", " DateTime = '" + Modfunction.SQLSafe(strActualArrivalDate) + "'", " JobNo='" + Modfunction.SQLSafe(strJobNo) + "' and Description = 'ACTUAL ARRIVAL DATE'"); } else { count = db.Scalar <int>("Select Max(LineItemNo) from Jmjm3 where JobNo='" + Modfunction.SQLSafe(strJobNo) + "'"); count = count + 1; string updateBy = db.Scalar <string>("Select DeliveryAgentCode from jmjm1 Where JobNo='" + Modfunction.SQLSafe(strJobNo) + "'"); db.Insert(new Jmjm3 { JobNo = strJobNo, DateTime = Convert.ToDateTime(strActualArrivalDate), UpdateDatetime = DateTime.Now, LineItemNo = count, AutoFlag = "N", StatusCode = "", UpdateBy = updateBy, Description = "ACTUAL ARRIVAL DATE" }); } } if (strDeliveryDate != "") { db.Update("Jmjm1", " DeliveryDateTime = '" + Modfunction.SQLSafe(strDeliveryDate) + "'", " JobNo='" + strJobNo + "'"); } } } Result = 1; } } } } catch { throw; } return(Result); }