/// <summary> /// Update a database row from a class /// </summary> public static void UpdateRowFromOrderlines(ref DataRow row, Orderlines entity) { row.SetField("co_num", entity.coNum); row.SetField("wh_num", entity.whNum); row.SetField("order", entity.order); row.SetField("order_suffix", entity.orderSuffix); row.SetField("actual_freight", entity.actualFreight); row.SetField("line", entity.line); row.SetField("line_alt_number", entity.lineAltNumber); row.SetField("line_sequence", entity.lineSequence); row.SetField("abs_num", entity.absNum); row.SetField("abs_num_desc", entity.absNumDesc); row.SetField("act_qty", entity.actQty); row.SetField("altwhse", entity.altwhse); row.SetField("assigned", entity.assigned); row.SetField("bin_num", entity.binNum); row.SetField("charges", entity.charges); row.SetField("comment", entity.comment); 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("discount", entity.discount); row.SetField("drop_cube", entity.dropCube); row.SetField("drop_weight", entity.dropWeight); row.SetField("fl_zone", entity.flZone); row.SetField("id", entity.id); row.SetField("kit_required", entity.kitRequired); row.SetField("line_status", entity.lineStatus); row.SetField("line_status_desc", entity.lineStatusDesc); row.SetField("lostbusty", entity.lostbusty); row.SetField("lot", entity.lot); row.SetField("msds_employee", entity.msdsEmployee); row.SetField("msds_packed", entity.msdsPacked); row.SetField("msds_required", entity.msdsRequired); row.SetField("msds_sheet", entity.msdsSheet); row.SetField("order_alt_num", entity.orderAltNum); row.SetField("order_alt_suf", entity.orderAltSuf); row.SetField("ordered_qty", entity.orderedQty); row.SetField("orig_cube", entity.origCube); row.SetField("orig_req_qty", entity.origReqQty); row.SetField("orig_weight", entity.origWeight); row.SetField("origvalineno", entity.origvalineno); row.SetField("origvaseqno", entity.origvaseqno); row.SetField("package_code", entity.packageCode); row.SetField("pick_line", entity.pickLine); row.SetField("po_line", entity.poLine); row.SetField("po_line_sequence", entity.poLineSequence); row.SetField("po_number", entity.poNumber); row.SetField("po_suffix", entity.poSuffix); row.SetField("req_qty", entity.reqQty); row.SetField("ret_qty", entity.retQty); row.SetField("rt_num", entity.rtNum); row.SetField("sale_uom", entity.saleUom); row.SetField("sale_uom_conv", entity.saleUomConv); row.SetField("same_lot", entity.sameLot); row.SetField("serial_num", entity.serialNum); row.SetField("ship_cube", entity.shipCube); row.SetField("ship_weight", entity.shipWeight); row.SetField("shipcompfl", entity.shipcompfl); row.SetField("stock_stat", entity.stockStat); row.SetField("tax", entity.tax); row.SetField("vendor_id", entity.vendorId); row.SetField("wlpicktype", entity.wlpicktype); row.SetField("work_center", entity.workCenter); row.SetField("isComments", entity.isComments); row.SetField("item_serial_flag", entity.itemSerialFlag); row.SetField("rowID", entity.rowID.ToByteArray()); row.SetField("trans_date", entity.transDate); row.SetField("trans_proc", entity.transProc); row.SetField("trans_user", entity.transUser); row.SetField("userfield", entity.userfield); }
public static Orderlines BuildOrderlinesFromRow(DataRow row) { Orderlines entity = new Orderlines(); entity.coNum = row.IsNull("co_num") ? string.Empty : row.Field <string>("co_num"); entity.whNum = row.IsNull("wh_num") ? string.Empty : row.Field <string>("wh_num"); entity.order = row.IsNull("order") ? string.Empty : row.Field <string>("order"); entity.orderSuffix = row.IsNull("order_suffix") ? string.Empty : row.Field <string>("order_suffix"); entity.actualFreight = row.IsNull("actual_freight") ? decimal.Zero : row.Field <decimal>("actual_freight"); entity.line = row.IsNull("line") ? 0 : row.Field <int>("line"); entity.lineAltNumber = row.IsNull("line_alt_number") ? 0 : row.Field <int>("line_alt_number"); entity.lineSequence = row.IsNull("line_sequence") ? 0 : row.Field <int>("line_sequence"); entity.absNum = row.IsNull("abs_num") ? string.Empty : row.Field <string>("abs_num"); entity.absNumDesc = row.IsNull("abs_num_desc") ? string.Empty : row.Field <string>("abs_num_desc"); entity.actQty = row.IsNull("act_qty") ? decimal.Zero : row.Field <decimal>("act_qty"); entity.altwhse = row.IsNull("altwhse") ? string.Empty : row.Field <string>("altwhse"); entity.assigned = row.Field <bool>("assigned"); entity.binNum = row.IsNull("bin_num") ? string.Empty : row.Field <string>("bin_num"); entity.charges = row.IsNull("charges") ? decimal.Zero : row.Field <decimal>("charges"); entity.comment = row.IsNull("comment") ? string.Empty : row.Field <string>("comment"); 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.discount = row.IsNull("discount") ? decimal.Zero : row.Field <decimal>("discount"); entity.dropCube = row.IsNull("drop_cube") ? decimal.Zero : row.Field <decimal>("drop_cube"); entity.dropWeight = row.IsNull("drop_weight") ? decimal.Zero : row.Field <decimal>("drop_weight"); entity.flZone = row.IsNull("fl_zone") ? string.Empty : row.Field <string>("fl_zone"); entity.id = row.IsNull("id") ? 0 : row.Field <int>("id"); entity.kitRequired = row.Field <bool>("kit_required"); entity.lineStatus = row.IsNull("line_status") ? string.Empty : row.Field <string>("line_status"); entity.lineStatusDesc = row.IsNull("line_status_desc") ? string.Empty : row.Field <string>("line_status_desc"); entity.lostbusty = row.IsNull("lostbusty") ? string.Empty : row.Field <string>("lostbusty"); entity.lot = row.IsNull("lot") ? string.Empty : row.Field <string>("lot"); entity.msdsEmployee = row.IsNull("msds_employee") ? string.Empty : row.Field <string>("msds_employee"); entity.msdsPacked = row.Field <bool>("msds_packed"); entity.msdsRequired = row.Field <bool>("msds_required"); entity.msdsSheet = row.IsNull("msds_sheet") ? string.Empty : row.Field <string>("msds_sheet"); entity.orderAltNum = row.IsNull("order_alt_num") ? 0 : row.Field <int>("order_alt_num"); entity.orderAltSuf = row.IsNull("order_alt_suf") ? 0 : row.Field <int>("order_alt_suf"); entity.orderedQty = row.IsNull("ordered_qty") ? decimal.Zero : row.Field <decimal>("ordered_qty"); entity.origCube = row.IsNull("orig_cube") ? decimal.Zero : row.Field <decimal>("orig_cube"); entity.origReqQty = row.IsNull("orig_req_qty") ? decimal.Zero : row.Field <decimal>("orig_req_qty"); entity.origWeight = row.IsNull("orig_weight") ? decimal.Zero : row.Field <decimal>("orig_weight"); entity.origvalineno = row.IsNull("origvalineno") ? 0 : row.Field <int>("origvalineno"); entity.origvaseqno = row.IsNull("origvaseqno") ? 0 : row.Field <int>("origvaseqno"); entity.packageCode = row.IsNull("package_code") ? string.Empty : row.Field <string>("package_code"); entity.pickLine = row.Field <bool>("pick_line"); entity.poLine = row.IsNull("po_line") ? 0 : row.Field <int>("po_line"); entity.poLineSequence = row.IsNull("po_line_sequence") ? 0 : row.Field <int>("po_line_sequence"); 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.reqQty = row.IsNull("req_qty") ? decimal.Zero : row.Field <decimal>("req_qty"); entity.retQty = row.IsNull("ret_qty") ? decimal.Zero : row.Field <decimal>("ret_qty"); entity.rtNum = row.IsNull("rt_num") ? string.Empty : row.Field <string>("rt_num"); entity.saleUom = row.IsNull("sale_uom") ? string.Empty : row.Field <string>("sale_uom"); entity.saleUomConv = row.IsNull("sale_uom_conv") ? decimal.Zero : row.Field <decimal>("sale_uom_conv"); entity.sameLot = row.Field <bool>("same_lot"); entity.serialNum = row.IsNull("serial_num") ? string.Empty : row.Field <string>("serial_num"); entity.shipCube = row.IsNull("ship_cube") ? decimal.Zero : row.Field <decimal>("ship_cube"); entity.shipWeight = row.IsNull("ship_weight") ? decimal.Zero : row.Field <decimal>("ship_weight"); entity.shipcompfl = row.Field <bool>("shipcompfl"); entity.stockStat = row.IsNull("stock_stat") ? string.Empty : row.Field <string>("stock_stat"); entity.tax = row.IsNull("tax") ? decimal.Zero : row.Field <decimal>("tax"); entity.vendorId = row.IsNull("vendor_id") ? string.Empty : row.Field <string>("vendor_id"); entity.wlpicktype = row.IsNull("wlpicktype") ? string.Empty : row.Field <string>("wlpicktype"); entity.workCenter = row.IsNull("work_center") ? string.Empty : row.Field <string>("work_center"); entity.isComments = row.Field <bool>("isComments"); entity.itemSerialFlag = row.Field <bool>("item_serial_flag"); entity.rowID = row.Field <byte[]>("rowID").ToStringEncoded(); 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.userfield = row.IsNull("userfield") ? string.Empty : row.Field <string>("userfield"); return(entity); }