/// <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); }