/// <summary> /// Update a database row from a class /// </summary> public static void UpdateRowFromPickdetail(ref DataRow row, Pickdetail entity) { row.SetField("id", entity.id); row.SetField("wh_zone", entity.whZone); row.SetField("aisle", entity.aisle); row.SetField("bin_num", entity.binNum); row.SetField("qty", entity.qty); row.SetField("stock_stat", entity.stockStat); row.SetField("delete_flag", entity.deleteFlag); row.SetField("rowid", entity.rowid.ToByteArray()); row.SetField("userfield", entity.userfield); }
public static Pickdetail BuildPickdetailFromRow(DataRow row) { Pickdetail entity = new Pickdetail(); entity.id = row.IsNull("id") ? 0 : row.Field <int>("id"); entity.whZone = row.IsNull("wh_zone") ? string.Empty : row.Field <string>("wh_zone"); entity.aisle = row.IsNull("aisle") ? 0 : row.Field <int>("aisle"); entity.binNum = row.IsNull("bin_num") ? string.Empty : row.Field <string>("bin_num"); entity.qty = row.IsNull("qty") ? decimal.Zero : row.Field <decimal>("qty"); entity.stockStat = row.IsNull("stock_stat") ? string.Empty : row.Field <string>("stock_stat"); entity.deleteFlag = row.Field <bool>("delete_flag"); entity.rowid = row.Field <byte[]>("rowid").ToStringEncoded(); entity.userfield = row.IsNull("userfield") ? string.Empty : row.Field <string>("userfield"); return(entity); }