public void LoadPackingListDatabaseData(string id,string xmlpath)
{
XmlDocument xmlDoc = new XmlDocument();
string[] idSplit = id.Split(@"/".ToCharArray());
string internalID = idSplit[0];
string Tp = idSplit[1];
//根據internalID查找相關信息
NewDataSet packingList = new NewDataSet();
string whereMainClause = "WHERE InternalID='" + internalID + "'";
List<string> fields = new List<string>();
fields.Add("*");
DataTable pakTable = DBFactory.PopulateTempTable("[v_Shipment_PackList]", whereMainClause, fields);
NewDataSet.PACK_IDRow newRow = packingList.PACK_ID.NewPACK_IDRow();
newRow.PACK_ID_Id = 1;
int flag = 1;
double Qty = 0;
string return_to_zip = "";
foreach (DataColumn column in packingList.PACK_ID.Columns)
{
if (pakTable.Columns.Contains(column.ColumnName))
{
//if table contains name, then populate
//newRow[column] = pakTable.Rows[0][column.ColumnName];
if (flag == 1)
{
//创建声明节点
XmlDeclaration newDec = xmlDoc.CreateXmlDeclaration("1.0", "utf-8", null);
xmlDoc.AppendChild(newDec);
XmlElement newRoot = xmlDoc.CreateElement("PACK_ID");
xmlDoc.AppendChild(newRoot);
flag++;
return_to_zip = pakTable.Rows[0]["RETURN_TO_ZIP"].ToString();
}
////else
////{
//xmlDoc.Load("E:\\cc2.xml");
XmlElement xmlElemFileName = xmlDoc.CreateElement(column.ColumnName.ToString());
XmlText xmlTextFileName = xmlDoc.CreateTextNode(pakTable.Rows[0][column.ColumnName].ToString());
xmlElemFileName.AppendChild(xmlTextFileName);
xmlDoc.ChildNodes.Item(1).AppendChild(xmlElemFileName);
//xmlDoc.Save("E:\\cc2.xml");
//}
}
else
{
if (column.DataType == typeof(string))
newRow[column] = string.Empty;
else if (column.DataType == typeof(Double))
newRow[column] = 0;
else if (column.DataType == typeof(DateTime))
newRow[column] = string.Empty;
}
}
//生成UDF_HEAD資料行
string whereUDFHEADERClause_1 = "'" + pakTable.Rows[0]["InternalID"].ToString().Trim() + "'";
DataTable UDFHEADERTable_1 = DBFactory.PopulateTempTable_BySp("op_GetUDF_KEY_VALUE_HEADER_Shipment_QVC", whereUDFHEADERClause_1);
bool flag_return = UDFHEADERTable_1.Select("UDF_KEY_HEADER='KEY_HEADER_1ST_RETURN_MSG'").Length > 0;//判斷是否屬於non returnable 是則flag_return 為true
//flag_return = flag_return^true;
foreach (DataRow readRow2 in UDFHEADERTable_1.Rows)
{
//xmlDoc.Load("E:\\cc2.xml");
clsBarCode idEcode = new clsBarCode();//實例化IDAutomation
#region non returnable 版本
if (flag_return)
{
if (readRow2["UDF_KEY_HEADER"].ToString() == "KEY_HEADER_UPSRN")
{
continue;
}
else if (readRow2["UDF_KEY_HEADER"].ToString() == "KEY_HEADER_UPSGTN")
{
continue;
}
else if (readRow2["UDF_KEY_HEADER"].ToString() == "KEY_HEADER_USPSDN")
{
continue;
}
else if (readRow2["UDF_KEY_HEADER"].ToString() == "KEY_HEADER_RETAIL_PROMO_MSG")
{
XmlElement xmlElemFileName1 = xmlDoc.CreateElement("UDF_HEADER");
string key = readRow2["UDF_KEY_HEADER"].ToString().Trim();
XmlElement xmlElemFileName2 = xmlDoc.CreateElement("KEY");
xmlElemFileName2.InnerText = key;
xmlElemFileName1.AppendChild(xmlElemFileName2);
string value = readRow2["UDF_VALUE_HEADER"].ToString().Trim()+" ";
XmlCDataSection cdata = xmlDoc.CreateCDataSection("VALUE");
cdata.InnerText = value;
XmlElement xmlElemFileName3 = xmlDoc.CreateElement("VALUE");
xmlElemFileName3.AppendChild(cdata);
xmlElemFileName1.AppendChild(xmlElemFileName3);
xmlDoc.ChildNodes.Item(1).AppendChild(xmlElemFileName1);
}
else if (readRow2["UDF_KEY_HEADER"].ToString() == "KEY_HEADER_ENDCUST_PO")
{
XmlElement xmlElemFileName1 = xmlDoc.CreateElement("UDF_HEADER");
string key = readRow2["UDF_KEY_HEADER"].ToString().Trim();
XmlElement xmlElemFileName2 = xmlDoc.CreateElement("KEY");
xmlElemFileName2.InnerText = key;
xmlElemFileName1.AppendChild(xmlElemFileName2);
string KEY_HEADER_ENDCUST_PO_Value = readRow2["UDF_VALUE_HEADER"].ToString().Trim();
XmlElement VALUE = xmlDoc.CreateElement("VALUE");
VALUE.InnerText = KEY_HEADER_ENDCUST_PO_Value;
xmlElemFileName1.AppendChild(VALUE);
xmlDoc.ChildNodes.Item(1).AppendChild(xmlElemFileName1);
XmlElement KEY_HEADER_ENDCUST_PO_ENCODE = xmlDoc.CreateElement("UDF_HEADER");
XmlElement xmlElemFileName3 = xmlDoc.CreateElement("KEY");
xmlElemFileName3.InnerText = "KEY_HEADER_ENDCUST_PO_ENCODE";
KEY_HEADER_ENDCUST_PO_ENCODE.AppendChild(xmlElemFileName3);
string value = idEcode.Code128C(readRow2["UDF_VALUE_HEADER"].ToString().Trim()).ToString();
XmlElement xmlElemFileName4 = xmlDoc.CreateElement("VALUE");
XmlCDataSection cdata = xmlDoc.CreateCDataSection("VALUE");
cdata.InnerText = value;
xmlElemFileName4.AppendChild(cdata);
KEY_HEADER_ENDCUST_PO_ENCODE.AppendChild(xmlElemFileName4);
xmlDoc.ChildNodes.Item(1).AppendChild(KEY_HEADER_ENDCUST_PO_ENCODE);
}
else if (readRow2["UDF_KEY_HEADER"].ToString() == "KEY_HEADER_1ST_RETURN_MSG")
{
XmlElement xmlElemFileName1 = xmlDoc.CreateElement("UDF_HEADER");
string key = readRow2["UDF_KEY_HEADER"].ToString().Trim();
XmlElement xmlElemFileName2 = xmlDoc.CreateElement("KEY");
xmlElemFileName2.InnerText = key;
xmlElemFileName1.AppendChild(xmlElemFileName2);
string value = readRow2["UDF_VALUE_HEADER"].ToString().Trim();
XmlElement xmlElemFileName3 = xmlDoc.CreateElement("VALUE");
xmlElemFileName3.InnerText = value;
xmlElemFileName1.AppendChild(xmlElemFileName3);
xmlDoc.ChildNodes.Item(1).AppendChild(xmlElemFileName1);
}
else
{
XmlElement xmlElemFileName1 = xmlDoc.CreateElement("UDF_HEADER");
string key = readRow2["UDF_KEY_HEADER"].ToString().Trim();
XmlElement xmlElemFileName2 = xmlDoc.CreateElement("KEY");
xmlElemFileName2.InnerText = key;
xmlElemFileName1.AppendChild(xmlElemFileName2);
string value = readRow2["UDF_VALUE_HEADER"].ToString().Trim();
XmlCDataSection cdata = xmlDoc.CreateCDataSection("VALUE");
cdata.InnerText = value;
XmlElement xmlElemFileName3 = xmlDoc.CreateElement("VALUE");
xmlElemFileName3.AppendChild(cdata);
xmlElemFileName1.AppendChild(xmlElemFileName3);
xmlDoc.ChildNodes.Item(1).AppendChild(xmlElemFileName1);
}
}
#endregion
#region regular 版本
else
{
if (readRow2["UDF_KEY_HEADER"].ToString() == "KEY_HEADER_UPSRN")
{
XmlElement xmlElemFileName1 = xmlDoc.CreateElement("UDF_HEADER");
string key = readRow2["UDF_KEY_HEADER"].ToString().Trim();
XmlElement xmlElemFileName2 = xmlDoc.CreateElement("KEY");
xmlElemFileName2.InnerText = key;
xmlElemFileName1.AppendChild(xmlElemFileName2);
string KEY_HEADER_UPSRN_Value = readRow2["UDF_VALUE_HEADER"].ToString().Trim();
XmlElement VALUE = xmlDoc.CreateElement("VALUE");
VALUE.InnerText = KEY_HEADER_UPSRN_Value;
xmlElemFileName1.AppendChild(VALUE);
xmlDoc.ChildNodes.Item(1).AppendChild(xmlElemFileName1);
XmlElement KEY_HEADER_UPSRN_ENCODE = xmlDoc.CreateElement("UDF_HEADER");
XmlElement xmlElemFileName3 = xmlDoc.CreateElement("KEY");
xmlElemFileName3.InnerText = "KEY_HEADER_UPSRN_ENCODE";
KEY_HEADER_UPSRN_ENCODE.AppendChild(xmlElemFileName3);
//string value = "420" + readRow2["UDF_VALUE_HEADER"].ToString().Trim();
string value = "420" + return_to_zip;
string value1 = idEcode.Code128C(value).ToString();
XmlElement xmlElemFileName4 = xmlDoc.CreateElement("VALUE");
//XmlElement xmlElemFileName3 = xmlDoc.CreateElement();
XmlCDataSection cdata = xmlDoc.CreateCDataSection("VALUE");
cdata.InnerText = value1;
xmlElemFileName4.AppendChild(cdata);
KEY_HEADER_UPSRN_ENCODE.AppendChild(xmlElemFileName4);
xmlDoc.ChildNodes.Item(1).AppendChild(KEY_HEADER_UPSRN_ENCODE);
}
else if (readRow2["UDF_KEY_HEADER"].ToString() == "KEY_HEADER_UPSGTN" )
{
XmlElement xmlElemFileName1 = xmlDoc.CreateElement("UDF_HEADER");
string key = readRow2["UDF_KEY_HEADER"].ToString().Trim();
XmlElement xmlElemFileName2 = xmlDoc.CreateElement("KEY");
xmlElemFileName2.InnerText = key;
xmlElemFileName1.AppendChild(xmlElemFileName2);
string KEY_HEADER_UPSGTN_value = readRow2["UDF_VALUE_HEADER"].ToString().Trim();
XmlElement VALUE = xmlDoc.CreateElement("VALUE");
VALUE.InnerText = KEY_HEADER_UPSGTN_value;
xmlElemFileName1.AppendChild(VALUE);
xmlDoc.ChildNodes.Item(1).AppendChild(xmlElemFileName1);
XmlElement KEY_HEADER_UPSGTN_ENCODE = xmlDoc.CreateElement("UDF_HEADER");
XmlElement xmlElemFileName3 = xmlDoc.CreateElement("KEY");
xmlElemFileName3.InnerText = "KEY_HEADER_UPSGTN_ENCODE";
KEY_HEADER_UPSGTN_ENCODE.AppendChild(xmlElemFileName3);
string value = idEcode.Code128(readRow2["UDF_VALUE_HEADER"].ToString().Trim(),true).ToString();
//XmlElement xmlElemFileName3 = xmlDoc.CreateElement();
XmlElement xmlElemFileName4 = xmlDoc.CreateElement("VALUE");
//XmlElement xmlElemFileName3 = xmlDoc.CreateElement();
XmlCDataSection cdata = xmlDoc.CreateCDataSection("VALUE");
cdata.InnerText = value;
xmlElemFileName4.AppendChild(cdata);
KEY_HEADER_UPSGTN_ENCODE.AppendChild(xmlElemFileName4);
xmlDoc.ChildNodes.Item(1).AppendChild(KEY_HEADER_UPSGTN_ENCODE);
}
else if (readRow2["UDF_KEY_HEADER"].ToString() == "KEY_HEADER_USPSDN" )
{
XmlElement xmlElemFileName1 = xmlDoc.CreateElement("UDF_HEADER");
string key = readRow2["UDF_KEY_HEADER"].ToString().Trim();
XmlElement xmlElemFileName2 = xmlDoc.CreateElement("KEY");
xmlElemFileName2.InnerText = key;
xmlElemFileName1.AppendChild(xmlElemFileName2);
string KEY_HEADER_USPSDN_Value = readRow2["UDF_VALUE_HEADER"].ToString().Trim();
XmlElement VALUE = xmlDoc.CreateElement("VALUE");
VALUE.InnerText = KEY_HEADER_USPSDN_Value;
xmlElemFileName1.AppendChild(VALUE);
xmlDoc.ChildNodes.Item(1).AppendChild(xmlElemFileName1);
XmlElement KEY_HEADER_USPSDN_ENCODE = xmlDoc.CreateElement("UDF_HEADER");
XmlElement xmlElemFileName3 = xmlDoc.CreateElement("KEY");
xmlElemFileName3.InnerText = "KEY_HEADER_USPSDN_ENCODE";
KEY_HEADER_USPSDN_ENCODE.AppendChild(xmlElemFileName3);
//string ups_bacode = "(" + readRow2["UDF_VALUE_HEADER"].ToString().Trim().Substring(0, 2) + ")" + readRow2["UDF_VALUE_HEADER"].ToString().Trim().Substring(2);
//modify by 20130531
string value = "~21342056902~212" + readRow2["UDF_VALUE_HEADER"].ToString().Trim();// +"~m" + readRow2["UDF_VALUE_HEADER"].ToString().Trim().Length;
//string value1 = idEcode.UCC128(value).ToString();
string value1 = idEcode.Code128(value, true);
XmlElement xmlElemFileName4 = xmlDoc.CreateElement("VALUE");
XmlCDataSection cdata = xmlDoc.CreateCDataSection("VALUE");
cdata.InnerText = value1;
xmlElemFileName4.AppendChild(cdata);
KEY_HEADER_USPSDN_ENCODE.AppendChild(xmlElemFileName4);
xmlDoc.ChildNodes.Item(1).AppendChild(KEY_HEADER_USPSDN_ENCODE);
}
else if (readRow2["UDF_KEY_HEADER"].ToString() == "KEY_HEADER_ENDCUST_PO" )
{
XmlElement xmlElemFileName1 = xmlDoc.CreateElement("UDF_HEADER");
string key = readRow2["UDF_KEY_HEADER"].ToString().Trim();
XmlElement xmlElemFileName2 = xmlDoc.CreateElement("KEY");
xmlElemFileName2.InnerText = key;
xmlElemFileName1.AppendChild(xmlElemFileName2);
string KEY_HEADER_ENDCUST_PO_Value = readRow2["UDF_VALUE_HEADER"].ToString().Trim();
XmlElement VALUE = xmlDoc.CreateElement("VALUE");
VALUE.InnerText = KEY_HEADER_ENDCUST_PO_Value;
xmlElemFileName1.AppendChild(VALUE);
xmlDoc.ChildNodes.Item(1).AppendChild(xmlElemFileName1);
XmlElement KEY_HEADER_ENDCUST_PO_ENCODE = xmlDoc.CreateElement("UDF_HEADER");
XmlElement xmlElemFileName3 = xmlDoc.CreateElement("KEY");
xmlElemFileName3.InnerText = "KEY_HEADER_ENDCUST_PO_ENCODE";
KEY_HEADER_ENDCUST_PO_ENCODE.AppendChild(xmlElemFileName3);
string value = idEcode.Code128C(readRow2["UDF_VALUE_HEADER"].ToString().Trim()).ToString();
XmlElement xmlElemFileName4 = xmlDoc.CreateElement("VALUE");
XmlCDataSection cdata = xmlDoc.CreateCDataSection("VALUE");
cdata.InnerText = value;
xmlElemFileName4.AppendChild(cdata);
KEY_HEADER_ENDCUST_PO_ENCODE.AppendChild(xmlElemFileName4);
xmlDoc.ChildNodes.Item(1).AppendChild(KEY_HEADER_ENDCUST_PO_ENCODE);
}
else if (readRow2["UDF_KEY_HEADER"].ToString() == "KEY_HEADER_RETAIL_PROMO_MSG")
{
XmlElement xmlElemFileName1 = xmlDoc.CreateElement("UDF_HEADER");
string key = readRow2["UDF_KEY_HEADER"].ToString().Trim();
XmlElement xmlElemFileName2 = xmlDoc.CreateElement("KEY");
xmlElemFileName2.InnerText = key;
xmlElemFileName1.AppendChild(xmlElemFileName2);
string value = readRow2["UDF_VALUE_HEADER"].ToString().Trim() + " ";
XmlCDataSection cdata = xmlDoc.CreateCDataSection("VALUE");
cdata.InnerText = value;
XmlElement xmlElemFileName3 = xmlDoc.CreateElement("VALUE");
xmlElemFileName3.AppendChild(cdata);
xmlElemFileName1.AppendChild(xmlElemFileName3);
xmlDoc.ChildNodes.Item(1).AppendChild(xmlElemFileName1);
}
else
{
XmlElement xmlElemFileName1 = xmlDoc.CreateElement("UDF_HEADER");
string key = readRow2["UDF_KEY_HEADER"].ToString().Trim();
XmlElement xmlElemFileName2 = xmlDoc.CreateElement("KEY");
xmlElemFileName2.InnerText = key;
xmlElemFileName1.AppendChild(xmlElemFileName2);
string value = readRow2["UDF_VALUE_HEADER"].ToString().Trim();
XmlElement xmlElemFileName3 = xmlDoc.CreateElement("VALUE");
xmlElemFileName3.InnerText = value;
xmlElemFileName1.AppendChild(xmlElemFileName3);
xmlDoc.ChildNodes.Item(1).AppendChild(xmlElemFileName1);
}
}
#endregion
//xmlDoc.Save("E:\\cc2.xml");
}
string whereLneItemClause = "WHERE InternalID LIKE '" + internalID.Substring(0, 10) + "%'";
DataTable lineTable = DBFactory.PopulateTempTable("[v_Shipment_PAKComn]", whereLneItemClause, fields);
//xmlDoc.Load("E:\\cc2.xml");
XmlElement xmlElemFileName_1 = xmlDoc.CreateElement("PACK_ID_LINE_ITEM");
int index = 0;
int index2 = 0;
foreach (DataRow readRow in lineTable.Rows)
{
NewDataSet.PACK_ID_LINE_ITEMRow newLineRow = packingList.PACK_ID_LINE_ITEM.NewPACK_ID_LINE_ITEMRow();
newLineRow.PACK_ID_LINE_ITEM_Id = index;
Qty = Convert.ToDouble(readRow["PACK_ID_UNIT_QTY"]);
foreach (DataColumn column in packingList.PACK_ID_LINE_ITEM.Columns)
{
if (lineTable.Columns.Contains(column.ColumnName))
{
XmlElement xmlElemFileName2 = xmlDoc.CreateElement(column.ColumnName);
xmlElemFileName2.InnerText = readRow[column.ColumnName].ToString();
xmlElemFileName_1.AppendChild(xmlElemFileName2);
newLineRow[column] = readRow[column.ColumnName];
}
else
{
if (column.DataType == typeof(string))
newLineRow[column] = string.Empty;
else if (column.DataType == typeof(Double))
newLineRow[column] = 0;
else if (column.DataType == typeof(DateTime))
newLineRow[column] = string.Empty;
}
}
string whereWeightClause = "WHERE Model='" + lineTable.Rows[index]["Model"].ToString() + "'";
DataTable weightTable = DBFactory.PopulateTempTable("[PAK_SkuMasterWeight_FIS]", whereWeightClause, fields);
index++;
XmlElement xmlElemFileName3 = xmlDoc.CreateElement("EXTD_BOX_WEIGHT");
newLineRow.EXTD_BOX_WEIGHT = Convert.ToDouble(string.Format("{0:0.##}", newLineRow.PACK_ID_LINE_ITEM_BOX_QTY * Convert.ToDouble(weightTable.Rows[0]["Weight"])));
xmlElemFileName3.InnerText = newLineRow.EXTD_BOX_WEIGHT.ToString();
XmlElement xmlElemFileName4 = xmlDoc.CreateElement("PACK_ID_UNIT_UOM");
xmlElemFileName4.InnerText = "EA";
xmlElemFileName_1.AppendChild(xmlElemFileName3);
xmlElemFileName_1.AppendChild(xmlElemFileName4);
newLineRow.PACK_ID_UNIT_UOM = "EA";
newLineRow.PACK_ID_Id = newRow.PACK_ID_Id;
//packingList.PACK_ID_LINE_ITEM.Rows.Add(newLineRow);
// string where850Clause = "WHERE PO_NUM='" + readRow["PO_NUM"].ToString() + "' AND HP_PN_COMPONENT !='' order by HP_SO_LINE_ITEM ";
string where850Clause = "WHERE PO_NUM='" + readRow["PO_NUM"].ToString() + "' AND HP_PN_COMPONENT !='' and LINE_ITEM = '" + readRow["HP_SO_LINE_ITEM"].ToString() + "' order by HP_SO_LINE_ITEM ";
DataTable edi850Table = DBFactory.PopulateTempTable("[PAK.PAKEdi850raw]", where850Clause, fields);
foreach (DataRow ediRow in edi850Table.Rows)
{
NewDataSet.HP_PN_COMPONENTSRow newHPPNRow = packingList.HP_PN_COMPONENTS.NewHP_PN_COMPONENTSRow();
foreach (DataColumn column in packingList.HP_PN_COMPONENTS.Columns)
{
if (edi850Table.Columns.Contains(column.ColumnName))
{
XmlElement xmlElemFileName5 = xmlDoc.CreateElement(column.ColumnName);
xmlElemFileName5.InnerText = readRow[column.ColumnName].ToString();
xmlElemFileName_1.AppendChild(xmlElemFileName5);
newHPPNRow[column] = ediRow[column.ColumnName];
}
else
{
if (column.ColumnName == "COMPONENT_UNIT_QTY")
newHPPNRow[column] = ediRow["COMPONENT_QTY"];
else if (column.DataType == typeof(string))
newHPPNRow[column] = string.Empty;
else if (column.DataType == typeof(Double))
newHPPNRow[column] = 0;
else if (column.DataType == typeof(DateTime))
newHPPNRow[column] = string.Empty;
}
}
newHPPNRow.PACK_ID_LINE_ITEM_Id = newLineRow.PACK_ID_LINE_ITEM_Id;
//packingList.HP_PN_COMPONENTS.Rows.Add(newHPPNRow);
}
#region 生成DETAILL字段
string whereClause = "WHERE PO_NUM='" + pakTable.Rows[0]["PO_NUM"].ToString() + "'order by ID,VALUE";
DataTable miniTableName = DBFactory.PopulateTempTable("[v_PO_ITEM_DETAIL]", whereClause, fields);
double KEY_DETAIL_RETAIL_UNIT_SH = 0.00;
double KEY_DETAIL_RETAIL_ITEM_TAX = 0.00;
double KEY_DETAIL_RETAIL_ITEM_CR = 0.00;
double KEY_DETAIL_MERCHANDISE_PRICE_vaule = 0.00;
int flag_index = miniTableName.Rows.Count-1;
int flag_index_2=0;
/*
* if (flag_return) //non returnable 版本
{
string value = readRow_DETAIL["VALUE"].ToString().Trim();
XmlCDataSection cdata = xmlDoc.CreateCDataSection("VALUE");
cdata.InnerText = value;
UDF_DETAIL_VALUE.AppendChild(cdata);
UDF_DETAIL.AppendChild(UDF_DETAIL_VALUE);
}
else //regular 版本
{
UDF_DETAIL_VALUE.InnerText = readRow_DETAIL["VALUE"].ToString();
UDF_DETAIL.AppendChild(UDF_DETAIL_VALUE);
}
*
*
*
*
*/
foreach (DataRow readRow_DETAIL in miniTableName.Rows)
{
if (readRow_DETAIL["FIELDS"].ToString() == "KEY_DETAIL_RETAIL_UNIT_SH")
{
KEY_DETAIL_RETAIL_UNIT_SH = Convert.ToDouble(readRow_DETAIL["VALUE"].ToString());
XmlElement UDF_DETAIL = xmlDoc.CreateElement("UDF_DETAIL");
XmlElement UDF_DETAIL_KEY = xmlDoc.CreateElement("KEY");
UDF_DETAIL_KEY.InnerText = readRow_DETAIL["FIELDS"].ToString();
UDF_DETAIL.AppendChild(UDF_DETAIL_KEY);
XmlElement UDF_DETAIL_VALUE = xmlDoc.CreateElement("VALUE");
if (flag_return)
{
string value = readRow_DETAIL["VALUE"].ToString().Trim();
XmlCDataSection cdata = xmlDoc.CreateCDataSection("VALUE");
cdata.InnerText = value;
UDF_DETAIL_VALUE.AppendChild(cdata);
UDF_DETAIL.AppendChild(UDF_DETAIL_VALUE);
}
else
{
UDF_DETAIL_VALUE.InnerText = readRow_DETAIL["VALUE"].ToString();
UDF_DETAIL.AppendChild(UDF_DETAIL_VALUE);
}
xmlElemFileName_1.AppendChild(UDF_DETAIL);
}
else if (readRow_DETAIL["FIELDS"].ToString() == "KEY_DETAIL_RETAIL_ITEM_TAX")
{
KEY_DETAIL_RETAIL_ITEM_TAX = Convert.ToDouble(readRow_DETAIL["VALUE"].ToString());
XmlElement UDF_DETAIL = xmlDoc.CreateElement("UDF_DETAIL");
XmlElement UDF_DETAIL_KEY = xmlDoc.CreateElement("KEY");
UDF_DETAIL_KEY.InnerText = readRow_DETAIL["FIELDS"].ToString();
UDF_DETAIL.AppendChild(UDF_DETAIL_KEY);
XmlElement UDF_DETAIL_VALUE = xmlDoc.CreateElement("VALUE");
if (flag_return)
{
string value = readRow_DETAIL["VALUE"].ToString().Trim();
XmlCDataSection cdata = xmlDoc.CreateCDataSection("VALUE");
cdata.InnerText = value;
UDF_DETAIL_VALUE.AppendChild(cdata);
UDF_DETAIL.AppendChild(UDF_DETAIL_VALUE);
}
else
{
UDF_DETAIL_VALUE.InnerText = readRow_DETAIL["VALUE"].ToString();
UDF_DETAIL.AppendChild(UDF_DETAIL_VALUE);
}
xmlElemFileName_1.AppendChild(UDF_DETAIL);
}
else if (readRow_DETAIL["FIELDS"].ToString() == "KEY_DETAIL_RETAIL_ITEM_CR")
{
KEY_DETAIL_RETAIL_ITEM_CR = Convert.ToDouble(readRow_DETAIL["VALUE"].ToString());
XmlElement UDF_DETAIL = xmlDoc.CreateElement("UDF_DETAIL");
XmlElement UDF_DETAIL_KEY = xmlDoc.CreateElement("KEY");
UDF_DETAIL_KEY.InnerText = readRow_DETAIL["FIELDS"].ToString();
UDF_DETAIL.AppendChild(UDF_DETAIL_KEY);
XmlElement UDF_DETAIL_VALUE = xmlDoc.CreateElement("VALUE");
if (flag_return)
{
string value = readRow_DETAIL["VALUE"].ToString().Trim();
XmlCDataSection cdata = xmlDoc.CreateCDataSection("VALUE");
cdata.InnerText = value;
UDF_DETAIL_VALUE.AppendChild(cdata);
UDF_DETAIL.AppendChild(UDF_DETAIL_VALUE);
}
else
{
UDF_DETAIL_VALUE.InnerText = readRow_DETAIL["VALUE"].ToString();
UDF_DETAIL.AppendChild(UDF_DETAIL_VALUE);
}
xmlElemFileName_1.AppendChild(UDF_DETAIL);
}
else if (readRow_DETAIL["FIELDS"].ToString() == "KEY_DETAIL_RETAIL_UNIT_PRICE")
{
XmlElement KEY_DETAIL_RETAIL_UNIT_PRICE = xmlDoc.CreateElement("UDF_DETAIL");
XmlElement UDF_DETAIL_1_KEY = xmlDoc.CreateElement("KEY");
UDF_DETAIL_1_KEY.InnerText = readRow_DETAIL["FIELDS"].ToString();
KEY_DETAIL_RETAIL_UNIT_PRICE.AppendChild(UDF_DETAIL_1_KEY);
XmlElement UDF_DETAIL_1_VALUE = xmlDoc.CreateElement("VALUE");
if (flag_return)
{
string value = readRow_DETAIL["VALUE"].ToString().Trim();
XmlCDataSection cdata = xmlDoc.CreateCDataSection("VALUE");
cdata.InnerText = value;
UDF_DETAIL_1_VALUE.AppendChild(cdata);
KEY_DETAIL_RETAIL_UNIT_PRICE.AppendChild(UDF_DETAIL_1_VALUE);
}
else
{
UDF_DETAIL_1_VALUE.InnerText = readRow_DETAIL["VALUE"].ToString();
KEY_DETAIL_RETAIL_UNIT_PRICE.AppendChild(UDF_DETAIL_1_VALUE);
}
xmlElemFileName_1.AppendChild(KEY_DETAIL_RETAIL_UNIT_PRICE);
KEY_DETAIL_MERCHANDISE_PRICE_vaule = Convert.ToDouble(readRow_DETAIL["VALUE"]) * Qty;
XmlElement KEY_DETAIL_MERCHANDISE_PRICE = xmlDoc.CreateElement("UDF_DETAIL");
XmlElement UDF_DETAIL_KEY_2 = xmlDoc.CreateElement("KEY");
UDF_DETAIL_KEY_2.InnerText = "KEY_DETAIL_MERCHANDISE_PRICE";
KEY_DETAIL_MERCHANDISE_PRICE.AppendChild(UDF_DETAIL_KEY_2);
XmlElement UDF_DETAIL_VALUE_2 = xmlDoc.CreateElement("VALUE");
if (flag_return)
{
string value = KEY_DETAIL_MERCHANDISE_PRICE_vaule.ToString();
XmlCDataSection cdata = xmlDoc.CreateCDataSection("VALUE");
cdata.InnerText = value;
UDF_DETAIL_VALUE_2.AppendChild(cdata);
KEY_DETAIL_MERCHANDISE_PRICE.AppendChild(UDF_DETAIL_VALUE_2);
}
else
{
UDF_DETAIL_VALUE_2.InnerText = KEY_DETAIL_MERCHANDISE_PRICE_vaule.ToString();
KEY_DETAIL_MERCHANDISE_PRICE.AppendChild(UDF_DETAIL_VALUE_2);
}
xmlElemFileName_1.AppendChild(KEY_DETAIL_MERCHANDISE_PRICE);
}
else
{
XmlElement UDF_DETAIL = xmlDoc.CreateElement("UDF_DETAIL");
XmlElement UDF_DETAIL_KEY = xmlDoc.CreateElement("KEY");
UDF_DETAIL_KEY.InnerText = readRow_DETAIL["FIELDS"].ToString();
UDF_DETAIL.AppendChild(UDF_DETAIL_KEY);
XmlElement UDF_DETAIL_VALUE = xmlDoc.CreateElement("VALUE");
if (flag_return)
{
string value = readRow_DETAIL["VALUE"].ToString().Trim();
XmlCDataSection cdata = xmlDoc.CreateCDataSection("VALUE");
cdata.InnerText = value;
UDF_DETAIL_VALUE.AppendChild(cdata);
UDF_DETAIL.AppendChild(UDF_DETAIL_VALUE);
}
else
{
UDF_DETAIL_VALUE.InnerText = readRow_DETAIL["VALUE"].ToString();
UDF_DETAIL.AppendChild(UDF_DETAIL_VALUE);
}
xmlElemFileName_1.AppendChild(UDF_DETAIL);
}
if (flag_index_2 == flag_index)
{
double KEY_DETAIL_TOTAL_AMOUNT_PRICE_vaule = KEY_DETAIL_MERCHANDISE_PRICE_vaule + KEY_DETAIL_RETAIL_UNIT_SH + KEY_DETAIL_RETAIL_ITEM_TAX - KEY_DETAIL_RETAIL_ITEM_CR;
XmlElement KEY_DETAIL_TOTAL_AMOUNT_PRICE = xmlDoc.CreateElement("UDF_DETAIL");
XmlElement KEY_DETAIL_TOTAL_AMOUNT_PRICE_2 = xmlDoc.CreateElement("KEY");
KEY_DETAIL_TOTAL_AMOUNT_PRICE_2.InnerText = "KEY_DETAIL_TOTAL_AMOUNT_PRICE";
KEY_DETAIL_TOTAL_AMOUNT_PRICE.AppendChild(KEY_DETAIL_TOTAL_AMOUNT_PRICE_2);
XmlElement KEY_DETAIL_TOTAL_AMOUNT_PRICE_3 = xmlDoc.CreateElement("VALUE");
if (flag_return)
{
XmlCDataSection cdata = xmlDoc.CreateCDataSection("VALUE");
cdata.InnerText = KEY_DETAIL_TOTAL_AMOUNT_PRICE_vaule.ToString();
KEY_DETAIL_TOTAL_AMOUNT_PRICE_3.AppendChild(cdata);
KEY_DETAIL_TOTAL_AMOUNT_PRICE.AppendChild(KEY_DETAIL_TOTAL_AMOUNT_PRICE_3);
}
else
{
KEY_DETAIL_TOTAL_AMOUNT_PRICE_3.InnerText = KEY_DETAIL_TOTAL_AMOUNT_PRICE_vaule.ToString();
KEY_DETAIL_TOTAL_AMOUNT_PRICE.AppendChild(KEY_DETAIL_TOTAL_AMOUNT_PRICE_3);
}
xmlElemFileName_1.AppendChild(KEY_DETAIL_TOTAL_AMOUNT_PRICE);
}
else {
flag_index_2++;
}
}
#endregion
string whereBoxClause = "WHERE InternalID='" + readRow["InternalID"].ToString() + "'";
DataTable boxTable = DBFactory.PopulateTempTable("[PAK_PackkingData]", whereBoxClause, fields);
XmlElement box = xmlDoc.CreateElement("BOX");
if (boxTable.Rows.Count == 0)
{
NewDataSet.BOXRow newBoxRowPacking = packingList.BOX.NewBOXRow();
newBoxRowPacking.BOX_ID = "PACKING";
newBoxRowPacking.BOX_Id_0 = index2;
newBoxRowPacking.BOX_WEIGHT = Convert.ToDouble(weightTable.Rows[0]["Weight"]);
newBoxRowPacking.BOX_UNIT_QTY = Convert.ToDouble(pakTable.Rows[0]["BOX_UNIT_QTY"]);
newBoxRowPacking.BOX_WEIGHT_UOM = "KG";
newBoxRowPacking.PACK_ID_LINE_ITEM_Id = newLineRow.PACK_ID_LINE_ITEM_Id;
newBoxRowPacking.TRACK_NO_PARCEL = string.Empty;
//packingList.BOX.Rows.Add(newBoxRowPacking);
NewDataSet.SERIAL_NUMRow newSerialRowPacking = packingList.SERIAL_NUM.NewSERIAL_NUMRow();
newSerialRowPacking.BOX_Id_0 = index2;
newSerialRowPacking.SERIAL_NUM_Column = string.Empty;
//packingList.SERIAL_NUM.Rows.Add(newSerialRowPacking);
index2++;
}
else
{
foreach (DataRow readRow2 in boxTable.Rows)
{
NewDataSet.BOXRow newBoxRow = packingList.BOX.NewBOXRow();
newBoxRow.BOX_ID = readRow2["BOX_ID"].ToString().Trim();
newBoxRow.BOX_Id_0 = index2;
newBoxRow.BOX_WEIGHT = Convert.ToDouble(weightTable.Rows[0]["Weight"]);
newBoxRow.BOX_UNIT_QTY = Convert.ToDouble(pakTable.Rows[0]["BOX_UNIT_QTY"]);
newBoxRow.BOX_WEIGHT_UOM = "KG";
newBoxRow.PACK_ID_LINE_ITEM_Id = newLineRow.PACK_ID_LINE_ITEM_Id;
newBoxRow.TRACK_NO_PARCEL = readRow2["TRACK_NO_PARCEL"].ToString().Trim();
//packingList.BOX.Rows.Add(newBoxRow);
NewDataSet.SERIAL_NUMRow newSerialRow = packingList.SERIAL_NUM.NewSERIAL_NUMRow();
newSerialRow.BOX_Id_0 = index2;
newSerialRow.SERIAL_NUM_Column = readRow2["SERIAL_NUM"].ToString().Trim();
//packingList.SERIAL_NUM.Rows.Add(newSerialRow);
index2++;
XmlElement box1 = xmlDoc.CreateElement("BOX_ID");
box1.InnerText = readRow2["BOX_ID"].ToString().Trim();
box.AppendChild(box1);
XmlElement box2 = xmlDoc.CreateElement("BOX_UNIT_QTY");
box2.InnerText = Convert.ToDouble(pakTable.Rows[0]["BOX_UNIT_QTY"]).ToString();
box.AppendChild(box2);
XmlElement box3 = xmlDoc.CreateElement("SERIAL_NUM");
box3.InnerText = readRow2["SERIAL_NUM"].ToString().Trim();
box.AppendChild(box3);
XmlElement box4 = xmlDoc.CreateElement("TRACK_NO_PARCEL");
box4.InnerText = readRow2["TRACK_NO_PARCEL"].ToString().Trim();
box.AppendChild(box4);
XmlElement box5 = xmlDoc.CreateElement("BOX_WEIGHT");
box5.InnerText = Convert.ToDouble(weightTable.Rows[0]["Weight"]).ToString();
box.AppendChild(box5);
xmlElemFileName_1.AppendChild(box);
xmlDoc.ChildNodes.Item(1).AppendChild(xmlElemFileName_1);
//xmlDoc.Save("E:\\cc2.xml");
}
}
}
XmlTextWriter tr = new XmlTextWriter(xmlpath, null);
tr.Formatting = Formatting.Indented;
xmlDoc.WriteContentTo(tr);
tr.Close();
}
public void LoadPackingListDatabaseData(string id)
{
logger.Debug("LoadPackingListDatabaseData begin id="+id);
string[] idSplit = id.Split(@"/".ToCharArray());
string internalID = idSplit[0];
string Tp = idSplit[1];
//fill packID table
//--------------------- add by fan 20100107 ----------
string Type = "";
/*
string whereTDcheck = "'" + internalID + "','" + Tp + "','2'";
DataTable TDcheckTable = DBFactory.PopulateTempTable_BySp("[op_TwoDCode_Check]", whereTDcheck);
*/
logger.Debug("LoadPackingListDatabaseData op_TwoDCode_Check begin");
DataTable TDcheckTable = EditsSqlProc.sp__op_TwoDCode_Check(internalID, Tp, "2");
logger.Debug("LoadPackingListDatabaseData op_TwoDCode_Check end");
ChkRowNotNull("PackListShipmentXmlCreator id=" + id + ", op_TwoDCode_Check internalID=" + internalID + ", docs=" + Tp + ", tp=2", TDcheckTable);
Type = TDcheckTable.Rows[0][0].ToString().Trim();
//-------------------- end -----------------------------
NewDataSet packingList = new NewDataSet();
/*
string whereMainClause = "WHERE InternalID='" + internalID + "'";
List<string> fields = new List<string>();
fields.Add("*");
DataTable pakTable = DBFactory.PopulateTempTable("[v_Shipment_PackList]", whereMainClause, fields);
*/
logger.Debug("LoadPackingListDatabaseData v_Shipment_PackList begin");
DataTable pakTable = EditsSqlProc.v_Shipment_PackList__by__InternalID(internalID);
ChkRowNotNull("PackListShipmentXmlCreator id=" + id + ", v_Shipment_PackList internalID=" + internalID, pakTable);
logger.Debug("LoadPackingListDatabaseData v_Shipment_PackList end");
NewDataSet.PACK_IDRow newRow = packingList.PACK_ID.NewPACK_IDRow();
newRow.PACK_ID_Id = 1;
foreach (DataColumn column in packingList.PACK_ID.Columns)
{
if (pakTable.Columns.Contains(column.ColumnName)&& column.ColumnName != "PACK_ID_PALLET_QTY")
{
//ChkRowNotNull("PackListShipmentXmlCreator id=" + id + ", v_Shipment_PackList", pakTable);
//if table contains name, then populate
newRow[column] = pakTable.Rows[0][column.ColumnName];
}
else if (column.ColumnName == "PACK_ID_PALLET_QTY")
{
//ChkRowNotNull("PackListShipmentXmlCreator id=" + id + ", v_Shipment_PackList", pakTable);
double Pallet_Qty;
Pallet_Qty = Convert.ToDouble(pakTable.Rows[0][column.ColumnName]);
if (Pallet_Qty > -1)
{
newRow[column] = pakTable.Rows[0][column.ColumnName];
}
}
else
{
if (column.DataType == typeof(string))
newRow[column] = string.Empty;
else if (column.DataType == typeof(Double))
newRow[column] = 0;
else if (column.DataType == typeof(DateTime))
newRow[column] = string.Empty;
}
}
packingList.PACK_ID.Rows.Add(newRow);
//HAWB_BOX_QTY
//string whereClause = "'" + id.Substring(0,10)+ "'";
//DataTable HAWBBOXTable = DBFactory.PopulateTempTable_BySp("op_GETHAWB_BOX_QTY",whereClause);
//newRow["HAWB_BOX_QTY"] = HAWBBOXTable.Rows[0][0];
//HAWB_UNIT_QTY
//DataTable HAWBUNITTable = DBFactory.PopulateTempTable_BySp("op_GETHAWB_UNIT_QTY", whereClause);
//newRow["HAWB_UNIT_QTY"] = HAWBUNITTable.Rows[0][0];
//get line item
/*
string whereLneItemClause = "WHERE InternalID LIKE '" + internalID.Substring(0, 10) + "%'";
DataTable lineTable = DBFactory.PopulateTempTable("[v_Shipment_PAKComn]", whereLneItemClause, fields);
*/
logger.Debug("LoadPackingListDatabaseData v_Shipment_PAKComn begin");
DataTable lineTable = EditsSqlProc.v_Shipment_PAKComn__like__InternalID(internalID.Substring(0, 10) + "%");
//DataTable lineTable = EditsSqlProc.v_Shipment_PAKComn__like__InternalID(internalID.ToString() + "%");
logger.Debug("LoadPackingListDatabaseData v_Shipment_PAKComn end");
int index = 0;
int index2 = 0;
foreach (DataRow readRow in lineTable.Rows)
{
NewDataSet.PACK_ID_LINE_ITEMRow newLineRow = packingList.PACK_ID_LINE_ITEM.NewPACK_ID_LINE_ITEMRow();
newLineRow.PACK_ID_LINE_ITEM_Id = index;
foreach (DataColumn column in packingList.PACK_ID_LINE_ITEM.Columns)
{
if (lineTable.Columns.Contains(column.ColumnName))
{
newLineRow[column] = readRow[column.ColumnName];
}
else
{
if (column.DataType == typeof(string))
newLineRow[column] = string.Empty;
else if (column.DataType == typeof(Double))
newLineRow[column] = 0;
else if (column.DataType == typeof(DateTime))
newLineRow[column] = string.Empty;
}
}
/*
string whereWeightClause = "WHERE Model='" + lineTable.Rows[index]["Model"].ToString() + "'";
DataTable weightTable = DBFactory.PopulateTempTable("[PAK_SkuMasterWeight_FIS]", whereWeightClause, fields);
*/
logger.Debug("LoadPackingListDatabaseData PAK_SkuMasterWeight_FIS begin");
DataTable weightTable = EditsSqlProc.PAK_SkuMasterWeight_FIS__by__Model(lineTable.Rows[index]["Model"].ToString());
logger.Debug("LoadPackingListDatabaseData PAK_SkuMasterWeight_FIS end");
ChkRowNotNull("PackListShipmentXmlCreator id=" + id + ", PAK_SkuMasterWeight_FIS Model=" + lineTable.Rows[index]["Model"].ToString(), weightTable);
index++;
newLineRow.EXTD_BOX_WEIGHT = Convert.ToDouble(string.Format("{0:0.##}", newLineRow.PACK_ID_LINE_ITEM_UNIT_QTY * Convert.ToDouble(weightTable.Rows[0]["Weight"])));
newLineRow.PACK_ID_UNIT_UOM = "EA";
newLineRow.PACK_ID_Id = newRow.PACK_ID_Id;
packingList.PACK_ID_LINE_ITEM.Rows.Add(newLineRow);
// string where850Clause = "WHERE PO_NUM='" + readRow["PO_NUM"].ToString() + "' AND HP_PN_COMPONENT !='' order by HP_SO_LINE_ITEM ";
/*
string where850Clause = "WHERE PO_NUM='" + readRow["PO_NUM"].ToString() + "' AND HP_PN_COMPONENT !='' and LINE_ITEM = '" + readRow["HP_SO_LINE_ITEM"].ToString() + "' order by HP_SO_LINE_ITEM ";
DataTable edi850Table = DBFactory.PopulateTempTable("[PAK.PAKEdi850raw]", where850Clause, fields);
*/
logger.Debug("LoadPackingListDatabaseData PAK.PAKEdi850raw begin");
DataTable edi850Table = EditsSqlProc.PAK_PAKEdi850raw__by__PO_NUM__LINE_ITEM(readRow["PO_NUM"].ToString(), readRow["HP_SO_LINE_ITEM"].ToString());
logger.Debug("LoadPackingListDatabaseData PAK.PAKEdi850raw end");
foreach (DataRow ediRow in edi850Table.Rows)
{
NewDataSet.HP_PN_COMPONENTSRow newHPPNRow = packingList.HP_PN_COMPONENTS.NewHP_PN_COMPONENTSRow();
foreach (DataColumn column in packingList.HP_PN_COMPONENTS.Columns)
{
if (edi850Table.Columns.Contains(column.ColumnName))
{
newHPPNRow[column] = ediRow[column.ColumnName];
}
else
{
if (column.ColumnName == "COMPONENT_UNIT_QTY")
newHPPNRow[column] = ediRow["COMPONENT_QTY"];
else if (column.DataType == typeof(string))
newHPPNRow[column] = string.Empty;
else if (column.DataType == typeof(Double))
newHPPNRow[column] = 0;
else if (column.DataType == typeof(DateTime))
newHPPNRow[column] = string.Empty;
}
}
newHPPNRow.PACK_ID_LINE_ITEM_Id = newLineRow.PACK_ID_LINE_ITEM_Id;
packingList.HP_PN_COMPONENTS.Rows.Add(newHPPNRow);
}
/*
LoadMiniTable_Detail(packingList.EXPORT_NOTES_DETAIL,
"EXPORT_NOTES_DETAIL_Column",
"",
"PACK_ID_LINE_ITEM_Id",
newLineRow.PACK_ID_LINE_ITEM_Id,
"WHERE PO_NUM='" + pakTable.Rows[0]["PO_NUM"].ToString() + "' and FIELDS = 'EXPORT_NOTES_DETAIL' order by ID", "VALUE");
LoadMiniTable_Detail(packingList.SHIPPING_INSTR_DETAIL,
"SHIPPING_INSTR_DETAIL_Column",
"",
"PACK_ID_LINE_ITEM_Id",
newLineRow.PACK_ID_LINE_ITEM_Id,
"WHERE PO_NUM='" + pakTable.Rows[0]["PO_NUM"].ToString() + "' and FIELDS = 'SHIPPING_INSTR_DETAIL' order by ID", "VALUE");
LoadMiniTable_Detail(packingList.PICKING_INSTR_DETAIL,
"PICKING_INSTR_DETAIL_Column",
"",
"PACK_ID_LINE_ITEM_Id",
newLineRow.PACK_ID_LINE_ITEM_Id,
"WHERE PO_NUM='" + pakTable.Rows[0]["PO_NUM"].ToString() + "' and FIELDS = 'PICKING_INSTR_DETAIL' order by ID", "VALUE");
LoadMiniTable_Detail(packingList.DELIVERY_INSTR_DETAIL,
"DELIVERY_INSTR_DETAIL_Column",
"",
"PACK_ID_LINE_ITEM_Id",
newLineRow.PACK_ID_LINE_ITEM_Id,
"WHERE PO_NUM='" + pakTable.Rows[0]["PO_NUM"].ToString() + "' and FIELDS = 'DELIVERY_INSTR_DETAIL' order by ID", "VALUE");
LoadMiniTable_Detail(packingList.SPECIAL_INSTR_DETAIL,
"SPECIAL_INSTR_DETAIL_Column",
"",
"PACK_ID_LINE_ITEM_Id",
newLineRow.PACK_ID_LINE_ITEM_Id,
"WHERE PO_NUM='" + readRow["PO_NUM"].ToString() + "' and PO_ITEM = '" + readRow["C26"].ToString().Substring(1, 5) + "'and FIELDS = 'SPECIAL_INSTR_DETAIL' order by ID", "VALUE");
LoadMiniTable_Detail(packingList.CUSTOMER_INSTR_DETAIL,
"CUSTOMER_INSTR_DETAIL_Column",
"",
"PACK_ID_LINE_ITEM_Id",
newLineRow.PACK_ID_LINE_ITEM_Id,
"WHERE PO_NUM='" + pakTable.Rows[0]["PO_NUM"].ToString() + "' and FIELDS = 'CUSTOMER_INSTR_DETAIL' order by ID", "VALUE");
LoadMiniTable_Detail(packingList.HANDLING_INSTR_DETAIL,
"HANDLING_INSTR_DETAIL_Column",
"",
"PACK_ID_LINE_ITEM_Id",
newLineRow.PACK_ID_LINE_ITEM_Id,
"WHERE PO_NUM='" + pakTable.Rows[0]["PO_NUM"].ToString() + "' and FIELDS = 'HANDLING_INSTR_DETAIL' order by ID", "VALUE");
LoadMiniTable_Detail(packingList.UID_INSTR_DETAIL,
"UID_INSTR_DETAIL_Column",
"",
"PACK_ID_LINE_ITEM_Id",
newLineRow.PACK_ID_LINE_ITEM_Id,
"WHERE PO_NUM='" + pakTable.Rows[0]["PO_NUM"].ToString() + "' and FIELDS = 'UID_INSTR_DETAIL' order by ID", "VALUE");
LoadMiniTable_Detail(packingList.CONFIG_INSTR_DETAIL,
"CONFIG_INSTR_DETAIL_Column",
"",
"PACK_ID_LINE_ITEM_Id",
newLineRow.PACK_ID_LINE_ITEM_Id,
"WHERE PO_NUM='" + pakTable.Rows[0]["PO_NUM"].ToString() + "' and FIELDS = 'CONFIG_INSTR_DETAIL' order by ID", "VALUE");
LoadMiniTable_Detail(packingList.MAXKIT_DETAIL,
"MAXKIT_DETAIL_Column",
"",
"PACK_ID_LINE_ITEM_Id",
newLineRow.PACK_ID_LINE_ITEM_Id,
"WHERE PO_NUM='" + pakTable.Rows[0]["PO_NUM"].ToString() + "' and FIELDS = 'MAXKIT_DETAIL' order by ID", "VALUE");
*/
LoadMiniTable_Detail__by__PO_NUM__FIELDS(packingList.EXPORT_NOTES_DETAIL,
"EXPORT_NOTES_DETAIL_Column",
"",
"PACK_ID_LINE_ITEM_Id",
newLineRow.PACK_ID_LINE_ITEM_Id,
"VALUE", pakTable.Rows[0]["PO_NUM"].ToString(), "EXPORT_NOTES_DETAIL");
LoadMiniTable_Detail__by__PO_NUM__FIELDS(packingList.SHIPPING_INSTR_DETAIL,
"SHIPPING_INSTR_DETAIL_Column",
"",
"PACK_ID_LINE_ITEM_Id",
newLineRow.PACK_ID_LINE_ITEM_Id,
"VALUE", pakTable.Rows[0]["PO_NUM"].ToString(), "SHIPPING_INSTR_DETAIL");
LoadMiniTable_Detail__by__PO_NUM__FIELDS(packingList.PICKING_INSTR_DETAIL,
"PICKING_INSTR_DETAIL_Column",
"",
"PACK_ID_LINE_ITEM_Id",
newLineRow.PACK_ID_LINE_ITEM_Id,
"VALUE", pakTable.Rows[0]["PO_NUM"].ToString(), "PICKING_INSTR_DETAIL");
LoadMiniTable_Detail__by__PO_NUM__FIELDS(packingList.DELIVERY_INSTR_DETAIL,
"DELIVERY_INSTR_DETAIL_Column",
"",
"PACK_ID_LINE_ITEM_Id",
newLineRow.PACK_ID_LINE_ITEM_Id,
"VALUE", pakTable.Rows[0]["PO_NUM"].ToString(), "DELIVERY_INSTR_DETAIL");
LoadMiniTable_Detail__by__PO_NUM__PO_ITEM__FIELDS(packingList.SPECIAL_INSTR_DETAIL,
"SPECIAL_INSTR_DETAIL_Column",
"",
"PACK_ID_LINE_ITEM_Id",
newLineRow.PACK_ID_LINE_ITEM_Id,
"VALUE", readRow["PO_NUM"].ToString(), readRow["C26"].ToString().Substring(1, 5), "SPECIAL_INSTR_DETAIL");
LoadMiniTable_Detail__by__PO_NUM__FIELDS(packingList.CUSTOMER_INSTR_DETAIL,
"CUSTOMER_INSTR_DETAIL_Column",
"",
"PACK_ID_LINE_ITEM_Id",
newLineRow.PACK_ID_LINE_ITEM_Id,
"VALUE", pakTable.Rows[0]["PO_NUM"].ToString(), "CUSTOMER_INSTR_DETAIL");
LoadMiniTable_Detail__by__PO_NUM__FIELDS(packingList.HANDLING_INSTR_DETAIL,
"HANDLING_INSTR_DETAIL_Column",
"",
"PACK_ID_LINE_ITEM_Id",
newLineRow.PACK_ID_LINE_ITEM_Id,
"VALUE", pakTable.Rows[0]["PO_NUM"].ToString(), "HANDLING_INSTR_DETAIL");
LoadMiniTable_Detail__by__PO_NUM__FIELDS(packingList.UID_INSTR_DETAIL,
"UID_INSTR_DETAIL_Column",
"",
"PACK_ID_LINE_ITEM_Id",
newLineRow.PACK_ID_LINE_ITEM_Id,
"VALUE", pakTable.Rows[0]["PO_NUM"].ToString(), "UID_INSTR_DETAIL");
LoadMiniTable_Detail__by__PO_NUM__FIELDS(packingList.CONFIG_INSTR_DETAIL,
"CONFIG_INSTR_DETAIL_Column",
"",
"PACK_ID_LINE_ITEM_Id",
newLineRow.PACK_ID_LINE_ITEM_Id,
"VALUE", pakTable.Rows[0]["PO_NUM"].ToString(), "CONFIG_INSTR_DETAIL");
LoadMiniTable_Detail__by__PO_NUM__FIELDS(packingList.MAXKIT_DETAIL,
"MAXKIT_DETAIL_Column",
"",
"PACK_ID_LINE_ITEM_Id",
newLineRow.PACK_ID_LINE_ITEM_Id,
"VALUE", pakTable.Rows[0]["PO_NUM"].ToString(), "MAXKIT_DETAIL");
/*
LoadKeyValuePairs(packingList.UDF_DETAIL,
null,
"UDF_KEY_DETAIL",
"UDF_VALUE_DETAIL",
"PACK_ID_LINE_ITEM_Id",
newLineRow.PACK_ID_LINE_ITEM_Id,
"WHERE PO_NUM='" + readRow["PO_NUM"].ToString() + "'");
*/
//populate box information
/*
string whereBoxClause = "WHERE InternalID='" + readRow["InternalID"].ToString() + "'";
DataTable boxTable = DBFactory.PopulateTempTable("[PAK_PackkingData]", whereBoxClause, fields);
*/
logger.Debug("LoadPackingListDatabaseData PAK_PackkingData begin");
DataTable boxTable = EditsSqlProc.PAK_PackkingData__by__InternalID(readRow["InternalID"].ToString());
logger.Debug("LoadPackingListDatabaseData PAK_PackkingData end");
if (boxTable.Rows.Count == 0)
{
NewDataSet.BOXRow newBoxRowPacking = packingList.BOX.NewBOXRow();
newBoxRowPacking.BOX_ID = "PACKING";
newBoxRowPacking.BOX_Id_0 = index2;
newBoxRowPacking.BOX_WEIGHT = Convert.ToDouble(weightTable.Rows[0]["Weight"]);
newBoxRowPacking.BOX_UNIT_QTY = Convert.ToDouble(pakTable.Rows[0]["BOX_UNIT_QTY"]);
newBoxRowPacking.BOX_WEIGHT_UOM = "KG";
newBoxRowPacking.PACK_ID_LINE_ITEM_Id = newLineRow.PACK_ID_LINE_ITEM_Id;
newBoxRowPacking.TRACK_NO_PARCEL = string.Empty;
packingList.BOX.Rows.Add(newBoxRowPacking);
NewDataSet.SERIAL_NUMRow newSerialRowPacking = packingList.SERIAL_NUM.NewSERIAL_NUMRow();
newSerialRowPacking.BOX_Id_0 = index2;
newSerialRowPacking.SERIAL_NUM_Column = string.Empty;
packingList.SERIAL_NUM.Rows.Add(newSerialRowPacking);
// DataSet ds = LoadTwoD(internalID);------------------------encoding---------------------
/* if (Type == "Y")
{
string whereTwoDP = "'" + id + "','" + readRow2["BOX_ID"].ToString() + "'";
DataTable TwoDPTable = DBFactory.PopulateTempTable_BySp("[op_TwoDCode_Solution_packlist]", whereTwoDP);
string EnCoding = TwoDPTable.Rows[0]["EnCoding"].ToString(); // Y/N
string EnCoder = TwoDPTable.Rows[0]["EnCoder"].ToString(); //PDF417/MaxICode
string StringIDValue = "";
if (EnCoding == "Y")
{
//encoder
if (EnCoder == "PDF417")
{
//PDF417 generator
//StringIDValue = TransferCode.Encoder(TwoDTable.Rows[0]["StringIDValue"].ToString());
foreach (DataRow readRowtd in TwoDPTable.Rows)
{
NewDataSet.UDF_BOXRow newRowtwod = packingList.UDF_BOX.NewUDF_BOXRow();
StringIDValue = TransferCode.Encoder(readRowtd["StringIDValue"].ToString());
newRowtwod.KEY = readRowtd["StringIDKey"].ToString();
newRowtwod.VALUE = StringIDValue.ToString();
newRowtwod.BOX_Id_0 = index2;
packingList.UDF_BOX.Rows.Add(newRowtwod);
}
}
else //MaxICode
{
//MaxICode generator
}
}
else
{
foreach (DataRow readRowtd in TwoDPTable.Rows)
{
NewDataSet.UDF_BOXRow newRowtwod = packingList.UDF_BOX.NewUDF_BOXRow();
newRowtwod.KEY = readRowtd["StringIDKey"].ToString();
newRowtwod.VALUE = readRowtd["StringIDValue"].ToString();
newRowtwod.BOX_Id_0 = index2;
packingList.UDF_BOX.Rows.Add(newRowtwod);
}
}
}*/
//----------------------- end --------------------------------------------------------------
index2++;
}
else
{
foreach (DataRow readRow2 in boxTable.Rows)
{
NewDataSet.BOXRow newBoxRow = packingList.BOX.NewBOXRow();
newBoxRow.BOX_ID = readRow2["BOX_ID"].ToString().Trim();
newBoxRow.BOX_Id_0 = index2;
newBoxRow.BOX_WEIGHT = Convert.ToDouble(weightTable.Rows[0]["Weight"]);
newBoxRow.BOX_UNIT_QTY = Convert.ToDouble(pakTable.Rows[0]["BOX_UNIT_QTY"]);
newBoxRow.BOX_WEIGHT_UOM = "KG";
newBoxRow.PACK_ID_LINE_ITEM_Id = newLineRow.PACK_ID_LINE_ITEM_Id;
newBoxRow.TRACK_NO_PARCEL = readRow2["TRACK_NO_PARCEL"].ToString().Trim();
packingList.BOX.Rows.Add(newBoxRow);
////LoadMiniTable(packingList.SERIAL_NUM,
// "SERIAL_NUM_Column",
// readRow2["SERIAL_NUM_Column"].ToString(),
// "BOX_Id_0",
// index2);
NewDataSet.SERIAL_NUMRow newSerialRow = packingList.SERIAL_NUM.NewSERIAL_NUMRow();
newSerialRow.BOX_Id_0 = index2;
newSerialRow.SERIAL_NUM_Column = readRow2["SERIAL_NUM"].ToString().Trim();
packingList.SERIAL_NUM.Rows.Add(newSerialRow);
// DataSet ds = LoadTwoD(internalID);------------------------encoding---------------------
if (Type == "Y")
{
/*
string whereTwoDP = "'" + internalID + "','" + readRow2["BOX_ID"].ToString() + "','" + Tp + "'";
DataTable TwoDPTable = DBFactory.PopulateTempTable_BySp("[op_TwoDCode_Solution_packlist]", whereTwoDP);
*/
logger.Debug("LoadPackingListDatabaseData op_TwoDCode_Solution_packlist begin");
DataTable TwoDPTable = EditsSqlProc.sp__op_TwoDCode_Solution_packlist(internalID, readRow2["BOX_ID"].ToString(), Tp);
logger.Debug("LoadPackingListDatabaseData op_TwoDCode_Solution_packlist end");
ChkRowNotNull("PackListShipmentXmlCreator id=" + id + ", op_TwoDCode_Solution_packlist internalID=" + internalID + ", boxid=" + readRow2["BOX_ID"].ToString() + ", tp=" + Tp, TwoDPTable);
string EnCoding = TwoDPTable.Rows[0]["EnCoding"].ToString(); // Y/N
string EnCoder = TwoDPTable.Rows[0]["EnCoder"].ToString(); //PDF417/MaxICode
string StringIDValue = "";
if (EnCoding == "Y")
{
//encoder
if (EnCoder == "PDF417")
{
//20130314
/*
//PDF417 generator
//StringIDValue = TransferCode.Encoder(TwoDTable.Rows[0]["StringIDValue"].ToString());
foreach (DataRow readRowtd in TwoDPTable.Rows)
{
NewDataSet.UDF_BOXRow newRowtwod = packingList.UDF_BOX.NewUDF_BOXRow();
StringIDValue = TransferCode.Encoder(readRowtd["StringIDValue"].ToString());
newRowtwod.KEY = readRowtd["StringIDKey"].ToString();
newRowtwod.VALUE = StringIDValue.ToString();
newRowtwod.BOX_Id_0 = index2;
packingList.UDF_BOX.Rows.Add(newRowtwod);
}
*/
}
else //MaxICode
{
//MaxICode generator
}
}
else
{
foreach (DataRow readRowtd in TwoDPTable.Rows)
{
NewDataSet.UDF_BOXRow newRowtwod = packingList.UDF_BOX.NewUDF_BOXRow();
newRowtwod.KEY = readRowtd["StringIDKey"].ToString();
newRowtwod.VALUE = readRowtd["StringIDValue"].ToString();
newRowtwod.BOX_Id_0 = index2;
packingList.UDF_BOX.Rows.Add(newRowtwod);
}
}
}
//----------------------- end --------------------------------------------------------------
index2++;
}
}
}
/*
LoadMiniTable_PACK(packingList.EXPORT_NOTES_HEAD,
"EXPORT_NOTES_HEAD_Column",
"",
"PACK_ID_Id",
newRow.PACK_ID_Id,
"WHERE PO_NUM='" + pakTable.Rows[0]["PO_NUM"].ToString() + "' and FIELDS = 'EXPORT_NOTES_HEAD' order by ID", "VALUE");
LoadMiniTable_PACK(packingList.SHIPPING_INSTR_HEAD,
"SHIPPING_INSTR_HEAD_Column",
"",
"PACK_ID_Id",
newRow.PACK_ID_Id,
"WHERE PO_NUM='" + pakTable.Rows[0]["PO_NUM"].ToString() + "' and FIELDS = 'SHIPPING_INSTR_HEAD' order by ID", "VALUE");
LoadMiniTable_PACK(packingList.PICKING_INSTR_HEAD,
"PICKING_INSTR_HEAD_Column",
"",
"PACK_ID_Id",
newRow.PACK_ID_Id,
"WHERE PO_NUM='" + pakTable.Rows[0]["PO_NUM"].ToString() + "' and FIELDS = 'PICKING_INSTR_HEAD' order by ID", "VALUE");
LoadMiniTable_PACK(packingList.DELIVERY_INSTR_HEAD,
"DELIVERY_INSTR_HEAD_Column",
"",
"PACK_ID_Id",
newRow.PACK_ID_Id,
"WHERE PO_NUM='" + pakTable.Rows[0]["PO_NUM"].ToString() + "' and FIELDS = 'DELIVERY_INSTR_HEAD' order by ID", "VALUE");
LoadMiniTable_PACK(packingList.SPECIAL_INSTR_HEAD,
"SPECIAL_INSTR_HEAD_Column",
"",
"PACK_ID_Id",
newRow.PACK_ID_Id,
"WHERE PO_NUM='" + pakTable.Rows[0]["PO_NUM"].ToString() + "' and FIELDS = 'SPECIAL_INSTR_HEAD' order by ID", "VALUE");
LoadMiniTable_PACK(packingList.CUSTOMER_INSTR_HEAD,
"CUSTOMER_INSTR_HEAD_Column",
"",
"PACK_ID_Id",
newRow.PACK_ID_Id,
"WHERE PO_NUM='" + pakTable.Rows[0]["PO_NUM"].ToString() + "' and FIELDS = 'CUSTOMER_INSTR_HEAD' order by ID", "VALUE");
LoadMiniTable_PACK(packingList.LABEL_INSTR_HEAD,
"LABEL_INSTR_HEAD_Column",
"",
"PACK_ID_Id",
newRow.PACK_ID_Id,
"WHERE PO_NUM='" + pakTable.Rows[0]["PO_NUM"].ToString() + "' and FIELDS = 'LABEL_INSTR_HEAD' order by ID", "VALUE");
LoadMiniTable_PACK(packingList.CARRIER_INST_HEAD,
"CARRIER_INST_HEAD_Column",
"",
"PACK_ID_Id",
newRow.PACK_ID_Id,
"WHERE PO_NUM='" + pakTable.Rows[0]["PO_NUM"].ToString() + "' and FIELDS = 'CARRIER_INST_HEAD' order by ID", "VALUE");
LoadMiniTable_PACK(packingList.HANDLING_INSTR_HEAD,
"HANDLING_INSTR_HEAD_Column",
"",
"PACK_ID_Id",
newRow.PACK_ID_Id,
"WHERE PO_NUM='" + pakTable.Rows[0]["PO_NUM"].ToString() + "' and FIELDS = 'HANDLING_INSTR_HEAD' order by ID", "VALUE");
LoadMiniTable_PACK(packingList.INVOICE_UDF_HEAD,
"INVOICE_UDF_HEAD_Column",
"",
"PACK_ID_Id",
newRow.PACK_ID_Id,
"WHERE PO_NUM='" + pakTable.Rows[0]["PO_NUM"].ToString() + "' and FIELDS = 'INVOICE_UDF_HEAD' order by ID", "VALUE");
LoadMiniTable_PACK(packingList.UDF_HEAD,
"UDF_HEAD_Column",
"",
"PACK_ID_Id",
newRow.PACK_ID_Id,
"WHERE PO_NUM='" + pakTable.Rows[0]["PO_NUM"].ToString() + "' and FIELDS = 'UDF_HEAD' order by ID", "VALUE");
*/
LoadMiniTable_PACK__by__PO_NUM__FIELDS(packingList.EXPORT_NOTES_HEAD,
"EXPORT_NOTES_HEAD_Column",
"",
"PACK_ID_Id",
newRow.PACK_ID_Id,
"VALUE", pakTable.Rows[0]["PO_NUM"].ToString(), "EXPORT_NOTES_HEAD");
LoadMiniTable_PACK__by__PO_NUM__FIELDS(packingList.SHIPPING_INSTR_HEAD,
"SHIPPING_INSTR_HEAD_Column",
"",
"PACK_ID_Id",
newRow.PACK_ID_Id,
"VALUE", pakTable.Rows[0]["PO_NUM"].ToString(), "SHIPPING_INSTR_HEAD");
LoadMiniTable_PACK__by__PO_NUM__FIELDS(packingList.PICKING_INSTR_HEAD,
"PICKING_INSTR_HEAD_Column",
"",
"PACK_ID_Id",
newRow.PACK_ID_Id,
"VALUE", pakTable.Rows[0]["PO_NUM"].ToString(), "PICKING_INSTR_HEAD");
LoadMiniTable_PACK__by__PO_NUM__FIELDS(packingList.DELIVERY_INSTR_HEAD,
"DELIVERY_INSTR_HEAD_Column",
"",
"PACK_ID_Id",
newRow.PACK_ID_Id,
"VALUE", pakTable.Rows[0]["PO_NUM"].ToString(), "DELIVERY_INSTR_HEAD");
LoadMiniTable_PACK__by__PO_NUM__FIELDS(packingList.SPECIAL_INSTR_HEAD,
"SPECIAL_INSTR_HEAD_Column",
"",
"PACK_ID_Id",
newRow.PACK_ID_Id,
"VALUE", pakTable.Rows[0]["PO_NUM"].ToString(), "SPECIAL_INSTR_HEAD");
LoadMiniTable_PACK__by__PO_NUM__FIELDS(packingList.CUSTOMER_INSTR_HEAD,
"CUSTOMER_INSTR_HEAD_Column",
"",
"PACK_ID_Id",
newRow.PACK_ID_Id,
"VALUE", pakTable.Rows[0]["PO_NUM"].ToString(), "CUSTOMER_INSTR_HEAD");
LoadMiniTable_PACK__by__PO_NUM__FIELDS(packingList.LABEL_INSTR_HEAD,
"LABEL_INSTR_HEAD_Column",
"",
"PACK_ID_Id",
newRow.PACK_ID_Id,
"VALUE", pakTable.Rows[0]["PO_NUM"].ToString(), "LABEL_INSTR_HEAD");
LoadMiniTable_PACK__by__PO_NUM__FIELDS(packingList.CARRIER_INST_HEAD,
"CARRIER_INST_HEAD_Column",
"",
"PACK_ID_Id",
newRow.PACK_ID_Id,
"VALUE", pakTable.Rows[0]["PO_NUM"].ToString(), "CARRIER_INST_HEAD");
LoadMiniTable_PACK__by__PO_NUM__FIELDS(packingList.HANDLING_INSTR_HEAD,
"HANDLING_INSTR_HEAD_Column",
"",
"PACK_ID_Id",
newRow.PACK_ID_Id,
"VALUE", pakTable.Rows[0]["PO_NUM"].ToString(), "HANDLING_INSTR_HEAD");
LoadMiniTable_PACK__by__PO_NUM__FIELDS(packingList.INVOICE_UDF_HEAD,
"INVOICE_UDF_HEAD_Column",
"",
"PACK_ID_Id",
newRow.PACK_ID_Id,
"VALUE", pakTable.Rows[0]["PO_NUM"].ToString(), "INVOICE_UDF_HEAD");
LoadMiniTable_PACK__by__PO_NUM__FIELDS(packingList.UDF_HEAD,
"UDF_HEAD_Column",
"",
"PACK_ID_Id",
newRow.PACK_ID_Id,
"VALUE", pakTable.Rows[0]["PO_NUM"].ToString(), "UDF_HEAD");
//get UDF_KEY/VALUE_HEADER
/*
string whereUDFHEADERClause = "'" + pakTable.Rows[0]["InternalID"].ToString().Trim() + "'";
DataTable UDFHEADERTable = DBFactory.PopulateTempTable_BySp("op_GetUDF_KEY_VALUE_HEADER_Shipment", whereUDFHEADERClause);
*/
logger.Debug("LoadPackingListDatabaseData op_GetUDF_KEY_VALUE_HEADER_Shipment begin");
DataTable UDFHEADERTable = EditsSqlProc.sp__op_GetUDF_KEY_VALUE_HEADER_Shipment(pakTable.Rows[0]["InternalID"].ToString().Trim());
logger.Debug("LoadPackingListDatabaseData op_GetUDF_KEY_VALUE_HEADER_Shipment end");
foreach (DataRow readRow2 in UDFHEADERTable.Rows)
{
LoadKeyValuePairs(packingList.UDF_HEADER,
readRow2,
"UDF_KEY_HEADER",
"UDF_VALUE_HEADER",
"PACK_ID_Id",
newRow.PACK_ID_Id);
}
/*
LoadKeyValuePairs(packingList.UDF_HEADER,
null,
"UDF_KEY_HEADER",
"UDF_VALUE_HEADER",
"PACK_ID_Id",
newRow.PACK_ID_Id,
"WHERE PO_NUM='" + pakTable.Rows[0]["PO_NUM"].ToString() + "'");
*/
//populate mini tables
//set this dataset to packinglist so we can outputXML
this.m_DataSet = packingList;
logger.Debug("LoadPackingListDatabaseData end");
}
