コード例 #1
0
 /// <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());
 }
コード例 #2
0
 /// <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());
 }