/// <summary> /// Build a minimal row from a class (key fields only) /// </summary> public static void BuildMinimalRow(ref DataRow row, CmcsqBase entity) { row.SetField("campaigncd", entity.campaigncd); row.SetField("pageno", entity.pageno); row.SetField("cmcsqRowID", entity.rowID.ToByteArray()); }
/// <summary> /// Update a database row from a class /// </summary> public static void UpdateRowFromCmcsqBase(ref DataRow row, CmcsqBase entity) { row.SetField("campaigncd", entity.campaigncd); row.SetField("heading", entity.heading); row.SetField("quest1", entity.quest1); row.SetField("quest2", entity.quest2); row.SetField("quest3", entity.quest3); row.SetField("quest4", entity.quest4); row.SetField("quest5", entity.quest5); row.SetField("quest6", entity.quest6); row.SetField("qtype1", entity.qtype1); row.SetField("qtype2", entity.qtype2); row.SetField("qtype3", entity.qtype3); row.SetField("qtype4", entity.qtype4); row.SetField("qtype5", entity.qtype5); row.SetField("qtype6", entity.qtype6); row.SetField("rank", entity.rank); row.SetField("pageno", entity.pageno); row.SetField("operinit", entity.operinit); row.SetField("transdt", entity.transdt); row.SetField("transtm", entity.transtm); row.SetField("mcdesc1", entity.mcdesc1); row.SetField("mcdesc2", entity.mcdesc2); row.SetField("mcdesc3", entity.mcdesc3); row.SetField("mcdesc4", entity.mcdesc4); row.SetField("mcdesc5", entity.mcdesc5); row.SetField("mcdesc6", entity.mcdesc6); row.SetField("mcdesc7", entity.mcdesc7); row.SetField("mcdesc8", entity.mcdesc8); row.SetField("mcdesc9", entity.mcdesc9); row.SetField("mcdesc10", entity.mcdesc10); row.SetField("mcdesc11", entity.mcdesc11); row.SetField("mcdesc12", entity.mcdesc12); row.SetField("mcdesc13", entity.mcdesc13); row.SetField("mcdesc14", entity.mcdesc14); row.SetField("mcdesc15", entity.mcdesc15); row.SetField("mcdesc16", entity.mcdesc16); row.SetField("mcdesc17", entity.mcdesc17); row.SetField("mcdesc18", entity.mcdesc18); row.SetField("mcdesc19", entity.mcdesc19); row.SetField("mcdesc20", entity.mcdesc20); row.SetField("mcdesc21", entity.mcdesc21); row.SetField("mcdesc22", entity.mcdesc22); row.SetField("mcdesc23", entity.mcdesc23); row.SetField("mcdesc24", entity.mcdesc24); row.SetField("mcdesc25", entity.mcdesc25); row.SetField("mcdesc26", entity.mcdesc26); row.SetField("mcdesc27", entity.mcdesc27); row.SetField("mcdesc28", entity.mcdesc28); row.SetField("mcdesc29", entity.mcdesc29); row.SetField("mcdesc30", entity.mcdesc30); row.SetField("mcdesc31", entity.mcdesc31); row.SetField("mcdesc32", entity.mcdesc32); row.SetField("mcdesc33", entity.mcdesc33); row.SetField("mcdesc34", entity.mcdesc34); row.SetField("mcdesc35", entity.mcdesc35); row.SetField("mcdesc36", entity.mcdesc36); row.SetField("mcrank1", entity.mcrank1); row.SetField("mcrank2", entity.mcrank2); row.SetField("mcrank3", entity.mcrank3); row.SetField("mcrank4", entity.mcrank4); row.SetField("mcrank5", entity.mcrank5); row.SetField("mcrank6", entity.mcrank6); row.SetField("mcrank7", entity.mcrank7); row.SetField("mcrank8", entity.mcrank8); row.SetField("mcrank9", entity.mcrank9); row.SetField("mcrank10", entity.mcrank10); row.SetField("mcrank11", entity.mcrank11); row.SetField("mcrank12", entity.mcrank12); row.SetField("mcrank13", entity.mcrank13); row.SetField("mcrank14", entity.mcrank14); row.SetField("mcrank15", entity.mcrank15); row.SetField("mcrank16", entity.mcrank16); row.SetField("mcrank17", entity.mcrank17); row.SetField("mcrank18", entity.mcrank18); row.SetField("mcrank19", entity.mcrank19); row.SetField("mcrank20", entity.mcrank20); row.SetField("mcrank21", entity.mcrank21); row.SetField("mcrank22", entity.mcrank22); row.SetField("mcrank23", entity.mcrank23); row.SetField("mcrank24", entity.mcrank24); row.SetField("mcrank25", entity.mcrank25); row.SetField("mcrank26", entity.mcrank26); row.SetField("mcrank27", entity.mcrank27); row.SetField("mcrank28", entity.mcrank28); row.SetField("mcrank29", entity.mcrank29); row.SetField("mcrank30", entity.mcrank30); row.SetField("mcrank31", entity.mcrank31); row.SetField("mcrank32", entity.mcrank32); row.SetField("mcrank33", entity.mcrank33); row.SetField("mcrank34", entity.mcrank34); row.SetField("mcrank35", entity.mcrank35); row.SetField("mcrank36", entity.mcrank36); row.SetField("entereddt", entity.entereddt); row.SetField("slsrep", entity.slsrep); row.SetField("user1", entity.user1); row.SetField("user2", entity.user2); row.SetField("user3", entity.user3); row.SetField("user4", entity.user4); row.SetField("user5", entity.user5); row.SetField("user6", entity.user6); row.SetField("user7", entity.user7); row.SetField("user8", entity.user8); row.SetField("user9", entity.user9); row.SetField("transproc", entity.transproc); row.SetField("cmcsqRowID", entity.rowID.ToByteArray()); }