/// <summary> /// Update a database row from a class /// </summary> public static void UpdateRowFromValmultiloccreatecriteria(ref DataRow row, Valmultiloccreatecriteria entity) { row.SetField("co_num", entity.coNum); row.SetField("wh_num", entity.whNum); row.SetField("whZone", entity.whZone); row.SetField("aisle", entity.aisle); row.SetField("prefix", entity.prefix); row.SetField("positionType", entity.positionType); row.SetField("positionFrom", entity.positionFrom); row.SetField("positionTo", entity.positionTo); row.SetField("positionLength", entity.positionLength); row.SetField("positionRangeType", entity.positionRangeType); row.SetField("levelType", entity.levelType); row.SetField("levelFrom", entity.levelFrom); row.SetField("levelTo", entity.levelTo); row.SetField("levelLength", entity.levelLength); row.SetField("locType", entity.locType); row.SetField("abc", entity.abc); row.SetField("height", entity.height); row.SetField("width", entity.width); row.SetField("depth", entity.depth); row.SetField("cube", entity.cube); row.SetField("maxWeight", entity.maxWeight); row.SetField("palletFootprint", entity.palletFootprint); row.SetField("stackHeight", entity.stackHeight); row.SetField("pickSequence", entity.pickSequence); row.SetField("putawayGroup", entity.putawayGroup); row.SetField("userfield", entity.userfield); }
public static Valmultiloccreatecriteria BuildValmultiloccreatecriteriaFromRow(DataRow row) { Valmultiloccreatecriteria entity = new Valmultiloccreatecriteria(); entity.coNum = row.IsNull("co_num") ? string.Empty : row.Field <string>("co_num"); entity.whNum = row.IsNull("wh_num") ? string.Empty : row.Field <string>("wh_num"); entity.whZone = row.IsNull("whZone") ? string.Empty : row.Field <string>("whZone"); entity.aisle = row.IsNull("aisle") ? 0 : row.Field <int>("aisle"); entity.prefix = row.IsNull("prefix") ? string.Empty : row.Field <string>("prefix"); entity.positionType = row.IsNull("positionType") ? 0 : row.Field <int>("positionType"); entity.positionFrom = row.IsNull("positionFrom") ? string.Empty : row.Field <string>("positionFrom"); entity.positionTo = row.IsNull("positionTo") ? string.Empty : row.Field <string>("positionTo"); entity.positionLength = row.IsNull("positionLength") ? 0 : row.Field <int>("positionLength"); entity.positionRangeType = row.IsNull("positionRangeType") ? string.Empty : row.Field <string>("positionRangeType"); entity.levelType = row.IsNull("levelType") ? 0 : row.Field <int>("levelType"); entity.levelFrom = row.IsNull("levelFrom") ? string.Empty : row.Field <string>("levelFrom"); entity.levelTo = row.IsNull("levelTo") ? string.Empty : row.Field <string>("levelTo"); entity.levelLength = row.IsNull("levelLength") ? 0 : row.Field <int>("levelLength"); entity.locType = row.IsNull("locType") ? string.Empty : row.Field <string>("locType"); entity.abc = row.IsNull("abc") ? string.Empty : row.Field <string>("abc"); entity.height = row.IsNull("height") ? 0 : row.Field <int>("height"); entity.width = row.IsNull("width") ? 0 : row.Field <int>("width"); entity.depth = row.IsNull("depth") ? 0 : row.Field <int>("depth"); entity.cube = row.IsNull("cube") ? decimal.Zero : row.Field <decimal>("cube"); entity.maxWeight = row.IsNull("maxWeight") ? 0 : row.Field <int>("maxWeight"); entity.palletFootprint = row.IsNull("palletFootprint") ? 0 : row.Field <int>("palletFootprint"); entity.stackHeight = row.IsNull("stackHeight") ? 0 : row.Field <int>("stackHeight"); entity.pickSequence = row.IsNull("pickSequence") ? 0 : row.Field <int>("pickSequence"); entity.putawayGroup = row.IsNull("putawayGroup") ? string.Empty : row.Field <string>("putawayGroup"); entity.userfield = row.IsNull("userfield") ? string.Empty : row.Field <string>("userfield"); return(entity); }