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);
}
