private string formatSortedItemRecord(SortedItemDS.SortedItemTableRow sortedItem)
{
//Returns a string formatted by concatination of the Catons row columns
//Note: Include time in pickup date string format (even though no time in data date field)
const string DELIM = ",";
const string QUOTE = "\"";
string item = "";
try {
item =
QUOTE + sortedItem.CLIENT_NUMBER.Trim() + QUOTE + DELIM +
QUOTE + sortedItem.CLIENT_DIV_NUM.Trim() + QUOTE + DELIM +
QUOTE + sortedItem.VENDOR_NUMBER.Trim() + QUOTE + DELIM +
sortedItem.PICKUP_DATE.ToString("MM/dd/yyyy HH:mm:ss") + DELIM +
sortedItem.PICKUP_NUMBER + DELIM +
QUOTE + sortedItem.VENDOR_ITEM_NUMBER + QUOTE + DELIM +
QUOTE + sortedItem.LABEL_SEQ_NUMBER.Trim() + QUOTE + DELIM +
sortedItem.ITEM_WEIGHT + DELIM +
QUOTE + sortedItem.STORE.ToString("00000") + QUOTE + DELIM +
QUOTE + sortedItem.SORT_DATE.ToShortDateString() + QUOTE + DELIM +
QUOTE + sortedItem.END_TIME.ToLongTimeString() + QUOTE + DELIM +
QUOTE + (sortedItem.IsDAMAGE_CODENull() ? "" : sortedItem.DAMAGE_CODE.Trim()) + QUOTE + DELIM +
QUOTE + sortedItem.FreightType.Trim() + QUOTE;
}
catch (Exception ex) { throw new ApplicationException("Unexpected error while formatting sortedItem export string.", ex); }
return(item);
}
private string formatSortedItemRecord(string clientCode, SortedItemDS.SortedItemTableRow sortedItem)
{
//Returns a string representation of the sorted item
#region Sorted Item record
//S29127133277 020021220094806123456
//S000744232835 020040809084200
//S1850200205252 020040809102100
//S060440839041028135854050 020041102084439
//S0000420018049386522806125 020061031082012
//-==========================-========------======
//|| || | |
//ab cd e f
//a) Barcode Origin [1]
// – S = Scanned; M = Manual (always S for RDS Export application)
//b) Barcode Stream [26]
// - sorted item vendor item# in Client file
// - 24 position sorted item# in Argix file
//c) Damage Code [1]
// - sorted item damage code
//d) Scan Date [8, YYYYMMDD]
// - sorted item sort date
//e) Scan Time [6, HHMMSS]
// - sorted item end time
//f) Override (Inbound) or From Store (Return, Transfer) [6]
// – sorted item weight (999900 = 9999.00, i.e. decimal understood)
#endregion
string s = "";
try {
string lsn24 = sortedItem.CLIENT_NUMBER + (sortedItem.FreightType.ToUpper() == "R" ? "88" : "44") + sortedItem.STORE.ToString("00000") + sortedItem.LABEL_SEQ_NUMBER + "0";
string barcode = (clientCode.Trim().ToLower() == global::Argix.Properties.Settings.Default.ArgixClientCode.Trim().ToLower()) ? lsn24 : sortedItem.VENDOR_ITEM_NUMBER.Trim();
string dc = sortedItem.IsDAMAGE_CODENull() ? "0" : sortedItem.DAMAGE_CODE.Trim().PadLeft(2, '0').Substring(1, 1);
s = "S" +
barcode.PadRight(26, ' ') +
dc +
sortedItem.SORT_DATE.ToString("yyyyMMdd") +
sortedItem.END_TIME.ToString("HHmmss") +
(sortedItem.ITEM_WEIGHT.ToString() + "00").PadLeft(6, '0');
}
catch (Exception ex) { throw new ApplicationException("Unexpected error while formatting sorted item export string.", ex); }
return(s);
}
private string formatSortedItemRecord(string clientCode, SortedItemDS.SortedItemTableRow sortedItem)
{
//Returns a string representation of the sorted item
#region Sorted Item record
//S29127133277 020021220094806
//S000744232835 020040809084200
//S1850200205252 020040809102100
//S060440839041028135854050 020041102084439
//S0000420018049386522806125 020061031082012
//-==========================-========------
//|| || |
//ab cd e
//a) Barcode Origin [1]
// – S = Scanned; M = Manual (always S)
//b) Barcode Stream [25]
// - sorted item vendor item# in Client file
//c) Damage Code [1]
// - sorted item damage code
//d) Scan Date [8, YYYYMMDD]
// - sorted item sort date
//e) Scan Time [6, HHMMSS]
// - sorted item end time
#endregion
string s = "";
try {
string barcode = sortedItem.VENDOR_ITEM_NUMBER.Trim();
string dc = sortedItem.IsDAMAGE_CODENull() ? "0" : sortedItem.DAMAGE_CODE.Trim().PadLeft(2, '0').Substring(1, 1);
s = "S" +
barcode.PadRight(25, ' ') +
dc +
sortedItem.SORT_DATE.ToString("yyyyMMdd") +
sortedItem.END_TIME.ToString("HHmmss");
}
catch (Exception ex) { throw new ApplicationException("Unexpected error while formatting sorted item export string.", ex); }
return(s);
}
public SortedItem(SortedItemDS.SortedItemTableRow sortedItem)
{
//Constructor
try {
if (sortedItem != null)
{
this._labelseqnumber = sortedItem.LABEL_SEQ_NUMBER;
if (!sortedItem.IsCLIENT_NUMBERNull())
{
this._clientnumber = sortedItem.CLIENT_NUMBER.Trim();
}
if (!sortedItem.IsCLIENT_DIV_NUMNull())
{
this._clientdivnumber = sortedItem.CLIENT_DIV_NUM.Trim();
}
if (!sortedItem.IsAGENT_NUMBERNull())
{
this._agentnumber = sortedItem.AGENT_NUMBER.Trim();
}
if (!sortedItem.IsVENDOR_NUMBERNull())
{
this._vendornumber = sortedItem.VENDOR_NUMBER.Trim();
}
if (!sortedItem.IsSORTED_LOCATIONNull())
{
this._sortedlocation = sortedItem.SORTED_LOCATION.Trim();
}
if (!sortedItem.IsDAMAGE_CODENull())
{
this._damagecode = sortedItem.DAMAGE_CODE.Trim();
}
if (!sortedItem.IsPICKUP_DATENull())
{
this._pickupdate = sortedItem.PICKUP_DATE;
}
if (!sortedItem.IsPICKUP_NUMBERNull())
{
this._pickupnumber = sortedItem.PICKUP_NUMBER;
}
if (!sortedItem.IsSTORENull())
{
this._store = sortedItem.STORE;
}
if (!sortedItem.IsZONE_CODENull())
{
this._zonecode = sortedItem.ZONE_CODE.Trim();
}
if (!sortedItem.IsTRAILER_LOAD_NUMNull())
{
this._trailerloadnumber = sortedItem.TRAILER_LOAD_NUM.Trim();
}
if (!sortedItem.IsITEM_TYPENull())
{
this._itemtype = sortedItem.ITEM_TYPE.Trim();
}
if (!sortedItem.IsITEM_WEIGHTNull())
{
this._itemweight = sortedItem.ITEM_WEIGHT;
}
if (!sortedItem.IsVENDOR_KEYNull())
{
this._vendorkey = sortedItem.VENDOR_KEY.Trim();
}
if (!sortedItem.IsVENDOR_ITEM_NUMBERNull())
{
this._vemdoritemnumber = sortedItem.VENDOR_ITEM_NUMBER.Trim();
}
if (!sortedItem.IsRETURN_FLAGNull())
{
this._returnflag = sortedItem.RETURN_FLAG.Trim();
}
if (!sortedItem.IsRETURN_NUMBERNull())
{
this._returnnumber = sortedItem.RETURN_NUMBER.Trim();
}
if (!sortedItem.IsSHIFT_NUMBERNull())
{
this._shiftnumber = sortedItem.SHIFT_NUMBER.Trim();
}
if (!sortedItem.IsSHIFT_DATENull())
{
this._shiftdate = sortedItem.SHIFT_DATE;
}
if (!sortedItem.IsEND_TIMENull())
{
this._endtime = sortedItem.END_TIME;
}
if (!sortedItem.IsARC_DATENull())
{
this._arcdate = sortedItem.ARC_DATE;
}
if (!sortedItem.IsSTATIONNull())
{
this._station = sortedItem.STATION.Trim();
}
if (!sortedItem.IsITEM_CUBENull())
{
this._itemcube = sortedItem.ITEM_CUBE;
}
if (!sortedItem.IsSORT_DATENull())
{
this._sortdate = sortedItem.SORT_DATE;
}
if (!sortedItem.IsSAN_NUMBERNull())
{
this._sannumber = sortedItem.SAN_NUMBER.Trim();
}
if (!sortedItem.IsELAPSED_SECONDSNull())
{
this._elapsedseconds = sortedItem.ELAPSED_SECONDS;
}
if (!sortedItem.IsDOWN_SECONDSNull())
{
this._downseconds = sortedItem.DOWN_SECONDS;
}
if (!sortedItem.IsPO_NUMBERNull())
{
this._ponumber = sortedItem.PO_NUMBER.Trim();
}
if (!sortedItem.IsOS_TRACKING_NUMBERNull())
{
this._ostrackingnumber = sortedItem.OS_TRACKING_NUMBER.Trim();
}
if (!sortedItem.IsSHIPPING_METHODNull())
{
this._shippingmethod = sortedItem.SHIPPING_METHOD.Trim();
}
if (!sortedItem.IsSAMPLE_DATENull())
{
this._sampledate = sortedItem.SAMPLE_DATE;
}
if (!sortedItem.IsScanStringNull())
{
this._scanstring = sortedItem.ScanString.Trim();
}
if (!sortedItem.IsInboundLabelIDNull())
{
this._inboundlabelid = sortedItem.InboundLabelID;
}
if (!sortedItem.IsFreightTypeNull())
{
this._freighttype = sortedItem.FreightType.Trim();
}
}
}
catch (Exception ex) { throw new ApplicationException("", ex); }
}
