public void LoadPalletADatabaseData(string id) { logger.Debug("LoadPalletADatabaseData begin id="+id); string[] idSplit = id.Split(@"/".ToCharArray()); string internalID = idSplit[0]; string palletID = idSplit[1]; //fill packID table PALLETS palletList = new PALLETS(); //string whereMainClause = "WHERE InternalID='" + internalID + "' AND PALLET_ID='" + palletID + "'"; /* string whereMainClause = "'" + internalID.Substring(0, 16) + "','" + palletID + "'"; List<string> fields = new List<string>(); fields.Add("*"); DataTable palletTable = DBFactory.PopulateTempTable_BySp("[op_Shipment_PAKPalletTypeALineItem]", whereMainClause); */ logger.Debug("LoadPalletADatabaseData [op_Shipment_PAKPalletTypeALineItem] begin"); DataTable palletTable = EditsSqlProc.sp__op_Shipment_PAKPalletTypeALineItem(internalID.Substring(0, 16), palletID); logger.Debug("LoadPalletADatabaseData [op_Shipment_PAKPalletTypeALineItem] end"); //logger.Debug("xxx [op_Shipment_PAKPalletTypeALineItem] begin"); //DataTable palletTable = DBFactory.PopulateTempTable("[op_Shipment_PAKPalletTypeALineItem]", whereMainClause, fields); //logger.Debug("xxx [op_Shipment_PAKPalletTypeALineItem] end"); PALLETS.PALLETDataTable newTable = palletList.PALLET; int index = 0; foreach (DataRow readRow in palletTable.Rows) { PALLETS.PALLETRow newRow = newTable.NewPALLETRow(); newRow.PALLET_Id_0 = index; // index++; foreach (DataColumn column in newTable.Columns) { if (palletTable.Columns.Contains(column.ColumnName)) { //PACK_ID_UNIT_QTY_PER_PALLET if (column.ColumnName == "PACK_ID_UNIT_QTY_PER_PALLET") { /* List<string> fieldsUNITPALLET = new List<string>(); fieldsUNITPALLET.Add("Sum(convert(int,PACK_ID_UNIT_QTY_PER_PALLET)) as PACK_ID_UNIT_QTY_PER_PALLET"); string whereUNITPALLET = "where PALLET_ID = '" + palletID + "' and Left(InternalID,10) = '" + internalID.Substring(0, 10) + "'";*/ /* string whereUNITPALLET = "'" + internalID.Substring(0, 16) + "','" + palletID + "'"; DataTable BOXUNITPALLET = DBFactory.PopulateTempTable_BySp("[op_Shipment_PAKPalletTypeALineItem]", whereUNITPALLET); */ logger.Debug("LoadPalletADatabaseData [op_Shipment_PAKPalletTypeALineItem] begin"); DataTable BOXUNITPALLET = EditsSqlProc.sp__op_Shipment_PAKPalletTypeALineItem(internalID.Substring(0, 16), palletID); logger.Debug("LoadPalletADatabaseData [op_Shipment_PAKPalletTypeALineItem] end"); ChkRowNotNull("PalletAShipmentXmlCreator id=" + id + ", op_Shipment_PAKPalletTypeALineItem internalID=" + internalID.Substring(0, 16) + ", palletID=" + palletID, BOXUNITPALLET); newRow[column] = BOXUNITPALLET.Rows[0]["PACK_ID_UNIT_QTY_PER_PALLET"]; continue; } //PACK_ID_BOX_QTY_PER_PALLET if (column.ColumnName == "PACK_ID_BOX_QTY_PER_PALLET") { /*List<string> fieldsBOXPALLET = new List<string>(); fieldsBOXPALLET.Add("Sum(convert(int,PACK_ID_BOX_QTY_PER_PALLET)) as PACK_ID_BOX_QTY_PER_PALLET"); string whereBOXPALLET = "where PALLET_ID = '" + palletID + "' and Left(InternalID,10) = '" + internalID.Substring(0, 10) + "'"; DataTable BOXPERPALLET = DBFactory.PopulateTempTable("[v_Shipment_PAKPalletTypeALineItem]", whereBOXPALLET, fieldsBOXPALLET);*/ /* string whereBOXPALLET = "'" + internalID.Substring(0, 16) + "','" + palletID + "'"; DataTable BOXPERPALLET = DBFactory.PopulateTempTable_BySp("[op_Shipment_PAKPalletTypeALineItem]", whereBOXPALLET); */ logger.Debug("LoadPalletADatabaseData [op_Shipment_PAKPalletTypeALineItem] begin"); DataTable BOXPERPALLET = EditsSqlProc.sp__op_Shipment_PAKPalletTypeALineItem(internalID.Substring(0, 16), palletID); logger.Debug("LoadPalletADatabaseData [op_Shipment_PAKPalletTypeALineItem] end"); ChkRowNotNull("PalletAShipmentXmlCreator id=" + id + ", op_Shipment_PAKPalletTypeALineItem internalID=" + internalID.Substring(0, 16) + ", palletID=" + palletID, BOXPERPALLET); newRow[column] = BOXPERPALLET.Rows[0]["PACK_ID_BOX_QTY_PER_PALLET"]; continue; } if (column.ColumnName == "PALLET_ID") { /* List<string> fieldsplts = new List<string>(); fieldsplts.Add("*"); string wherePLTS = "where PALLET_ID = '" + palletID + "' and Left(InternalID,10) = '" + internalID.Substring(0, 10) + "'"; DataTable PLTUCC = DBFactory.PopulateTempTable("[v_Shipment_PAKPalletTypeB]", wherePLTS, fieldsplts); */ logger.Debug("LoadPalletADatabaseData [v_Shipment_PAKPalletTypeB] begin"); DataTable PLTUCC = EditsSqlProc.v_Shipment_PAKPalletTypeB__by__PALLET_ID__InternalID10(palletID, internalID.Substring(0, 10)); logger.Debug("LoadPalletADatabaseData [v_Shipment_PAKPalletTypeB] end"); ChkRowNotNull("PalletAShipmentXmlCreator id=" + id + ", v_Shipment_PAKPalletTypeB internalID=" + internalID.Substring(0, 10) + ", palletID=" + palletID, PLTUCC); if (PLTUCC.Rows[0]["UCC"].ToString().Trim().Length == 20) { newRow[column] = PLTUCC.Rows[0]["UCC"].ToString().Trim(); } else { newRow[column] = palletTable.Rows[0][column.ColumnName].ToString(); } continue; } //if table contains name, then populate newRow[column] = readRow[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; } } //get the order item /* string whereOrderClause = "WHERE InternalID='" + internalID + "'"; DataTable orderTable = DBFactory.PopulateTempTable("[v_Shipment_PAKComn]", whereOrderClause, fields); */ logger.Debug("LoadPalletADatabaseData [v_Shipment_PAKComn] begin"); DataTable orderTable = EditsSqlProc.v_Shipment_PAKComn__by__InternalID(internalID); logger.Debug("LoadPalletADatabaseData [v_Shipment_PAKComn] end"); ChkRowNotNull("PalletAShipmentXmlCreator id=" + id + ", v_Shipment_PAKComn internalID=" + internalID, orderTable); foreach (DataColumn column in newTable.Columns) { if (orderTable.Columns.Contains(column.ColumnName)) { //HP_PN if (column.ColumnName == "HP_PN") { /* List<string> fieldsPN = new List<string>(); fieldsPN.Add("distinct HP_PN"); string whereHP_PN = "where PALLET_ID = '" + palletID + "' and Left(InternalID,10) = '" + internalID.Substring(0, 10) + "'"; DataTable HP_PNTable = DBFactory.PopulateTempTable("[v_Shipment_PAKPalletTypeA]", whereHP_PN, fieldsPN); */ logger.Debug("LoadPalletADatabaseData [v_Shipment_PAKPalletTypeA] begin"); DataTable HP_PNTable = EditsSqlProc.HP_PN__from__v_Shipment_PAKPalletTypeA__by__PALLET_ID__InternalID10(palletID, internalID.Substring(0, 10)); logger.Debug("LoadPalletADatabaseData [v_Shipment_PAKPalletTypeA] end"); if (HP_PNTable.Rows.Count > 1) { newRow[column] = "MIXED"; } else { //ChkRowNotNull("PalletAShipmentXmlCreator id=" + id + ", v_Shipment_PAKComn", orderTable); newRow[column] = orderTable.Rows[0][column.ColumnName].ToString();//.Split('/')[1]; } continue; } if (column.ColumnName == "PALLET_ID") { /* List<string> fieldsPLT = new List<string>(); fieldsPLT.Add("* "); string wherePallet_ID = "where PALLET_ID = '" + palletID + "' and Left(InternalID,10) = '" + internalID.Substring(0, 10) + "'"; DataTable Pallet_IDTable = DBFactory.PopulateTempTable("[v_Shipment_PAKPalletTypeB]", wherePallet_ID, fieldsPLT); */ logger.Debug("LoadPalletADatabaseData [v_Shipment_PAKPalletTypeB] begin"); DataTable Pallet_IDTable = EditsSqlProc.v_Shipment_PAKPalletTypeB__by__PALLET_ID__InternalID10(palletID, internalID.Substring(0, 10)); logger.Debug("LoadPalletADatabaseData [v_Shipment_PAKPalletTypeB] end"); if (Pallet_IDTable.Rows.Count > 1) { newRow[column] = "MIXED"; } else { if ((Pallet_IDTable.Rows.Count == 1) && Pallet_IDTable.Rows[0]["UCC"].ToString().Trim().Length == 20) { newRow[column] = Pallet_IDTable.Rows[0]["UCC"].ToString().Trim(); } else { //ChkRowNotNull("PalletAShipmentXmlCreator id=" + id + ", v_Shipment_PAKComn", orderTable); newRow[column] = orderTable.Rows[0][column.ColumnName].ToString(); } // newRow[column] = orderTable.Rows[0][column.ColumnName].ToString();//.Split('/')[1]; } continue; } if (column.ColumnName == "PALLET_BOX_QTY") { /* List<string> fieldsBOXQTY = new List<string>(); fieldsBOXQTY.Add("Sum(PALLET_BOX_QTY) as PALLET_BOX_QTY"); string whereBOXQTY = "where PALLET_ID = '" + palletID + "' and Left(InternalID,10) = '" + internalID.Substring(0, 10) + "'"; DataTable BOXQTYTable = DBFactory.PopulateTempTable("[v_Shipment_PAKPalletTypeA]", whereBOXQTY, fieldsBOXQTY); */ logger.Debug("LoadPalletADatabaseData [v_Shipment_PAKPalletTypeA] begin"); DataTable BOXQTYTable = EditsSqlProc.sum_PALLET_BOX_QTY__from__v_Shipment_PAKPalletTypeA__by__PALLET_ID__InternalID10(palletID, internalID.Substring(0, 10)); logger.Debug("LoadPalletADatabaseData [v_Shipment_PAKPalletTypeA] end"); ChkRowNotNull("PalletAShipmentXmlCreator id=" + id + ", v_Shipment_PAKPalletTypeA internalID=" + internalID.Substring(0, 10) + ", palletID=" + palletID, BOXQTYTable); newRow[column] = BOXQTYTable.Rows[0]["PALLET_BOX_QTY"]; continue; } if (column.ColumnName == "PALLET_UNIT_QTY") { /* List<string> fieldsUNITQTY = new List<string>(); fieldsUNITQTY.Add("Sum(PALLET_UNIT_QTY) as PALLET_UNIT_QTY"); string whereUNITQTY = "where PALLET_ID = '" + palletID + "' and Left(InternalID,10) = '" + internalID.Substring(0, 10) + "'"; DataTable UNITQTYTable = DBFactory.PopulateTempTable("[v_Shipment_PAKPalletTypeA]", whereUNITQTY, fieldsUNITQTY); */ logger.Debug("LoadPalletADatabaseData [v_Shipment_PAKPalletTypeA] begin"); DataTable UNITQTYTable = EditsSqlProc.sum_PALLET_UNIT_QTY__from__v_Shipment_PAKPalletTypeA__by__PALLET_ID__InternalID10(palletID, internalID.Substring(0, 10)); logger.Debug("LoadPalletADatabaseData [v_Shipment_PAKPalletTypeA] end"); ChkRowNotNull("PalletAShipmentXmlCreator id=" + id + ", v_Shipment_PAKPalletTypeA internalID=" + internalID.Substring(0, 10) + ", palletID=" + palletID, UNITQTYTable); newRow[column] = UNITQTYTable.Rows[0]["PALLET_UNIT_QTY"]; continue; } //if table contains name, then populate newRow[column] = orderTable.Rows[0][column.ColumnName]; } } //newRow.SHIP_FROM_STREET_2 = "Caohejing EPZ"; //newRow.SHIP_FROM_STREET_2 = "Shapingba district"; newTable.Rows.Add(newRow); //get LABEL_INSTR_HEADER /* string whereLneItemClause_LABEL = "WHERE PO_NUM='" + orderTable.Rows[0]["PO_NUM"].ToString().Trim() + "' and FIELDS = 'LABEL_INSTR_HEAD'"; DataTable lineItemTable_LABEL = DBFactory.PopulateTempTable("[PAKEDI_INSTR]", whereLneItemClause_LABEL, fields); */ logger.Debug("LoadPalletADatabaseData [PAKEDI_INSTR] begin"); DataTable lineItemTable_LABEL = EditsSqlProc.PAKEDI_INSTR__by__PO_NUM__FIELDS(orderTable.Rows[0]["PO_NUM"].ToString().Trim()); logger.Debug("LoadPalletADatabaseData [PAKEDI_INSTR] end"); foreach (DataRow readRow4 in lineItemTable_LABEL.Rows) { LoadINSTRPairs(palletList.LABEL_INSTR_HEAD, readRow4, "VALUE", "PALLET_Id_0", newRow.PALLET_Id_0); } //get line item /* string whereLneItemClause = "WHERE SERIAL_NUM='" + palletID + "'"; DataTable lineTable = DBFactory.PopulateTempTable("[PAKODMSESSION]", whereLneItemClause, fields); */ logger.Debug("LoadPalletADatabaseData [PAKODMSESSION] begin"); DataTable lineTable = EditsSqlProc.PAKODMSESSION__by__SERIAL_NUM(palletID); logger.Debug("LoadPalletADatabaseData [PAKODMSESSION] end"); foreach (DataRow readRow2 in lineTable.Rows) { LoadKeyValuePairs(palletList.UDF_HEADER, readRow2, "UDF_KEY_HEADER", "UDF_VALUE_HEADER", "PALLET_Id_0", newRow.PALLET_Id_0); LoadKeyValuePairs(palletList.UDF_DETAIL, readRow2, "UDF_KEY_DETAIL", "UDF_VALUE_DETAIL", "PALLET_Id_0", newRow.PALLET_Id_0); } // DataSet ds = LoadTwoD(internalID);------------------------encoding--------------------- /* string whereTwoD = "'" + internalID + "', '" + palletID + "'"; DataTable TwoDTable = DBFactory.PopulateTempTable_BySp("[op_TwoDCode_Solution]", whereTwoD); */ logger.Debug("LoadPalletADatabaseData [op_TwoDCode_Solution] begin"); DataTable TwoDTable = EditsSqlProc.sp__op_TwoDCode_Solution(internalID, palletID); logger.Debug("LoadPalletADatabaseData [op_TwoDCode_Solution] end"); ChkRowNotNull("PalletAShipmentXmlCreator id=" + id + ", op_TwoDCode_Solution internalID=" + internalID + ", palletID=" + palletID, TwoDTable); string EnCoding = TwoDTable.Rows[0]["EnCoding"].ToString(); // Y/N string EnCoder = TwoDTable.Rows[0]["EnCoder"].ToString(); //PDF417/MaxICode string StringIDValue = ""; if (EnCoding == "Y") { //encoder if (EnCoder.Substring(0,6) == "PDF417") { //20130314 /* //PDF417 generator //StringIDValue = TransferCode.Encoder(TwoDTable.Rows[0]["StringIDValue"].ToString()); foreach (DataRow readRowtd in TwoDTable.Rows) { PALLETS.UDF_PALLETRow newRowtwod = palletList.UDF_PALLET.NewUDF_PALLETRow(); StringIDValue = TransferCode.Encoder(readRowtd["StringIDValue"].ToString().Trim()); newRowtwod.KEY = readRowtd["StringIDKey"].ToString().Trim(); newRowtwod.VALUE = StringIDValue.ToString().Trim(); newRowtwod.PALLET_Id_0 = index; palletList.UDF_PALLET.Rows.Add(newRowtwod); } */ } else //MaxICode { //MaxICode generator } } else { foreach (DataRow readRowtd in TwoDTable.Rows) { PALLETS.UDF_PALLETRow newRowtwod = palletList.UDF_PALLET.NewUDF_PALLETRow(); newRowtwod.KEY = readRowtd["StringIDKey"].ToString(); newRowtwod.VALUE = readRowtd["StringIDValue"].ToString(); newRowtwod.PALLET_Id_0 = index; palletList.UDF_PALLET.Rows.Add(newRowtwod); } } //----------------------- end -------------------------------------------------------------- index++; } //populate mini tables //set this dataset to packinglist so we can outputXML this.m_DataSet = palletList; logger.Debug("LoadPalletADatabaseData end"); }
public void LoadPalletADatabaseData(string id) { string[] idSplit = id.Split(@"/".ToCharArray()); string internalID = idSplit[0]; string palletID = idSplit[1]; //fill packID table PALLETS palletList = new PALLETS(); string whereMainClause = "WHERE InternalID='" + internalID + "' AND PALLET_ID='" + palletID + "'"; List<string> fields = new List<string>(); fields.Add("*"); DataTable palletTable = DBFactory.PopulateTempTable("[v_PAKPalletTypeALineItem]", whereMainClause, fields); PALLETS.PALLETDataTable newTable = palletList.PALLET; int index = 0; foreach (DataRow readRow in palletTable.Rows) { PALLETS.PALLETRow newRow = newTable.NewPALLETRow(); newRow.PALLET_Id_0 = index; //index++; foreach (DataColumn column in newTable.Columns) { if (palletTable.Columns.Contains(column.ColumnName)) { //PACK_ID_UNIT_QTY_PER_PALLET if (column.ColumnName == "PACK_ID_UNIT_QTY_PER_PALLET") { List<string> fieldsUNITPALLET = new List<string>(); fieldsUNITPALLET.Add("Sum(convert(int,PACK_ID_UNIT_QTY_PER_PALLET)) as PACK_ID_UNIT_QTY_PER_PALLET"); string whereUNITPALLET = "where PALLET_ID = '" + palletID + "' and Left(InternalID,10) = '" + internalID.Substring(0, 10) + "'"; DataTable BOXUNITPALLET = DBFactory.PopulateTempTable("[v_PAKPalletTypeALineItem]", whereUNITPALLET, fieldsUNITPALLET); newRow[column] = BOXUNITPALLET.Rows[0]["PACK_ID_UNIT_QTY_PER_PALLET"]; continue; } //PACK_ID_BOX_QTY_PER_PALLET if (column.ColumnName == "PACK_ID_BOX_QTY_PER_PALLET") { List<string> fieldsBOXPALLET = new List<string>(); fieldsBOXPALLET.Add("Sum(convert(int,PACK_ID_BOX_QTY_PER_PALLET)) as PACK_ID_BOX_QTY_PER_PALLET"); string whereBOXPALLET = "where PALLET_ID = '" + palletID + "' and Left(InternalID,10) = '" + internalID.Substring(0, 10) + "'"; DataTable BOXPERPALLET = DBFactory.PopulateTempTable("[v_PAKPalletTypeALineItem]", whereBOXPALLET, fieldsBOXPALLET); newRow[column] = BOXPERPALLET.Rows[0]["PACK_ID_BOX_QTY_PER_PALLET"]; continue; } //if table contains name, then populate newRow[column] = readRow[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; } } //get the order item string whereOrderClause = "WHERE InternalID='" + internalID + "'"; DataTable orderTable = DBFactory.PopulateTempTable("[v_PAKComn]", whereOrderClause, fields); foreach (DataColumn column in newTable.Columns) { if (orderTable.Columns.Contains(column.ColumnName)) { //HP_PN if (column.ColumnName == "HP_PN") { List<string> fieldsPN = new List<string>(); fieldsPN.Add("distinct HP_PN"); string whereHP_PN = "where PALLET_ID = '" + palletID + "' and Left(InternalID,10) = '" + internalID.Substring(0, 10) + "'"; DataTable HP_PNTable = DBFactory.PopulateTempTable("[v_PAKPalletTypeA]", whereHP_PN, fieldsPN); if (HP_PNTable.Rows.Count > 1) { newRow[column] = "MIXED"; } else { newRow[column] = orderTable.Rows[0][column.ColumnName].ToString();//.Split('/')[1]; } continue; } if (column.ColumnName == "PALLET_BOX_QTY") { List<string> fieldsBOXQTY = new List<string>(); fieldsBOXQTY.Add("Sum(PALLET_BOX_QTY) as PALLET_BOX_QTY"); string whereBOXQTY = "where PALLET_ID = '" + palletID + "' and Left(InternalID,10) = '" + internalID.Substring(0, 10) + "'"; DataTable BOXQTYTable = DBFactory.PopulateTempTable("[v_PAKPalletTypeA]", whereBOXQTY, fieldsBOXQTY); newRow[column] = BOXQTYTable.Rows[0]["PALLET_BOX_QTY"]; continue; } if (column.ColumnName == "PALLET_UNIT_QTY") { List<string> fieldsUNITQTY = new List<string>(); fieldsUNITQTY.Add("Sum(PALLET_UNIT_QTY) as PALLET_UNIT_QTY"); string whereUNITQTY = "where PALLET_ID = '" + palletID + "' and Left(InternalID,10) = '" + internalID.Substring(0, 10) + "'"; DataTable UNITQTYTable = DBFactory.PopulateTempTable("[v_PAKPalletTypeA]", whereUNITQTY, fieldsUNITQTY); newRow[column] = UNITQTYTable.Rows[0]["PALLET_UNIT_QTY"]; continue; } //if table contains name, then populate newRow[column] = orderTable.Rows[0][column.ColumnName]; } } newTable.Rows.Add(newRow); //get LABEL_INSTR_HEADER string whereLneItemClause_LABEL = "WHERE PO_NUM='" + orderTable.Rows[0]["PO_NUM"].ToString().Trim() + "' and FIELDS = 'LABEL_INSTR_HEAD'"; DataTable lineItemTable_LABEL = DBFactory.PopulateTempTable("[PAKEDI_INSTR]", whereLneItemClause_LABEL, fields); foreach (DataRow readRow4 in lineItemTable_LABEL.Rows) { LoadINSTRPairs(palletList.LABEL_INSTR_HEAD, readRow4, "VALUE", "PALLET_Id_0", newRow.PALLET_Id_0); } //get line item string whereLneItemClause = "WHERE SERIAL_NUM='" + palletID + "'"; DataTable lineTable = DBFactory.PopulateTempTable("[PAKODMSESSION]", whereLneItemClause, fields); foreach (DataRow readRow2 in lineTable.Rows) { LoadKeyValuePairs(palletList.UDF_HEADER, readRow2, "UDF_KEY_HEADER", "UDF_VALUE_HEADER", "PALLET_Id_0", newRow.PALLET_Id_0); LoadKeyValuePairs(palletList.UDF_DETAIL, readRow2, "UDF_KEY_DETAIL", "UDF_VALUE_DETAIL", "PALLET_Id_0", newRow.PALLET_Id_0); } // DataSet ds = LoadTwoD(internalID); // DataSet ds = LoadTwoD(internalID);------------------------encoding--------------------- string whereTwoD = "'" + internalID + "', '" + palletID + "'"; DataTable TwoDTable = DBFactory.PopulateTempTable_BySp("[op_TwoDCode_Solution]", whereTwoD); string EnCoding = TwoDTable.Rows[0]["EnCoding"].ToString(); // Y/N string EnCoder = TwoDTable.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 TwoDTable.Rows) { PALLETS.UDF_PALLETRow newRowtwod = palletList.UDF_PALLET.NewUDF_PALLETRow(); StringIDValue = TransferCode.Encoder(readRowtd["StringIDValue"].ToString().Trim()); newRowtwod.KEY = readRowtd["StringIDKey"].ToString().Trim(); newRowtwod.VALUE = StringIDValue.ToString(); newRowtwod.PALLET_Id_0 = index; palletList.UDF_PALLET.Rows.Add(newRowtwod); } } else //MaxICode { //MaxICode generator } } else { foreach (DataRow readRowtd in TwoDTable.Rows) { PALLETS.UDF_PALLETRow newRowtwod = palletList.UDF_PALLET.NewUDF_PALLETRow(); newRowtwod.KEY = readRowtd["StringIDKey"].ToString(); newRowtwod.VALUE = readRowtd["StringIDValue"].ToString(); newRowtwod.PALLET_Id_0 = index; palletList.UDF_PALLET.Rows.Add(newRowtwod); } } //----------------------- end -------------------------------------------------------------- index++; } //populate mini tables //set this dataset to packinglist so we can outputXML this.m_DataSet = palletList; }