public static Ptxsrrouterule BuildPtxsrrouteruleFromRow(DataRow row)
{
Ptxsrrouterule entity = new Ptxsrrouterule();
entity.keytype = row.IsNull("keytype") ? string.Empty : row.Field <string>("keytype");
entity.vendno = row.IsNull("vendno") ? decimal.Zero : row.Field <decimal>("vendno");
entity.shipfmno = row.IsNull("shipfmno") ? 0 : row.Field <int>("shipfmno");
entity.custno = row.IsNull("custno") ? decimal.Zero : row.Field <decimal>("custno");
entity.shipto = row.IsNull("shipto") ? string.Empty : row.Field <string>("shipto");
entity.prod = row.IsNull("prod") ? string.Empty : row.Field <string>("prod");
entity.prodcat = row.IsNull("prodcat") ? string.Empty : row.Field <string>("prodcat");
entity.hierarchy = row.IsNull("hierarchy") ? 0 : row.Field <int>("hierarchy");
entity.user1 = row.IsNull("user1") ? string.Empty : row.Field <string>("user1");
entity.user2 = row.IsNull("user2") ? string.Empty : row.Field <string>("user2");
entity.user3 = row.IsNull("user3") ? string.Empty : row.Field <string>("user3");
entity.user4 = row.IsNull("user4") ? string.Empty : row.Field <string>("user4");
entity.user5 = row.IsNull("user5") ? string.Empty : row.Field <string>("user5");
entity.user6 = row.Field <decimal?>("user6");
entity.user7 = row.Field <decimal?>("user7");
entity.user8 = row.Field <DateTime?>("user8");
entity.user9 = row.Field <DateTime?>("user9");
entity.ptxrouterulerowid = row.Field <byte[]>("ptxrouterulerowid").ToStringEncoded();
entity.userfield = row.IsNull("userfield") ? string.Empty : row.Field <string>("userfield");
return(entity);
}
/// <summary>
/// Update a database row from a class
/// </summary>
public static void UpdateRowFromPtxsrrouterule(ref DataRow row, Ptxsrrouterule entity)
{
row.SetField("keytype", entity.keytype);
row.SetField("vendno", entity.vendno);
row.SetField("shipfmno", entity.shipfmno);
row.SetField("custno", entity.custno);
row.SetField("shipto", entity.shipto);
row.SetField("prod", entity.prod);
row.SetField("prodcat", entity.prodcat);
row.SetField("hierarchy", entity.hierarchy);
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("ptxrouterulerowid", entity.ptxrouterulerowid.ToByteArray());
row.SetField("userfield", entity.userfield);
}
