/// <summary> /// Build a minimal row from a class (key fields only) /// </summary> public static void BuildMinimalRow(ref DataRow row, PvSapbmBase entity) { row.SetField("queueName", entity.queueName); row.SetField("queueNo", entity.queueNo); row.SetField("pv_sapbmRowID", entity.rowID.ToByteArray()); }
/// <summary> /// Update a database row from a class /// </summary> public static void UpdateRowFromPvSapbmBase(ref DataRow row, PvSapbmBase entity) { row.SetField("queue_name", entity.queueName); row.SetField("RptsProcessed", entity.rptsProcessed); row.SetField("transtm", entity.transtm); row.SetField("queue_status", entity.queueStatus); row.SetField("queue_no", entity.queueNo); row.SetField("StartDt", entity.startDt); row.SetField("StartTm", entity.startTm); row.SetField("LastRptStartDt", entity.lastRptStartDt); row.SetField("LastRptStartTm", entity.lastRptStartTm); row.SetField("LastRptName", entity.lastRptName); row.SetField("Daily_Stop_Time", entity.dailyStopTime); 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("operinit", entity.operinit); row.SetField("transdt", entity.transdt); row.SetField("transproc", entity.transproc); row.SetField("PID", entity.pID); row.SetField("patch-level1", entity.patchLevel1); row.SetField("patch-level2", entity.patchLevel2); row.SetField("patch-level3", entity.patchLevel3); row.SetField("patch-level4", entity.patchLevel4); row.SetField("patch-level5", entity.patchLevel5); row.SetField("patch-level6", entity.patchLevel6); row.SetField("patch-level7", entity.patchLevel7); row.SetField("patch-level8", entity.patchLevel8); row.SetField("patch-level9", entity.patchLevel9); row.SetField("patch-level10", entity.patchLevel10); row.SetField("file-name1", entity.fileName1); row.SetField("file-name2", entity.fileName2); row.SetField("file-name3", entity.fileName3); row.SetField("file-name4", entity.fileName4); row.SetField("file-name5", entity.fileName5); row.SetField("file-name6", entity.fileName6); row.SetField("file-name7", entity.fileName7); row.SetField("file-name8", entity.fileName8); row.SetField("file-name9", entity.fileName9); row.SetField("file-name10", entity.fileName10); row.SetField("file-create-date1", entity.fileCreateDate1); row.SetField("file-create-date2", entity.fileCreateDate2); row.SetField("file-create-date3", entity.fileCreateDate3); row.SetField("file-create-date4", entity.fileCreateDate4); row.SetField("file-create-date5", entity.fileCreateDate5); row.SetField("file-create-date6", entity.fileCreateDate6); row.SetField("file-create-date7", entity.fileCreateDate7); row.SetField("file-create-date8", entity.fileCreateDate8); row.SetField("file-create-date9", entity.fileCreateDate9); row.SetField("file-create-date10", entity.fileCreateDate10); row.SetField("file-create-time1", entity.fileCreateTime1); row.SetField("file-create-time2", entity.fileCreateTime2); row.SetField("file-create-time3", entity.fileCreateTime3); row.SetField("file-create-time4", entity.fileCreateTime4); row.SetField("file-create-time5", entity.fileCreateTime5); row.SetField("file-create-time6", entity.fileCreateTime6); row.SetField("file-create-time7", entity.fileCreateTime7); row.SetField("file-create-time8", entity.fileCreateTime8); row.SetField("file-create-time9", entity.fileCreateTime9); row.SetField("file-create-time10", entity.fileCreateTime10); row.SetField("file-mod-date1", entity.fileModDate1); row.SetField("file-mod-date2", entity.fileModDate2); row.SetField("file-mod-date3", entity.fileModDate3); row.SetField("file-mod-date4", entity.fileModDate4); row.SetField("file-mod-date5", entity.fileModDate5); row.SetField("file-mod-date6", entity.fileModDate6); row.SetField("file-mod-date7", entity.fileModDate7); row.SetField("file-mod-date8", entity.fileModDate8); row.SetField("file-mod-date9", entity.fileModDate9); row.SetField("file-mod-date10", entity.fileModDate10); row.SetField("file-mod-time1", entity.fileModTime1); row.SetField("file-mod-time2", entity.fileModTime2); row.SetField("file-mod-time3", entity.fileModTime3); row.SetField("file-mod-time4", entity.fileModTime4); row.SetField("file-mod-time5", entity.fileModTime5); row.SetField("file-mod-time6", entity.fileModTime6); row.SetField("file-mod-time7", entity.fileModTime7); row.SetField("file-mod-time8", entity.fileModTime8); row.SetField("file-mod-time9", entity.fileModTime9); row.SetField("file-mod-time10", entity.fileModTime10); row.SetField("full-pathname1", entity.fullPathname1); row.SetField("full-pathname2", entity.fullPathname2); row.SetField("full-pathname3", entity.fullPathname3); row.SetField("full-pathname4", entity.fullPathname4); row.SetField("full-pathname5", entity.fullPathname5); row.SetField("full-pathname6", entity.fullPathname6); row.SetField("full-pathname7", entity.fullPathname7); row.SetField("full-pathname8", entity.fullPathname8); row.SetField("full-pathname9", entity.fullPathname9); row.SetField("full-pathname10", entity.fullPathname10); row.SetField("pathname1", entity.pathname1); row.SetField("pathname2", entity.pathname2); row.SetField("pathname3", entity.pathname3); row.SetField("pathname4", entity.pathname4); row.SetField("pathname5", entity.pathname5); row.SetField("pathname6", entity.pathname6); row.SetField("pathname7", entity.pathname7); row.SetField("pathname8", entity.pathname8); row.SetField("pathname9", entity.pathname9); row.SetField("pathname10", entity.pathname10); row.SetField("file-size1", entity.fileSize1); row.SetField("file-size2", entity.fileSize2); row.SetField("file-size3", entity.fileSize3); row.SetField("file-size4", entity.fileSize4); row.SetField("file-size5", entity.fileSize5); row.SetField("file-size6", entity.fileSize6); row.SetField("file-size7", entity.fileSize7); row.SetField("file-size8", entity.fileSize8); row.SetField("file-size9", entity.fileSize9); row.SetField("file-size10", entity.fileSize10); row.SetField("file-type1", entity.fileType1); row.SetField("file-type2", entity.fileType2); row.SetField("file-type3", entity.fileType3); row.SetField("file-type4", entity.fileType4); row.SetField("file-type5", entity.fileType5); row.SetField("file-type6", entity.fileType6); row.SetField("file-type7", entity.fileType7); row.SetField("file-type8", entity.fileType8); row.SetField("file-type9", entity.fileType9); row.SetField("file-type10", entity.fileType10); row.SetField("parameters", entity.parameters); row.SetField("startup-propath", entity.startupPropath); row.SetField("pv_sapbmRowID", entity.rowID.ToByteArray()); }