/// <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); }
/// <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()); }