/// <summary> /// Build a minimal row from a class (key fields only) /// </summary> public static void BuildMinimalRow(ref DataRow row, PdscBase entity) { row.SetField("cono", entity.cono); row.SetField("custno", entity.custno); row.SetField("custtype", entity.custtype); row.SetField("whse", entity.whse); row.SetField("units", entity.units); row.SetField("startdt", entity.startdt); row.SetField("prod", entity.prod); row.SetField("levelcd", entity.levelcd); row.SetField("pdscRowID", entity.rowID.ToByteArray()); row.SetField("rowpointer", entity.rowpointer); }
/// <summary> /// Update a database row from a class /// </summary> public static void UpdateRowFromPdscBase(ref DataRow row, PdscBase entity) { row.SetField("cono", entity.cono); row.SetField("custno", entity.custno); row.SetField("custtype", entity.custtype); row.SetField("whse", entity.whse); row.SetField("units", entity.units); row.SetField("startdt", entity.startdt); row.SetField("enddt", entity.enddt); row.SetField("statustype", entity.statustype); row.SetField("refer", entity.refer); row.SetField("commtype", entity.commtype); row.SetField("minqty", entity.minqty); row.SetField("maxqty", entity.maxqty); row.SetField("actqty", entity.actqty); row.SetField("pround", entity.pround); row.SetField("qtytype", entity.qtytype); row.SetField("ptarget", entity.ptarget); row.SetField("pexactrnd", entity.pexactrnd); row.SetField("prctype", entity.prctype); row.SetField("operinit", entity.operinit); row.SetField("transdt", entity.transdt); row.SetField("transtm", entity.transtm); row.SetField("qtyyymm", entity.qtyyymm); row.SetField("prod", entity.prod); row.SetField("pdrecno", entity.pdrecno); row.SetField("disctype", entity.disctype); row.SetField("levelcd", entity.levelcd); row.SetField("prcdisc1", entity.prcdisc1); row.SetField("prcdisc2", entity.prcdisc2); row.SetField("prcdisc3", entity.prcdisc3); row.SetField("prcdisc4", entity.prcdisc4); row.SetField("prcdisc5", entity.prcdisc5); row.SetField("prcdisc6", entity.prcdisc6); row.SetField("prcdisc7", entity.prcdisc7); row.SetField("prcdisc8", entity.prcdisc8); row.SetField("prcdisc9", entity.prcdisc9); row.SetField("prcmult1", entity.prcmult1); row.SetField("prcmult2", entity.prcmult2); row.SetField("prcmult3", entity.prcmult3); row.SetField("prcmult4", entity.prcmult4); row.SetField("prcmult5", entity.prcmult5); row.SetField("prcmult6", entity.prcmult6); row.SetField("prcmult7", entity.prcmult7); row.SetField("prcmult8", entity.prcmult8); row.SetField("prcmult9", entity.prcmult9); row.SetField("quotefl", entity.quotefl); row.SetField("pricecostty", entity.pricecostty); row.SetField("qtybrk1", entity.qtybrk1); row.SetField("qtybrk2", entity.qtybrk2); row.SetField("qtybrk3", entity.qtybrk3); row.SetField("qtybrk4", entity.qtybrk4); row.SetField("qtybrk5", entity.qtybrk5); row.SetField("qtybrk6", entity.qtybrk6); row.SetField("qtybrk7", entity.qtybrk7); row.SetField("qtybrk8", entity.qtybrk8); row.SetField("ContractNo", entity.contractNo); row.SetField("promofl", entity.promofl); row.SetField("PriceSheet", entity.priceSheet); row.SetField("qtybreakty", entity.qtybreakty); row.SetField("quoteno", entity.quoteno); row.SetField("jobno", entity.jobno); row.SetField("prodcost", entity.prodcost); row.SetField("PriceEffectiveDate", entity.priceEffectiveDate); row.SetField("termsdiscfl", entity.termsdiscfl); row.SetField("termspct", entity.termspct); row.SetField("user1", entity.user1); row.SetField("user2", entity.user2); row.SetField("pricety", entity.pricety); row.SetField("user3", entity.user3); row.SetField("priceonty", entity.priceonty); 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("transproc", entity.transproc); row.SetField("slchgdt", entity.slchgdt); row.SetField("modifiernm", entity.modifiernm); row.SetField("modifierrebfl", entity.modifierrebfl); row.SetField("hardmaxqtyfl", entity.hardmaxqtyfl); row.SetField("maxqtytype", entity.maxqtytype); row.SetField("hardpricefl", entity.hardpricefl); row.SetField("rowpointer", entity.rowpointer); row.SetField("lastuseddt", entity.lastuseddt); row.SetField("ovrridepctup", entity.ovrridepctup); row.SetField("ovrridepctdown", entity.ovrridepctdown); row.SetField("transdttmz", entity.transdttmz); row.SetField("pdscRowID", entity.rowID.ToByteArray()); }