Exemple #1
0
 /// <summary>
 /// Update a database row from a class
 /// </summary>
 public static void UpdateRowFromReceipttranscontdet(ref DataRow row, Receipttranscontdet entity)
 {
     row.SetField("abs_num", entity.absNum);
     row.SetField("act_quantity", entity.actQuantity);
     row.SetField("asn_flag", entity.asnFlag);
     row.SetField("bo_count", entity.boCount);
     row.SetField("bo_quantity", entity.boQuantity);
     row.SetField("case_quantity", entity.caseQuantity);
     row.SetField("comments", entity.comments);
     row.SetField("co_num", entity.coNum);
     row.SetField("custom_data1", entity.customData1);
     row.SetField("custom_data2", entity.customData2);
     row.SetField("custom_data3", entity.customData3);
     row.SetField("custom_data4", entity.customData4);
     row.SetField("custom_data5", entity.customData5);
     row.SetField("delivery", entity.delivery);
     row.SetField("exp_quantity", entity.expQuantity);
     row.SetField("item_cost", entity.itemCost);
     row.SetField("item_desc", entity.itemDesc);
     row.SetField("item_num", entity.itemNum);
     row.SetField("line_indicator", entity.lineIndicator);
     row.SetField("line_num", entity.lineNum);
     row.SetField("line_sequence", entity.lineSequence);
     row.SetField("lot", entity.lot);
     row.SetField("ordered_qty", entity.orderedQty);
     row.SetField("packer", entity.packer);
     row.SetField("packing_list", entity.packingList);
     row.SetField("packing_list_mst", entity.packingListMst);
     row.SetField("percent_fill", entity.percentFill);
     row.SetField("po_line", entity.poLine);
     row.SetField("po_number", entity.poNumber);
     row.SetField("po_suffix", entity.poSuffix);
     row.SetField("po_type", entity.poType);
     row.SetField("prod_desc", entity.prodDesc);
     row.SetField("qty_unavail", entity.qtyUnavail);
     row.SetField("quantity", entity.quantity);
     row.SetField("rd_po_type", entity.rdPoType);
     row.SetField("receiver_num", entity.receiverNum);
     row.SetField("return_fl", entity.returnFl);
     row.SetField("ret_line", entity.retLine);
     row.SetField("ret_line_sequence", entity.retLineSequence);
     row.SetField("row_status", entity.rowStatus);
     row.SetField("row_status_mst", entity.rowStatusMst);
     row.SetField("rtn_order", entity.rtnOrder);
     row.SetField("rtn_order_suffix", entity.rtnOrderSuffix);
     row.SetField("rt_id", entity.rtId);
     row.SetField("rt_num_mst", entity.rtNumMst);
     row.SetField("special_handling", entity.specialHandling);
     row.SetField("stock_stat", entity.stockStat);
     row.SetField("trans_date", entity.transDate);
     row.SetField("trans_proc", entity.transProc);
     row.SetField("trans_user", entity.transUser);
     row.SetField("uom", entity.uom);
     row.SetField("vendor_id", entity.vendorId);
     row.SetField("vend_item", entity.vendItem);
     row.SetField("wh_num", entity.whNum);
     row.SetField("rowID", entity.rowID.ToByteArray());
     row.SetField("commentsExistFl", entity.commentsExistFl);
     row.SetField("userfield", entity.userfield);
 }
