public int GetShippingFilesST() { Jinsdb.GetImportShippingST(); var rs = Jinsdb.GetUnShippingFilesST(); if (rs.Tables[0].Rows.Count <= 0) { return(0); } foreach (DataRow item in rs.Tables[0].Rows) { OrdMain model = this.PrepareShippingModel(item); model.SubST = new List <OrdST>(); var rsdetail = Jinsdb.GetOrdShipDetail(model.ID); foreach (DataRow item2 in rsdetail.Tables[0].Rows) { var subid = item2["SubID"].ToString().GetIntFromStr(); var opc = item2["OPC"].ToString(); var qtyship = item2["QtyShip"].ToString().GetIntFromStr(); model.SubST.Add(new OrdST() { ID = model.ID, SubID = subid, OPC = opc, Qty = qtyship }); } var xmldoc = Jinsxml.CreateShippingXMLFile(model); xmldoc.Save(localFolder_shipping + @"\" + model.OrdID + @".xml"); Jinsdb.UpdateShippingFlatST(model); } return(rs.Tables[0].Rows.Count); }
public int GetShippingFilesRX() { var rs = Jinsdb.GetUnShippingFilesRX(); if (rs.Tables[0].Rows.Count <= 0) { return(0); } foreach (DataRow item in rs.Tables[0].Rows) { OrdMain model = this.PrepareShippingModel(item); var xmldoc = Jinsxml.CreateShippingXMLFile(model); xmldoc.Save(localFolder_shipping + @"\" + model.OrdID + @".xml"); Jinsdb.UpdateShippingFlatRX(model.OrdID); } return(rs.Tables[0].Rows.Count); }
public int GetConfirmFiles() { var rs = Jinsdb.GetUnConfirmFiles(); if (rs.Tables[0].Rows.Count <= 0) { return(0); } foreach (DataRow item in rs.Tables[0].Rows) { var _ID = item["ID"].ToString(); var _OrdType = item["OrdType"].ToString(); var _OrdHdID = item["OrdHdID"].ToString(); var _OrdID = item["OrdID"].ToString(); var _F_Reject = item["F_Reject"].ToString().GetBoolStr(); JinsPub.OrdID = _OrdID; OrdMain model = new OrdMain() { ID = _ID, OrdID = _OrdID, OrdHdID = _OrdHdID, OrdType = _OrdType, F_Reject = _F_Reject }; if (model.OrdType.ToLower() != "rx") { model.SubST = new List <OrdST>(); var rsdetail = Jinsdb.GetOrdDetail(model.ID); foreach (DataRow item2 in rsdetail.Tables[0].Rows) { var subid = item2["SubID"].ToString().GetIntFromStr(); var opc = item2["OPC"].ToString(); var qty = item2["Qty"].ToString().GetIntFromStr(); model.SubST.Add(new OrdST() { ID = model.ID, SubID = subid, OPC = opc, Qty = qty }); } } var xmldoc = Jinsxml.CreateConfirmXMLFile(model); xmldoc.Save(localFolder_confirm + @"\" + model.OrdID + @".xml"); Jinsdb.UpdateConfirmFlat(model.OrdID); } return(rs.Tables[0].Rows.Count); }
public int ConvertXMLFile() { DirectoryInfo folder = new DirectoryInfo(localFolder_order); FileInfo[] fileList = null; string fileName = ""; var count = 0; fileList = folder.GetFiles("*.xml"); if (fileList.Count() <= 0) { return(0); } foreach (FileInfo fi in fileList) { fileName = fi.Name; JinsPub.OrdID = fileName.Substring(0, fileName.LastIndexOf(".")); var fullPath = localFolder_order + @"\" + fileName; OrdMain model = Jinsxml.ConvertXMLtoOrdModel(fullPath); if (Jinsdb.CheckOrdReject(model.OrdID)) { fi.Delete(); continue; } Jinsdb.DeleteOrdErr(model.OrdID); try { Jinsdb.AddOrd(model); fi.Delete(); } catch (Exception ex) { OrdMain modelErr = new OrdMain() { Address1 = "", Created = DateTime.Now, ECode = "", OrdHdID = model.OrdHdID, Postal = "", SalesOfficeCode = "", SalesOfficeName = "", OrdType = model.OrdType, OrdID = model.OrdID, Tel = "", Memo = "Err", Procurement_Type = "", }; modelErr.SubZ = new OrdZ() { BillCode = model.OrdID, Remark = ex.Message, BillDate = model.Created, BillType = "", ConsignDate = model.Created, CusCode = "", ML = "", MR = "", Notes = "", OBillCode = "", QtyL = 0, QtyR = 0, SumQty = 0 }; modelErr.SubConet = new OrdConet() { BCode1 = model.OrdID, BCode2 = "*轉換錯誤請參考備註信息*", F_Confirm = false, F_Read = false, F_Reject = false, F_Shipping = 0, F_Err_Convert = true }; switch (ex.Message) { case "RX001": modelErr.SubConet.BCode2 = "已拒絕[自動標記]"; modelErr.SubConet.F_Read = true; modelErr.SubConet.F_Reject = true; modelErr.SubZ.Remark = "鏡片資料缺失"; break; default: break; } // Jinsdb.AddOrdErr(modelErr); // switch (ex.Message) { case "RX001": fi.Delete(); break; default: break; } } count++; } return(count); }