/// <summary> /// Update a database row from a class /// </summary> public static void UpdateRowFromUserspecificresults(ref DataRow row, Userspecificresults entity) { row.SetField("emp_num", entity.empNum); row.SetField("dept_num", entity.deptNum); row.SetField("sys_name", entity.sysName); row.SetField("udc_desc", entity.udcDesc); row.SetField("udc_value", entity.udcValue); row.SetField("udc_type", entity.udcType); row.SetField("udc_id", entity.udcId); row.SetField("default_respfl", entity.defaultRespfl); row.SetField("user_specificfl", entity.userSpecificfl); row.SetField("auto_respfl", entity.autoRespfl); row.SetField("trans_date", entity.transDate); row.SetField("trans_proc", entity.transProc); row.SetField("udcfgrowid", entity.udcfgrowid.ToByteArray()); row.SetField("userspecificresultsuserfield", entity.userspecificresultsuserfield); row.SetField("userfield", entity.userfield); }
public static Userspecificresults BuildUserspecificresultsFromRow(DataRow row) { Userspecificresults entity = new Userspecificresults(); entity.empNum = row.IsNull("emp_num") ? string.Empty : row.Field <string>("emp_num"); entity.deptNum = row.IsNull("dept_num") ? 0 : row.Field <int>("dept_num"); entity.sysName = row.IsNull("sys_name") ? string.Empty : row.Field <string>("sys_name"); entity.udcDesc = row.IsNull("udc_desc") ? string.Empty : row.Field <string>("udc_desc"); entity.udcValue = row.IsNull("udc_value") ? string.Empty : row.Field <string>("udc_value"); entity.udcType = row.IsNull("udc_type") ? string.Empty : row.Field <string>("udc_type"); entity.udcId = row.IsNull("udc_id") ? string.Empty : row.Field <string>("udc_id"); entity.defaultRespfl = row.Field <bool>("default_respfl"); entity.userSpecificfl = row.Field <bool>("user_specificfl"); entity.autoRespfl = row.Field <bool>("auto_respfl"); entity.transDate = row.IsNull("trans_date") ? string.Empty : row.Field <string>("trans_date"); entity.transProc = row.IsNull("trans_proc") ? string.Empty : row.Field <string>("trans_proc"); entity.udcfgrowid = row.Field <byte[]>("udcfgrowid").ToStringEncoded(); entity.userspecificresultsuserfield = row.IsNull("userspecificresultsuserfield") ? string.Empty : row.Field <string>("userspecificresultsuserfield"); entity.userfield = row.IsNull("userfield") ? string.Empty : row.Field <string>("userfield"); return(entity); }