/// <summary>
/// Update a database row from a class
/// </summary>
public static void UpdateRowFromWmbin(ref DataRow row, Wmbin entity)
{
row.SetField("whse", entity.whse);
row.SetField("binloc", entity.binloc);
row.SetField("assigncode", entity.assigncode);
row.SetField("bintype", entity.bintype);
row.SetField("binlength", entity.binlength);
row.SetField("binheight", entity.binheight);
row.SetField("priority", entity.priority);
row.SetField("binwidth", entity.binwidth);
row.SetField("cubes", entity.cubes);
row.SetField("statuscode", entity.statuscode);
row.SetField("fstoredt", entity.fstoredt);
row.SetField("bindescrip", entity.bindescrip);
row.SetField("lstoredt", entity.lstoredt);
row.SetField("sizetype", entity.sizetype);
row.SetField("sizedescrip", entity.sizedescrip);
row.SetField("lpickdt", entity.lpickdt);
row.SetField("pounittype", entity.pounittype);
row.SetField("tmstored", entity.tmstored);
row.SetField("descrip", entity.descrip);
row.SetField("tmpicked", entity.tmpicked);
row.SetField("multisinglefl", entity.multisinglefl);
row.SetField("userfield", entity.userfield);
}
public static Wmbin BuildWmbinFromRow(DataRow row)
{
Wmbin entity = new Wmbin();
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.bintype = row.IsNull("bintype") ? string.Empty : row.Field <string>("bintype");
entity.binlength = row.IsNull("binlength") ? decimal.Zero : row.Field <decimal>("binlength");
entity.binheight = row.IsNull("binheight") ? decimal.Zero : row.Field <decimal>("binheight");
entity.priority = row.IsNull("priority") ? 0 : row.Field <int>("priority");
entity.binwidth = row.IsNull("binwidth") ? decimal.Zero : row.Field <decimal>("binwidth");
entity.cubes = row.IsNull("cubes") ? decimal.Zero : row.Field <decimal>("cubes");
entity.statuscode = row.IsNull("statuscode") ? string.Empty : row.Field <string>("statuscode");
entity.fstoredt = row.Field <DateTime?>("fstoredt");
entity.bindescrip = row.IsNull("bindescrip") ? string.Empty : row.Field <string>("bindescrip");
entity.lstoredt = row.Field <DateTime?>("lstoredt");
entity.sizetype = row.IsNull("sizetype") ? string.Empty : row.Field <string>("sizetype");
entity.sizedescrip = row.IsNull("sizedescrip") ? string.Empty : row.Field <string>("sizedescrip");
entity.lpickdt = row.Field <DateTime?>("lpickdt");
entity.pounittype = row.IsNull("pounittype") ? string.Empty : row.Field <string>("pounittype");
entity.tmstored = row.IsNull("tmstored") ? 0 : row.Field <int>("tmstored");
entity.descrip = row.IsNull("descrip") ? string.Empty : row.Field <string>("descrip");
entity.tmpicked = row.IsNull("tmpicked") ? 0 : row.Field <int>("tmpicked");
entity.multisinglefl = row.Field <bool>("multisinglefl");
entity.userfield = row.IsNull("userfield") ? string.Empty : row.Field <string>("userfield");
return(entity);
}
