예제 #1
0
 /// <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());
 }
예제 #2
0
 /// <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());
 }