public static Wmsbsearchresults BuildWmsbsearchresultsFromRow(DataRow row)
{
Wmsbsearchresults entity = new Wmsbsearchresults();
entity.whse = row.IsNull("whse") ? string.Empty : row.Field <string>("whse");
entity.binloc = row.IsNull("binloc") ? string.Empty : row.Field <string>("binloc");
entity.assigncode = row.IsNull("assigncode") ? string.Empty : row.Field <string>("assigncode");
entity.binheight = row.IsNull("binheight") ? decimal.Zero : row.Field <decimal>("binheight");
entity.binlength = row.IsNull("binlength") ? decimal.Zero : row.Field <decimal>("binlength");
entity.bintype = row.IsNull("bintype") ? string.Empty : row.Field <string>("bintype");
entity.binwidth = row.IsNull("binwidth") ? decimal.Zero : row.Field <decimal>("binwidth");
entity.building = row.IsNull("building") ? string.Empty : row.Field <string>("building");
entity.cubes = row.IsNull("cubes") ? decimal.Zero : row.Field <decimal>("cubes");
entity.descrip = row.IsNull("descrip") ? string.Empty : row.Field <string>("descrip");
entity.fstoredt = row.Field <DateTime?>("fstoredt");
entity.lpickdt = row.Field <DateTime?>("lpickdt");
entity.lstoredt = row.Field <DateTime?>("lstoredt");
entity.operinit = row.IsNull("operinit") ? string.Empty : row.Field <string>("operinit");
entity.pounittype = row.IsNull("pounittype") ? string.Empty : row.Field <string>("pounittype");
entity.priority = row.IsNull("priority") ? 0 : row.Field <int>("priority");
entity.sizetype = row.IsNull("sizetype") ? string.Empty : row.Field <string>("sizetype");
entity.statuscode = row.IsNull("statuscode") ? string.Empty : row.Field <string>("statuscode");
entity.tmpicked = row.IsNull("tmpicked") ? 0 : row.Field <int>("tmpicked");
entity.tmstored = row.IsNull("tmstored") ? 0 : row.Field <int>("tmstored");
entity.transdt = row.Field <DateTime?>("transdt");
entity.transproc = row.IsNull("transproc") ? string.Empty : row.Field <string>("transproc");
entity.transtm = row.IsNull("transtm") ? string.Empty : row.Field <string>("transtm");
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.rowid = row.Field <byte[]>("rowid").ToStringEncoded();
entity.userfield = row.IsNull("userfield") ? string.Empty : row.Field <string>("userfield");
entity.restrict = row.IsNull("restrict") ? string.Empty : row.Field <string>("restrict");
entity.restrictbld = row.IsNull("restrictbld") ? string.Empty : row.Field <string>("restrictbld");
entity.restrictrow = row.IsNull("restrictrow") ? string.Empty : row.Field <string>("restrictrow");
entity.productcnt = row.IsNull("productcnt") ? 0 : row.Field <int>("productcnt");
return(entity);
}
/// <summary>
/// Update a database row from a class
/// </summary>
public static void UpdateRowFromWmsbsearchresults(ref DataRow row, Wmsbsearchresults entity)
{
row.SetField("whse", entity.whse);
row.SetField("binloc", entity.binloc);
row.SetField("assigncode", entity.assigncode);
row.SetField("binheight", entity.binheight);
row.SetField("binlength", entity.binlength);
row.SetField("bintype", entity.bintype);
row.SetField("binwidth", entity.binwidth);
row.SetField("building", entity.building);
row.SetField("cubes", entity.cubes);
row.SetField("descrip", entity.descrip);
row.SetField("fstoredt", entity.fstoredt);
row.SetField("lpickdt", entity.lpickdt);
row.SetField("lstoredt", entity.lstoredt);
row.SetField("operinit", entity.operinit);
row.SetField("pounittype", entity.pounittype);
row.SetField("priority", entity.priority);
row.SetField("sizetype", entity.sizetype);
row.SetField("statuscode", entity.statuscode);
row.SetField("tmpicked", entity.tmpicked);
row.SetField("tmstored", entity.tmstored);
row.SetField("transdt", entity.transdt);
row.SetField("transproc", entity.transproc);
row.SetField("transtm", entity.transtm);
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("rowid", entity.rowid.ToByteArray());
row.SetField("userfield", entity.userfield);
row.SetField("restrict", entity.restrict);
row.SetField("restrictbld", entity.restrictbld);
row.SetField("restrictrow", entity.restrictrow);
row.SetField("productcnt", entity.productcnt);
}
