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