/// <summary> /// Build a minimal row from a class (key fields only) /// </summary> public static void BuildMinimalRow(ref DataRow row, CrsbBase entity) { row.SetField("cono", entity.cono); row.SetField("bankno", entity.bankno); row.SetField("crsbRowID", entity.rowID.ToByteArray()); row.SetField("rowpointer", entity.rowpointer); }
/// <summary> /// Update a database row from a class /// </summary> public static void UpdateRowFromCrsbBase(ref DataRow row, CrsbBase entity) { row.SetField("cono", entity.cono); row.SetField("bankno", entity.bankno); 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("bankacct", entity.bankacct); row.SetField("gldivno", entity.gldivno); row.SetField("gldeptno", entity.gldeptno); row.SetField("glacctno", entity.glacctno); row.SetField("glsubno", entity.glsubno); row.SetField("statustype", entity.statustype); row.SetField("curbookbal", entity.curbookbal); row.SetField("lastbnkbal", entity.lastbnkbal); row.SetField("lastverbal", entity.lastverbal); row.SetField("lastchkdt", entity.lastchkdt); row.SetField("lastbaldt", entity.lastbaldt); row.SetField("lastchkno", entity.lastchkno); row.SetField("lastadjno", entity.lastadjno); row.SetField("lastoutno", entity.lastoutno); row.SetField("lastdepno", entity.lastdepno); row.SetField("lastintno", entity.lastintno); row.SetField("lastchgeno", entity.lastchgeno); row.SetField("lastinno", entity.lastinno); row.SetField("transdt", entity.transdt); row.SetField("transtm", entity.transtm); row.SetField("operinit", entity.operinit); row.SetField("lasttrialno", entity.lasttrialno); row.SetField("lastbalno", entity.lastbalno); row.SetField("currencyty", entity.currencyty); row.SetField("divno", entity.divno); row.SetField("transrouteno", entity.transrouteno); 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("transproc", entity.transproc); row.SetField("addr3", entity.addr3); row.SetField("chkopeninit", entity.chkopeninit); row.SetField("rowpointer", entity.rowpointer); row.SetField("bacsfrmt", entity.bacsfrmt); row.SetField("transdttmz", entity.transdttmz); row.SetField("batchno", entity.batchno); row.SetField("modifier", entity.modifier); row.SetField("companyid", entity.companyid); row.SetField("moddate", entity.moddate); row.SetField("paymentty", entity.paymentty); row.SetField("merchantuserid", entity.merchantuserid); row.SetField("merchantuserpw", entity.merchantuserpw); row.SetField("lastachno", entity.lastachno); row.SetField("lastachdt", entity.lastachdt); row.SetField("merchantid", entity.merchantid); row.SetField("pospaytype", entity.pospaytype); row.SetField("pospayvoid", entity.pospayvoid); row.SetField("pospayurl", entity.pospayurl); row.SetField("crsbRowID", entity.rowID.ToByteArray()); }