public static Icsebcontrol BuildIcsebcontrolFromRow(DataRow row) { Icsebcontrol entity = new Icsebcontrol(); entity.columnlabel1 = row.IsNull("columnlabel1") ? string.Empty : row.Field <string>("columnlabel1"); entity.columnlabel2 = row.IsNull("columnlabel2") ? string.Empty : row.Field <string>("columnlabel2"); entity.columnlabel3 = row.IsNull("columnlabel3") ? string.Empty : row.Field <string>("columnlabel3"); entity.columnlabel4 = row.IsNull("columnlabel4") ? string.Empty : row.Field <string>("columnlabel4"); entity.columnlabel5 = row.IsNull("columnlabel5") ? string.Empty : row.Field <string>("columnlabel5"); entity.columnlabel6 = row.IsNull("columnlabel6") ? string.Empty : row.Field <string>("columnlabel6"); entity.columnlabel7 = row.IsNull("columnlabel7") ? string.Empty : row.Field <string>("columnlabel7"); entity.columnlabel8 = row.IsNull("columnlabel8") ? string.Empty : row.Field <string>("columnlabel8"); entity.columnlabel9 = row.IsNull("columnlabel9") ? string.Empty : row.Field <string>("columnlabel9"); entity.columnlabel10 = row.IsNull("columnlabel10") ? string.Empty : row.Field <string>("columnlabel10"); entity.columnlabel11 = row.IsNull("columnlabel11") ? string.Empty : row.Field <string>("columnlabel11"); entity.columnlabel12 = row.IsNull("columnlabel12") ? string.Empty : row.Field <string>("columnlabel12"); entity.columnlabel13 = row.IsNull("columnlabel13") ? string.Empty : row.Field <string>("columnlabel13"); entity.columnlabel14 = row.IsNull("columnlabel14") ? string.Empty : row.Field <string>("columnlabel14"); entity.columnlabel15 = row.IsNull("columnlabel15") ? string.Empty : row.Field <string>("columnlabel15"); entity.columnlabel16 = row.IsNull("columnlabel16") ? string.Empty : row.Field <string>("columnlabel16"); entity.columnlabel17 = row.IsNull("columnlabel17") ? string.Empty : row.Field <string>("columnlabel17"); entity.columnlabel18 = row.IsNull("columnlabel18") ? string.Empty : row.Field <string>("columnlabel18"); entity.columnlabel19 = row.IsNull("columnlabel19") ? string.Empty : row.Field <string>("columnlabel19"); entity.columnlabel20 = row.IsNull("columnlabel20") ? string.Empty : row.Field <string>("columnlabel20"); entity.columnhidden1 = row.Field <bool>("columnhidden1"); entity.columnhidden2 = row.Field <bool>("columnhidden2"); entity.columnhidden3 = row.Field <bool>("columnhidden3"); entity.columnhidden4 = row.Field <bool>("columnhidden4"); entity.columnhidden5 = row.Field <bool>("columnhidden5"); entity.columnhidden6 = row.Field <bool>("columnhidden6"); entity.columnhidden7 = row.Field <bool>("columnhidden7"); entity.columnhidden8 = row.Field <bool>("columnhidden8"); entity.columnhidden9 = row.Field <bool>("columnhidden9"); entity.columnhidden10 = row.Field <bool>("columnhidden10"); entity.columnhidden11 = row.Field <bool>("columnhidden11"); entity.columnhidden12 = row.Field <bool>("columnhidden12"); entity.columnhidden13 = row.Field <bool>("columnhidden13"); entity.columnhidden14 = row.Field <bool>("columnhidden14"); entity.columnhidden15 = row.Field <bool>("columnhidden15"); entity.columnhidden16 = row.Field <bool>("columnhidden16"); entity.columnhidden17 = row.Field <bool>("columnhidden17"); entity.columnhidden18 = row.Field <bool>("columnhidden18"); entity.columnhidden19 = row.Field <bool>("columnhidden19"); entity.columnhidden20 = row.Field <bool>("columnhidden20"); entity.lmemomixfl = row.Field <bool>("lmemomixfl"); entity.lrandommixfl = row.Field <bool>("lrandommixfl"); entity.inquirefl = row.Field <bool>("inquirefl"); entity.cKPSMwhse = row.IsNull("cKPSMwhse") ? string.Empty : row.Field <string>("cKPSMwhse"); entity.userfield = row.IsNull("userfield") ? string.Empty : row.Field <string>("userfield"); return(entity); }
/// <summary> /// Update a database row from a class /// </summary> public static void UpdateRowFromIcsebcontrol(ref DataRow row, Icsebcontrol entity) { row.SetField("columnlabel1", entity.columnlabel1); row.SetField("columnlabel2", entity.columnlabel2); row.SetField("columnlabel3", entity.columnlabel3); row.SetField("columnlabel4", entity.columnlabel4); row.SetField("columnlabel5", entity.columnlabel5); row.SetField("columnlabel6", entity.columnlabel6); row.SetField("columnlabel7", entity.columnlabel7); row.SetField("columnlabel8", entity.columnlabel8); row.SetField("columnlabel9", entity.columnlabel9); row.SetField("columnlabel10", entity.columnlabel10); row.SetField("columnlabel11", entity.columnlabel11); row.SetField("columnlabel12", entity.columnlabel12); row.SetField("columnlabel13", entity.columnlabel13); row.SetField("columnlabel14", entity.columnlabel14); row.SetField("columnlabel15", entity.columnlabel15); row.SetField("columnlabel16", entity.columnlabel16); row.SetField("columnlabel17", entity.columnlabel17); row.SetField("columnlabel18", entity.columnlabel18); row.SetField("columnlabel19", entity.columnlabel19); row.SetField("columnlabel20", entity.columnlabel20); row.SetField("columnhidden1", entity.columnhidden1); row.SetField("columnhidden2", entity.columnhidden2); row.SetField("columnhidden3", entity.columnhidden3); row.SetField("columnhidden4", entity.columnhidden4); row.SetField("columnhidden5", entity.columnhidden5); row.SetField("columnhidden6", entity.columnhidden6); row.SetField("columnhidden7", entity.columnhidden7); row.SetField("columnhidden8", entity.columnhidden8); row.SetField("columnhidden9", entity.columnhidden9); row.SetField("columnhidden10", entity.columnhidden10); row.SetField("columnhidden11", entity.columnhidden11); row.SetField("columnhidden12", entity.columnhidden12); row.SetField("columnhidden13", entity.columnhidden13); row.SetField("columnhidden14", entity.columnhidden14); row.SetField("columnhidden15", entity.columnhidden15); row.SetField("columnhidden16", entity.columnhidden16); row.SetField("columnhidden17", entity.columnhidden17); row.SetField("columnhidden18", entity.columnhidden18); row.SetField("columnhidden19", entity.columnhidden19); row.SetField("columnhidden20", entity.columnhidden20); row.SetField("lmemomixfl", entity.lmemomixfl); row.SetField("lrandommixfl", entity.lrandommixfl); row.SetField("inquirefl", entity.inquirefl); row.SetField("cKPSMwhse", entity.cKPSMwhse); row.SetField("userfield", entity.userfield); }