/// <summary>
/// Update a database row from a class
/// </summary>
public static void UpdateRowFromOeerdetail(ref DataRow row, Oeerdetail entity)
{
row.SetField("shipreqno", entity.shipreqno);
row.SetField("notesfl", entity.notesfl);
row.SetField("name", entity.name);
row.SetField("reqinit", entity.reqinit);
row.SetField("addr1", entity.addr1);
row.SetField("addr2", entity.addr2);
row.SetField("addr3", entity.addr3);
row.SetField("city", entity.city);
row.SetField("state", entity.state);
row.SetField("zipcd", entity.zipcd);
row.SetField("shipdt", entity.shipdt);
row.SetField("transdt", entity.transdt);
row.SetField("transtm", entity.transtm);
row.SetField("sendtoinfo", entity.sendtoinfo);
row.SetField("PMESRecid", entity.pMESRecid);
row.SetField("PMESRowid", entity.pMESRowid.ToByteArray());
row.SetField("prtreqno", entity.prtreqno);
row.SetField("prtdetail", entity.prtdetail);
row.SetField("prtother", entity.prtother);
row.SetField("prtnotes", entity.prtnotes);
row.SetField("sendtype", entity.sendtype);
row.SetField("sendno", entity.sendno);
row.SetField("apprinit", entity.apprinit);
row.SetField("shipviaty", entity.shipviaty);
row.SetField("descrip1", entity.descrip1);
row.SetField("descrip2", entity.descrip2);
row.SetField("userfield", entity.userfield);
}
public static Oeerdetail BuildOeerdetailFromRow(DataRow row)
{
Oeerdetail entity = new Oeerdetail();
entity.shipreqno = row.IsNull("shipreqno") ? 0 : row.Field <int>("shipreqno");
entity.notesfl = row.IsNull("notesfl") ? string.Empty : row.Field <string>("notesfl");
entity.name = row.IsNull("name") ? string.Empty : row.Field <string>("name");
entity.reqinit = row.IsNull("reqinit") ? string.Empty : row.Field <string>("reqinit");
entity.addr1 = row.IsNull("addr1") ? string.Empty : row.Field <string>("addr1");
entity.addr2 = row.IsNull("addr2") ? string.Empty : row.Field <string>("addr2");
entity.addr3 = row.IsNull("addr3") ? string.Empty : row.Field <string>("addr3");
entity.city = row.IsNull("city") ? string.Empty : row.Field <string>("city");
entity.state = row.IsNull("state") ? string.Empty : row.Field <string>("state");
entity.zipcd = row.IsNull("zipcd") ? string.Empty : row.Field <string>("zipcd");
entity.shipdt = row.Field <DateTime?>("shipdt");
entity.transdt = row.Field <DateTime?>("transdt");
entity.transtm = row.IsNull("transtm") ? string.Empty : row.Field <string>("transtm");
entity.sendtoinfo = row.IsNull("sendtoinfo") ? string.Empty : row.Field <string>("sendtoinfo");
entity.pMESRecid = row.IsNull("PMESRecid") ? 0 : row.Field <long>("PMESRecid");
entity.pMESRowid = row.Field <byte[]>("PMESRowid").ToStringEncoded();
entity.prtreqno = row.IsNull("prtreqno") ? 0 : row.Field <int>("prtreqno");
entity.prtdetail = row.Field <bool>("prtdetail");
entity.prtother = row.Field <bool>("prtother");
entity.prtnotes = row.Field <bool>("prtnotes");
entity.sendtype = row.IsNull("sendtype") ? string.Empty : row.Field <string>("sendtype");
entity.sendno = row.IsNull("sendno") ? decimal.Zero : row.Field <decimal>("sendno");
entity.apprinit = row.IsNull("apprinit") ? string.Empty : row.Field <string>("apprinit");
entity.shipviaty = row.IsNull("shipviaty") ? string.Empty : row.Field <string>("shipviaty");
entity.descrip1 = row.IsNull("descrip1") ? string.Empty : row.Field <string>("descrip1");
entity.descrip2 = row.IsNull("descrip2") ? string.Empty : row.Field <string>("descrip2");
entity.userfield = row.IsNull("userfield") ? string.Empty : row.Field <string>("userfield");
return(entity);
}