Exemple #2
0
        public static Receipttranscontdet BuildReceipttranscontdetFromRow(DataRow row)
        {
            Receipttranscontdet entity = new Receipttranscontdet();

            entity.absNum          = row.IsNull("abs_num") ? string.Empty : row.Field <string>("abs_num");
            entity.actQuantity     = row.IsNull("act_quantity") ? decimal.Zero : row.Field <decimal>("act_quantity");
            entity.asnFlag         = row.Field <bool>("asn_flag");
            entity.boCount         = row.IsNull("bo_count") ? 0 : row.Field <int>("bo_count");
            entity.boQuantity      = row.IsNull("bo_quantity") ? decimal.Zero : row.Field <decimal>("bo_quantity");
            entity.caseQuantity    = row.IsNull("case_quantity") ? decimal.Zero : row.Field <decimal>("case_quantity");
            entity.comments        = row.IsNull("comments") ? string.Empty : row.Field <string>("comments");
            entity.coNum           = row.IsNull("co_num") ? string.Empty : row.Field <string>("co_num");
            entity.customData1     = row.IsNull("custom_data1") ? string.Empty : row.Field <string>("custom_data1");
            entity.customData2     = row.IsNull("custom_data2") ? string.Empty : row.Field <string>("custom_data2");
            entity.customData3     = row.IsNull("custom_data3") ? string.Empty : row.Field <string>("custom_data3");
            entity.customData4     = row.IsNull("custom_data4") ? string.Empty : row.Field <string>("custom_data4");
            entity.customData5     = row.IsNull("custom_data5") ? string.Empty : row.Field <string>("custom_data5");
            entity.delivery        = row.Field <DateTime?>("delivery");
            entity.expQuantity     = row.IsNull("exp_quantity") ? decimal.Zero : row.Field <decimal>("exp_quantity");
            entity.itemCost        = row.IsNull("item_cost") ? decimal.Zero : row.Field <decimal>("item_cost");
            entity.itemDesc        = row.IsNull("item_desc") ? string.Empty : row.Field <string>("item_desc");
            entity.itemNum         = row.IsNull("item_num") ? string.Empty : row.Field <string>("item_num");
            entity.lineIndicator   = row.IsNull("line_indicator") ? string.Empty : row.Field <string>("line_indicator");
            entity.lineNum         = row.IsNull("line_num") ? 0 : row.Field <int>("line_num");
            entity.lineSequence    = row.IsNull("line_sequence") ? 0 : row.Field <int>("line_sequence");
            entity.lot             = row.IsNull("lot") ? string.Empty : row.Field <string>("lot");
            entity.orderedQty      = row.IsNull("ordered_qty") ? decimal.Zero : row.Field <decimal>("ordered_qty");
            entity.packer          = row.IsNull("packer") ? string.Empty : row.Field <string>("packer");
            entity.packingList     = row.Field <bool>("packing_list");
            entity.packingListMst  = row.Field <bool>("packing_list_mst");
            entity.percentFill     = row.IsNull("percent_fill") ? decimal.Zero : row.Field <decimal>("percent_fill");
            entity.poLine          = row.IsNull("po_line") ? 0 : row.Field <int>("po_line");
            entity.poNumber        = row.IsNull("po_number") ? string.Empty : row.Field <string>("po_number");
            entity.poSuffix        = row.IsNull("po_suffix") ? string.Empty : row.Field <string>("po_suffix");
            entity.poType          = row.IsNull("po_type") ? string.Empty : row.Field <string>("po_type");
            entity.prodDesc        = row.IsNull("prod_desc") ? string.Empty : row.Field <string>("prod_desc");
            entity.qtyUnavail      = row.IsNull("qty_unavail") ? decimal.Zero : row.Field <decimal>("qty_unavail");
            entity.quantity        = row.IsNull("quantity") ? decimal.Zero : row.Field <decimal>("quantity");
            entity.rdPoType        = row.IsNull("rd_po_type") ? string.Empty : row.Field <string>("rd_po_type");
            entity.receiverNum     = row.IsNull("receiver_num") ? string.Empty : row.Field <string>("receiver_num");
            entity.returnFl        = row.IsNull("return_fl") ? string.Empty : row.Field <string>("return_fl");
            entity.retLine         = row.IsNull("ret_line") ? 0 : row.Field <int>("ret_line");
            entity.retLineSequence = row.IsNull("ret_line_sequence") ? 0 : row.Field <int>("ret_line_sequence");
            entity.rowStatus       = row.IsNull("row_status") ? string.Empty : row.Field <string>("row_status");
            entity.rowStatusMst    = row.IsNull("row_status_mst") ? string.Empty : row.Field <string>("row_status_mst");
            entity.rtnOrder        = row.IsNull("rtn_order") ? string.Empty : row.Field <string>("rtn_order");
            entity.rtnOrderSuffix  = row.IsNull("rtn_order_suffix") ? string.Empty : row.Field <string>("rtn_order_suffix");
            entity.rtId            = row.IsNull("rt_id") ? 0 : row.Field <int>("rt_id");
            entity.rtNumMst        = row.IsNull("rt_num_mst") ? string.Empty : row.Field <string>("rt_num_mst");
            entity.specialHandling = row.IsNull("special_handling") ? string.Empty : row.Field <string>("special_handling");
            entity.stockStat       = row.IsNull("stock_stat") ? string.Empty : row.Field <string>("stock_stat");
            entity.transDate       = row.IsNull("trans_date") ? string.Empty : row.Field <string>("trans_date");
            entity.transProc       = row.IsNull("trans_proc") ? string.Empty : row.Field <string>("trans_proc");
            entity.transUser       = row.IsNull("trans_user") ? string.Empty : row.Field <string>("trans_user");
            entity.uom             = row.IsNull("uom") ? string.Empty : row.Field <string>("uom");
            entity.vendorId        = row.IsNull("vendor_id") ? string.Empty : row.Field <string>("vendor_id");
            entity.vendItem        = row.IsNull("vend_item") ? string.Empty : row.Field <string>("vend_item");
            entity.whNum           = row.IsNull("wh_num") ? string.Empty : row.Field <string>("wh_num");
            entity.rowID           = row.Field <byte[]>("rowID").ToStringEncoded();
            entity.commentsExistFl = row.Field <bool>("commentsExistFl");
            entity.userfield       = row.IsNull("userfield") ? string.Empty : row.Field <string>("userfield");
            return(entity);
        }