/// <summary> /// Update a database row from a class /// </summary> public static void UpdateRowFromAutodroprule(ref DataRow row, Autodroprule entity) { row.SetField("co_num", entity.coNum); row.SetField("wh_num", entity.whNum); row.SetField("rule_code", entity.ruleCode); row.SetField("criteria", entity.criteria); row.SetField("criteria_list", entity.criteriaList); row.SetField("drp_query", entity.drpQuery); row.SetField("redo_criteria", entity.redoCriteria); row.SetField("redo_list", entity.redoList); row.SetField("undo_list", entity.undoList); row.SetField("query_error", entity.queryError); row.SetField("query_results", entity.queryResults); row.SetField("test_only", entity.testOnly); row.SetField("ruleRowID", entity.ruleRowID.ToByteArray()); row.SetField("userfield", entity.userfield); }
public static Autodroprule BuildAutodropruleFromRow(DataRow row) { Autodroprule entity = new Autodroprule(); 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.ruleCode = row.IsNull("rule_code") ? string.Empty : row.Field <string>("rule_code"); entity.criteria = row.IsNull("criteria") ? string.Empty : row.Field <string>("criteria"); entity.criteriaList = row.IsNull("criteria_list") ? string.Empty : row.Field <string>("criteria_list"); entity.drpQuery = row.IsNull("drp_query") ? string.Empty : row.Field <string>("drp_query"); entity.redoCriteria = row.IsNull("redo_criteria") ? string.Empty : row.Field <string>("redo_criteria"); entity.redoList = row.IsNull("redo_list") ? string.Empty : row.Field <string>("redo_list"); entity.undoList = row.IsNull("undo_list") ? string.Empty : row.Field <string>("undo_list"); entity.queryError = row.IsNull("query_error") ? string.Empty : row.Field <string>("query_error"); entity.queryResults = row.IsNull("query_results") ? 0 : row.Field <int>("query_results"); entity.testOnly = row.Field <bool>("test_only"); entity.ruleRowID = row.Field <byte[]>("ruleRowID").ToStringEncoded(); entity.userfield = row.IsNull("userfield") ? string.Empty : row.Field <string>("userfield"); return(entity); }