/// <summary>
/// Update a database row from a class
/// </summary>
public static void UpdateRowFromUserspecificcriteria(ref DataRow row, Userspecificcriteria entity)
{
row.SetField("co_num", entity.coNum);
row.SetField("wh_num", entity.whNum);
row.SetField("sys_name", entity.sysName);
row.SetField("dept_num", entity.deptNum);
row.SetField("emp_num", entity.empNum);
row.SetField("udc_id", entity.udcId);
row.SetField("udc_desc", entity.udcDesc);
row.SetField("udc_type", entity.udcType);
row.SetField("udc_value", entity.udcValue);
row.SetField("udc_level", entity.udcLevel);
row.SetField("recordcountlimit", entity.recordcountlimit);
row.SetField("userspecificcriteriauserfield", entity.userspecificcriteriauserfield);
row.SetField("userfield", entity.userfield);
}
public static Userspecificcriteria BuildUserspecificcriteriaFromRow(DataRow row)
{
Userspecificcriteria entity = new Userspecificcriteria();
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.sysName = row.IsNull("sys_name") ? string.Empty : row.Field <string>("sys_name");
entity.deptNum = row.IsNull("dept_num") ? 0 : row.Field <int>("dept_num");
entity.empNum = row.IsNull("emp_num") ? string.Empty : row.Field <string>("emp_num");
entity.udcId = row.IsNull("udc_id") ? string.Empty : row.Field <string>("udc_id");
entity.udcDesc = row.IsNull("udc_desc") ? string.Empty : row.Field <string>("udc_desc");
entity.udcType = row.IsNull("udc_type") ? string.Empty : row.Field <string>("udc_type");
entity.udcValue = row.IsNull("udc_value") ? string.Empty : row.Field <string>("udc_value");
entity.udcLevel = row.IsNull("udc_level") ? 0 : row.Field <int>("udc_level");
entity.recordcountlimit = row.IsNull("recordcountlimit") ? 0 : row.Field <int>("recordcountlimit");
entity.userspecificcriteriauserfield = row.IsNull("userspecificcriteriauserfield") ? string.Empty : row.Field <string>("userspecificcriteriauserfield");
entity.userfield = row.IsNull("userfield") ? string.Empty : row.Field <string>("userfield");
return(entity);
}
