/// <summary> /// Build a minimal row from a class (key fields only) /// </summary> public static void BuildMinimalRow(ref DataRow row, SmsnBase entity) { row.SetField("cono", entity.cono); row.SetField("slsrep", entity.slsrep); row.SetField("smsnRowID", entity.rowID.ToByteArray()); row.SetField("rowpointer", entity.rowpointer); }
/// <summary> /// Update a database row from a class /// </summary> public static void UpdateRowFromSmsnBase(ref DataRow row, SmsnBase entity) { row.SetField("cono", entity.cono); row.SetField("slsrep", entity.slsrep); 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("phoneno", entity.phoneno); row.SetField("slstype", entity.slstype); row.SetField("operinit", entity.operinit); row.SetField("oper2", entity.oper2); row.SetField("transdt", entity.transdt); row.SetField("email", entity.email); row.SetField("transtm", entity.transtm); row.SetField("autocmfl", entity.autocmfl); row.SetField("synccrmfl", entity.synccrmfl); row.SetField("user1", entity.user1); row.SetField("mgr", entity.mgr); row.SetField("user2", entity.user2); row.SetField("slstitle", entity.slstitle); row.SetField("user3", entity.user3); row.SetField("user4", entity.user4); row.SetField("letterdir", entity.letterdir); row.SetField("user5", entity.user5); row.SetField("lettercd1", entity.lettercd1); row.SetField("lettercd2", entity.lettercd2); row.SetField("lettercd3", entity.lettercd3); row.SetField("lettercd4", entity.lettercd4); row.SetField("lettercd5", entity.lettercd5); row.SetField("lettercd6", entity.lettercd6); row.SetField("user6", entity.user6); row.SetField("commtype", entity.commtype); row.SetField("user7", entity.user7); row.SetField("site", entity.site); row.SetField("user8", entity.user8); row.SetField("securefl", entity.securefl); row.SetField("user9", entity.user9); row.SetField("sysname", entity.sysname); row.SetField("beglastdt", entity.beglastdt); row.SetField("endlastdt", entity.endlastdt); row.SetField("modphoneno", entity.modphoneno); row.SetField("commfl", entity.commfl); row.SetField("phonesuf", entity.phonesuf); row.SetField("begprosno", entity.begprosno); row.SetField("endprosno", entity.endprosno); row.SetField("transproc", entity.transproc); row.SetField("laborprod", entity.laborprod); row.SetField("listprice", entity.listprice); row.SetField("addr3", entity.addr3); row.SetField("geocd", entity.geocd); row.SetField("countrycd", entity.countrycd); row.SetField("outofcityfl", entity.outofcityfl); row.SetField("rowpointer", entity.rowpointer); row.SetField("transdttmz", entity.transdttmz); row.SetField("smsnRowID", entity.rowID.ToByteArray()); }