/// <summary> /// Build a minimal row from a class (key fields only) /// </summary> public static void BuildMinimalRow(ref DataRow row, CmspBase entity) { row.SetField("prosno", entity.prosno); row.SetField("cmspRowID", entity.rowID.ToByteArray()); row.SetField("rowpointer", entity.rowpointer); }
/// <summary> /// Update a database row from a class /// </summary> public static void UpdateRowFromCmspBase(ref DataRow row, CmspBase entity) { row.SetField("prosno", entity.prosno); row.SetField("name", entity.name); row.SetField("addr1", entity.addr1); row.SetField("addr2", entity.addr2); row.SetField("city", entity.city); row.SetField("state", entity.state); row.SetField("zipcd", entity.zipcd); row.SetField("country", entity.country); row.SetField("slsrep", entity.slsrep); row.SetField("phoneno", entity.phoneno); row.SetField("faxphoneno", entity.faxphoneno); row.SetField("contactfreq", entity.contactfreq); row.SetField("freqtype", entity.freqtype); row.SetField("lastcontdt", entity.lastcontdt); row.SetField("lastconttm", entity.lastconttm); row.SetField("nextcontdt", entity.nextcontdt); row.SetField("nextconttm", entity.nextconttm); row.SetField("prostype", entity.prostype); row.SetField("cosize", entity.cosize); row.SetField("siccd1", entity.siccd1); row.SetField("siccd2", entity.siccd2); row.SetField("siccd3", entity.siccd3); row.SetField("rating", entity.rating); row.SetField("stage", entity.stage); row.SetField("comment", entity.comment); row.SetField("competition", entity.competition); row.SetField("bestcall", entity.bestcall); row.SetField("sourcepros", entity.sourcepros); row.SetField("custno", entity.custno); row.SetField("conoul", entity.conoul); row.SetField("usercd1", entity.usercd1); row.SetField("usercd2", entity.usercd2); row.SetField("usertype1", entity.usertype1); row.SetField("usertype2", entity.usertype2); row.SetField("notesfl", entity.notesfl); row.SetField("operinit", entity.operinit); row.SetField("transdt", entity.transdt); row.SetField("transtm", entity.transtm); row.SetField("autoactcd", entity.autoactcd); row.SetField("newrec", entity.newrec); row.SetField("inslsrep", entity.inslsrep); row.SetField("spcdefaultty", entity.spcdefaultty); row.SetField("user1", entity.user1); row.SetField("user2", entity.user2); 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("eproptype", entity.eproptype); row.SetField("transproc", entity.transproc); row.SetField("addr3", entity.addr3); row.SetField("synccrmfl", entity.synccrmfl); row.SetField("syncmddfl", entity.syncmddfl); row.SetField("rowpointer", entity.rowpointer); row.SetField("transdttmz", entity.transdttmz); row.SetField("cmspRowID", entity.rowID.ToByteArray()); }