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); } }