I am at a loss of what to do. I love this product but it produced errors around the label statements that I am trying to resolve. Unfortuantely I have to put the whole function here for it to make sense since I can't attach zip files here apparently. I created a case in support but am still waiting to hear from them. Errors are marked off as with [ERROR]. I am kind of desperate here so please feel free to comment.
private void ProcessOrders()
{
DataRow[] dataRowArray;
DataRow dataRow3;
DataRow dataRow4;
DataRow dataRow5;
DataRow dataRow6;
string str5;
Exception ex;
DataRow[] dataRowArray1;
DataRow[] dataRowArray2;
string str6;
string str8;
string path1;
string path2;
string path3;
char[] chrArray;
DataRow[] dataRowArray6;
int j;
string str9;
int k;
object obj;
object obj1;
object obj2;
object obj3;
object obj4;
object obj5;
object obj6;
try
{
if ((this.reprintOrders == null ? false : this.reprintOrders.Count > 0))
{
DataTable dataTable1 = new DataTable();
DataTable dataTable2 = this.rowPRTTRK.Clone();
foreach (string str in this.reprintOrders)
{
chrArray = new char[] { '-' };
string[] strArray = str.Split(chrArray);
dataRowArray = this.rowPRTTRK.Select(string.Format("ORDNR = {0} AND ORVCH = {1}", strArray[0].Trim(), strArray[1].Trim()));
if ((int)dataRowArray.Length > 0)
{
dataTable2.ImportRow(dataRowArray[0]);
}
}
this.rowPRTTRK = dataTable2;
}
this.ProcessDocList();
this.dtRepeaterPrint.Columns.Add("CompanyMailName", Type.GetType("System.String"));
this.dtRepeaterPrint.Columns.Add("CompanyMailAddr", Type.GetType("System.String"));
this.dtRepeaterPrint.Columns.Add("CompanyMailCSZ", Type.GetType("System.String"));
this.dtRepeaterPrint.Columns.Add("PlantID", Type.GetType("System.String"));
this.dtRepeaterPrint.Columns.Add("ArtPrtPrsPlantID", Type.GetType("System.String"));
this.dtRepeaterPrint.Columns.Add("OrderNumber", Type.GetType("System.String"));
this.dtRepeaterPrint.Columns.Add("VoucherNumber", Type.GetType("System.String"));
this.dtRepeaterPrint.Columns.Add("StyleNumber", Type.GetType("System.String"));
this.dtRepeaterPrint.Columns.Add("StyleNumber2", Type.GetType("System.String"));
this.dtRepeaterPrint.Columns.Add("ScheduleDate", Type.GetType("System.String"));
this.dtRepeaterPrint.Columns.Add("VoucherQuantity", Type.GetType("System.String"));
this.dtRepeaterPrint.Columns.Add("VoucherAction", Type.GetType("System.String"));
this.dtRepeaterPrint.Columns.Add("VoucherAction2", Type.GetType("System.String"));
this.dtRepeaterPrint.Columns.Add("ShippingMethod", Type.GetType("System.String"));
this.dtRepeaterPrint.Columns.Add("UnitPrice", Type.GetType("System.String"));
this.dtRepeaterPrint.Columns.Add("TotalPrice", Type.GetType("System.String"));
this.dtRepeaterPrint.Columns.Add("CompanyPhysName", Type.GetType("System.String"));
this.dtRepeaterPrint.Columns.Add("CompanyPhysAddr", Type.GetType("System.String"));
this.dtRepeaterPrint.Columns.Add("CompanyPhysCSZ", Type.GetType("System.String"));
this.dtRepeaterPrint.Columns.Add("DetailDate", Type.GetType("System.String"));
this.dtRepeaterPrint.Columns.Add("CustomerClass", Type.GetType("System.String"));
this.dtRepeaterPrint.Columns.Add("CustomerClass2", Type.GetType("System.String"));
this.dtRepeaterPrint.Columns.Add("PurchaseOrder", Type.GetType("System.String"));
this.dtRepeaterPrint.Columns.Add("CustomerNumber", Type.GetType("System.String"));
this.dtRepeaterPrint.Columns.Add("CustomerName", Type.GetType("System.String"));
this.dtRepeaterPrint.Columns.Add("CustomerContact", Type.GetType("System.String"));
this.dtRepeaterPrint.Columns.Add("CustomerAddr", Type.GetType("System.String"));
this.dtRepeaterPrint.Columns.Add("CustomerCSZ", Type.GetType("System.String"));
this.dtRepeaterPrint.Columns.Add("VoucherImageName", Type.GetType("System.String"));
this.dtRepeaterPrint.Columns.Add("VoucherImage", Type.GetType("System.String"));
this.dtRepeaterPrint.Columns.Add("VoucherBackImage", Type.GetType("System.String"));
this.dtRepeaterPrint.Columns.Add("VoucherURLImage", Type.GetType("System.String"));
this.dtRepeaterPrint.Columns.Add("VoucherURLBackImage", Type.GetType("System.String"));
this.dtRepeaterPrint.Columns.Add("VoucherURLSideImage", Type.GetType("System.String"));
this.dtRepeaterPrint.Columns.Add("LetteringItem", Type.GetType("System.String"));
this.dtRepeaterPrint.Columns.Add("LetteringItemQty", Type.GetType("System.String"));
this.dtRepeaterPrint.Columns.Add("LetteringStyle", Type.GetType("System.String"));
this.dtRepeaterPrint.Columns.Add("LetteringStyleQty", Type.GetType("System.String"));
this.dtRepeaterPrint.Columns.Add("LetteringItemInfo", Type.GetType("System.String"));
this.dtRepeaterPrint.Columns.Add("LetteringItemInfo2", Type.GetType("System.String"));
this.dtRepeaterPrint.Columns.Add("LetteringItemSize", Type.GetType("System.String"));
this.dtRepeaterPrint.Columns.Add("LetteringItemLtrs", Type.GetType("System.String"));
this.dtRepeaterPrint.Columns.Add("LetteringWord1", Type.GetType("System.String"));
this.dtRepeaterPrint.Columns.Add("LetteringWord2", Type.GetType("System.String"));
this.dtRepeaterPrint.Columns.Add("LetteringWord3", Type.GetType("System.String"));
this.dtRepeaterPrint.Columns.Add("LetteringWord4", Type.GetType("System.String"));
this.dtRepeaterPrint.Columns.Add("LetteringColor1", Type.GetType("System.String"));
this.dtRepeaterPrint.Columns.Add("LetteringColor2", Type.GetType("System.String"));
this.dtRepeaterPrint.Columns.Add("LetteringColor3", Type.GetType("System.String"));
this.dtRepeaterPrint.Columns.Add("LetteringColor4", Type.GetType("System.String"));
this.dtRepeaterPrint.Columns.Add("LetteringColor5", Type.GetType("System.String"));
this.dtRepeaterPrint.Columns.Add("LetteringPic", Type.GetType("System.String"));
this.dtRepeaterPrint.Columns.Add("LetteringPos", Type.GetType("System.String"));
this.dtRepeaterPrint.Columns.Add("LetteringArr", Type.GetType("System.String"));
this.dtRepeaterPrint.Columns.Add("LetteringXrX", Type.GetType("System.String"));
this.dtRepeaterPrint.Columns.Add("LetteringAdultWidth", Type.GetType("System.String"));
this.dtRepeaterPrint.Columns.Add("LetteringAdultCNT", Type.GetType("System.String"));
this.dtRepeaterPrint.Columns.Add("LetteringYouthWidth", Type.GetType("System.String"));
this.dtRepeaterPrint.Columns.Add("LetteringYouthCNT", Type.GetType("System.String"));
this.dtRepeaterPrint.Columns.Add("LetteringReqDate", Type.GetType("System.String"));
this.dtRepeaterPrint.Columns.Add("VoucherComments", Type.GetType("System.String"));
this.dtRepeaterPrint.Columns.Add("OrderVoucherNumber", Type.GetType("System.String"));
this.dtRepeaterPrint.Columns.Add("TodayDate", Type.GetType("System.String"));
this.dtRepeaterPrint.Columns.Add("PackingListTitle", Type.GetType("System.String"));
this.dtRepeaterPrint.Columns.Add("PackingImage", Type.GetType("System.String"));
this.dtRepeaterPrint.Columns.Add("PackingBatch", Type.GetType("System.String"));
this.dtRepeaterPrint.Columns.Add("PackingListCustName", Type.GetType("System.String"));
this.dtRepeaterPrint.Columns.Add("PackingListAttnName", Type.GetType("System.String"));
this.dtRepeaterPrint.Columns.Add("PackingListCustAddr", Type.GetType("System.String"));
this.dtRepeaterPrint.Columns.Add("PackingListCustCitySTZip", Type.GetType("System.String"));
this.dtRepeaterPrint.Columns.Add("PackingListContactName", Type.GetType("System.String"));
this.dtRepeaterPrint.Columns.Add("ReturnRemakeOrdID", Type.GetType("System.String"));
this.dtRepeaterPrint.Columns.Add("ReturnRemakeVchID", Type.GetType("System.String"));
this.dtRepeaterPrint.Columns.Add("ReturnNeedBy", Type.GetType("System.String"));
this.dtRepeaterPrint.Columns.Add("ReturnOrgOrdID", Type.GetType("System.String"));
this.dtRepeaterPrint.Columns.Add("ReturnOrgVchID", Type.GetType("System.String"));
this.dtRepeaterPrint.Columns.Add("ReturnCustomerID", Type.GetType("System.String"));
this.dtRepeaterPrint.Columns.Add("ReturnRegion", Type.GetType("System.String"));
this.dtRepeaterPrint.Columns.Add("ReturnCustomerName", Type.GetType("System.String"));
this.dtRepeaterPrint.Columns.Add("ReturnPlantID", Type.GetType("System.String"));
this.dtRepeaterPrint.Columns.Add("ReturnHowRcvd", Type.GetType("System.String"));
this.dtRepeaterPrint.Columns.Add("ReturnDiscount", Type.GetType("System.String"));
this.dtRepeaterPrint.Columns.Add("ReturnRepID", Type.GetType("System.String"));
this.dtRepeaterPrint.Columns.Add("ReturnRepName", Type.GetType("System.String"));
this.dtRepeaterPrint.Columns.Add("ReturnCustomerContact", Type.GetType("System.String"));
this.dtRepeaterPrint.Columns.Add("ReturnItemStyle", Type.GetType("System.String"));
this.dtRepeaterPrint.Columns.Add("ReturnItemQty", Type.GetType("System.String"));
this.dtRepeaterPrint.Columns.Add("ReturnNumber", Type.GetType("System.String"));
this.dtRepeaterPrint.Columns.Add("ReturnDateIssued", Type.GetType("System.String"));
this.dtRepeaterPrint.Columns.Add("ReturnRequestedBy", Type.GetType("System.String"));
this.dtRepeaterPrint.Columns.Add("ReturnPBR", Type.GetType("System.String"));
this.dtRepeaterPrint.Columns.Add("ReturnHMR", Type.GetType("System.String"));
this.dtRepeaterPrint.Columns.Add("ReturnReason", Type.GetType("System.String"));
this.dtRepeaterPrint.Columns.Add("ReturnResolution", Type.GetType("System.String"));
this.dtRepeaterPrint.Columns.Add("ReturnRmkCrd", Type.GetType("System.String"));
this.dtRepeaterPrint.Columns.Add("ReturnRmkCrdText", Type.GetType("System.String"));
this.dtRepeaterPrint.Columns.Add("ReturnShipToName", Type.GetType("System.String"));
this.dtRepeaterPrint.Columns.Add("ReturnShipToAttn", Type.GetType("System.String"));
this.dtRepeaterPrint.Columns.Add("ReturnShipToAddr", Type.GetType("System.String"));
this.dtRepeaterPrint.Columns.Add("ReturnShipToAddr2", Type.GetType("System.String"));
this.dtRepeaterPrint.Columns.Add("ReturnComments", Type.GetType("System.String"));
this.dtRepeaterPrint.Columns.Add("RepComments", Type.GetType("System.String"));
foreach (DataRow dataRow1 in this.rowPRTTRK.Rows)
{
try
{
if (dataRow1["SCHDT"].ToString().Length >= 6)
{
DataRow row = this.dtRepeaterPrint.NewRow();
DataRow[] dataRowArray7 = this.rowVOUCHER.Select(string.Format("ORDNR = {0} AND ORVCH = {1}", dataRow1["ORDNR"].ToString().Trim(), dataRow1["ORVCH"].ToString().Trim()));
for (int i = 0; i < (int)dataRowArray7.Length; i++)
{
DataRow dataRow2 = dataRowArray7[i];
this.IsLettering = dataRow2["STYLE_GARMTYPE"].ToString().Trim() == "L";
string str1 = string.Empty;
string str2 = string.Empty;
string str3 = string.Empty;
string str4 = string.Empty;
object[] objArray = new object[] { dataRow2["DORMO"].ToString(), dataRow2["DORDA"].ToString(), dataRow2["DORCY"].ToString(), dataRow2["DORYR"].ToString() };
string.Format("{0}/{1}/{2}{3}", objArray);
try
{
row["CompanyMailName"] = this.rowCOMPANY.Rows[0]["COMPANY_NAME"].ToString().Trim();
row["CompanyMailAddr"] = this.rowCOMPANY.Rows[0]["ack_address"].ToString().Trim();
row["CompanyMailCSZ"] = this.rowCOMPANY.Rows[0]["ack_city"].ToString().Trim();
DataRow dataRow = row;
dataRow3 = dataRow;
dataRow["CompanyMailCSZ"] = string.Concat((object)((string)dataRow3["CompanyMailCSZ"]), (object)", ", (object)((string)this.rowCOMPANY.Rows[0]["ack_state"]));
DataRow dataRow14 = row;
dataRow4 = dataRow14;
dataRow14["CompanyMailCSZ"] = string.Concat((object)((string)dataRow4["CompanyMailCSZ"]), (object)" ", (object)((string)this.rowCOMPANY.Rows[0]["ack_zip"]));
if (!(dataRow1["HTCUT"].ToString().Trim() == ""))
{
row["PlantID"] = dataRow1["HTCUT"].ToString().Trim();
if (dataRow1["DHOUS"].ToString().Trim() != "")
{
DataRow dataRow15 = row;
dataRow5 = dataRow15;
dataRow15["PlantID"] = string.Concat((object)((string)dataRow5["PlantID"]), (object)string.Format(" - {0}", dataRow1["DHOUS"]));
}
}
else
{
row["PlantID"] = dataRow1["DHOUS"].ToString().Trim();
}
dataRowArray = this.rowVDSSUB.Select(string.Format("ORDNR={0} AND ORVCH={1}", dataRow2["ORDNR"].ToString().Trim(), dataRow2["ORVCH"].ToString().Trim()));
if ((int)dataRowArray.Length <= 0)
{
row["ArtPrtPrsPlantID"] = "n/a";
}
else
{
dataRowArray6 = dataRowArray;
for (j = 0; j < (int)dataRowArray6.Length; j++)
{
dataRow5 = dataRowArray6[j];
if ((!(row["ArtPrtPrsPlantID"].ToString().Trim() == "") || !(dataRow5["PRJOB"].ToString().Trim() != "GCT") ? true : !(dataRow5["PRJOB"].ToString().Trim() != "SEW")))
{
str9 = dataRow5["PRJOB"].ToString().Trim();
if (str9 != null)
{
if (str9 == "ART")
{
DataRow dataRow16 = row;
dataRow6 = dataRow16;
dataRow16["ArtPrtPrsPlantID"] = string.Concat((object)((string)dataRow6["ArtPrtPrsPlantID"]), (object)"-", (object)dataRow5["SUBART"].ToString().Trim());
goto Label0;
}
else if (str9 == "PRT")
{
DataRow dataRow17 = row;
DataRow dataRow7 = dataRow17;
dataRow17["ArtPrtPrsPlantID"] = string.Concat((object)((string)dataRow7["ArtPrtPrsPlantID"]), (object)"-", (object)dataRow5["SUBART"].ToString().Trim());
goto Label0;
}
else
{
if (str9 != "PRS")
{
goto Label6;
}
DataRow dataRow18 = row;
DataRow dataRow8 = dataRow18;
dataRow18["ArtPrtPrsPlantID"] = string.Concat((object)((string)dataRow8["ArtPrtPrsPlantID"]), (object)"-", (object)dataRow5["SUBART"].ToString().Trim());
goto Label0;
}
}
Label6:
row["ArtPrtPrsPlantID"] = row["ArtPrtPrsPlantID"].ToString().Trim();
}
else
{
row["ArtPrtPrsPlantID"] = dataRow5["SUBART"].ToString().Trim();
}
Label0:[ERROR]
}
[
}
row["OrderNumber"] = dataRow1["ORDNR"].ToString().Trim();
row["VoucherNumber"] = dataRow1["ORVCH"].ToString().Trim();
row["OrderVoucherNumber"] = string.Format("{0}-{1}", dataRow1["ORDNR"].ToString().Trim(), dataRow1["ORVCH"].ToString().Trim());
str5 = dataRow1["SCHDT"].ToString().Trim();
row["ScheduleDate"] = string.Format("{0}/{1}/{2}", str5.Substring(4, 2), str5.Substring(6, 2), str5.Substring(0, 4));
row["TodayDate"] = this.todaysDate;
row["StyleNumber"] = dataRow2["DITEM"].ToString().Trim();
str9 = dataRow1["ORRMK"].ToString().Trim();
if (str9 != null)
{
if (str9 == "R")
{
row["VoucherAction"] = "REMAKE";
row["VoucherAction2"] = "REMAKE";
goto Label2;
}
else
{
if (str9 != "Z")
{
goto Label7;
}
row["VoucherAction"] = "ALTER";
row["VoucherAction2"] = "ALTER";
goto Label2;
}
}
Label7:
row["VoucherAction"] = "";
if (dataRow1["APPCD"].ToString() == "PRT")
{
if (!(row["VoucherAction"].ToString() == ""))
{
DataRow dataRow19 = row;
dataRow5 = dataRow19;
dataRow19["VoucherAction"] = string.Concat((object)((string)dataRow5["VoucherAction"]), (object)"<br /> REPRINT");
DataRow dataRow20 = row;
dataRow6 = dataRow20;
dataRow20["VoucherAction2"] = string.Concat((object)((string)dataRow6["VoucherAction2"]), (object)"<br /> REPRINT");
}
else
{
row["VoucherAction"] = "REPRINT";
row["VoucherAction2"] = "REPRINT";
}
}
else if ((Convert.ToInt32(dataRow1["DTPRT"].ToString().Trim()) <= 0 ? false : dataRow1["APPCD"].ToString() == "NEW"))
{
if (!(row["VoucherAction"].ToString() == ""))
{
DataRow dataRow21 = row;
dataRow5 = dataRow21;
dataRow21["VoucherAction"] = string.Concat((object)((string)dataRow5["VoucherAction"]), (object)"<br /> RESET");
}
else
{
row["VoucherAction"] = "RESET";
}
}
row["UnitPrice"] = (dataRow1["LBRUNT"].ToString().Trim() == "" ? "0.00" : dataRow1["LBRUNT"].ToString().Trim());
row["TotalPrice"] = (dataRow1["LBRVCH"].ToString().Trim() == "" ? "0.00" : dataRow1["LBRVCH"].ToString().Trim());
row["CompanyPhysName"] = "VARSITY";
row["CompanyPhysAddr"] = this.rowCOMPANY.Rows[0]["address_1"].ToString().Trim();
DataRow dataRow22 = row;
DataRow dataRow9 = dataRow22;
dataRow22["CompanyPhysAddr"] = string.Concat((object)((string)dataRow9["CompanyPhysAddr"]), (object)" ", (object)this.rowCOMPANY.Rows[0]["address_2"].ToString().Trim());
row["CompanyPhysCSZ"] = this.rowCOMPANY.Rows[0]["city"].ToString().Trim();
DataRow dataRow23 = row;
DataRow dataRow10 = dataRow23;
dataRow23["CompanyPhysCSZ"] = string.Concat((object)((string)dataRow10["CompanyPhysCSZ"]), (object)", ", (object)this.rowCOMPANY.Rows[0]["state_cd"].ToString().Trim());
DataRow dataRow24 = row;
DataRow dataRow11 = dataRow24;
dataRow24["CompanyPhysCSZ"] = string.Concat((object)((string)dataRow11["CompanyPhysCSZ"]), (object)" ", (object)this.rowCOMPANY.Rows[0]["zip_cd"].ToString().Trim());
if (dataRow1["ORCCL"].ToString().Trim() == "AS")
{
row["CustomerClass"] = "All Star";
row["CustomerClass2"] = "";
}
else if (dataRow1["ORCCL"].ToString().Trim() == "IO")
{
row["CustomerClass"] = "International";
row["CustomerClass2"] = "International";
}
row["CustomerNumber"] = dataRow1["ORCUS"].ToString().Trim();
row["CustomerName"] = dataRow1["ORSNM"].ToString().Trim();
row["CustomerContact"] = dataRow1["ORSA1"].ToString().Trim();
row["CustomerAddr"] = dataRow1["ORSA2"].ToString().Trim();
row["CustomerCSZ"] = dataRow1["ORSCT"].ToString().Trim();
DataRow dataRow25 = row;
DataRow dataRow12 = dataRow25;
dataRow25["CustomerCSZ"] = string.Concat((object)((string)dataRow12["CustomerCSZ"]), (object)" ", (object)dataRow1["ORSST"].ToString().Trim());
DataRow dataRow26 = row;
DataRow dataRow13 = dataRow26;
dataRow26["CustomerCSZ"] = string.Concat((object)((string)dataRow13["CustomerCSZ"]), (object)" ", (object)dataRow1["ORSZP"].ToString().Trim());
row["PurchaseOrder"] = (dataRow1["ORPON"].ToString().Trim() == "" ? "NA" : dataRow1["ORPON"].ToString().Trim());
} [ERROR]
catch (Exception exception)
{
ex = exception;
base.Response.Redirect(ConfigurationManager.AppSettings.Get("ErrorURL"), false);
}
try
{
dataRowArray = this.rowSHIPMETHOD.Select(string.Format("SMETH = '{0}'", dataRow2["DMETH"].ToString().Trim()));
if ((int)dataRowArray.Length > 0)
{
row["ShippingMethod"] = dataRowArray[0]["DCRSM"].ToString().Trim();
}
row["VoucherQuantity"] = dataRow2["DOQTY"].ToString().Trim();
objArray = new object[] { dataRow2["DORMO"].ToString().Trim(), dataRow2["DORDA"].ToString().Trim(), dataRow2["DORCY"].ToString().Trim(), dataRow2["DORYR"].ToString().Trim() };
row["DetailDate"] = string.Format("{0}/{1}/{2}{3}", objArray);
}
catch (Exception exception1)
{
ex = exception1;
base.Response.Redirect(ConfigurationManager.AppSettings.Get("ErrorURL"), false);
}
try
{
dataRowArray1 = (!this.IsLettering ? this.rowPICTURE.Select(string.Format("DETAIL_ORDID = {0} AND DETAIL_VOUCHER = {1}", dataRow2["ORDNR"].ToString().Trim(), dataRow2["ORVCH"].ToString().Trim())) : this.rowPICTURE.Select(string.Format("DETAIL_ORDID={0} AND DETAIL_VOUCHER={1}", dataRow2["ORDNR"].ToString().Trim(), dataRow2["DPVCH"].ToString().Trim())));
if ((int)dataRowArray1.Length > 0)
{
str1 = dataRowArray1[0]["STYLE_LONGDESC"].ToString().Trim();
dataRowArray2 = this.rowVOUCHER.Select(string.Format("ORDNR = {0} AND ORVCH = {1}", dataRow2["ORDNR"].ToString().Trim(), dataRow2["DPVCH"].ToString().Trim()));
str2 = ((int)dataRowArray2.Length <= 0 ? string.Format("Garment Plant: {0} {1}", dataRow1["DHOUS"].ToString().Trim(), dataRowArray1[0]["DETAIL_STYLECD"].ToString().Trim()) : string.Format("Garment Plant: {0} {1}", dataRowArray2[0]["DHOUS"].ToString().Trim(), dataRowArray1[0]["DETAIL_STYLECD"].ToString().Trim()));
if (dataRowArray1[0]["STYLE_FRIMAGE"].ToString().Trim() != "")
{
str3 = string.Format("{0}{1}", this.imagePath, dataRowArray1[0]["STYLE_FRIMAGE"]);
}
if (dataRowArray1[0]["STYLE_BKIMAGE"].ToString().Trim() != "")
{
str4 = string.Format("{0}{1}", this.imagePath, dataRowArray1[0]["STYLE_BKIMAGE"]);
}
}
}
catch (Exception exception2)
{
ex = exception2;
base.Response.Redirect(ConfigurationManager.AppSettings.Get("ErrorURL"), false);
}
if (DataAccessManager.PrintVDSImages(dataRow2["DCLAS"].ToString().Trim(), this.curUser))
{
try
{
str5 = string.Empty;
str6 = string.Empty;
string str7 = string.Empty;
if (!this.IsLettering)
{
dataRowArray = this.rowPICTURE.Select(string.Format("DETAIL_ORDID = {0} AND DETAIL_VOUCHER = {1}", dataRow2["ORDNR"].ToString().Trim(), dataRow2["ORVCH"].ToString().Trim()));
if ((int)dataRowArray.Length > 0)
{
if ((dataRowArray[0]["IMAGEURL"].ToString().Trim() != "" ? false : !(dataRowArray[0]["BACKIMAGEURL"].ToString().Trim() != "")))
{
str8 = dataRow2["ORVCH"].ToString().Trim();
if (str8.Length < 3)
{
do
{
str8 = string.Concat("0", str8);
}
while (str8.Length < 3);
}
path1 = string.Format("{0}{1}_{2}_F.png", this.imageVDSPath, dataRow2["ORDNR"].ToString().Trim(), str8);
path2 = string.Format("{0}{1}_{2}_B.png", this.imageVDSPath, dataRow2["ORDNR"].ToString().Trim(), str8);
path3 = string.Format("{0}{1}_{2}_S.png", this.imageVDSPath, dataRow2["ORDNR"].ToString().Trim(), str8);
DataRow dataRow27 = row;
if (!File.Exists(path1))
{
obj1 = null;
}
else
{
obj1 = path1;
}
dataRow27["VoucherURLImage"] = obj1;
DataRow dataRow28 = row;
if (!File.Exists(path2))
{
obj2 = null;
}
else
{
obj2 = path2;
}
dataRow28["VoucherURLBackImage"] = obj2;
DataRow dataRow29 = row;
if (!File.Exists(path3))
{
obj3 = null;
}
else
{
obj3 = path3;
}
dataRow29["VoucherURLSideImage"] = obj3;
}
else
{
if (dataRowArray[0]["IMAGEURL"].ToString().Trim() != "")
{
row["VoucherURLImage"] = dataRowArray[0]["IMAGEURL"].ToString();
}
if (dataRowArray[0]["BACKIMAGEURL"].ToString().Trim() != "")
{
row["VoucherURLBackImage"] = dataRowArray[0]["BACKIMAGEURL"].ToString();
}
if (dataRowArray[0]["SIDEIMAGEURL"].ToString().Trim() != "")
{
row["VoucherURLSideImage"] = dataRowArray[0]["SIDEIMAGEURL"].ToString();
}
}
}
}
else
{
dataRowArray = this.rowPICTURE.Select(string.Format("DETAIL_ORDID={0} AND DETAIL_VOUCHER={1}", dataRow2["ORDNR"].ToString().Trim(), dataRow2["DPVCH"].ToString().Trim()));
if ((int)dataRowArray.Length > 0)
{
if ((dataRowArray[0]["IMAGEURL"].ToString().Trim() != "" ? false : !(dataRowArray[0]["BACKIMAGEURL"].ToString().Trim() != "")))
{
str8 = dataRow2["DPVCH"].ToString().Trim();
if (str8.Length < 3)
{
do
{
str8 = string.Concat("0", str8);
}
while (str8.Length < 3);
}
path1 = string.Format("{0}{1}_{2}_F.png", this.imageVDSPath, dataRow2["ORDNR"].ToString().Trim(), str8);
path2 = string.Format("{0}{1}_{2}_B.png", this.imageVDSPath, dataRow2["ORDNR"].ToString().Trim(), str8);
path3 = string.Format("{0}{1}_{2}_S.png", this.imageVDSPath, dataRow2["ORDNR"].ToString().Trim(), str8);
DataRow dataRow30 = row;
if (!File.Exists(path1))
{
obj4 = null;
}
else
{
obj4 = path1;
}
dataRow30["VoucherURLImage"] = obj4;
DataRow dataRow31 = row;
if (!File.Exists(path2))
{
obj5 = null;
}
else
{
obj5 = path2;
}
dataRow31["VoucherURLBackImage"] = obj5;
DataRow dataRow32 = row;
if (!File.Exists(path3))
{
obj6 = null;
}
else
{
obj6 = path3;
}
dataRow32["VoucherURLSideImage"] = obj6;
}
else
{
if (dataRowArray[0]["IMAGEURL"].ToString().Trim() != "")
{
row["VoucherURLImage"] = dataRowArray[0]["IMAGEURL"].ToString();
}
if (dataRowArray[0]["BACKIMAGEURL"].ToString().Trim() != "")
{
row["VoucherURLBackImage"] = dataRowArray[0]["BACKIMAGEURL"].ToString();
}
if (dataRowArray[0]["SIDEIMAGEURL"].ToString().Trim() != "")
{
row["VoucherURLSideImage"] = dataRowArray[0]["SIDEIMAGEURL"].ToString();
}
}
}
}
}
catch (Exception exception3)
{
ex = exception3;
base.Response.Redirect(ConfigurationManager.AppSettings.Get("ErrorURL"), false);
}
}
if (!this.IsLettering)
{
row["StyleNumber2"] = dataRow2["DITEM"].ToString().Trim();
row["VoucherImageName"] = str1;
row["VoucherImage"] = str3;
row["VoucherBackImage"] = str4;
}
else
{
row["StyleNumber2"] = string.Empty;
row["VoucherImageName"] = str2;
row["VoucherImage"] = str3;
try
{
dataRowArray1 = this.rowPARENT.Select(string.Format("ORDNR = {0} AND ORVCH = {1}", dataRow2["ORDNR"].ToString().Trim(), dataRow2["DPVCH"].ToString().Trim()));
if ((int)dataRowArray1.Length <= 0)
{
row["LetteringItem"] = "Sold Separately";
}
else if (dataRowArray1[0]["DITEM"].ToString().Trim() == "")
{
row["LetteringItem"] = "Sold Separately";
}
else if ((int)dataRowArray1.Length > 0)
{
row["LetteringItem"] = dataRowArray1[0]["DITEM"].ToString().Trim();
row["LetteringItemQty"] = dataRowArray1[0]["DOQTY"].ToString().Trim();
}
row["LetteringStyle"] = dataRow2["DITEM"].ToString().Trim();
row["LetteringStyleQty"] = dataRow2["DOQTY"].ToString().Trim();
row["LetteringItemInfo"] = dataRow2["ITCDS"].ToString().Trim();
row["LetteringItemInfo2"] = dataRow2["ITDSC"].ToString().Trim();
row["LetteringItemSize"] = dataRow2["DLSIZ"].ToString().Trim();
if (row["LetteringItemSize"].ToString() != "")
{
DataRow dataRow33 = row;
dataRow3 = dataRow33;
dataRow33["LetteringItemSize"] = string.Concat((object)((string)dataRow3["LetteringItemSize"]), (object)"''");
}
row["LetteringItemLtrs"] = dataRow2["DLNO1"].ToString().Trim();
row["LetteringWord1"] = dataRow2["DLWR1"].ToString().Trim();
row["LetteringWord2"] = dataRow2["DLWR2"].ToString().Trim();
row["LetteringWord3"] = dataRow2["DLWR3"].ToString().Trim();
row["LetteringWord4"] = dataRow2["DLWR4"].ToString().Trim();
if (dataRow2["DCLR1"].ToString().Trim() != "")
{
dataRowArray2 = this.rowCOLORS.Select(string.Format("RSPKY = '{0}'", dataRow2["DCLR1"].ToString().Trim()));
if ((int)dataRowArray2.Length > 0)
{
row["LetteringColor1"] = string.Format("{0} / {1}", dataRow2["DCLR1"].ToString().Trim(), dataRowArray2[0]["RSPTX"].ToString().Trim());
}
}
if (dataRow2["DCLR2"].ToString().Trim() != "")
{
dataRowArray2 = this.rowCOLORS.Select(string.Format("RSPKY = '{0}'", dataRow2["DCLR2"].ToString().Trim()));
if ((int)dataRowArray2.Length > 0)
{
row["LetteringColor2"] = string.Format("{0} / {1}", dataRow2["DCLR2"].ToString().Trim(), dataRowArray2[0]["RSPTX"].ToString().Trim());
}
}
if (dataRow2["DCLR3"].ToString().Trim() != "")
{
dataRowArray2 = this.rowCOLORS.Select(string.Format("RSPKY = '{0}'", dataRow2["DCLR3"].ToString().Trim()));
if ((int)dataRowArray2.Length > 0)
{
row["LetteringColor3"] = string.Format("{0} / {1}", dataRow2["DCLR3"].ToString().Trim(), dataRowArray2[0]["RSPTX"].ToString().Trim());
}
}
if (dataRow2["DCLR4"].ToString().Trim() != "")
{
dataRowArray2 = this.rowCOLORS.Select(string.Format("RSPKY = '{0}'", dataRow2["DCLR4"].ToString().Trim()));
if ((int)dataRowArray2.Length > 0)
{
row["LetteringColor4"] = string.Format("{0} / {1}", dataRow2["DCLR4"].ToString().Trim(), dataRowArray2[0]["RSPTX"].ToString().Trim());
}
}
if (dataRow2["DCLR5"].ToString().Trim() != "")
{
dataRowArray2 = this.rowCOLORS.Select(string.Format("RSPKY = '{0}'", dataRow2["DCLR5"].ToString().Trim()));
if ((int)dataRowArray2.Length > 0)
{
row["LetteringColor5"] = string.Format("{0} / {1}", dataRow2["DCLR5"].ToString().Trim(), dataRowArray2[0]["RSPTX"].ToString().Trim());
}
}
DataRow[] dataRowArray3 = this.rowSYBASE2.Select(string.Format("ORD_NUM = {0} AND ITEM_VOUCHER = {1}", dataRow2["ORDNR"].ToString().Trim(), dataRow2["ORVCH"].ToString().Trim()));
if ((int)dataRowArray3.Length > 0)
{
if (dataRowArray3[0]["LTR_PAGE_REF"].ToString().Trim() != "***")
{
row["LetteringPic"] = dataRowArray3[0]["LTR_PAGE_REF"].ToString().Trim();
}
row["LetteringPos"] = dataRowArray3[0]["LTR_POSITION"].ToString().Trim();
row["LetteringArr"] = dataRowArray3[0]["LTR_ARRANGE"].ToString().Trim();
}
str5 = string.Empty;
str9 = dataRow2["DXERX"].ToString().Trim();
if (str9 != null)
{
switch (str9)
{
case "D":
{
str5 = "Placement";
break;
}
case "F":
{
str5 = "Fill In/No Xerox";
break;
}
case "M":
{
str5 = "Match";
break;
}
case "N":
{
str5 = "New";
break;
}
case "O":
{
str5 = "Fill in/Refer Pr. Ord #";
break;
}
case "S":
{
str5 = "Match";
break;
}
case "W":
{
str5 = "Fill in /No Xerox";
break;
}
}
}
row["LetteringXrX"] = str5;
if (OrderManager.PrintSpecWidths(this.rowLETTERCLASS, dataRow2["ITCLS"].ToString().Trim()))
{
dataRowArray2 = this.rowsSIZING.Select(string.Format("ORDNR = {0} AND ORVCH = {1} AND SETUPOPT_YTHSIZE = 'N'", dataRow2["ORDNR"].ToString().Trim(), dataRow2["DPVCH"].ToString().Trim()));
DataRow[] dataRowArray4 = this.rowsSIZING.Select(string.Format("ORDNR = {0} AND ORVCH = {1} AND SETUPOPT_YTHSIZE = 'Y'", dataRow2["ORDNR"].ToString().Trim(), dataRow2["DPVCH"].ToString().Trim()));
DataRow[] dataRowArray5 = this.rowsSIZING2.Select(string.Format("ORDNR = {0} AND ORVCH = {1}", dataRow2["ORDNR"].ToString().Trim(), dataRow2["ORVCH"].ToString().Trim()));
if (((int)dataRowArray2.Length > 0 ? true : (int)dataRowArray4.Length > 0))
{
if (((int)dataRowArray2.Length <= 0 ? false : dataRow2["DLNO1"].ToString().Trim() != "0"))
{
if (dataRowArray2[0]["STYLE_ADULTSPEC"].ToString().Trim() != "")
{
string str10 = dataRowArray2[0]["STYLE_ADULTSPEC"].ToString().Trim();
chrArray = new char[] { '0' };
row["LetteringAdultWidth"] = str10.TrimEnd(chrArray);
}
this.adultCNTPerVoucher = 0;
dataRowArray6 = dataRowArray2;
for (j = 0; j < (int)dataRowArray6.Length; j++)
{
dataRow3 = dataRowArray6[j];
PlantDoc num = this;
num.adultCNTPerVoucher = num.adultCNTPerVoucher + Convert.ToInt32(dataRow3["GQTY"]);
}
row["LetteringAdultCNT"] = string.Concat(" QTY:", this.adultCNTPerVoucher);
}
if (((int)dataRowArray4.Length <= 0 ? false : dataRow2["DLNO1"].ToString().Trim() != "0"))
{
if (dataRowArray4[0]["STYLE_YTHSPEC"].ToString().Trim() != "")
{
string str11 = dataRowArray4[0]["STYLE_YTHSPEC"].ToString().Trim();
chrArray = new char[] { '0' };
row["LetteringYouthWidth"] = str11.TrimEnd(chrArray);
}
this.youthCNTPerVoucher = 0;
dataRowArray6 = dataRowArray4;
for (j = 0; j < (int)dataRowArray6.Length; j++)
{
dataRow3 = dataRowArray6[j];
PlantDoc plantDoc = this;
plantDoc.youthCNTPerVoucher = plantDoc.youthCNTPerVoucher + Convert.ToInt32(dataRow3["GQTY"]);
}
row["LetteringYouthCNT"] = string.Concat(" QTY:", this.youthCNTPerVoucher);
}
}
else if (((int)dataRowArray5.Length <= 0 || !(dataRow2["DLNO1"].ToString().Trim() == "0") ? false : dataRowArray5[0]["STYLE_ADULTSPEC"].ToString().Trim() != ""))
{
string str12 = dataRowArray5[0]["STYLE_ADULTSPEC"].ToString().Trim();
chrArray = new char[] { '0' };
row["LetteringAdultWidth"] = str12.TrimEnd(chrArray);
row["LetteringAdultCNT"] = string.Concat(" QTY:", dataRowArray5[0]["GQTY"].ToString().Trim());
}
}
str6 = string.Format("{0}/{1}/{2}", dataRow2["DRQMO"].ToString().Trim(), dataRow2["DRQDA"].ToString().Trim(), string.Format("{0}{1}", dataRow2["DRQCY"].ToString().Trim(), dataRow2["DRQYR"].ToString().Trim()));
if (str6 != "")
{
if (str6 != "00/00/0000")
{
if (str6 != "0/0/00")
{
row["LetteringReqDate"] = string.Format("<b>Request Date:</b> {0}", str6);
}
}
}
}
catch (Exception exception4)
{
ex = exception4;
base.Response.Redirect(ConfigurationManager.AppSettings.Get("ErrorURL"), false);
}
}
try
{
dataRowArray = this.rowSYBASE.Select(string.Format("ORD_NUM = {0} AND ITEM_VOUCHER = {1}", dataRow1["ORDNR"].ToString().Trim(), dataRow1["ORVCH"].ToString().Trim()));
if ((int)dataRowArray.Length > 0)
{
row["VoucherComments"] = dataRowArray[0]["ITEM_COMMENTS"].ToString();
row["TodayDate"] = this.todaysDate;
}
}
catch (Exception exception5)
{
ex = exception5;
base.Response.Redirect(ConfigurationManager.AppSettings.Get("ErrorURL"), false);
}
if (!this.IsLettering)
{
try
{
row["PackingListTitle"] = (!(dataRow1["ORCCL"].ToString().Trim() != "") || !(dataRow1["ORCCL"].ToString().Trim() == "IO") ? "Packing List" : "Packing List (International)");
row["PackingImage"] = "Varsity_Logo.gif";
if ((dataRow1["LBDTE"].ToString().Trim() == "" ? false : Convert.ToInt32(dataRow1["LBDTE"].ToString().Trim()) > 89999999))
{
row["PackingBatch"] = string.Concat("Batch: ", dataRow1["LBDTE"].ToString().Trim());
}
row["PackingListCustName"] = this.myText.ToTitleCase(dataRow1["ORBNM"].ToString().Trim().ToLower());
row["PackingListAttnName"] = this.myText.ToTitleCase(dataRow1["ORSA1"].ToString().Trim().ToLower());
row["PackingListCustAddr"] = this.myText.ToTitleCase(dataRow1["ORSA2"].ToString().Trim().ToLower());
row["PackingListCustCitySTZip"] = string.Format("{0}, {1} {2}", this.myText.ToTitleCase(dataRow1["ORSCT"].ToString().Trim().ToLower()), dataRow1["ORSST"].ToString().Trim(), dataRow1["ORSZP"].ToString().Trim());
DataRow dataRow34 = row;
if (dataRow1["ORCNM"].ToString().Trim() == "")
{
obj = (dataRow1["ORBNM"].ToString().Trim() == "" ? "Dear Patron:" : string.Format("Dear {0}:", this.myText.ToTitleCase(dataRow1["ORBNM"].ToString().Trim().ToLower())));
}
else
{
obj = string.Format("Dear {0}:", this.myText.ToTitleCase(dataRow1["ORCNM"].ToString().Trim().ToLower()));
}
dataRow34["PackingListContactName"] = obj;
}
catch (Exception exception6)
{
ex = exception6;
base.Response.Redirect(ConfigurationManager.AppSettings.Get("ErrorURL"), false);
}
}
if (dataRow2["ORRMK"].ToString().Trim() != "R")
{
if (dataRow2["ORRMK"].ToString().Trim() != "Z")
{
goto Label4;
}
}
try
{
dataRowArray = this.rowPARENT.Select(string.Format("ORDNR = {0} AND ORVCH = {1}", dataRow2["ORDNR"].ToString().Trim(), dataRow2["ORVCH"].ToString().Trim()));
dataRowArray6 = (!this.IsLettering ? this.rowRETURN.Select(string.Format("RMKNO = {0} AND RMKVC = {1}", dataRow2["ORDNR"].ToString().Trim(), dataRowArray[0]["ORVCH"].ToString().Trim())) : this.rowRETURN.Select(string.Format("RMKNO = {0} AND RMKVC = {1}", dataRow2["ORDNR"].ToString().Trim(), dataRowArray[0]["DPVCH"].ToString().Trim())));
for (j = 0; j < (int)dataRowArray6.Length; j++)
{
dataRow3 = dataRowArray6[j];
row["ReturnRemakeOrdID"] = dataRow3["RMKNO"].ToString().Trim();
row["ReturnRemakeVchID"] = dataRow3["RMKVC"].ToString().Trim();
if ((dataRow3["NBYMO"].ToString().Trim() == "" ? false : Convert.ToInt32(dataRow3["NBYMO"].ToString().Trim()) > 0))
{
objArray = new object[] { dataRow3["NBYMO"].ToString().Trim(), dataRow3["NBYDA"].ToString().Trim(), dataRow3["NBYCY"].ToString().Trim(), dataRow3["NBYYR"].ToString().Trim() };
row["ReturnNeedBy"] = string.Format("{0}/{1}/{2}{3}", objArray);
}
row["ReturnOrgOrdID"] = dataRow3["ORDNR"].ToString().Trim();
row["ReturnOrgVchID"] = dataRow3["VCHNO"].ToString().Trim();
row["ReturnCustomerID"] = dataRow3["CUSNR"].ToString().Trim();
row["ReturnRegion"] = dataRow3["RGNCD"].ToString().Trim();
row["ReturnCustomerName"] = this.myText.ToTitleCase(dataRow3["CSNAM"].ToString().Trim());
row["ReturnPlantID"] = dataRow3["HOUSE"].ToString().Trim();
row["ReturnHowRcvd"] = dataRow3["ORHRC"].ToString().Trim();
row["ReturnDiscount"] = dataRow3["DSCP1"].ToString().Trim();
row["ReturnRepID"] = dataRow3["REPNR"].ToString().Trim();
row["ReturnRepName"] = dataRow3["SLSNM"].ToString().Trim();
row["ReturnCustomerContact"] = dataRow3["CNTAC"].ToString().Trim();
row["ReturnItemStyle"] = dataRow3["ITNBR"].ToString().Trim();
row["ReturnItemQty"] = dataRow3["QTYRQ"].ToString().Trim();
row["ReturnNumber"] = dataRow3["RETANO"].ToString().Trim();
if ((dataRow3["ISUMO"].ToString().Trim() == "" ? false : Convert.ToInt32(dataRow3["ISUMO"].ToString().Trim()) > 0))
{
objArray = new object[] { dataRow3["ISUMO"].ToString().Trim(), dataRow3["ISUDA"].ToString().Trim(), dataRow3["ISUCY"].ToString().Trim(), dataRow3["ISUYR"].ToString().Trim() };
row["ReturnDateIssued"] = string.Format("{0}/{1}/{2}{3}", objArray);
}
row["ReturnRequestedBy"] = dataRow3["ISUBY"].ToString().Trim();
row["ReturnPBR"] = dataRow3["PRCBF"].ToString().Trim();
row["ReturnHMR"] = dataRow3["HLDMR"].ToString().Trim();
row["ReturnReason"] = dataRow3["REACD"].ToString().Trim();
row["ReturnResolution"] = dataRow3["RSLCD"].ToString().Trim();
row["ReturnRmkCrd"] = dataRow3["RMKCR"].ToString().Trim();
row["ReturnRmkCrdText"] = "";
DataRow[] dataRowArray8 = this.rowRETRMKCRD.Select(string.Format("COMNO = {0} AND REACD = '{1}'", Convert.ToInt32(dataRow1["COMNO"].ToString().Trim()), dataRow3["RMKCR"].ToString().Trim()));
for (k = 0; k < (int)dataRowArray8.Length; k++)
{
dataRow4 = dataRowArray8[k];
row["ReturnRmkCrdText"] = dataRow4["DCRRE"].ToString().Trim();
}
row["ReturnShipToName"] = this.myText.ToTitleCase(dataRow3["CSNAM"].ToString().Trim());
row["ReturnShipToAttn"] = this.myText.ToTitleCase(dataRow3["CSATN"].ToString().Trim());
row["ReturnShipToAddr"] = this.myText.ToTitleCase(dataRow3["CSAD1"].ToString().Trim());
row["ReturnShipToAddr2"] = string.Format("{0}, {1} {2}", this.myText.ToTitleCase(dataRow3["CSCIT"].ToString().Trim()), this.myText.ToTitleCase(dataRow3["CSSTA"].ToString().Trim()), dataRow3["CSZIP"].ToString().Trim());
row["ReturnComments"] = dataRow3["RETCT"].ToString().Trim();
DataRow[] rowsReturnComments = this.rowsRETCOMMENT.Select(string.Format("RETANO = {0}", dataRow3["RETANO"].ToString().Trim()));
dataRowArray8 = rowsReturnComments;
for (k = 0; k < (int)dataRowArray8.Length; k++)
{
DataRow rowComment = dataRowArray8[k];
DataRow dataRow35 = row;
DataRow dataRow36 = dataRow35;
dataRow35["RepComments"] = string.Concat(dataRow36["RepComments"], rowComment["CMTRE"].ToString());
}
}
}
catch (Exception exception7)
{
ex = exception7;
base.Response.Redirect(ConfigurationManager.AppSettings.Get("ErrorURL"), false);
}
Label4:
}
this.dtRepeaterPrint.Rows.Add(row);
}[ERROR]
} [ERROR]
catch (Exception exception8)
{
ex = exception8;
base.Response.Redirect(ConfigurationManager.AppSettings.Get("ErrorURL"), false);
}
}
}
catch (Exception exception9)
{
ex = exception9;
base.Response.Redirect(ConfigurationManager.AppSettings.Get("ErrorURL"), false);
}
}