/// <summary> /// Build a minimal row from a class (key fields only) /// </summary> public static void BuildMinimalRow(ref DataRow row, OtehBase entity) { row.SetField("cono", entity.cono); row.SetField("trackno", entity.trackno); row.SetField("otehRowID", entity.rowID.ToByteArray()); }
/// <summary> /// Update a database row from a class /// </summary> public static void UpdateRowFromOtehBase(ref DataRow row, OtehBase entity) { row.SetField("cono", entity.cono); row.SetField("trackno", entity.trackno); row.SetField("contno", entity.contno); row.SetField("bolno", entity.bolno); row.SetField("shipid", entity.shipid); row.SetField("shipco", entity.shipco); row.SetField("vesselnm", entity.vesselnm); row.SetField("voyageno", entity.voyageno); row.SetField("countryorgcd", entity.countryorgcd); row.SetField("countrydestcd", entity.countrydestcd); row.SetField("portno", entity.portno); row.SetField("portnm", entity.portnm); row.SetField("ltofcreditno", entity.ltofcreditno); row.SetField("contsize", entity.contsize); row.SetField("estdeptdt", entity.estdeptdt); row.SetField("revdeptdt", entity.revdeptdt); row.SetField("actdeptdt", entity.actdeptdt); row.SetField("estdockarrdt", entity.estdockarrdt); row.SetField("actdockarrdt", entity.actdockarrdt); row.SetField("estdockreddt", entity.estdockreddt); row.SetField("actdockreddt", entity.actdockreddt); row.SetField("estdockdemurdt", entity.estdockdemurdt); row.SetField("actdockdemurdt", entity.actdockdemurdt); row.SetField("estlastfreedt", entity.estlastfreedt); row.SetField("actlastfreedt", entity.actlastfreedt); row.SetField("estwhseunldt", entity.estwhseunldt); row.SetField("actwhseunldt", entity.actwhseunldt); row.SetField("estempdt", entity.estempdt); row.SetField("actempdt", entity.actempdt); row.SetField("estretdt", entity.estretdt); row.SetField("actretdt", entity.actretdt); row.SetField("trackbusyfl", entity.trackbusyfl); row.SetField("stagecd", entity.stagecd); row.SetField("vendno", entity.vendno); row.SetField("contactnm", entity.contactnm); row.SetField("addonno1", entity.addonno1); row.SetField("addonno2", entity.addonno2); row.SetField("addonno3", entity.addonno3); row.SetField("addonno4", entity.addonno4); row.SetField("addonamt1", entity.addonamt1); row.SetField("addonamt2", entity.addonamt2); row.SetField("addonamt3", entity.addonamt3); row.SetField("addonamt4", entity.addonamt4); row.SetField("addonnet1", entity.addonnet1); row.SetField("addonnet2", entity.addonnet2); row.SetField("addonnet3", entity.addonnet3); row.SetField("addonnet4", entity.addonnet4); row.SetField("addontype1", entity.addontype1); row.SetField("addontype2", entity.addontype2); row.SetField("addontype3", entity.addontype3); row.SetField("addontype4", entity.addontype4); 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("openinit", entity.openinit); row.SetField("whse", entity.whse); row.SetField("operinit", entity.operinit); row.SetField("transdt", entity.transdt); row.SetField("transtm", entity.transtm); row.SetField("transproc", entity.transproc); row.SetField("estatwhsedt", entity.estatwhsedt); row.SetField("actatwhsedt", entity.actatwhsedt); row.SetField("shipfmno", entity.shipfmno); row.SetField("manname", entity.manname); row.SetField("manaddr1", entity.manaddr1); row.SetField("manaddr2", entity.manaddr2); row.SetField("mancity", entity.mancity); row.SetField("manstate", entity.manstate); row.SetField("manzipcd", entity.manzipcd); row.SetField("mancountrycd", entity.mancountrycd); row.SetField("manphoneno", entity.manphoneno); row.SetField("totamt", entity.totamt); row.SetField("estprodstdt", entity.estprodstdt); row.SetField("revprodstdt", entity.revprodstdt); row.SetField("actprodstdt", entity.actprodstdt); row.SetField("estprodcompdt", entity.estprodcompdt); row.SetField("revprodcompdt", entity.revprodcompdt); row.SetField("actprodcompdt", entity.actprodcompdt); row.SetField("revdockdemurdt", entity.revdockdemurdt); row.SetField("revlastfreedt", entity.revlastfreedt); row.SetField("revatwhsedt", entity.revatwhsedt); row.SetField("revempdt", entity.revempdt); row.SetField("revdockarrdt", entity.revdockarrdt); row.SetField("revdockreddt", entity.revdockreddt); row.SetField("revretdt", entity.revretdt); row.SetField("revwhseunldt", entity.revwhseunldt); row.SetField("notesfl", entity.notesfl); row.SetField("manaddr3", entity.manaddr3); row.SetField("jrnlnoin", entity.jrnlnoin); row.SetField("jrnlnoout", entity.jrnlnoout); row.SetField("otehRowID", entity.rowID.ToByteArray()); }