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);
}
private void t1_Elapsed(object source, ElapsedEventArgs e)
{
try
{
RunGetXMLFiles();
}
catch (Exception ex)
{
Default.html += DateTime.Now.ToShortDateString() + " " + DateTime.Now.ToLongTimeString() + "[Getting]" + ex.Message + "<br />";
Jinsdb.AddLog(ex.Message);
}
}
void t4_Elapsed(object sender, ElapsedEventArgs e)
{
try
{
RunConvertXMLFiles();
}
catch (Exception ex)
{
Default.html += DateTime.Now.ToShortDateString() + " " + DateTime.Now.ToLongTimeString() + "[Convert]" + ex.Message + "<br />";
Jinsdb.AddLog(ex.Message);
}
}
void t3_Elapsed(object sender, ElapsedEventArgs e)
{
try
{
RunGetShippingXMLFiles();
RunUploadShippingXMLFiles();
}
catch (Exception ex)
{
Default.html += DateTime.Now.ToShortDateString() + " " + DateTime.Now.ToLongTimeString() + "[Shipping]" + ex.Message + "<br />";
Jinsdb.AddLog(ex.Message);
}
}
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 static OrdMain ConvertXMLtoOrdModel(string xmlPath)
{
OrdMain model = new OrdMain();
var file = xmlPath.Substring(xmlPath.LastIndexOf("\\") + 1);
model.OrdID = file.Substring(0, file.LastIndexOf("."));
model.ID = "";
try
{
using (XmlReader _XReader = XmlReader.Create(xmlPath))
{
XElement _XElement = XElement.Load(_XReader);
model.OrdHdID = _XElement.Element("purchase_order_header_id").Value;
model.OrdType = _XElement.Element("po_type_id").Value;
model.Address1 = _XElement.Element("address").Value;
model.Postal = _XElement.Element("postal").Value;
model.Tel = _XElement.Element("telephone").Value;
model.Memo = _XElement.Element("memorandum").Value;
var t = _XElement.Element("created").Value;
try { model.Created = Convert.ToDateTime(t); }
catch { model.Created = DateTime.Now; }
model.SalesOfficeCode = _XElement.Element("salesOfficeCode").Value;
model.SalesOfficeName = _XElement.Element("salesOfficeName").Value;
try { model.Procurement_Type = _XElement.Element("procurement_type").Value; }
catch { model.Procurement_Type = ""; }
//
switch (model.OrdType)
{
case "rx":
model.SubRX = new OrdRX();
var modelrx = model.SubRX;
var _detail = _XElement.Elements("detail").FirstOrDefault();
//
modelrx.SpecialRight1 = _detail.Element("specialright1").Value;
modelrx.SpecialRight2 = _detail.Element("specialright2").Value;
modelrx.SpecialRight3 = _detail.Element("specialright3").Value;
modelrx.SpecialRight4 = _detail.Element("specialright4").Value;
modelrx.SpecialLeft1 = _detail.Element("specialleft1").Value;
modelrx.SpecialLeft2 = _detail.Element("specialleft2").Value;
modelrx.SpecialLeft3 = _detail.Element("specialleft3").Value;
modelrx.SpecialLeft4 = _detail.Element("specialleft4").Value;
//
modelrx.Lens_Type = _detail.Element("lens_type").Value;
modelrx.Tint_Type = _detail.Element("tint_type").Value;
modelrx.Tint = _detail.Element("tint").Value;
modelrx.Polarized = _detail.Element("polarized").Value;
modelrx.Mirrored = _detail.Element("mirrored").Value;
//
modelrx.Oculus_Dexter_Sphere = _detail.Element("oculus_dexter_sphere").Value.GetDecimalStr();
modelrx.Oculus_Sinister_Sphere = _detail.Element("oculus_sinister_sphere").Value.GetDecimalStr();
modelrx.Oculus_Dexter_Cylinder = _detail.Element("oculus_dexter_cylinder").Value.GetDecimalStr();
modelrx.Oculus_Sinister_Cylinder = _detail.Element("oculus_sinister_cylinder").Value.GetDecimalStr();
modelrx.Oculus_Dexter_Axis = _detail.Element("oculus_dexter_axis").Value.GetDecimalStr();
modelrx.Oculus_Sinister_Axis = _detail.Element("oculus_sinister_axis").Value.GetDecimalStr();
modelrx.Oculus_Dexter_Add = _detail.Element("oculus_dexter_add").Value.GetDecimalStr();
modelrx.Oculus_Sinister_Add = _detail.Element("oculus_sinister_add").Value.GetDecimalStr();
//
modelrx.Oculus_Dexter_Diameter = _detail.Element("oculus_dexter_diameter").Value.GetIntFromStr();
modelrx.Oculus_Sinister_Diameter = _detail.Element("oculus_sinister_diameter").Value.GetIntFromStr();
//
modelrx.Oculus_Dexter_Quantity = _detail.Element("oculus_dexter_quantity").Value.GetIntFromStr();
modelrx.Oculus_Sinister_Quantity = _detail.Element("oculus_sinister_quantity").Value.GetIntFromStr();
//new column
try { modelrx.Frame_Code = _detail.Element("frame_code").Value; }
catch { modelrx.Frame_Code = ""; }
try { modelrx.Polishing = _detail.Element("polishing").Value; }
catch { modelrx.Polishing = ""; }
try { modelrx.Oculus_Eye_Point = _detail.Element("oculus_eye_point").Value; }
catch { modelrx.Oculus_Eye_Point = ""; }
try { modelrx.Oculus_Dexter_Pupillary_Distance = _detail.Element("oculus_dexter_pupillary_distance").Value; }
catch { modelrx.Oculus_Dexter_Pupillary_Distance = ""; }
try { modelrx.Oculus_Sinister_Pupillary_Distance = _detail.Element("oculus_sinister_pupillary_distance").Value; }
catch { modelrx.Oculus_Sinister_Pupillary_Distance = ""; }
break;
default:
model.SubST = new List <OrdST>();
var modelst = model.SubST;
OrdST ordst = null;
var details = _XElement.Elements("detail");
foreach (var item in details)
{
ordst = new OrdST()
{
SubID = item.Attribute("id").Value.GetIntFromStr(),
OPC = item.Element("opc").Value,
Qty = item.Element("qty").Value.GetIntFromStr(),
};
modelst.Add(ordst);
}
break;
}
}
//ordz
InitOrdZ(model);
//ordzmain
InitOrdZMain(model);
return(model);
}
catch (Exception ex)
{
Jinsdb.AddLog(ex.Message);
throw;
}
}
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);
}
