Пример #1
0
 /// <summary>
 /// Build a minimal row from a class (key fields only)
 /// </summary>
 public static void BuildMinimalRow(ref DataRow row, OeelkBase entity)
 {
     row.SetField("cono", entity.cono);
     row.SetField("orderno", entity.orderno);
     row.SetField("ordersuf", entity.ordersuf);
     row.SetField("lineno", entity.lineno);
     row.SetField("seqno", entity.seqno);
     row.SetField("ordertype", entity.ordertype);
     row.SetField("oeelkRowID", entity.rowID.ToByteArray());
 }
Пример #2
0
 /// <summary>
 /// Update a database row from a class
 /// </summary>
 public static void UpdateRowFromOeelkBase(ref DataRow row, OeelkBase entity)
 {
     row.SetField("cono", entity.cono);
     row.SetField("orderno", entity.orderno);
     row.SetField("ordersuf", entity.ordersuf);
     row.SetField("lineno", entity.lineno);
     row.SetField("seqno", entity.seqno);
     row.SetField("shipprod", entity.shipprod);
     row.SetField("stkqtyship", entity.stkqtyship);
     row.SetField("subfl", entity.subfl);
     row.SetField("variablefl", entity.variablefl);
     row.SetField("serlottype", entity.serlottype);
     row.SetField("qtyneeded", entity.qtyneeded);
     row.SetField("unit", entity.unit);
     row.SetField("custno", entity.custno);
     row.SetField("transdt", entity.transdt);
     row.SetField("transtm", entity.transtm);
     row.SetField("operinit", entity.operinit);
     row.SetField("shipto", entity.shipto);
     row.SetField("transtype", entity.transtype);
     row.SetField("whse", entity.whse);
     row.SetField("altwhse", entity.altwhse);
     row.SetField("price", entity.price);
     row.SetField("prodcat", entity.prodcat);
     row.SetField("prodcost", entity.prodcost);
     row.SetField("stkqtyord", entity.stkqtyord);
     row.SetField("prevprod", entity.prevprod);
     row.SetField("prevqtyship", entity.prevqtyship);
     row.SetField("salesterr", entity.salesterr);
     row.SetField("statustype", entity.statustype);
     row.SetField("specnstype", entity.specnstype);
     row.SetField("prevqtyord", entity.prevqtyord);
     row.SetField("commcost", entity.commcost);
     row.SetField("comptype", entity.comptype);
     row.SetField("groupoptname", entity.groupoptname);
     row.SetField("ordertype", entity.ordertype);
     row.SetField("prevunit", entity.prevunit);
     row.SetField("pricefl", entity.pricefl);
     row.SetField("printfl", entity.printfl);
     row.SetField("processtatfl", entity.processtatfl);
     row.SetField("qtyord", entity.qtyord);
     row.SetField("user1", entity.user1);
     row.SetField("qtyship", entity.qtyship);
     row.SetField("user2", entity.user2);
     row.SetField("refer", entity.refer);
     row.SetField("glcost", entity.glcost);
     row.SetField("reqfl", entity.reqfl);
     row.SetField("reqprod", entity.reqprod);
     row.SetField("prevqtyrsv", entity.prevqtyrsv);
     row.SetField("conv", entity.conv);
     row.SetField("qtyreservd", entity.qtyreservd);
     row.SetField("pdrecno", entity.pdrecno);
     row.SetField("compboty", entity.compboty);
     row.SetField("wmqtyship", entity.wmqtyship);
     row.SetField("prevspecns", entity.prevspecns);
     row.SetField("prevconv", entity.prevconv);
     row.SetField("instructions", entity.instructions);
     row.SetField("wlpicktype", entity.wlpicktype);
     row.SetField("retseqno", entity.retseqno);
     row.SetField("rbcparm", entity.rbcparm);
     row.SetField("proddesc2", entity.proddesc2);
     row.SetField("icspecrecno", entity.icspecrecno);
     row.SetField("ovshipfl", entity.ovshipfl);
     row.SetField("delayresrvfl", entity.delayresrvfl);
     row.SetField("user3", entity.user3);
     row.SetField("user4", entity.user4);
     row.SetField("user5", entity.user5);
     row.SetField("user6", entity.user6);
     row.SetField("user7", entity.user7);
     row.SetField("user8", entity.user8);
     row.SetField("user9", entity.user9);
     row.SetField("arpvendno", entity.arpvendno);
     row.SetField("arpprodline", entity.arpprodline);
     row.SetField("arpwhse", entity.arpwhse);
     row.SetField("proddesc", entity.proddesc);
     row.SetField("pricetype", entity.pricetype);
     row.SetField("orderalttype", entity.orderalttype);
     row.SetField("orderaltno", entity.orderaltno);
     row.SetField("linealtno", entity.linealtno);
     row.SetField("cataddfl", entity.cataddfl);
     row.SetField("qtyfmrcvs", entity.qtyfmrcvs);
     row.SetField("costoverfl", entity.costoverfl);
     row.SetField("transproc", entity.transproc);
     row.SetField("user10", entity.user10);
     row.SetField("user11", entity.user11);
     row.SetField("user12", entity.user12);
     row.SetField("user13", entity.user13);
     row.SetField("user14", entity.user14);
     row.SetField("user15", entity.user15);
     row.SetField("user16", entity.user16);
     row.SetField("user17", entity.user17);
     row.SetField("user18", entity.user18);
     row.SetField("user19", entity.user19);
     row.SetField("user20", entity.user20);
     row.SetField("user21", entity.user21);
     row.SetField("user22", entity.user22);
     row.SetField("user23", entity.user23);
     row.SetField("user24", entity.user24);
     row.SetField("custcost", entity.custcost);
     row.SetField("custqty", entity.custqty);
     row.SetField("cfgcompfl", entity.cfgcompfl);
     row.SetField("cfgcompmodfl", entity.cfgcompmodfl);
     row.SetField("leadtm", entity.leadtm);
     row.SetField("countryoforigin", entity.countryoforigin);
     row.SetField("tariffcd", entity.tariffcd);
     row.SetField("oeelkRowID", entity.rowID.ToByteArray());
 }