/// <summary> /// Update a database row from a class /// </summary> public static void UpdateRowFromOrdhdrBase(ref DataRow row, OrdhdrBase entity) { row.SetField("id", entity.id); 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("order_date", entity.orderDate); row.SetField("ship_date", entity.shipDate); row.SetField("orig_order_date", entity.origOrderDate); row.SetField("exp_ship_date", entity.expShipDate); row.SetField("cust_code", entity.custCode); row.SetField("bill_name", entity.billName); row.SetField("bill_addr1", entity.billAddr1); row.SetField("bill_addr2", entity.billAddr2); row.SetField("bill_addr_ext1", entity.billAddrExt1); row.SetField("bill_addr_ext2", entity.billAddrExt2); row.SetField("bill_addr_ext3", entity.billAddrExt3); row.SetField("bill_city", entity.billCity); row.SetField("bill_state", entity.billState); row.SetField("bill_zip", entity.billZip); row.SetField("bill_country", entity.billCountry); row.SetField("ship_cust_code", entity.shipCustCode); row.SetField("ship_name", entity.shipName); row.SetField("ship_addr1", entity.shipAddr1); row.SetField("ship_addr2", entity.shipAddr2); row.SetField("ship_addr_ext1", entity.shipAddrExt1); row.SetField("ship_addr_ext2", entity.shipAddrExt2); row.SetField("ship_addr_ext3", entity.shipAddrExt3); row.SetField("ship_city", entity.shipCity); row.SetField("ship_state", entity.shipState); row.SetField("ship_zip", entity.shipZip); row.SetField("ship_country", entity.shipCountry); row.SetField("cod_flag", entity.codFlag); row.SetField("cod_amount", entity.codAmount); row.SetField("cod_charge", entity.codCharge); row.SetField("cod_name", entity.codName); row.SetField("cod_addr1", entity.codAddr1); row.SetField("cod_addr2", entity.codAddr2); row.SetField("cod_addr3", entity.codAddr3); row.SetField("cod_addr4", entity.codAddr4); row.SetField("cod_addr5", entity.codAddr5); row.SetField("cod_city", entity.codCity); row.SetField("cod_state", entity.codState); row.SetField("cod_zip", entity.codZip); row.SetField("cod_country", entity.codCountry); row.SetField("customer_po", entity.customerPo); row.SetField("branch_id", entity.branchId); row.SetField("carrier", entity.carrier); row.SetField("service", entity.service); row.SetField("pro_number", entity.proNumber); row.SetField("customer_freight", entity.customerFreight); row.SetField("actual_freight", entity.actualFreight); row.SetField("discount", entity.discount); row.SetField("tax", entity.tax); row.SetField("charges", entity.charges); row.SetField("line_count", entity.lineCount); row.SetField("partial", entity.partial); row.SetField("type", entity.type); row.SetField("class", entity.@class); row.SetField("drop_type", entity.dropType); row.SetField("kit_build_type", entity.kitBuildType); row.SetField("international", entity.international); row.SetField("priority", entity.priority); row.SetField("assigned", entity.assigned); row.SetField("printed", entity.printed); row.SetField("batch", entity.batch); row.SetField("host_batch", entity.hostBatch); row.SetField("host_sequence", entity.hostSequence); row.SetField("comment", entity.comment); row.SetField("del_route", entity.delRoute); row.SetField("rate_type", entity.rateType); row.SetField("freight_terms", entity.freightTerms); row.SetField("hold_reason", entity.holdReason); row.SetField("product", entity.product); row.SetField("lot", entity.lot); row.SetField("product_qty", entity.productQty); row.SetField("orig_weight", entity.origWeight); row.SetField("drop_weight", entity.dropWeight); row.SetField("ship_weight", entity.shipWeight); row.SetField("orig_cube", entity.origCube); row.SetField("drop_cube", entity.dropCube); row.SetField("ship_cube", entity.shipCube); row.SetField("shp_by_irms", entity.shpByIrms); row.SetField("host_selector", entity.hostSelector); row.SetField("custom_selector", entity.customSelector); row.SetField("pay_method", entity.payMethod); row.SetField("max_days", entity.maxDays); row.SetField("guaranteed_del_time", entity.guaranteedDelTime); 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("cancel_flag", entity.cancelFlag); row.SetField("clearance_required", entity.clearanceRequired); row.SetField("clearance_code", entity.clearanceCode); row.SetField("order_status", entity.orderStatus); row.SetField("row_status", entity.rowStatus); row.SetField("ship_to_code", entity.shipToCode); row.SetField("pallet_drop_fl", entity.palletDropFl); row.SetField("route", entity.route); row.SetField("trans_user", entity.transUser); row.SetField("trans_date", entity.transDate); row.SetField("trans_proc", entity.transProc); row.SetField("takenby", entity.takenby); row.SetField("slsrepin", entity.slsrepin); row.SetField("slsrepout", entity.slsrepout); row.SetField("memo", entity.memo); row.SetField("total_line_cnt", entity.totalLineCnt); row.SetField("total_line_qty", entity.totalLineQty); row.SetField("ordhdrRowID", entity.rowID.ToByteArray()); }
/// <summary> /// Build a minimal row from a class (key fields only) /// </summary> public static void BuildMinimalRow(ref DataRow row, OrdhdrBase entity) { row.SetField("id", entity.id); row.SetField("ordhdrRowID", entity.rowID.ToByteArray()); }