/// <summary> /// Build a minimal row from a class (key fields only) /// </summary> public static void BuildMinimalRow(ref DataRow row, SwsssBase entity) { row.SetField("cono", entity.cono); row.SetField("tech", entity.tech); row.SetField("wkstartdt", entity.wkstartdt); row.SetField("swsssRowID", entity.rowID.ToByteArray()); }
/// <summary> /// Update a database row from a class /// </summary> public static void UpdateRowFromSwsssBase(ref DataRow row, SwsssBase entity) { row.SetField("cono", entity.cono); row.SetField("lunchhrs", entity.lunchhrs); row.SetField("ottype", entity.ottype); row.SetField("ourproc", entity.ourproc); row.SetField("ratetype1", entity.ratetype1); row.SetField("ratetype2", entity.ratetype2); row.SetField("ratetype3", entity.ratetype3); row.SetField("ratetype4", entity.ratetype4); row.SetField("ratetype5", entity.ratetype5); row.SetField("ratetype6", entity.ratetype6); row.SetField("ratetype7", entity.ratetype7); row.SetField("ratetype8", entity.ratetype8); row.SetField("ratetype9", entity.ratetype9); row.SetField("ratetypefl1", entity.ratetypefl1); row.SetField("ratetypefl2", entity.ratetypefl2); row.SetField("ratetypefl3", entity.ratetypefl3); row.SetField("ratetypefl4", entity.ratetypefl4); row.SetField("ratetypefl5", entity.ratetypefl5); row.SetField("ratetypefl6", entity.ratetypefl6); row.SetField("ratetypefl7", entity.ratetypefl7); row.SetField("ratetypefl8", entity.ratetypefl8); row.SetField("ratetypefl9", entity.ratetypefl9); row.SetField("shift", entity.shift); row.SetField("shiftday1", entity.shiftday1); row.SetField("shiftday2", entity.shiftday2); row.SetField("shiftday3", entity.shiftday3); row.SetField("shiftday4", entity.shiftday4); row.SetField("shiftday5", entity.shiftday5); row.SetField("shiftday6", entity.shiftday6); row.SetField("shiftday7", entity.shiftday7); row.SetField("shiftendtm", entity.shiftendtm); row.SetField("shifthrs", entity.shifthrs); row.SetField("shiftstarttm", entity.shiftstarttm); row.SetField("tech", entity.tech); row.SetField("whseday1", entity.whseday1); row.SetField("whseday2", entity.whseday2); row.SetField("whseday3", entity.whseday3); row.SetField("whseday4", entity.whseday4); row.SetField("whseday5", entity.whseday5); row.SetField("whseday6", entity.whseday6); row.SetField("whseday7", entity.whseday7); row.SetField("wkstartdt", entity.wkstartdt); row.SetField("transdt", entity.transdt); row.SetField("transtm", entity.transtm); row.SetField("operinit", entity.operinit); 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("daystarttm", entity.daystarttm); row.SetField("transproc", entity.transproc); row.SetField("swsssRowID", entity.rowID.ToByteArray()); }