Exemplo n.º 1
0
 /// <summary>
 /// Build a minimal row from a class (key fields only)
 /// </summary>
 public static void BuildMinimalRow(ref DataRow row, IcscBase entity)
 {
     row.SetField("catalog", entity.catalog);
     row.SetField("icscRowID", entity.rowID.ToByteArray());
     row.SetField("rowpointer", entity.rowpointer);
 }
Exemplo n.º 2
0
 /// <summary>
 /// Update a database row from a class
 /// </summary>
 public static void UpdateRowFromIcscBase(ref DataRow row, IcscBase entity)
 {
     row.SetField("vendno", entity.vendno);
     row.SetField("catalog", entity.catalog);
     row.SetField("baseprice", entity.baseprice);
     row.SetField("listprice", entity.listprice);
     row.SetField("prodcost", entity.prodcost);
     row.SetField("unitstock", entity.unitstock);
     row.SetField("prodcat", entity.prodcat);
     row.SetField("prodline", entity.prodline);
     row.SetField("autotype", entity.autotype);
     row.SetField("descrip1", entity.descrip1);
     row.SetField("descrip2", entity.descrip2);
     row.SetField("weight", entity.weight);
     row.SetField("pricetype", entity.pricetype);
     row.SetField("priceonty", entity.priceonty);
     row.SetField("user1", entity.user1);
     row.SetField("user2", entity.user2);
     row.SetField("notesfl", entity.notesfl);
     row.SetField("cubes", entity.cubes);
     row.SetField("transdt", entity.transdt);
     row.SetField("desckey", entity.desckey);
     row.SetField("prccostper", entity.prccostper);
     row.SetField("speccostty", entity.speccostty);
     row.SetField("csunperstk", entity.csunperstk);
     row.SetField("length", entity.length);
     row.SetField("width", entity.width);
     row.SetField("webpageext", entity.webpageext);
     row.SetField("rebsubty", entity.rebsubty);
     row.SetField("rebatety", entity.rebatety);
     row.SetField("serlottype", entity.serlottype);
     row.SetField("slgroup", entity.slgroup);
     row.SetField("pbseqno", entity.pbseqno);
     row.SetField("msdschgdt", entity.msdschgdt);
     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("msdssheetno", entity.msdssheetno);
     row.SetField("termsdiscfl", entity.termsdiscfl);
     row.SetField("termspct", entity.termspct);
     row.SetField("stndcost", entity.stndcost);
     row.SetField("transtm", entity.transtm);
     row.SetField("operinit", entity.operinit);
     row.SetField("rebatecost", entity.rebatecost);
     row.SetField("pctcode", entity.pctcode);
     row.SetField("msdsfl", entity.msdsfl);
     row.SetField("autoupcd", entity.autoupcd);
     row.SetField("height", entity.height);
     row.SetField("webpage", entity.webpage);
     row.SetField("icspecrecno", entity.icspecrecno);
     row.SetField("transproc", entity.transproc);
     row.SetField("longdescrip", entity.longdescrip);
     row.SetField("Model", entity.model);
     row.SetField("ThumbnailPic", entity.thumbnailPic);
     row.SetField("catkeyindex1", entity.catkeyindex1);
     row.SetField("catkeyindex2", entity.catkeyindex2);
     row.SetField("catkeyindex3", entity.catkeyindex3);
     row.SetField("catkeyindex4", entity.catkeyindex4);
     row.SetField("AuthGrpList", entity.authGrpList);
     row.SetField("vendprod", entity.vendprod);
     row.SetField("unitstnd", entity.unitstnd);
     row.SetField("documentdescrip", entity.documentdescrip);
     row.SetField("unspsc", entity.unspsc);
     row.SetField("extprod", entity.extprod);
     row.SetField("tradename", entity.tradename);
     row.SetField("corpid", entity.corpid);
     row.SetField("param-list", entity.paramList);
     row.SetField("statustype", entity.statustype);
     row.SetField("statusdt", entity.statusdt);
     row.SetField("storeid", entity.storeid);
     row.SetField("mfg-no", entity.mfgNo);
     row.SetField("node-list", entity.nodeList);
     row.SetField("ecbatchnm", entity.ecbatchnm);
     row.SetField("slchgdt", entity.slchgdt);
     row.SetField("descrip3", entity.descrip3);
     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("rowpointer", entity.rowpointer);
     row.SetField("commoditycd", entity.commoditycd);
     row.SetField("netmassamt", entity.netmassamt);
     row.SetField("usesuppunits", entity.usesuppunits);
     row.SetField("mfgprod", entity.mfgprod);
     row.SetField("brandcode", entity.brandcode);
     row.SetField("acceptoefl", entity.acceptoefl);
     row.SetField("inventorystatus", entity.inventorystatus);
     row.SetField("ncnr", entity.ncnr);
     row.SetField("eccnclasscd", entity.eccnclasscd);
     row.SetField("countryoforigin", entity.countryoforigin);
     row.SetField("tariffcd", entity.tariffcd);
     row.SetField("prodtier", entity.prodtier);
     row.SetField("altprodgrp", entity.altprodgrp);
     row.SetField("altprodprccd", entity.altprodprccd);
     row.SetField("prodpreference", entity.prodpreference);
     row.SetField("prodtiergrp", entity.prodtiergrp);
     row.SetField("transdttmz", entity.transdttmz);
     row.SetField("modelcode", entity.modelcode);
     row.SetField("taxweight", entity.taxweight);
     row.SetField("icscRowID", entity.rowID.ToByteArray());
 }