string OutputToPDF(string cmd)
{
logger.Debug("OutputToPDF begin");
string sessionDoc = Session["SCHEMA_FILE_NAME"].ToString();
string docCattp = Session["DOC"].ToString().Trim();
XmlCreator xmlCreator = null;
Guid docGuid = Guid.NewGuid();
bool useOuter = true;
if (sessionDoc.StartsWith("Schema_Box_Ship_Label"))
{
xmlCreator = new BoxLabelXmlCreator();
//xmlCreator = new BoxLabelShipmentXmlCreator();
//xmlCreator.LoadData(txtInternalID.Text.Trim());
xmlCreator.LoadData(txtInternalID.Text.Trim() + "/" + lblselect.Text.ToString());
}
else if (sessionDoc.StartsWith("Schema_Pallet_Label_TypeA"))
{
xmlCreator = new PalletAXmlCreator();
//xmlCreator = new PalletAShipmentXmlCreator();
xmlCreator.LoadData(txtInternalID.Text.Trim() + "/" + lblselect.Text.ToString());
}
else if (sessionDoc.StartsWith("Schema_Pallet_Label_TypeB"))
{
//xmlCreator = new PalletBXmlCreator();
xmlCreator = new PalletBShipmentXmlCreator();
xmlCreator.LoadData(txtInternalID.Text.Trim() + "/" + lblselect.Text.ToString());
}
else if (sessionDoc.StartsWith("Schema_Pack_List"))
{
useOuter = false;
//xmlCreator = new PackListXmlCreator();
xmlCreator = new PackListShipmentXmlCreator();
xmlCreator.LoadData(txtInternalID.Text.Trim() + "/" + docCattp.ToString().Trim());
// xmlCreator.LoadData(txtInternalID.Text.Trim());
}
else if (sessionDoc.StartsWith("Schema_Waybill"))
{
/////xmlCreator = new WayBillXmlCreator();
//xmlCreator = new WayBillShipmentXmlCreator();
xmlCreator = new WayBillShipmentXmlCreator();
xmlCreator.LoadData(txtInternalID.Text.Trim());
}
else if (sessionDoc.StartsWith("Schema_HouseWaybills"))
{
xmlCreator = new HouseWaybillsXmlCreator();
xmlCreator.LoadData(txtInternalID.Text.Trim());
}
//---------------------add by lck------------------------------------------------
else if (sessionDoc.StartsWith("Schema_Master_Waybill"))
{
xmlCreator = new MasterWaybillShipmentXmlCreator();
xmlCreator.LoadData(txtInternalID.Text.Trim() + "/" + "xxxxx");
}
//---------------------------------------------------------------------
string docName = ConfigurationManager.AppSettings["FilePath"] + @"\" + docGuid.ToString() + ".xml";
//string docName = Server.MapPath(@"~\Output\" + docGuid.ToString() + ".xml");
xmlCreator.WriteXml(docName, useOuter);
/*
string fopPath = ConfigurationManager.AppSettings["FOPPath"];
FOPWrap.FOP.GeneratePDF(
fopPath,
docName,
Server.MapPath(@"~\XSL\" + Session["XSL"].ToString()),
ConfigurationManager.AppSettings["FilePath"] + @"\" + docGuid.ToString()+".pdf");
//Server.MapPath(@"~\Output\" + docGuid.ToString() + ".pdf"));
//return @"~\Output\" + docGuid.ToString() + ".pdf";
*/
/*
string[] args = new string[] {
// setup config file
"-c", fopCfgXml,
"-xml", docName,
"-xsl", Server.MapPath(@"~\XSL\" + Session["XSL"].ToString()),
"-pdf", ConfigurationManager.AppSettings["FilePath"] + @"\" + docGuid.ToString()+".pdf" };
InvokeFOP(args);
*/
logger.Debug("OutputToPDF InvokeFOP begin xslFile=" + Server.MapPath(@"~\XSL\" + Session["XSL"].ToString()) + " , xmlFile=" + docName + " , pdfFile=" + ConfigurationManager.AppSettings["FilePath"] + @"\" + docGuid.ToString() + ".pdf");
using (localhost.EDITS c = new localhost.EDITS())
{
string errmsg = "";
bool result = c.GenPDF(Server.MapPath(@"~\XSL\" + Session["XSL"].ToString()), docName, ConfigurationManager.AppSettings["FilePath"] + @"\" + docGuid.ToString() + ".pdf", ref errmsg);
}
logger.Debug("OutputToPDF InvokeFOP end");
logger.Debug("OutputToPDF end");
if (cmd=="ViewPDF")
return ConfigurationManager.AppSettings["FileSite"] + docGuid.ToString() + ".pdf";
else
return ConfigurationManager.AppSettings["FilePath"] + @"\" + docGuid.ToString() +".pdf";
}
protected void SNVIEW_SelectedIndexChanged(object sender, EventArgs e)
{
XmlCreator xmlCreator = null;//实例化xmlcreator
bool useOuter = true;
string version = "";
string Pallet_Id = SNVIEW.SelectedRow.Cells[1].Text.ToString().Trim();
string Serial_Num = SNVIEW.SelectedRow.Cells[2].Text.ToString().Trim();
//String value = DOCVIEW.Columns[1];
//string doc = DOCVIEW.Rows[1];
//Response.Write("<script type='text/javascript'>alert('"+ DOCVIEW.Rows[1] +"');</script>");
DataConnLib con1 = new DataConnLib(ConfigurationManager.AppSettings["Database"]);
try
{
string query = "select top 1 (VERSION) from [PAK.PAKRT_Log] nolock order by CREATE_DATE desc";
con1.SqlQueComm(query, "VERSION");
version = con1.Ds.Tables[0].Rows[0][0].ToString().Trim();
}
catch (System.Exception err)
{
System.Windows.Forms.MessageBox.Show(err.Message.ToString());
}
DataConnLib con = new DataConnLib(ConfigurationManager.AppSettings["Database"]);
try
{
string query = "select distinct b.DOC_CAT,b.DOC_SET_NUMBER, b.XSL_TEMPLATE_NAME, a.PO_NUM, b.SCHEMA_FILE_NAME,a.CARTON_QTY from [PAK_PAKComn] a,[PAK.PAKRT] b where a.DOC_SET_NUMBER = b.DOC_SET_NUMBER collate Chinese_Taiwan_Stroke_90_BIN and a.InternalID = '" + BOX_DN.Text.ToString().Trim() + "'";//collate Chinese_Taiwan_Stroke_90_BIN
con.SqlQueComm(query,"DOCTable");
if (con.Ds.Tables.Count > 0)
{
if (con.Ds.Tables[0].Rows.Count > 0)
{
string dateyear = System.DateTime.Now.Year.ToString();
string datemonth = System.DateTime.Now.Month.ToString().Trim();
if (datemonth.Length == 1)
{
datemonth = "0" + datemonth;
}
string dateday = System.DateTime.Now.Day.ToString().Trim();
if (dateday.Length == 1)
{
dateday = "0" + dateday;
}
if (RadioButton_Step1.Checked)
{
Label_Messege.Text = "ZipFileName: Inventec_PRE_MTP_TEST_DATE_" + dateyear + datemonth + dateday + "_EDITS_REVISION_" + dateyear + version;
}
else if (RadioButton_Step2.Checked)
{
Label_Messege.Text = "ZipFileName: Inventec_MTP_TEST_DATE_" + dateyear + datemonth + dateday + "_EDITS_REVISION_" + dateyear + version;
}
else
{
Label_Messege.Text = "ZipFileName: Inventec_PROD_CHECK_DATE_" + dateyear + datemonth + dateday + "_EDITS_REVISION_" + dateyear +version;
}
#region step1&step2
if (RadioButton_Step1.Checked || RadioButton_Step2.Checked)
{
// for (int i = 0; i <= con.Ds.Tables[0].Rows.Count; i++)
for (int i = 0; i < con.Ds.Tables[0].Rows.Count; i++)
{
bool isBsam = false;
if (con.Ds.Tables[0].Rows[i][4].ToString().ToUpper().IndexOf("BSAM") > 0)
isBsam = true;
if (int.Parse(con.Ds.Tables[0].Rows[i][5].ToString()) > 1)
{
if (con.Ds.Tables[0].Rows[i][0].ToString().Trim() == "Box Ship Label_Tablet_MRP")
{
useOuter = true;
string filename_XML = DropDownList_ID.Text + "_" + con.Ds.Tables[0].Rows[i][1].ToString() + "_" + con.Ds.Tables[0].Rows[i][3].ToString() + "_" + con.Ds.Tables[0].Rows[i][2].ToString().Replace(".xslt", ".xml");
string filename_PDF = DropDownList_ID.Text + "_" + con.Ds.Tables[0].Rows[i][1].ToString() + "_" + con.Ds.Tables[0].Rows[i][3].ToString() + "_" + con.Ds.Tables[0].Rows[i][2].ToString().Replace(".xslt", ".pdf");
string filename_FO = DropDownList_ID.Text + "_" + con.Ds.Tables[0].Rows[i][1].ToString() + "_" + con.Ds.Tables[0].Rows[i][3].ToString() + "_" + con.Ds.Tables[0].Rows[i][2].ToString().Replace(".xslt", ".fo");
xmlCreator = new BoxShipmentMRPXMLCreator();
xmlCreator.LoadData(BOX_DN.Text.Trim() + "/" + Serial_Num + "/" + "M" + Serial_Num);
string docName_XML = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_XML;
xmlCreator.WriteXml(docName_XML, useOuter);
string docName_PDF = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_PDF;
string docName_FO = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_FO;
string fopPath = ConfigurationManager.AppSettings["FOPPath"];
//FOPWrap.FOP.GeneratePDF(
// fopPath,
// docName_XML,
// Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()),
// docName_PDF);
//FOPWrap.FOP.GenerateFo(
// fopPath,
// docName_XML,
// Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()),
// docName_FO);
DoGenFile(PDF, Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()), docName_XML, docName_PDF);
DoGenFile(FO, Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()), docName_XML, docName_FO);
}
else if (con.Ds.Tables[0].Rows[i][0].ToString().Trim() == "Box Ship Label_Tablet_Wholesale")
{
useOuter = true;
string filename_XML = DropDownList_ID.Text + "_" + con.Ds.Tables[0].Rows[i][1].ToString() + "_" + con.Ds.Tables[0].Rows[i][3].ToString() + "_" + con.Ds.Tables[0].Rows[i][2].ToString().Replace(".xslt", ".xml");
string filename_PDF = DropDownList_ID.Text + "_" + con.Ds.Tables[0].Rows[i][1].ToString() + "_" + con.Ds.Tables[0].Rows[i][3].ToString() + "_" + con.Ds.Tables[0].Rows[i][2].ToString().Replace(".xslt", ".pdf");
string filename_FO = DropDownList_ID.Text + "_" + con.Ds.Tables[0].Rows[i][1].ToString() + "_" + con.Ds.Tables[0].Rows[i][3].ToString() + "_" + con.Ds.Tables[0].Rows[i][2].ToString().Replace(".xslt", ".fo");
xmlCreator = new BoxLabelShipmentXmlCreator();
xmlCreator.LoadData(BOX_DN.Text.Trim() + "/" + Serial_Num);
string docName_XML = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_XML;
xmlCreator.WriteXml(docName_XML, useOuter);
string docName_PDF = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_PDF;
string docName_FO = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_FO;
string fopPath = ConfigurationManager.AppSettings["FOPPath"];
//FOPWrap.FOP.GeneratePDF(
// fopPath,
// docName_XML,
// Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()),
// docName_PDF);
//FOPWrap.FOP.GenerateFo(
// fopPath,
// docName_XML,
// Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()),
// docName_FO);
DoGenFile(PDF, Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()), docName_XML, docName_PDF);
DoGenFile(FO, Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()), docName_XML, docName_FO);
}
else if (con.Ds.Tables[0].Rows[i][0].ToString().Trim() == "Box Ship Label" && isBsam)
{
useOuter = true;
string filename_XML = DropDownList_ID.Text + "_" + con.Ds.Tables[0].Rows[i][1].ToString() + "_" + con.Ds.Tables[0].Rows[i][3].ToString() + "_" + con.Ds.Tables[0].Rows[i][2].ToString().Replace(".xslt", ".xml");
string filename_PDF = DropDownList_ID.Text + "_" + con.Ds.Tables[0].Rows[i][1].ToString() + "_" + con.Ds.Tables[0].Rows[i][3].ToString() + "_" + con.Ds.Tables[0].Rows[i][2].ToString().Replace(".xslt", ".pdf");
string filename_FO = DropDownList_ID.Text + "_" + con.Ds.Tables[0].Rows[i][1].ToString() + "_" + con.Ds.Tables[0].Rows[i][3].ToString() + "_" + con.Ds.Tables[0].Rows[i][2].ToString().Replace(".xslt", ".fo");
xmlCreator = new BoxLabelShipmentXmlCreator();
xmlCreator.LoadData(BOX_DN.Text.Trim() + "/" + Serial_Num);
string docName_XML = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_XML;
xmlCreator.WriteXml(docName_XML, useOuter);
string docName_PDF = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_PDF;
string docName_FO = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_FO;
string fopPath = ConfigurationManager.AppSettings["FOPPath"];
//FOPWrap.FOP.GeneratePDF(
// fopPath,
// docName_XML,
// Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()),
// docName_PDF);
//FOPWrap.FOP.GenerateFo(
// fopPath,
// docName_XML,
// Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()),
// docName_FO);
DoGenFile(PDF, Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()), docName_XML, docName_PDF);
DoGenFile(FO, Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()), docName_XML, docName_FO);
}
}
else
{
if (con.Ds.Tables[0].Rows[i][0].ToString().Trim() == "Box Ship Label_Single Pack")
{
useOuter = true;
string filename_XML = DropDownList_ID.Text + "_" + con.Ds.Tables[0].Rows[i][1].ToString() + "_" + con.Ds.Tables[0].Rows[i][3].ToString() + "_" + con.Ds.Tables[0].Rows[i][2].ToString().Replace(".xslt", ".xml");
string filename_PDF = DropDownList_ID.Text + "_" + con.Ds.Tables[0].Rows[i][1].ToString() + "_" + con.Ds.Tables[0].Rows[i][3].ToString() + "_" + con.Ds.Tables[0].Rows[i][2].ToString().Replace(".xslt", ".pdf");
string filename_FO = DropDownList_ID.Text + "_" + con.Ds.Tables[0].Rows[i][1].ToString() + "_" + con.Ds.Tables[0].Rows[i][3].ToString() + "_" + con.Ds.Tables[0].Rows[i][2].ToString().Replace(".xslt", ".fo");
xmlCreator = new BoxLabelShipmentXmlCreator();
xmlCreator.LoadData(BOX_DN.Text.Trim() + "/" + Serial_Num);
string docName_XML = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_XML;
xmlCreator.WriteXml(docName_XML, useOuter);
string docName_PDF = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_PDF;
string docName_FO = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_FO;
string fopPath = ConfigurationManager.AppSettings["FOPPath"];
//FOPWrap.FOP.GeneratePDF(
// fopPath,
// docName_XML,
// Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()),
// docName_PDF);
//FOPWrap.FOP.GenerateFo(
// fopPath,
// docName_XML,
// Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()),
// docName_FO);
DoGenFile(PDF, Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()), docName_XML, docName_PDF);
DoGenFile(FO, Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()), docName_XML, docName_FO);
}
else if (con.Ds.Tables[0].Rows[i][0].ToString().Trim() == "Box Ship Label")
{
useOuter = true;
string filename_XML = DropDownList_ID.Text + "_" + con.Ds.Tables[0].Rows[i][1].ToString() + "_" + con.Ds.Tables[0].Rows[i][3].ToString() + "_" + con.Ds.Tables[0].Rows[i][2].ToString().Replace(".xslt", ".xml");
string filename_PDF = DropDownList_ID.Text + "_" + con.Ds.Tables[0].Rows[i][1].ToString() + "_" + con.Ds.Tables[0].Rows[i][3].ToString() + "_" + con.Ds.Tables[0].Rows[i][2].ToString().Replace(".xslt", ".pdf");
string filename_FO = DropDownList_ID.Text + "_" + con.Ds.Tables[0].Rows[i][1].ToString() + "_" + con.Ds.Tables[0].Rows[i][3].ToString() + "_" + con.Ds.Tables[0].Rows[i][2].ToString().Replace(".xslt", ".fo");
xmlCreator = new BoxLabelShipmentXmlCreator();
xmlCreator.LoadData(BOX_DN.Text.Trim() + "/" + Serial_Num);
string docName_XML = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_XML;
xmlCreator.WriteXml(docName_XML, useOuter);
string docName_PDF = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_PDF;
string docName_FO = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_FO;
string fopPath = ConfigurationManager.AppSettings["FOPPath"];
//FOPWrap.FOP.GeneratePDF(
// fopPath,
// docName_XML,
// Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()),
// docName_PDF);
//FOPWrap.FOP.GenerateFo(
// fopPath,
// docName_XML,
// Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()),
// docName_FO);
DoGenFile(PDF, Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()), docName_XML, docName_PDF);
DoGenFile(FO, Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()), docName_XML, docName_FO);
}
#region mark
/*
else if (con.Ds.Tables[0].Rows[i][0].ToString().Trim() == "Box Ship Label_Tablet_MRP")
{
useOuter = true;
string filename_XML = DropDownList_ID.Text + "_" + con.Ds.Tables[0].Rows[i][1].ToString() + "_" + con.Ds.Tables[0].Rows[i][3].ToString() + "_" + con.Ds.Tables[0].Rows[i][2].ToString().Replace(".xslt", ".xml");
string filename_PDF = DropDownList_ID.Text + "_" + con.Ds.Tables[0].Rows[i][1].ToString() + "_" + con.Ds.Tables[0].Rows[i][3].ToString() + "_" + con.Ds.Tables[0].Rows[i][2].ToString().Replace(".xslt", ".pdf");
string filename_FO = DropDownList_ID.Text + "_" + con.Ds.Tables[0].Rows[i][1].ToString() + "_" + con.Ds.Tables[0].Rows[i][3].ToString() + "_" + con.Ds.Tables[0].Rows[i][2].ToString().Replace(".xslt", ".fo");
xmlCreator = new BoxShipmentMRPXMLCreator();
xmlCreator.LoadData(BOX_DN.Text.Trim() + "/" + Serial_Num + "/" + "M" + Serial_Num);
string docName_XML = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_XML;
xmlCreator.WriteXml(docName_XML, useOuter);
string docName_PDF = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_PDF;
string docName_FO = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_FO;
string fopPath = ConfigurationManager.AppSettings["FOPPath"];
//FOPWrap.FOP.GeneratePDF(
// fopPath,
// docName_XML,
// Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()),
// docName_PDF);
//FOPWrap.FOP.GenerateFo(
// fopPath,
// docName_XML,
// Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()),
// docName_FO);
DoGenFile(PDF, Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()), docName_XML, docName_PDF);
DoGenFile(FO, Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()), docName_XML, docName_FO);
}
else if (con.Ds.Tables[0].Rows[i][0].ToString().Trim() == "Box Ship Label_Tablet_Wholesale")
{
useOuter = true;
string filename_XML = DropDownList_ID.Text + "_" + con.Ds.Tables[0].Rows[i][1].ToString() + "_" + con.Ds.Tables[0].Rows[i][3].ToString() + "_" + con.Ds.Tables[0].Rows[i][2].ToString().Replace(".xslt", ".xml");
string filename_PDF = DropDownList_ID.Text + "_" + con.Ds.Tables[0].Rows[i][1].ToString() + "_" + con.Ds.Tables[0].Rows[i][3].ToString() + "_" + con.Ds.Tables[0].Rows[i][2].ToString().Replace(".xslt", ".pdf");
string filename_FO = DropDownList_ID.Text + "_" + con.Ds.Tables[0].Rows[i][1].ToString() + "_" + con.Ds.Tables[0].Rows[i][3].ToString() + "_" + con.Ds.Tables[0].Rows[i][2].ToString().Replace(".xslt", ".fo");
xmlCreator = new BoxLabelShipmentXmlCreator();
xmlCreator.LoadData(BOX_DN.Text.Trim() + "/" + Serial_Num);
string docName_XML = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_XML;
xmlCreator.WriteXml(docName_XML, useOuter);
string docName_PDF = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_PDF;
string docName_FO = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_FO;
string fopPath = ConfigurationManager.AppSettings["FOPPath"];
//FOPWrap.FOP.GeneratePDF(
// fopPath,
// docName_XML,
// Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()),
// docName_PDF);
//FOPWrap.FOP.GenerateFo(
// fopPath,
// docName_XML,
// Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()),
// docName_FO);
DoGenFile(PDF, Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()), docName_XML, docName_PDF);
DoGenFile(FO, Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()), docName_XML, docName_FO);
}
**/
#endregion
}
if (con.Ds.Tables[0].Rows[i][0].ToString().Trim() == "Pallet Ship Label- Pack ID Single")
{
useOuter = true;
//////if (Pallet_Id.Substring(0,2).ToString() == "NA" || Pallet_Id.Substring(0,2).ToString() == "BA")
//////{
////// continue;
//////}
string filename_XML = DropDownList_ID.Text + "_" + con.Ds.Tables[0].Rows[i][1].ToString() + "_" + con.Ds.Tables[0].Rows[i][3].ToString() + "_" + con.Ds.Tables[0].Rows[i][2].ToString().Replace(".xslt", ".xml");
string filename_PDF = DropDownList_ID.Text + "_" + con.Ds.Tables[0].Rows[i][1].ToString() + "_" + con.Ds.Tables[0].Rows[i][3].ToString() + "_" + con.Ds.Tables[0].Rows[i][2].ToString().Replace(".xslt", ".pdf");
string filename_FO = DropDownList_ID.Text + "_" + con.Ds.Tables[0].Rows[i][1].ToString() + "_" + con.Ds.Tables[0].Rows[i][3].ToString() + "_" + con.Ds.Tables[0].Rows[i][2].ToString().Replace(".xslt", ".fo");
if (filename_XML.IndexOf("TypeA") != -1)
{
xmlCreator = new PalletAShipmentXmlCreator();
}
else
{
if (isBsam)
xmlCreator = new PalletBShipmentBsamXmlCreator();
else
xmlCreator = new PalletBShipmentXmlCreator();
}
xmlCreator.LoadData(BOX_DN.Text.Trim() + "/" + Pallet_Id);
string docName_XML = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_XML;
xmlCreator.WriteXml(docName_XML, useOuter);
string docName_PDF = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_PDF;
string docName_FO = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_FO;
string fopPath = ConfigurationManager.AppSettings["FOPPath"];
//FOPWrap.FOP.GeneratePDF(
// fopPath,
// docName_XML,
// Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()),
// docName_PDF);
//FOPWrap.FOP.GenerateFo(
// fopPath,
// docName_XML,
// Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()),
// docName_FO);
DoGenFile(PDF, Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()), docName_XML, docName_PDF);
DoGenFile(FO, Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()), docName_XML, docName_FO);
}
else if (con.Ds.Tables[0].Rows[i][0].ToString().Trim() == "Pack List- Transportation")
{
useOuter = false;
string filename_XML = DropDownList_ID.Text + "_" + con.Ds.Tables[0].Rows[i][1].ToString() + "_" + con.Ds.Tables[0].Rows[i][3].ToString() + "_" + con.Ds.Tables[0].Rows[i][2].ToString().Replace(".xslt", ".xml");
string filename_PDF = DropDownList_ID.Text + "_" + con.Ds.Tables[0].Rows[i][1].ToString() + "_" + con.Ds.Tables[0].Rows[i][3].ToString() + "_" + con.Ds.Tables[0].Rows[i][2].ToString().Replace(".xslt", ".pdf");
string filename_FO = DropDownList_ID.Text + "_" + con.Ds.Tables[0].Rows[i][1].ToString() + "_" + con.Ds.Tables[0].Rows[i][3].ToString() + "_" + con.Ds.Tables[0].Rows[i][2].ToString().Replace(".xslt", ".fo");
#region Modify by 20130312
//xmlCreator = new PackListShipmentXmlCreator();
if (con.Ds.Tables[0].Rows[i][2].ToString().Contains("Rail"))
{
useOuter = true;
//xmlCreator = new MasterWaybillShipmentXmlCreator();
xmlCreator = new MasterWaybillShipmentXmlCreator();
}
else
{
xmlCreator = new PackListShipmentXmlCreator();
}
#endregion
xmlCreator.LoadData(BOX_DN.Text.Trim() + "/Pack List- Transportation");
string docName_XML = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_XML;
xmlCreator.WriteXml(docName_XML, useOuter);
string docName_PDF = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_PDF;
string docName_FO = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_FO;
string fopPath = ConfigurationManager.AppSettings["FOPPath"];
//FOPWrap.FOP.GeneratePDF(
// fopPath,
// docName_XML,
// Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()),
// docName_PDF);
//FOPWrap.FOP.GenerateFo(
// fopPath,
// docName_XML,
// Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()),
// docName_FO);
///*
DoGenFile(PDF, Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()), docName_XML, docName_PDF);
DoGenFile(FO, Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()), docName_XML, docName_FO);
//*/
}
else if (con.Ds.Tables[0].Rows[i][0].ToString().Trim() == "Pack List- Shipment")
{
useOuter = false;
string filename_XML = DropDownList_ID.Text + "_" + con.Ds.Tables[0].Rows[i][1].ToString() + "_" + con.Ds.Tables[0].Rows[i][3].ToString() + "_" + con.Ds.Tables[0].Rows[i][2].ToString().Replace(".xslt", ".xml");
string filename_PDF = DropDownList_ID.Text + "_" + con.Ds.Tables[0].Rows[i][1].ToString() + "_" + con.Ds.Tables[0].Rows[i][3].ToString() + "_" + con.Ds.Tables[0].Rows[i][2].ToString().Replace(".xslt", ".pdf");
string filename_FO = DropDownList_ID.Text + "_" + con.Ds.Tables[0].Rows[i][1].ToString() + "_" + con.Ds.Tables[0].Rows[i][3].ToString() + "_" + con.Ds.Tables[0].Rows[i][2].ToString().Replace(".xslt", ".fo");
string docName_XML = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_XML;
if (isBsam)
{
xmlCreator = new HouseWaybillsXmlCreator();
xmlCreator.LoadData(BOX_DN.Text.Trim());
xmlCreator.WriteXml(docName_XML, true);
}
else if (con.Ds.Tables[0].Rows[i][2].ToString().Contains("QVC")) //add for QVC 201305
{
xmlCreator = new PackListShipmentXmlCreator_QVC();
//string docName_XML = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_XML;
xmlCreator.LoadData(BOX_DN.Text.Trim() + "/Pack List- Shipment", docName_XML);
}
else
{
if (con.Ds.Tables[0].Rows[i][2].ToString().Contains("Rail"))
{
useOuter = true;
//xmlCreator = new MasterWaybillShipmentXmlCreator();
xmlCreator = new MasterWaybillShipmentXmlCreator();
}
else
{
xmlCreator = new PackListShipmentXmlCreator();
}
xmlCreator.LoadData(BOX_DN.Text.Trim() + "/Pack List- Shipment");
//string docName_XML = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_XML;
xmlCreator.WriteXml(docName_XML, useOuter);
}
string docName_PDF = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_PDF;
string docName_FO = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_FO;
string fopPath = ConfigurationManager.AppSettings["FOPPath"];
//FOPWrap.FOP.GeneratePDF(
// fopPath,
// docName_XML,
// Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()),
// docName_PDF);
//FOPWrap.FOP.GenerateFo(
// fopPath,
// docName_XML,
// Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()),
// docName_FO);
///*
DoGenFile(PDF, Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()), docName_XML, docName_PDF);
DoGenFile(FO, Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()), docName_XML, docName_FO);
//*/
}
else if (con.Ds.Tables[0].Rows[i][0].ToString().Trim() == "Pack List- Addition")
{
useOuter = false;
string filename_XML = DropDownList_ID.Text + "_" + con.Ds.Tables[0].Rows[i][1].ToString() + "_" + con.Ds.Tables[0].Rows[i][3].ToString() + "_" + con.Ds.Tables[0].Rows[i][2].ToString().Replace(".xslt", ".xml");
string filename_PDF = DropDownList_ID.Text + "_" + con.Ds.Tables[0].Rows[i][1].ToString() + "_" + con.Ds.Tables[0].Rows[i][3].ToString() + "_" + con.Ds.Tables[0].Rows[i][2].ToString().Replace(".xslt", ".pdf");
string filename_FO = DropDownList_ID.Text + "_" + con.Ds.Tables[0].Rows[i][1].ToString() + "_" + con.Ds.Tables[0].Rows[i][3].ToString() + "_" + con.Ds.Tables[0].Rows[i][2].ToString().Replace(".xslt", ".fo");
xmlCreator = new PackListShipmentXmlCreator();
xmlCreator.LoadData(BOX_DN.Text.Trim() + "/Pack List- Addition");
string docName_XML = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_XML;
xmlCreator.WriteXml(docName_XML, useOuter);
string docName_PDF = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_PDF;
string docName_FO = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_FO;
string fopPath = ConfigurationManager.AppSettings["FOPPath"];
//FOPWrap.FOP.GeneratePDF(
// fopPath,
// docName_XML,
// Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()),
// docName_PDF);
//FOPWrap.FOP.GenerateFo(
// fopPath,
// docName_XML,
// Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()),
// docName_FO);
///*
DoGenFile(PDF, Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()), docName_XML, docName_PDF);
DoGenFile(FO, Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()), docName_XML, docName_FO);
//*/
}
else if (con.Ds.Tables[0].Rows[i][0].ToString().Trim() == "Waybill- Addition")
{
useOuter = true;
string filename_XML = DropDownList_ID.Text + "_" + con.Ds.Tables[0].Rows[i][1].ToString() + "_" + con.Ds.Tables[0].Rows[i][3].ToString() + "_" + con.Ds.Tables[0].Rows[i][2].ToString().Replace(".xslt", ".xml");
string filename_PDF = DropDownList_ID.Text + "_" + con.Ds.Tables[0].Rows[i][1].ToString() + "_" + con.Ds.Tables[0].Rows[i][3].ToString() + "_" + con.Ds.Tables[0].Rows[i][2].ToString().Replace(".xslt", ".pdf");
string filename_FO = DropDownList_ID.Text + "_" + con.Ds.Tables[0].Rows[i][1].ToString() + "_" + con.Ds.Tables[0].Rows[i][3].ToString() + "_" + con.Ds.Tables[0].Rows[i][2].ToString().Replace(".xslt", ".fo");
//xmlCreator = new WayBillShipmentXmlCreator();
xmlCreator = new WayBillShipmentXmlCreator();
xmlCreator.LoadData(BOX_DN.Text.Trim());
string docName_XML = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_XML;
xmlCreator.WriteXml(docName_XML, useOuter);
string docName_PDF = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_PDF;
string docName_FO = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_FO;
string fopPath = ConfigurationManager.AppSettings["FOPPath"];
//FOPWrap.FOP.GeneratePDF(
// fopPath,
// docName_XML,
// Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()),
// docName_PDF);
//FOPWrap.FOP.GenerateFo(
// fopPath,
// docName_XML,
// Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()),
// docName_FO);
///*
DoGenFile(PDF, Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()), docName_XML, docName_PDF);
DoGenFile(FO, Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()), docName_XML, docName_FO);
//*/
}
else if (con.Ds.Tables[0].Rows[i][0].ToString().Trim() == "POS")
{
useOuter = false;
string filename_XML = DropDownList_ID.Text + "_" + con.Ds.Tables[0].Rows[i][1].ToString() + "_" + con.Ds.Tables[0].Rows[i][3].ToString() + "_" + con.Ds.Tables[0].Rows[i][2].ToString().Replace(".xslt", ".xml");
string filename_PDF = DropDownList_ID.Text + "_" + con.Ds.Tables[0].Rows[i][1].ToString() + "_" + con.Ds.Tables[0].Rows[i][3].ToString() + "_" + con.Ds.Tables[0].Rows[i][2].ToString().Replace(".xslt", ".pdf");
string filename_FO = DropDownList_ID.Text + "_" + con.Ds.Tables[0].Rows[i][1].ToString() + "_" + con.Ds.Tables[0].Rows[i][3].ToString() + "_" + con.Ds.Tables[0].Rows[i][2].ToString().Replace(".xslt", ".fo");
//xmlCreator = new WayBillShipmentXmlCreator();
string query_step3 = "select a.TruckID,[Date] from HPIMES.dbo.Forwarder a,HPIMES.dbo.MAWB b where a.MAWB=b.MAWB or a.MAWB=b.HAWB and b.Delivery= '" + BOX_DN.Text.ToString().Trim() + "'";//collate Chinese_Taiwan_Stroke_90_BIN
con.SqlQueComm(query_step3, "Truck");
if (con.Ds.Tables["Truck"].Rows.Count < 1)
{
Exception ex = new Exception("NO MAWB Or Forwarder Data!");
throw ex;
}
xmlCreator = new POSXmlCreator();
string TruckInfo = "";
TruckInfo = con.Ds.Tables["Truck"].Rows[0][0] + @"@" + con.Ds.Tables["Truck"].Rows[0][1];
xmlCreator.LoadData(TruckInfo);
string docName_XML = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_XML;
xmlCreator.WriteXml(docName_XML, useOuter);
string docName_PDF = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_PDF;
string docName_FO = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_FO;
string fopPath = ConfigurationManager.AppSettings["FOPPath"];
//FOPWrap.FOP.GeneratePDF(
// fopPath,
// docName_XML,
// Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()),
// docName_PDF);
//FOPWrap.FOP.GenerateFo(
// fopPath,
// docName_XML,
// Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()),
// docName_FO);
///*
DoGenFile(PDF, Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()), docName_XML, docName_PDF);
DoGenFile(FO, Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()), docName_XML, docName_FO);
//*/
}
}
}
#endregion
#region step3
else if (RadioButton_Step3.Checked)
{
//for (int i = 0; i <= con.Ds.Tables[0].Rows.Count; i++)
for (int i = 0; i < con.Ds.Tables[0].Rows.Count; i++)
{
bool isBsam = false;
if (con.Ds.Tables[0].Rows[i][4].ToString().ToUpper().IndexOf("BSAM") > 0)
isBsam = true;
if (int.Parse(con.Ds.Tables[0].Rows[i][5].ToString()) > 1)
{
//if (con.Ds.Tables[0].Rows[i][0].ToString().Trim() == "Box Ship Label_Over Pack_Gift Box")
if (con.Ds.Tables[0].Rows[i][0].ToString().Trim() == "Box Ship Label_Tablet_MRP")
{
useOuter = true;
string filename_XML = "PC_" + con.Ds.Tables[0].Rows[i][1].ToString() + "_" + con.Ds.Tables[0].Rows[i][3].ToString() + "_" + con.Ds.Tables[0].Rows[i][2].ToString().Replace(".xslt", ".xml");
string filename_PDF = "PC_" + con.Ds.Tables[0].Rows[i][1].ToString() + "_" + con.Ds.Tables[0].Rows[i][3].ToString() + "_" + con.Ds.Tables[0].Rows[i][2].ToString().Replace(".xslt", ".pdf");
string filename_FO = "PC_" + con.Ds.Tables[0].Rows[i][1].ToString() + "_" + con.Ds.Tables[0].Rows[i][3].ToString() + "_" + con.Ds.Tables[0].Rows[i][2].ToString().Replace(".xslt", ".fo");
xmlCreator = new BoxShipmentMRPXMLCreator();
xmlCreator.LoadData(BOX_DN.Text.Trim() + "/" + Serial_Num + "/" + "M" + Serial_Num);
string docName_XML = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_XML;
xmlCreator.WriteXml(docName_XML, useOuter);
string docName_PDF = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_PDF;
string docName_FO = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_FO;
string fopPath = ConfigurationManager.AppSettings["FOPPath"];
//FOPWrap.FOP.GeneratePDF(
// fopPath,
// docName_XML,
// Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()),
// docName_PDF);
//FOPWrap.FOP.GenerateFo(
// fopPath,
// docName_XML,
// Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()),
// docName_FO);
DoGenFile(PDF, Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()), docName_XML, docName_PDF);
DoGenFile(FO, Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()), docName_XML, docName_FO);
}
// else if (con.Ds.Tables[0].Rows[i][0].ToString().Trim() == "Box Ship Label_Over Pack_Wholesale")
else if (con.Ds.Tables[0].Rows[i][0].ToString().Trim() == "Box Ship Label_Tablet_Wholesale")
{
useOuter = true;
string filename_XML = "PC_" + con.Ds.Tables[0].Rows[i][1].ToString() + "_" + con.Ds.Tables[0].Rows[i][3].ToString() + "_" + con.Ds.Tables[0].Rows[i][2].ToString().Replace(".xslt", ".xml");
string filename_PDF = "PC_" + con.Ds.Tables[0].Rows[i][1].ToString() + "_" + con.Ds.Tables[0].Rows[i][3].ToString() + "_" + con.Ds.Tables[0].Rows[i][2].ToString().Replace(".xslt", ".pdf");
string filename_FO = "PC_" + con.Ds.Tables[0].Rows[i][1].ToString() + "_" + con.Ds.Tables[0].Rows[i][3].ToString() + "_" + con.Ds.Tables[0].Rows[i][2].ToString().Replace(".xslt", ".fo");
xmlCreator = new BoxLabelShipmentXmlCreator();
xmlCreator.LoadData(BOX_DN.Text.Trim() + "/" + Serial_Num);
string docName_XML = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_XML;
xmlCreator.WriteXml(docName_XML, useOuter);
string docName_PDF = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_PDF;
string docName_FO = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_FO;
string fopPath = ConfigurationManager.AppSettings["FOPPath"];
//FOPWrap.FOP.GeneratePDF(
// fopPath,
// docName_XML,
// Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()),
// docName_PDF);
//FOPWrap.FOP.GenerateFo(
// fopPath,
// docName_XML,
// Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()),
// docName_FO);
DoGenFile(PDF, Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()), docName_XML, docName_PDF);
DoGenFile(FO, Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()), docName_XML, docName_FO);
}
if (con.Ds.Tables[0].Rows[i][0].ToString().Trim() == "Box Ship Label"&&isBsam)
{
useOuter = true;
string filename_XML = "PC_" + con.Ds.Tables[0].Rows[i][1].ToString() + "_" + con.Ds.Tables[0].Rows[i][3].ToString() + "_" + con.Ds.Tables[0].Rows[i][2].ToString().Replace(".xslt", ".xml");
string filename_PDF = "PC_" + con.Ds.Tables[0].Rows[i][1].ToString() + "_" + con.Ds.Tables[0].Rows[i][3].ToString() + "_" + con.Ds.Tables[0].Rows[i][2].ToString().Replace(".xslt", ".pdf");
string filename_FO = "PC_" + con.Ds.Tables[0].Rows[i][1].ToString() + "_" + con.Ds.Tables[0].Rows[i][3].ToString() + "_" + con.Ds.Tables[0].Rows[i][2].ToString().Replace(".xslt", ".fo");
xmlCreator = new BoxLabelShipmentXmlCreator();
xmlCreator.LoadData(BOX_DN.Text.Trim() + "/" + Serial_Num);
string docName_XML = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_XML;
xmlCreator.WriteXml(docName_XML, useOuter);
string docName_PDF = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_PDF;
string docName_FO = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_FO;
string fopPath = ConfigurationManager.AppSettings["FOPPath"];
//FOPWrap.FOP.GeneratePDF(
// fopPath,
// docName_XML,
// Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()),
// docName_PDF);
//FOPWrap.FOP.GenerateFo(
// fopPath,
// docName_XML,
// Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()),
// docName_FO);
DoGenFile(PDF, Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()), docName_XML, docName_PDF);
DoGenFile(FO, Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()), docName_XML, docName_FO);
}
}
else
{
if (con.Ds.Tables[0].Rows[i][0].ToString().Trim() == "Box Ship Label" || con.Ds.Tables[0].Rows[i][0].ToString().Trim() == "Box Ship Label_Single Pack")
{
useOuter = true;
string filename_XML = "PC_" + con.Ds.Tables[0].Rows[i][1].ToString() + "_" + con.Ds.Tables[0].Rows[i][3].ToString() + "_" + con.Ds.Tables[0].Rows[i][2].ToString().Replace(".xslt", ".xml");
string filename_PDF = "PC_" + con.Ds.Tables[0].Rows[i][1].ToString() + "_" + con.Ds.Tables[0].Rows[i][3].ToString() + "_" + con.Ds.Tables[0].Rows[i][2].ToString().Replace(".xslt", ".pdf");
string filename_FO = "PC_" + con.Ds.Tables[0].Rows[i][1].ToString() + "_" + con.Ds.Tables[0].Rows[i][3].ToString() + "_" + con.Ds.Tables[0].Rows[i][2].ToString().Replace(".xslt", ".fo");
xmlCreator = new BoxLabelShipmentXmlCreator();
xmlCreator.LoadData(BOX_DN.Text.Trim() + "/" + Serial_Num);
string docName_XML = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_XML;
xmlCreator.WriteXml(docName_XML, useOuter);
string docName_PDF = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_PDF;
string docName_FO = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_FO;
string fopPath = ConfigurationManager.AppSettings["FOPPath"];
//FOPWrap.FOP.GeneratePDF(
// fopPath,
// docName_XML,
// Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()),
// docName_PDF);
//FOPWrap.FOP.GenerateFo(
// fopPath,
// docName_XML,
// Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()),
// docName_FO);
DoGenFile(PDF, Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()), docName_XML, docName_PDF);
DoGenFile(FO, Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()), docName_XML, docName_FO);
}
}
if (con.Ds.Tables[0].Rows[i][0].ToString().Trim() == "Pallet Ship Label- Pack ID Single")
{
useOuter = true;
//if (Pallet_Id.Substring(0, 2).ToString() == "NA" || Pallet_Id.Substring(0, 2).ToString() == "BA")
//{
// continue;
//}
string filename_XML = "PC_" + con.Ds.Tables[0].Rows[i][1].ToString() + "_" + con.Ds.Tables[0].Rows[i][3].ToString() + "_" + con.Ds.Tables[0].Rows[i][2].ToString().Replace(".xslt", ".xml");
string filename_PDF = "PC_" + con.Ds.Tables[0].Rows[i][1].ToString() + "_" + con.Ds.Tables[0].Rows[i][3].ToString() + "_" + con.Ds.Tables[0].Rows[i][2].ToString().Replace(".xslt", ".pdf");
string filename_FO = "PC_" + con.Ds.Tables[0].Rows[i][1].ToString() + "_" + con.Ds.Tables[0].Rows[i][3].ToString() + "_" + con.Ds.Tables[0].Rows[i][2].ToString().Replace(".xslt", ".fo");
if (filename_XML.IndexOf("TypeA") != -1)
{
xmlCreator = new PalletAShipmentXmlCreator();
}
else
{
if (isBsam)
xmlCreator = new PalletBShipmentBsamXmlCreator();
else
xmlCreator = new PalletBShipmentXmlCreator();
}
xmlCreator.LoadData(BOX_DN.Text.Trim() + "/" + Pallet_Id);
string docName_XML = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_XML;
xmlCreator.WriteXml(docName_XML, useOuter);
string docName_PDF = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_PDF;
string docName_FO = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_FO;
string fopPath = ConfigurationManager.AppSettings["FOPPath"];
//FOPWrap.FOP.GeneratePDF(
// fopPath,
// docName_XML,
// Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()),
// docName_PDF);
//FOPWrap.FOP.GenerateFo(
// fopPath,
// docName_XML,
// Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()),
// docName_FO);
DoGenFile(PDF, Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()), docName_XML, docName_PDF);
DoGenFile(FO, Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()), docName_XML, docName_FO);
}
else if (con.Ds.Tables[0].Rows[i][0].ToString().Trim() == "Pack List- Transportation")
{
useOuter = false;
string filename_XML = "PC_" + con.Ds.Tables[0].Rows[i][1].ToString() + "_" + con.Ds.Tables[0].Rows[i][3].ToString() + "_" + con.Ds.Tables[0].Rows[i][2].ToString().Replace(".xslt", ".xml");
string filename_PDF = "PC_" + con.Ds.Tables[0].Rows[i][1].ToString() + "_" + con.Ds.Tables[0].Rows[i][3].ToString() + "_" + con.Ds.Tables[0].Rows[i][2].ToString().Replace(".xslt", ".pdf");
string filename_FO = "PC_" + con.Ds.Tables[0].Rows[i][1].ToString() + "_" + con.Ds.Tables[0].Rows[i][3].ToString() + "_" + con.Ds.Tables[0].Rows[i][2].ToString().Replace(".xslt", ".fo");
//xmlCreator = new PackListShipmentXmlCreator();
if (con.Ds.Tables[0].Rows[i][2].ToString().Contains("Rail"))
{
useOuter = true;
xmlCreator = new MasterWaybillShipmentXmlCreator();
}
else
{
xmlCreator = new PackListShipmentXmlCreator();
}
xmlCreator.LoadData(BOX_DN.Text.Trim() + "/Pack List- Transportation");
string docName_XML = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_XML;
xmlCreator.WriteXml(docName_XML, useOuter);
string docName_PDF = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_PDF;
string docName_FO = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_FO;
string fopPath = ConfigurationManager.AppSettings["FOPPath"];
//FOPWrap.FOP.GeneratePDF(
// fopPath,
// docName_XML,
// Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()),
// docName_PDF);
//FOPWrap.FOP.GenerateFo(
// fopPath,
// docName_XML,
// Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()),
// docName_FO);
DoGenFile(PDF, Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()), docName_XML, docName_PDF);
DoGenFile(FO, Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()), docName_XML, docName_FO);
}
else if (con.Ds.Tables[0].Rows[i][0].ToString().Trim() == "Pack List- Shipment")
{
useOuter = false;
string filename_XML = "PC_" + con.Ds.Tables[0].Rows[i][1].ToString() + "_" + con.Ds.Tables[0].Rows[i][3].ToString() + "_" + con.Ds.Tables[0].Rows[i][2].ToString().Replace(".xslt", ".xml");
string filename_PDF = "PC_" + con.Ds.Tables[0].Rows[i][1].ToString() + "_" + con.Ds.Tables[0].Rows[i][3].ToString() + "_" + con.Ds.Tables[0].Rows[i][2].ToString().Replace(".xslt", ".pdf");
string filename_FO = "PC_" + con.Ds.Tables[0].Rows[i][1].ToString() + "_" + con.Ds.Tables[0].Rows[i][3].ToString() + "_" + con.Ds.Tables[0].Rows[i][2].ToString().Replace(".xslt", ".fo");
string docName_XML = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_XML;
if (isBsam)
{
xmlCreator = new HouseWaybillsXmlCreator();
xmlCreator.LoadData(BOX_DN.Text.Trim());
xmlCreator.WriteXml(docName_XML, true);
}
else if (con.Ds.Tables[0].Rows[i][2].ToString().Contains("QVC")) //add for QVC 201305
{
xmlCreator = new PackListShipmentXmlCreator_QVC();
//string docName_XML = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_XML;
xmlCreator.LoadData(BOX_DN.Text.Trim() + "/Pack List- Shipment", docName_XML);
}
else
{
if (con.Ds.Tables[0].Rows[i][2].ToString().Contains("Rail"))
{
useOuter = true;
xmlCreator = new MasterWaybillShipmentXmlCreator();
}
else
{
xmlCreator = new PackListShipmentXmlCreator();
}
xmlCreator.LoadData(BOX_DN.Text.Trim() + "/Pack List- Shipment");
//string docName_XML = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_XML;
xmlCreator.WriteXml(docName_XML, useOuter);
}
string docName_PDF = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_PDF;
string docName_FO = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_FO;
string fopPath = ConfigurationManager.AppSettings["FOPPath"];
//FOPWrap.FOP.GeneratePDF(
// fopPath,
// docName_XML,
// Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()),
// docName_PDF);
//FOPWrap.FOP.GenerateFo(
// fopPath,
// docName_XML,
// Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()),
// docName_FO);
DoGenFile(PDF, Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()), docName_XML, docName_PDF);
DoGenFile(FO, Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()), docName_XML, docName_FO);
#region mark
/*
//xmlCreator = new PackListShipmentXmlCreator();
if (con.Ds.Tables[0].Rows[i][2].ToString().Contains("Rail"))
{
useOuter = true;
xmlCreator = new MasterWaybillShipmentXmlCreator();
}
else if (con.Ds.Tables[0].Rows[i][2].ToString().Contains("QVC"))
{
xmlCreator = new PackListShipmentXmlCreator_QVC();
}
else
{
xmlCreator = new PackListShipmentXmlCreator();
}
// xmlCreator.LoadData(BOX_DN.Text.Trim());
xmlCreator.LoadData(BOX_DN.Text.Trim() + "/Pack List- Shipment");
string docName_XML = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_XML;
xmlCreator.WriteXml(docName_XML, useOuter);
string docName_PDF = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_PDF;
string docName_FO = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_FO;
string fopPath = ConfigurationManager.AppSettings["FOPPath"];
FOPWrap.FOP.GeneratePDF(
fopPath,
docName_XML,
Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()),
docName_PDF);
FOPWrap.FOP.GenerateFo(
fopPath,
docName_XML,
Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()),
docName_FO);*/
#endregion
}
else if (con.Ds.Tables[0].Rows[i][0].ToString().Trim() == "Pack List- Addition")
{
useOuter = false;
string filename_XML = "PC_" + con.Ds.Tables[0].Rows[i][1].ToString() + "_" + con.Ds.Tables[0].Rows[i][3].ToString() + "_" + con.Ds.Tables[0].Rows[i][2].ToString().Replace(".xslt", ".xml");
string filename_PDF = "PC_" + con.Ds.Tables[0].Rows[i][1].ToString() + "_" + con.Ds.Tables[0].Rows[i][3].ToString() + "_" + con.Ds.Tables[0].Rows[i][2].ToString().Replace(".xslt", ".pdf");
string filename_FO = "PC_" + con.Ds.Tables[0].Rows[i][1].ToString() + "_" + con.Ds.Tables[0].Rows[i][3].ToString() + "_" + con.Ds.Tables[0].Rows[i][2].ToString().Replace(".xslt", ".fo");
xmlCreator = new PackListShipmentXmlCreator();
//xmlCreator.LoadData(BOX_DN.Text.Trim() + "/Pack List- Addition");
xmlCreator.LoadData(BOX_DN.Text.Trim() + "/Pack List- Addition");
string docName_XML = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_XML;
xmlCreator.WriteXml(docName_XML, useOuter);
string docName_PDF = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_PDF;
string docName_FO = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_FO;
string fopPath = ConfigurationManager.AppSettings["FOPPath"];
//FOPWrap.FOP.GeneratePDF(
// fopPath,
// docName_XML,
// Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()),
// docName_PDF);
//FOPWrap.FOP.GenerateFo(
// fopPath,
// docName_XML,
// Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()),
// docName_FO);
DoGenFile(PDF, Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()), docName_XML, docName_PDF);
DoGenFile(FO, Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()), docName_XML, docName_FO);
}
else if (con.Ds.Tables[0].Rows[i][0].ToString().Trim() == "Waybill- Addition")
{
useOuter = true;
string filename_XML = "PC_" + con.Ds.Tables[0].Rows[i][1].ToString() + "_" + con.Ds.Tables[0].Rows[i][3].ToString() + "_" + con.Ds.Tables[0].Rows[i][2].ToString().Replace(".xslt", ".xml");
string filename_PDF = "PC_" + con.Ds.Tables[0].Rows[i][1].ToString() + "_" + con.Ds.Tables[0].Rows[i][3].ToString() + "_" + con.Ds.Tables[0].Rows[i][2].ToString().Replace(".xslt", ".pdf");
string filename_FO = "PC_" + con.Ds.Tables[0].Rows[i][1].ToString() + "_" + con.Ds.Tables[0].Rows[i][3].ToString() + "_" + con.Ds.Tables[0].Rows[i][2].ToString().Replace(".xslt", ".fo");
//xmlCreator = new WayBillShipmentXmlCreator();
xmlCreator = new WayBillShipmentXmlCreator();
xmlCreator.LoadData(BOX_DN.Text.Trim() );
string docName_XML = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_XML;
xmlCreator.WriteXml(docName_XML, useOuter);
string docName_PDF = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_PDF;
string docName_FO = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_FO;
string fopPath = ConfigurationManager.AppSettings["FOPPath"];
//FOPWrap.FOP.GeneratePDF(
// fopPath,
// docName_XML,
// Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()),
// docName_PDF);
//FOPWrap.FOP.GenerateFo(
// fopPath,
// docName_XML,
// Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()),
// docName_FO);
DoGenFile(PDF, Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()), docName_XML, docName_PDF);
DoGenFile(FO, Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()), docName_XML, docName_FO);
}
#region POS
else if (con.Ds.Tables[0].Rows[i][0].ToString().Trim() == "POS")
{
useOuter = false;
string filename_XML = "PC_" + con.Ds.Tables[0].Rows[i][1].ToString() + "_" + con.Ds.Tables[0].Rows[i][3].ToString() + "_" + con.Ds.Tables[0].Rows[i][2].ToString().Replace(".xslt", ".xml");
string filename_PDF = "PC_" + con.Ds.Tables[0].Rows[i][1].ToString() + "_" + con.Ds.Tables[0].Rows[i][3].ToString() + "_" + con.Ds.Tables[0].Rows[i][2].ToString().Replace(".xslt", ".pdf");
string filename_FO = "PC_" + con.Ds.Tables[0].Rows[i][1].ToString() + "_" + con.Ds.Tables[0].Rows[i][3].ToString() + "_" + con.Ds.Tables[0].Rows[i][2].ToString().Replace(".xslt", ".fo");
//xmlCreator = new WayBillShipmentXmlCreator();
string query_step3 = "select a.TruckID,[Date] from HPIMES.dbo.Forwarder a,HPIMES.dbo.MAWB b where a.MAWB=b.MAWB or a.MAWB=b.HAWB and b.Delivery= '" + BOX_DN.Text.ToString().Trim() + "'";//collate Chinese_Taiwan_Stroke_90_BIN
con.SqlQueComm(query_step3, "Truck");
if (con.Ds.Tables["Truck"].Rows.Count < 1)
{
Exception ex = new Exception("NO MAWB Or Forwarder Data!");
throw ex;
}
xmlCreator = new POSXmlCreator();
string TruckInfo = "";
TruckInfo = con.Ds.Tables["Truck"].Rows[0][0] + @"@" + con.Ds.Tables["Truck"].Rows[0][1];
xmlCreator.LoadData(TruckInfo);
string docName_XML = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_XML;
xmlCreator.WriteXml(docName_XML, useOuter);
string docName_PDF = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_PDF;
string docName_FO = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_FO;
string fopPath = ConfigurationManager.AppSettings["FOPPath"];
//FOPWrap.FOP.GeneratePDF(
// fopPath,
// docName_XML,
// Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()),
// docName_PDF);
//FOPWrap.FOP.GenerateFo(
// fopPath,
// docName_XML,
// Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()),
// docName_FO);
DoGenFile(PDF, Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()), docName_XML, docName_PDF);
DoGenFile(FO, Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()), docName_XML, docName_FO);
}
#endregion
}
}
#endregion
//Response.Write("<script type='text/javascript'>alert('" + con.Ds.Tables[0].Rows[0][0] + "');</script>");
}
}
}
catch (System.Exception err)
{
// MessageBox.Show(err.Message.ToString());
logger.Error(err.Message + Environment.NewLine + err.ToString() + Environment.NewLine + err.InnerException);
Response.Write(err);
}
}
protected void btnViewXML_Click(object sender, EventArgs e)
{
string sessionDoc = Session["SCHEMA_FILE_NAME"].ToString();
string docCattp = Session["DOC"].ToString().Trim();
logger.Info("sessionDoc= " + sessionDoc);
logger.Info("docCattp= " + docCattp);
logger.Info("lblselect= " + lblselect.Text);
logger.Info("txtInternalID= " + txtInternalID.Text);
XmlCreator xmlCreator = null;
Guid docGuid = Guid.NewGuid();
bool useOuter = true;
if (sessionDoc.StartsWith("Schema_Box_Ship_Label"))
{
xmlCreator = new BoxLabelXmlCreator();
//xmlCreator =new BoxLabelShipmentXmlCreator();
xmlCreator.LoadData(txtInternalID.Text.Trim() + "/" + lblselect.Text.ToString());
//xmlCreator.LoadData(txtInternalID.Text.Trim());
}
else if (sessionDoc.StartsWith("Schema_Pallet_Label_TypeA"))
{
// xmlCreator = new PalletAXmlCreator();
xmlCreator = new PalletAShipmentXmlCreator();
xmlCreator.LoadData(txtInternalID.Text.Trim() + "/" + lblselect.Text.ToString());
}
else if (sessionDoc.StartsWith("Schema_Pallet_Label_TypeB"))
{
//xmlCreator = new PalletBXmlCreator();
xmlCreator = new PalletBShipmentXmlCreator();
xmlCreator.LoadData(txtInternalID.Text.Trim() + "/" + lblselect.Text.ToString());
}
else if (sessionDoc.StartsWith("Schema_Pack_List"))
{
useOuter = false;
//useOuter = true;
//xmlCreator = new PackListXmlCreator();
xmlCreator = new PackListShipmentXmlCreator();
xmlCreator.LoadData(txtInternalID.Text.Trim() + "/" + docCattp.ToString().Trim());
}
else if (sessionDoc.StartsWith("Schema_Waybill"))
{
//-- xmlCreator = new WayBillXmlCreator();
//xmlCreator = new WayBillShipmentXmlCreator();
xmlCreator = new WayBillShipmentXmlCreator();
xmlCreator.LoadData(txtInternalID.Text.Trim());
}
else if (sessionDoc.StartsWith("Schema_HouseWaybills"))
{
xmlCreator = new HouseWaybillsXmlCreator();
xmlCreator.LoadData(txtInternalID.Text.Trim());
}
//---------------------add by lck------------------------------------------------
else if (sessionDoc.StartsWith("Schema_Master_Waybill"))
{
xmlCreator = new MasterWaybillShipmentXmlCreator();
xmlCreator.LoadData(txtInternalID.Text.Trim() + "/" + "xxxxx");
}
//---------------------------------------------------------------------
/*if (!sessionDoc.StartsWith("Pallet Ship Label"))
{
string docType = Session["DOC"].ToString().Split("-".ToCharArray())[0];
switch (docType)
{
case "Box Ship Label":
xmlCreator = new BoxLabelXmlCreator();
break;
case "Pack List":
useOuter = false;
xmlCreator = new PackListXmlCreator();
break;
case "Waybill":
xmlCreator = new WayBillXmlCreator();
break;
}
}
else
{
if (sessionDoc == "Pallet Ship Label- Pack ID Single")
{
xmlCreator = new PalletAXmlCreator();
}
else
{
xmlCreator = new PalletBXmlCreator();
}
}*/
//xmlCreator.LoadData(txtInternalID.Text.Trim());
string docName = ConfigurationManager.AppSettings["FilePath"] + @"\" + docGuid.ToString() + ".xml";
//string docName = Server.MapPath(@"~\Output\" + docGuid.ToString() + ".xml");
xmlCreator.WriteXml(docName, useOuter);
string url = ConfigurationManager.AppSettings["FileSite"] + docGuid.ToString() + ".xml";
//Response.Redirect(@"~\Output\" + docGuid.ToString() + ".xml");
OpenWindows(url,"XML");
}
public string WayBillShipmentList(string FilePH, string Dn)
{
XmlCreator xmlCreator = null;
// xmlCreator = new WayBillShipmentXmlCreator();
xmlCreator = new WayBillShipmentXmlCreator();
string res = null;
try
{
xmlCreator.LoadData(Dn.ToString().Trim());
xmlCreator.WriteXml(FilePH, true);
res = Dn;
}
catch (Exception err)
{
res = err.Message.ToString();
}
return res;
}
string OutputToPDF(string cmd)
{
string sessionDoc = Session["SCHEMA_FILE_NAME"].ToString();
string docCattp = Session["DOC"].ToString().Trim();
XmlCreator xmlCreator = null;
Guid docGuid = Guid.NewGuid();
bool useOuter = true;
if (sessionDoc.StartsWith("Schema_Box_Ship_Label"))
{
xmlCreator = new BoxLabelXmlCreator();
//xmlCreator = new BoxLabelShipmentXmlCreator();
//xmlCreator.LoadData(txtInternalID.Text.Trim());
xmlCreator.LoadData(txtInternalID.Text.Trim() + "/" + lblselect.Text.ToString());
}
else if (sessionDoc.StartsWith("Schema_Pallet_Label_TypeA"))
{
xmlCreator = new PalletAXmlCreator();
//xmlCreator = new PalletAShipmentXmlCreator();
xmlCreator.LoadData(txtInternalID.Text.Trim() + "/" + lblselect.Text.ToString());
}
else if (sessionDoc.StartsWith("Schema_Pallet_Label_TypeB"))
{
//xmlCreator = new PalletBXmlCreator();
xmlCreator = new PalletBShipmentXmlCreator();
xmlCreator.LoadData(txtInternalID.Text.Trim() + "/" + lblselect.Text.ToString());
}
else if (sessionDoc.StartsWith("Schema_Pack_List"))
{
useOuter = false;
//xmlCreator = new PackListXmlCreator();
xmlCreator = new PackListShipmentXmlCreator();
xmlCreator.LoadData(txtInternalID.Text.Trim() + "/" + docCattp.ToString().Trim());
// xmlCreator.LoadData(txtInternalID.Text.Trim());
}
else if (sessionDoc.StartsWith("Schema_Waybill"))
{
/////xmlCreator = new WayBillXmlCreator();
//xmlCreator = new WayBillShipmentXmlCreator();
xmlCreator = new WayBillShipmentXmlCreator();
xmlCreator.LoadData(txtInternalID.Text.Trim());
}
//---------------------add by lck------------------------------------------------
else if (sessionDoc.StartsWith("Schema_Master_Waybill"))
{
xmlCreator = new MasterWaybillShipmentXmlCreator();
xmlCreator.LoadData(txtInternalID.Text.Trim() + "/" + "xxxxx");
}
//---------------------------------------------------------------------
string docName = ConfigurationManager.AppSettings["FilePath"] + @"\" + docGuid.ToString() + ".xml";
//string docName = Server.MapPath(@"~\Output\" + docGuid.ToString() + ".xml");
xmlCreator.WriteXml(docName, useOuter);
string fopPath = ConfigurationManager.AppSettings["FOPPath"];
FOPWrap.FOP.GeneratePDF(
fopPath,
docName,
Server.MapPath(@"~\XSL\" + Session["XSL"].ToString()),
ConfigurationManager.AppSettings["FilePath"] + @"\" + docGuid.ToString()+".pdf");
//Server.MapPath(@"~\Output\" + docGuid.ToString() + ".pdf"));
//return @"~\Output\" + docGuid.ToString() + ".pdf";
if (cmd=="ViewPDF")
return ConfigurationManager.AppSettings["FileSite"] + docGuid.ToString() + ".pdf";
else
return ConfigurationManager.AppSettings["FilePath"] + @"\" + docGuid.ToString() +".pdf";
}
public string WayBillShipmentList(string FilePH, string Dn)
{
logger.Info("WayBillShipmentList begin; FilePH=" + FilePH + " , Dn=" + Dn);
XmlCreator xmlCreator = null;
// xmlCreator = new WayBillShipmentXmlCreator();
xmlCreator = new WayBillShipmentXmlCreator();
string res = null;
try
{
ChkAndCreatePath(FilePH);
xmlCreator.LoadData(Dn.ToString().Trim());
xmlCreator.WriteXml(FilePH, true);
res = Dn;
}
catch (Exception err)
{
res = RecordError("WayBillShipmentList", ref err);
}
finally
{
logger.Info("WayBillShipmentList end");
}
return res;
}
protected void SNVIEW_SelectedIndexChanged(object sender, EventArgs e)
{
XmlCreator xmlCreator = null;//实例化xmlcreator
bool useOuter = true;
string version = "";
string Pallet_Id = SNVIEW.SelectedRow.Cells[1].Text.ToString().Trim();
string Serial_Num = SNVIEW.SelectedRow.Cells[2].Text.ToString().Trim();
//String value = DOCVIEW.Columns[1];
//string doc = DOCVIEW.Rows[1];
//Response.Write("<script type='text/javascript'>alert('"+ DOCVIEW.Rows[1] +"');</script>");
DataConnLib con1 = new DataConnLib(ConfigurationManager.AppSettings["Database"]);
try
{
string query = "select top 1 (VERSION) from [PAK.PAKRT_Log] nolock order by CREATE_DATE desc";
con1.SqlQueComm(query,"VERSION");
version = con1.Ds.Tables[0].Rows[0][0].ToString().Trim();
}
catch (System.Exception err)
{
System.Windows.Forms.MessageBox.Show(err.Message.ToString());
}
DataConnLib con = new DataConnLib(ConfigurationManager.AppSettings["Database"]);
try
{
string query = "select distinct b.DOC_CAT,b.DOC_SET_NUMBER, b.XSL_TEMPLATE_NAME, a.PO_NUM from [PAK_PAKComn] a,[PAK.PAKRT] b where a.DOC_SET_NUMBER = b.DOC_SET_NUMBER collate Chinese_Taiwan_Stroke_90_BIN and a.InternalID = '" + BOX_DN.Text.ToString().Trim() + "'";//collate Chinese_Taiwan_Stroke_90_BIN
con.SqlQueComm(query,"DOCTable");
if (con.Ds.Tables.Count > 0)
{
if (con.Ds.Tables[0].Rows.Count > 0)
{
string dateyear = System.DateTime.Now.Year.ToString();
string datemonth = System.DateTime.Now.Month.ToString().Trim();
if (datemonth.Length == 1)
{
datemonth = "0" + datemonth;
}
string dateday = System.DateTime.Now.Day.ToString().Trim();
if (dateday.Length == 1)
{
dateday = "0" + dateday;
}
if (RadioButton_Step1.Checked)
{
Label_Messege.Text = "ZipFileName: Inventec_PRE_MTP_TEST_DATE_" + dateyear + datemonth + dateday + "_EDITS_REVISION_" + dateyear + version;
}
else if (RadioButton_Step2.Checked)
{
Label_Messege.Text = "ZipFileName: Inventec_MTP_TEST_DATE_" + dateyear + datemonth + dateday + "_EDITS_REVISION_" + dateyear + version;
}
else
{
Label_Messege.Text = "ZipFileName: Inventec_PROD_CHECK_DATE_" + dateyear + datemonth + dateday + "_EDITS_REVISION_" + dateyear +version;
}
if (RadioButton_Step1.Checked || RadioButton_Step2.Checked)
{
// for (int i = 0; i <= con.Ds.Tables[0].Rows.Count; i++)
for (int i = 0; i < con.Ds.Tables[0].Rows.Count; i++)
{
if (con.Ds.Tables[0].Rows[i][0].ToString().Trim() == "Box Ship Label")
{
useOuter = true;
string filename_XML = DropDownList_ID.Text + "_" + con.Ds.Tables[0].Rows[i][1].ToString() + "_" + con.Ds.Tables[0].Rows[i][3].ToString() + "_" + con.Ds.Tables[0].Rows[i][2].ToString().Replace(".xslt", ".xml");
string filename_PDF = DropDownList_ID.Text + "_" + con.Ds.Tables[0].Rows[i][1].ToString() + "_" + con.Ds.Tables[0].Rows[i][3].ToString() + "_" + con.Ds.Tables[0].Rows[i][2].ToString().Replace(".xslt", ".pdf");
string filename_FO = DropDownList_ID.Text + "_" + con.Ds.Tables[0].Rows[i][1].ToString() + "_" + con.Ds.Tables[0].Rows[i][3].ToString() + "_" + con.Ds.Tables[0].Rows[i][2].ToString().Replace(".xslt", ".fo");
xmlCreator = new BoxLabelShipmentXmlCreator();
xmlCreator.LoadData(BOX_DN.Text.Trim() + "/" + Serial_Num);
string docName_XML = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_XML;
xmlCreator.WriteXml(docName_XML, useOuter);
string docName_PDF = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_PDF;
string docName_FO = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_FO;
string fopPath = ConfigurationManager.AppSettings["FOPPath"];
FOPWrap.FOP.GeneratePDF(
fopPath,
docName_XML,
Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()),
docName_PDF);
FOPWrap.FOP.GenerateFo(
fopPath,
docName_XML,
Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()),
docName_FO);
}
else if (con.Ds.Tables[0].Rows[i][0].ToString().Trim() == "Pallet Ship Label- Pack ID Single")
{
useOuter = true;
//////if (Pallet_Id.Substring(0,2).ToString() == "NA" || Pallet_Id.Substring(0,2).ToString() == "BA")
//////{
////// continue;
//////}
string filename_XML = DropDownList_ID.Text + "_" + con.Ds.Tables[0].Rows[i][1].ToString() + "_" + con.Ds.Tables[0].Rows[i][3].ToString() + "_" + con.Ds.Tables[0].Rows[i][2].ToString().Replace(".xslt", ".xml");
string filename_PDF = DropDownList_ID.Text + "_" + con.Ds.Tables[0].Rows[i][1].ToString() + "_" + con.Ds.Tables[0].Rows[i][3].ToString() + "_" + con.Ds.Tables[0].Rows[i][2].ToString().Replace(".xslt", ".pdf");
string filename_FO = DropDownList_ID.Text + "_" + con.Ds.Tables[0].Rows[i][1].ToString() + "_" + con.Ds.Tables[0].Rows[i][3].ToString() + "_" + con.Ds.Tables[0].Rows[i][2].ToString().Replace(".xslt", ".fo");
if (filename_XML.IndexOf("TypeA") != -1)
{
xmlCreator = new PalletAShipmentXmlCreator();
}
else
{
xmlCreator = new PalletBShipmentXmlCreator();
}
xmlCreator.LoadData(BOX_DN.Text.Trim() + "/" + Pallet_Id);
string docName_XML = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_XML;
xmlCreator.WriteXml(docName_XML, useOuter);
string docName_PDF = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_PDF;
string docName_FO = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_FO;
string fopPath = ConfigurationManager.AppSettings["FOPPath"];
FOPWrap.FOP.GeneratePDF(
fopPath,
docName_XML,
Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()),
docName_PDF);
FOPWrap.FOP.GenerateFo(
fopPath,
docName_XML,
Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()),
docName_FO);
}
else if (con.Ds.Tables[0].Rows[i][0].ToString().Trim() == "Pack List- Transportation")
{
useOuter = false;
string filename_XML = DropDownList_ID.Text + "_" + con.Ds.Tables[0].Rows[i][1].ToString() + "_" + con.Ds.Tables[0].Rows[i][3].ToString() + "_" + con.Ds.Tables[0].Rows[i][2].ToString().Replace(".xslt", ".xml");
string filename_PDF = DropDownList_ID.Text + "_" + con.Ds.Tables[0].Rows[i][1].ToString() + "_" + con.Ds.Tables[0].Rows[i][3].ToString() + "_" + con.Ds.Tables[0].Rows[i][2].ToString().Replace(".xslt", ".pdf");
string filename_FO = DropDownList_ID.Text + "_" + con.Ds.Tables[0].Rows[i][1].ToString() + "_" + con.Ds.Tables[0].Rows[i][3].ToString() + "_" + con.Ds.Tables[0].Rows[i][2].ToString().Replace(".xslt", ".fo");
#region Modify by 20130312
//xmlCreator = new PackListShipmentXmlCreator();
if (con.Ds.Tables[0].Rows[i][2].ToString().Contains("Rail"))
{
useOuter = true;
xmlCreator = new MasterWaybillShipmentXmlCreator();
}
else
{
xmlCreator = new PackListShipmentXmlCreator();
}
#endregion
xmlCreator.LoadData(BOX_DN.Text.Trim() + "/Pack List- Transportation");
string docName_XML = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_XML;
xmlCreator.WriteXml(docName_XML, useOuter);
string docName_PDF = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_PDF;
string docName_FO = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_FO;
string fopPath = ConfigurationManager.AppSettings["FOPPath"];
FOPWrap.FOP.GeneratePDF(
fopPath,
docName_XML,
Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()),
docName_PDF);
FOPWrap.FOP.GenerateFo(
fopPath,
docName_XML,
Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()),
docName_FO);
}
else if (con.Ds.Tables[0].Rows[i][0].ToString().Trim() == "Pack List- Shipment")
{
useOuter = false;
string filename_XML = DropDownList_ID.Text + "_" + con.Ds.Tables[0].Rows[i][1].ToString() + "_" + con.Ds.Tables[0].Rows[i][3].ToString() + "_" + con.Ds.Tables[0].Rows[i][2].ToString().Replace(".xslt", ".xml");
string filename_PDF = DropDownList_ID.Text + "_" + con.Ds.Tables[0].Rows[i][1].ToString() + "_" + con.Ds.Tables[0].Rows[i][3].ToString() + "_" + con.Ds.Tables[0].Rows[i][2].ToString().Replace(".xslt", ".pdf");
string filename_FO = DropDownList_ID.Text + "_" + con.Ds.Tables[0].Rows[i][1].ToString() + "_" + con.Ds.Tables[0].Rows[i][3].ToString() + "_" + con.Ds.Tables[0].Rows[i][2].ToString().Replace(".xslt", ".fo");
string docName_XML = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_XML;
if (con.Ds.Tables[0].Rows[i][2].ToString().Contains("QVC")) //add for QVC 201305
{
xmlCreator = new PackListShipmentXmlCreator_QVC();
//string docName_XML = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_XML;
xmlCreator.LoadData(BOX_DN.Text.Trim() + "/Pack List- Shipment", docName_XML);
}
else
{
if (con.Ds.Tables[0].Rows[i][2].ToString().Contains("Rail"))
{
useOuter = true;
xmlCreator = new MasterWaybillShipmentXmlCreator();
}
else
{
xmlCreator = new PackListShipmentXmlCreator();
}
xmlCreator.LoadData(BOX_DN.Text.Trim() + "/Pack List- Shipment");
//string docName_XML = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_XML;
xmlCreator.WriteXml(docName_XML, useOuter);
}
string docName_PDF = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_PDF;
string docName_FO = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_FO;
string fopPath = ConfigurationManager.AppSettings["FOPPath"];
FOPWrap.FOP.GeneratePDF(
fopPath,
docName_XML,
Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()),
docName_PDF);
FOPWrap.FOP.GenerateFo(
fopPath,
docName_XML,
Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()),
docName_FO);
}
else if (con.Ds.Tables[0].Rows[i][0].ToString().Trim() == "Pack List- Addition")
{
useOuter = false;
string filename_XML = DropDownList_ID.Text + "_" + con.Ds.Tables[0].Rows[i][1].ToString() + "_" + con.Ds.Tables[0].Rows[i][3].ToString() + "_" + con.Ds.Tables[0].Rows[i][2].ToString().Replace(".xslt", ".xml");
string filename_PDF = DropDownList_ID.Text + "_" + con.Ds.Tables[0].Rows[i][1].ToString() + "_" + con.Ds.Tables[0].Rows[i][3].ToString() + "_" + con.Ds.Tables[0].Rows[i][2].ToString().Replace(".xslt", ".pdf");
string filename_FO = DropDownList_ID.Text + "_" + con.Ds.Tables[0].Rows[i][1].ToString() + "_" + con.Ds.Tables[0].Rows[i][3].ToString() + "_" + con.Ds.Tables[0].Rows[i][2].ToString().Replace(".xslt", ".fo");
xmlCreator = new PackListShipmentXmlCreator();
xmlCreator.LoadData(BOX_DN.Text.Trim() + "/Pack List- Addition");
string docName_XML = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_XML;
xmlCreator.WriteXml(docName_XML, useOuter);
string docName_PDF = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_PDF;
string docName_FO = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_FO;
string fopPath = ConfigurationManager.AppSettings["FOPPath"];
FOPWrap.FOP.GeneratePDF(
fopPath,
docName_XML,
Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()),
docName_PDF);
FOPWrap.FOP.GenerateFo(
fopPath,
docName_XML,
Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()),
docName_FO);
}
else if (con.Ds.Tables[0].Rows[i][0].ToString().Trim() == "Waybill- Addition")
{
useOuter = true;
string filename_XML = DropDownList_ID.Text + "_" + con.Ds.Tables[0].Rows[i][1].ToString() + "_" + con.Ds.Tables[0].Rows[i][3].ToString() + "_" + con.Ds.Tables[0].Rows[i][2].ToString().Replace(".xslt", ".xml");
string filename_PDF = DropDownList_ID.Text + "_" + con.Ds.Tables[0].Rows[i][1].ToString() + "_" + con.Ds.Tables[0].Rows[i][3].ToString() + "_" + con.Ds.Tables[0].Rows[i][2].ToString().Replace(".xslt", ".pdf");
string filename_FO = DropDownList_ID.Text + "_" + con.Ds.Tables[0].Rows[i][1].ToString() + "_" + con.Ds.Tables[0].Rows[i][3].ToString() + "_" + con.Ds.Tables[0].Rows[i][2].ToString().Replace(".xslt", ".fo");
//xmlCreator = new WayBillShipmentXmlCreator();
xmlCreator = new WayBillShipmentXmlCreator();
xmlCreator.LoadData(BOX_DN.Text.Trim());
string docName_XML = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_XML;
xmlCreator.WriteXml(docName_XML, useOuter);
string docName_PDF = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_PDF;
string docName_FO = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_FO;
string fopPath = ConfigurationManager.AppSettings["FOPPath"];
FOPWrap.FOP.GeneratePDF(
fopPath,
docName_XML,
Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()),
docName_PDF);
FOPWrap.FOP.GenerateFo(
fopPath,
docName_XML,
Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()),
docName_FO);
}
}
}
#region step3
else if (RadioButton_Step3.Checked)
{
//for (int i = 0; i <= con.Ds.Tables[0].Rows.Count; i++)
for (int i = 0; i < con.Ds.Tables[0].Rows.Count; i++)
{
if (con.Ds.Tables[0].Rows[i][0].ToString().Trim() == "Box Ship Label")
{
useOuter = true;
string filename_XML = "PC_" + con.Ds.Tables[0].Rows[i][1].ToString() + "_" + con.Ds.Tables[0].Rows[i][3].ToString() + "_" + con.Ds.Tables[0].Rows[i][2].ToString().Replace(".xslt", ".xml");
string filename_PDF = "PC_" + con.Ds.Tables[0].Rows[i][1].ToString() + "_" + con.Ds.Tables[0].Rows[i][3].ToString() + "_" + con.Ds.Tables[0].Rows[i][2].ToString().Replace(".xslt", ".pdf");
string filename_FO = "PC_" + con.Ds.Tables[0].Rows[i][1].ToString() + "_" + con.Ds.Tables[0].Rows[i][3].ToString() + "_" + con.Ds.Tables[0].Rows[i][2].ToString().Replace(".xslt", ".fo");
xmlCreator = new BoxLabelShipmentXmlCreator();
xmlCreator.LoadData(BOX_DN.Text.Trim() + "/" + Serial_Num);
string docName_XML = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_XML;
xmlCreator.WriteXml(docName_XML, useOuter);
string docName_PDF = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_PDF;
string docName_FO = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_FO;
string fopPath = ConfigurationManager.AppSettings["FOPPath"];
FOPWrap.FOP.GeneratePDF(
fopPath,
docName_XML,
Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()),
docName_PDF);
FOPWrap.FOP.GenerateFo(
fopPath,
docName_XML,
Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()),
docName_FO);
}
else if (con.Ds.Tables[0].Rows[i][0].ToString().Trim() == "Pallet Ship Label- Pack ID Single")
{
useOuter = true;
//if (Pallet_Id.Substring(0, 2).ToString() == "NA" || Pallet_Id.Substring(0, 2).ToString() == "BA")
//{
// continue;
//}
string filename_XML = "PC_" + con.Ds.Tables[0].Rows[i][1].ToString() + "_" + con.Ds.Tables[0].Rows[i][3].ToString() + "_" + con.Ds.Tables[0].Rows[i][2].ToString().Replace(".xslt", ".xml");
string filename_PDF = "PC_" + con.Ds.Tables[0].Rows[i][1].ToString() + "_" + con.Ds.Tables[0].Rows[i][3].ToString() + "_" + con.Ds.Tables[0].Rows[i][2].ToString().Replace(".xslt", ".pdf");
string filename_FO = "PC_" + con.Ds.Tables[0].Rows[i][1].ToString() + "_" + con.Ds.Tables[0].Rows[i][3].ToString() + "_" + con.Ds.Tables[0].Rows[i][2].ToString().Replace(".xslt", ".fo");
if (filename_XML.IndexOf("TypeA") != -1)
{
xmlCreator = new PalletAShipmentXmlCreator();
}
else
{
xmlCreator = new PalletBShipmentXmlCreator();
}
xmlCreator.LoadData(BOX_DN.Text.Trim() + "/" + Pallet_Id);
string docName_XML = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_XML;
xmlCreator.WriteXml(docName_XML, useOuter);
string docName_PDF = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_PDF;
string docName_FO = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_FO;
string fopPath = ConfigurationManager.AppSettings["FOPPath"];
FOPWrap.FOP.GeneratePDF(
fopPath,
docName_XML,
Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()),
docName_PDF);
FOPWrap.FOP.GenerateFo(
fopPath,
docName_XML,
Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()),
docName_FO);
}
else if (con.Ds.Tables[0].Rows[i][0].ToString().Trim() == "Pack List- Transportation")
{
useOuter = false;
string filename_XML = "PC_" + con.Ds.Tables[0].Rows[i][1].ToString() + "_" + con.Ds.Tables[0].Rows[i][3].ToString() + "_" + con.Ds.Tables[0].Rows[i][2].ToString().Replace(".xslt", ".xml");
string filename_PDF = "PC_" + con.Ds.Tables[0].Rows[i][1].ToString() + "_" + con.Ds.Tables[0].Rows[i][3].ToString() + "_" + con.Ds.Tables[0].Rows[i][2].ToString().Replace(".xslt", ".pdf");
string filename_FO = "PC_" + con.Ds.Tables[0].Rows[i][1].ToString() + "_" + con.Ds.Tables[0].Rows[i][3].ToString() + "_" + con.Ds.Tables[0].Rows[i][2].ToString().Replace(".xslt", ".fo");
//xmlCreator = new PackListShipmentXmlCreator();
if (con.Ds.Tables[0].Rows[i][2].ToString().Contains("Rail"))
{
useOuter = true;
xmlCreator = new MasterWaybillShipmentXmlCreator();
}
else
{
xmlCreator = new PackListShipmentXmlCreator();
}
xmlCreator.LoadData(BOX_DN.Text.Trim() + "/Pack List- Transportation");
string docName_XML = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_XML;
xmlCreator.WriteXml(docName_XML, useOuter);
string docName_PDF = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_PDF;
string docName_FO = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_FO;
string fopPath = ConfigurationManager.AppSettings["FOPPath"];
FOPWrap.FOP.GeneratePDF(
fopPath,
docName_XML,
Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()),
docName_PDF);
FOPWrap.FOP.GenerateFo(
fopPath,
docName_XML,
Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()),
docName_FO);
}
else if (con.Ds.Tables[0].Rows[i][0].ToString().Trim() == "Pack List- Shipment")
{
useOuter = false;
string filename_XML = "PC_" + con.Ds.Tables[0].Rows[i][1].ToString() + "_" + con.Ds.Tables[0].Rows[i][3].ToString() + "_" + con.Ds.Tables[0].Rows[i][2].ToString().Replace(".xslt", ".xml");
string filename_PDF = "PC_" + con.Ds.Tables[0].Rows[i][1].ToString() + "_" + con.Ds.Tables[0].Rows[i][3].ToString() + "_" + con.Ds.Tables[0].Rows[i][2].ToString().Replace(".xslt", ".pdf");
string filename_FO = "PC_" + con.Ds.Tables[0].Rows[i][1].ToString() + "_" + con.Ds.Tables[0].Rows[i][3].ToString() + "_" + con.Ds.Tables[0].Rows[i][2].ToString().Replace(".xslt", ".fo");
string docName_XML = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_XML;
if (con.Ds.Tables[0].Rows[i][2].ToString().Contains("QVC")) //add for QVC 201305
{
xmlCreator = new PackListShipmentXmlCreator_QVC();
//string docName_XML = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_XML;
xmlCreator.LoadData(BOX_DN.Text.Trim() + "/Pack List- Shipment", docName_XML);
}
else
{
if (con.Ds.Tables[0].Rows[i][2].ToString().Contains("Rail"))
{
useOuter = true;
xmlCreator = new MasterWaybillShipmentXmlCreator();
}
else
{
xmlCreator = new PackListShipmentXmlCreator();
}
xmlCreator.LoadData(BOX_DN.Text.Trim() + "/Pack List- Shipment");
//string docName_XML = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_XML;
xmlCreator.WriteXml(docName_XML, useOuter);
}
string docName_PDF = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_PDF;
string docName_FO = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_FO;
string fopPath = ConfigurationManager.AppSettings["FOPPath"];
FOPWrap.FOP.GeneratePDF(
fopPath,
docName_XML,
Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()),
docName_PDF);
FOPWrap.FOP.GenerateFo(
fopPath,
docName_XML,
Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()),
docName_FO);
/*
//xmlCreator = new PackListShipmentXmlCreator();
if (con.Ds.Tables[0].Rows[i][2].ToString().Contains("Rail"))
{
useOuter = true;
xmlCreator = new MasterWaybillShipmentXmlCreator();
}
else if (con.Ds.Tables[0].Rows[i][2].ToString().Contains("QVC"))
{
xmlCreator = new PackListShipmentXmlCreator_QVC();
}
else
{
xmlCreator = new PackListShipmentXmlCreator();
}
// xmlCreator.LoadData(BOX_DN.Text.Trim());
xmlCreator.LoadData(BOX_DN.Text.Trim() + "/Pack List- Shipment");
string docName_XML = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_XML;
xmlCreator.WriteXml(docName_XML, useOuter);
string docName_PDF = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_PDF;
string docName_FO = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_FO;
string fopPath = ConfigurationManager.AppSettings["FOPPath"];
FOPWrap.FOP.GeneratePDF(
fopPath,
docName_XML,
Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()),
docName_PDF);
FOPWrap.FOP.GenerateFo(
fopPath,
docName_XML,
Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()),
docName_FO);*/
}
else if (con.Ds.Tables[0].Rows[i][0].ToString().Trim() == "Pack List- Addition")
{
useOuter = false;
string filename_XML = "PC_" + con.Ds.Tables[0].Rows[i][1].ToString() + "_" + con.Ds.Tables[0].Rows[i][3].ToString() + "_" + con.Ds.Tables[0].Rows[i][2].ToString().Replace(".xslt", ".xml");
string filename_PDF = "PC_" + con.Ds.Tables[0].Rows[i][1].ToString() + "_" + con.Ds.Tables[0].Rows[i][3].ToString() + "_" + con.Ds.Tables[0].Rows[i][2].ToString().Replace(".xslt", ".pdf");
string filename_FO = "PC_" + con.Ds.Tables[0].Rows[i][1].ToString() + "_" + con.Ds.Tables[0].Rows[i][3].ToString() + "_" + con.Ds.Tables[0].Rows[i][2].ToString().Replace(".xslt", ".fo");
xmlCreator = new PackListShipmentXmlCreator();
//xmlCreator.LoadData(BOX_DN.Text.Trim() + "/Pack List- Addition");
xmlCreator.LoadData(BOX_DN.Text.Trim() + "/Pack List- Addition");
string docName_XML = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_XML;
xmlCreator.WriteXml(docName_XML, useOuter);
string docName_PDF = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_PDF;
string docName_FO = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_FO;
string fopPath = ConfigurationManager.AppSettings["FOPPath"];
FOPWrap.FOP.GeneratePDF(
fopPath,
docName_XML,
Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()),
docName_PDF);
FOPWrap.FOP.GenerateFo(
fopPath,
docName_XML,
Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()),
docName_FO);
}
else if (con.Ds.Tables[0].Rows[i][0].ToString().Trim() == "Waybill- Addition")
{
useOuter = true;
string filename_XML = "PC_" + con.Ds.Tables[0].Rows[i][1].ToString() + "_" + con.Ds.Tables[0].Rows[i][3].ToString() + "_" + con.Ds.Tables[0].Rows[i][2].ToString().Replace(".xslt", ".xml");
string filename_PDF = "PC_" + con.Ds.Tables[0].Rows[i][1].ToString() + "_" + con.Ds.Tables[0].Rows[i][3].ToString() + "_" + con.Ds.Tables[0].Rows[i][2].ToString().Replace(".xslt", ".pdf");
string filename_FO = "PC_" + con.Ds.Tables[0].Rows[i][1].ToString() + "_" + con.Ds.Tables[0].Rows[i][3].ToString() + "_" + con.Ds.Tables[0].Rows[i][2].ToString().Replace(".xslt", ".fo");
//xmlCreator = new WayBillShipmentXmlCreator();
xmlCreator = new WayBillShipmentXmlCreator();
xmlCreator.LoadData(BOX_DN.Text.Trim() );
string docName_XML = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_XML;
xmlCreator.WriteXml(docName_XML, useOuter);
string docName_PDF = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_PDF;
string docName_FO = ConfigurationManager.AppSettings["FilePath"] + @"\" + filename_FO;
string fopPath = ConfigurationManager.AppSettings["FOPPath"];
FOPWrap.FOP.GeneratePDF(
fopPath,
docName_XML,
Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()),
docName_PDF);
FOPWrap.FOP.GenerateFo(
fopPath,
docName_XML,
Server.MapPath(@"~\XSL\" + con.Ds.Tables[0].Rows[i][2].ToString().Trim()),
docName_FO);
}
}
}
#endregion
//Response.Write("<script type='text/javascript'>alert('" + con.Ds.Tables[0].Rows[0][0] + "');</script>");
}
}
}
catch (System.Exception err)
{
// MessageBox.Show(err.Message.ToString());
Response.Write(err);
}
}