{"id":874,"date":"2017-11-03T10:36:03","date_gmt":"2017-11-03T08:36:03","guid":{"rendered":"http:\/\/www.fultek.com.tr\/scada-yardim\/?p=874"},"modified":"2021-12-18T13:30:48","modified_gmt":"2021-12-18T11:30:48","slug":"web-server-ile-rapor-olusturma","status":"publish","type":"post","link":"https:\/\/www.fultek.com.tr\/scada-yardim\/2017\/11\/web-server-ile-rapor-olusturma\/","title":{"rendered":"Web Server ile Rapor olu\u015fturma."},"content":{"rendered":"

Web server ile eri\u015filen scada sayfalar\u0131nda baz\u0131 \u00f6zellikler k\u0131s\u0131tlan\u0131r. Bunun nedeni bilgisayar performans\u0131n\u0131 iyi kullanmak i\u00e7in web ile a\u00e7\u0131lan scada sayfalar\u0131n\u0131n cpu’nun di\u011fer \u00e7ekirde\u011finde \u00e7al\u0131\u015ft\u0131r\u0131lmas\u0131d\u0131r. Web browser ile izlenen scada sayfas\u0131nda rapor olu\u015ftururken iki problem kar\u015f\u0131m\u0131za \u00e7\u0131kar. 1. Datetimepicker ile tarih saat giri\u015finin zorlu\u011fu. 2. Datagridview \u00fczerinde scrool yapamamak.<\/p>\n

    \n
  1. Web \u00fczerinden Datetimepicker t\u0131kland\u0131\u011f\u0131nda a\u00e7\u0131lan pencereye text format\u0131nda tarih ve saat bilgisini girmeliyiz. Bu konuda yap\u0131lacak fazla bir\u015fey yok.<\/li>\n
  2. Rapor olu\u015fturuldu\u011funda Datagridview’deki bilgilerin bir k\u0131sm\u0131 hemen g\u00f6z\u00fck\u00fcr. Altda kalan bilgileri g\u00f6rmek i\u00e7in scrool (kayd\u0131rma) i\u015flemi script ile yapmal\u0131y\u0131z.<\/li>\n<\/ol>\n

    Bu konu i\u00e7in haz\u0131rlad\u0131\u011f\u0131m\u0131z \u00f6rnek projeyi buradan <\/a>indirebilirsiniz.<\/p>\n

    \u0130ki adet script ile datagrid’i yukar\u0131 ve a\u015fa\u011f\u0131 scrool yapmal\u0131y\u0131z. \u00d6rnek script a\u015fa\u011f\u0131dad\u0131r. Bu script’de dikkat edilmesi gereken baz\u0131 \u015feyleri a\u00e7\u0131klayal\u0131m.<\/p>\n

    Script ile sayfalar i\u00e7ersindeki nesnelere direkt olarak eri\u015filebilir. Fakat eri\u015fmek istedi\u011fimiz DataGridView rapor olu\u015fturulurken silinip yeniden yap\u0131l\u0131yor. Bu nedenle sayfa a\u00e7\u0131l\u0131rken olu\u015fturulan datagrid’den farkl\u0131 bir nesne var. Bu sorunu a\u015fmak i\u00e7in ilk \u00f6nce sayfaya eri\u015fiyoruz.<\/p>\n

    Dim MyScreen as object = ScadaScreen.Name(“Screen_1″,”Web”) bu komut ile web’de a\u00e7\u0131k olan Screen_1’e eri\u015fiyoruz.<\/p>\n

    Datagridview nesnesini bu sayfa i\u00e7ersindeki nesnelerde ar\u0131y\u0131p bulmal\u0131y\u0131z. A\u015fa\u011f\u0131daki komut bu ama\u00e7la yaz\u0131lm\u0131\u015ft\u0131r.<\/p>\n

    For each tmp as object in MyScreen.Controls<\/p>\n

    if tmp.name = “” then<\/p>\n

    For each tmp2 as object in tmp.Controls<\/p>\n

    if tmp2.name = “DataGridView_1” then<\/p>\n

    DataGrid = tmp2<\/p>\n

    Goto Ok<\/p>\n

    End if<\/p>\n

    next<\/p>\n

    end if<\/p>\n

    Next<\/p>\n

    Nesne eri\u015fimi tamamland\u0131ktan sonra datagridview scrool i\u015flemi i\u00e7in a\u015fa\u011f\u0131daki kodu \u00e7al\u0131\u015ft\u0131r\u0131yoruz.<\/p>\n

    Ok:\u00a0\u00a0\u00a0\u00a0 if DataGrid.RowCount > 0 Then<\/p>\n

    SelectedIndex += 10<\/p>\n

    if SelectedIndex >= DataGrid.RowCount Then SelectedIndex = DataGrid.RowCount – 1<\/p>\n

    DataGrid.ClearSelection()<\/p>\n

    DataGrid.Rows(SelectedIndex).Selected = True<\/p>\n

    DataGrid.FirstDisplayedScrollingRowIndex = SelectedIndex<\/p>\n

    End If<\/p>\n

     <\/p>\n

    Script’in tamam\u0131 a\u015fa\u011f\u0131dad\u0131r. Bu scriptin benzer yukar\u0131 kayd\u0131rma i\u015flemi i\u00e7inde yap\u0131lmal\u0131d\u0131r.<\/p>\n

     <\/p>\n

    Imports System<\/p>\n

    Imports System.IO<\/p>\n

    Imports System.Windows.Forms<\/p>\n

    Imports Microsoft.VisualBasic<\/p>\n

     <\/p>\n

    Namespace WinTr<\/p>\n

    Public Class MainClass<\/p>\n

    Public ScadaScreen As Object<\/p>\n

    Public SelectedIndex As Int16<\/p>\n

    Public Sub Load<\/p>\n

    Try<\/p>\n

    Dim DataGrid as DatagridView<\/p>\n

    Dim MyScreen as object = ScadaScreen.Name(“Screen_1″,”Web”)<\/p>\n

    if MyScreen Is Nothing then exit sub<\/p>\n

    For each tmp as object in MyScreen.Controls<\/p>\n

    if tmp.name = “” then<\/p>\n

    For each tmp2 as object in tmp.Controls<\/p>\n

    if tmp2.name = “DataGridView_1” then<\/p>\n

    DataGrid = tmp2<\/p>\n

    Goto Ok<\/p>\n

    End if<\/p>\n

    next<\/p>\n

    end if<\/p>\n

    Next<\/p>\n

    Exit Sub<\/p>\n

    Ok:\u00a0\u00a0\u00a0\u00a0 if DataGrid.RowCount > 0 Then<\/p>\n

    SelectedIndex += 10<\/p>\n

    if SelectedIndex >= DataGrid.RowCount Then SelectedIndex = DataGrid.RowCount – 1<\/p>\n

    DataGrid.ClearSelection()<\/p>\n

    DataGrid.Rows(SelectedIndex).Selected = True<\/p>\n

    DataGrid.FirstDisplayedScrollingRowIndex = SelectedIndex<\/p>\n

    End If<\/p>\n

    Catch ex As Exception<\/p>\n

    MessageBox.Show(Ex.ToString, “Down Script: ” & Ex.Message)<\/p>\n

    End Try<\/p>\n

    End Sub<\/p>\n

    End Class<\/p>\n

    End Namespace<\/p>\n","protected":false},"excerpt":{"rendered":"

    Web server ile eri\u015filen scada sayfalar\u0131nda baz\u0131 \u00f6zellikler k\u0131s\u0131tlan\u0131r. Bunun nedeni bilgisayar performans\u0131n\u0131 iyi kullanmak i\u00e7in web ile a\u00e7\u0131lan scada sayfalar\u0131n\u0131n cpu’nun di\u011fer \u00e7ekirde\u011finde \u00e7al\u0131\u015ft\u0131r\u0131lmas\u0131d\u0131r. Web browser ile izlenen scada sayfas\u0131nda rapor olu\u015ftururken iki problem kar\u015f\u0131m\u0131za \u00e7\u0131kar. 1. Datetimepicker ile tarih saat giri\u015finin zorlu\u011fu. 2. Datagridview \u00fczerinde scrool yapamamak. Web \u00fczerinden Datetimepicker t\u0131kland\u0131\u011f\u0131nda a\u00e7\u0131lan pencereye […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_swpsp_post_exclude":false,"footnotes":""},"categories":[28],"tags":[332,373],"class_list":["post-874","post","type-post","status-publish","format-standard","hentry","category-scada-report","tag-rapor","tag-web-rapor"],"yoast_head":"\nWeb Server ile Rapor olu\u015fturma. - SCADA E\u011fitim Sitesi<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.fultek.com.tr\/scada-yardim\/2017\/11\/web-server-ile-rapor-olusturma\/\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"Salih\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/2017\\\/11\\\/web-server-ile-rapor-olusturma\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/2017\\\/11\\\/web-server-ile-rapor-olusturma\\\/\"},\"author\":{\"name\":\"Salih\",\"@id\":\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/#\\\/schema\\\/person\\\/b439f08807fdc9e273a233976c5eb1be\"},\"headline\":\"Web Server ile Rapor olu\u015fturma.\",\"datePublished\":\"2017-11-03T08:36:03+00:00\",\"dateModified\":\"2021-12-18T11:30:48+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/2017\\\/11\\\/web-server-ile-rapor-olusturma\\\/\"},\"wordCount\":513,\"commentCount\":0,\"keywords\":[\"Rapor\",\"Web Rapor\"],\"articleSection\":[\"Rapor\"],\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/2017\\\/11\\\/web-server-ile-rapor-olusturma\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/2017\\\/11\\\/web-server-ile-rapor-olusturma\\\/\",\"url\":\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/2017\\\/11\\\/web-server-ile-rapor-olusturma\\\/\",\"name\":\"Web Server ile Rapor olu\u015fturma. - SCADA E\u011fitim Sitesi\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/#website\"},\"datePublished\":\"2017-11-03T08:36:03+00:00\",\"dateModified\":\"2021-12-18T11:30:48+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/#\\\/schema\\\/person\\\/b439f08807fdc9e273a233976c5eb1be\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/2017\\\/11\\\/web-server-ile-rapor-olusturma\\\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/2017\\\/11\\\/web-server-ile-rapor-olusturma\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/2017\\\/11\\\/web-server-ile-rapor-olusturma\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Web Server ile Rapor olu\u015fturma.\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/#website\",\"url\":\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/\",\"name\":\"SCADA E\u011fitim Sitesi\",\"description\":\"SCADA program\u0131 hakk\u0131nda bilmek istedikleriniz.\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"tr\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/#\\\/schema\\\/person\\\/b439f08807fdc9e273a233976c5eb1be\",\"name\":\"Salih\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/71953beeb6b97dd8eeecb5d9b86339eedb7662215ebdf0761d17ac26bc31f94b?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/71953beeb6b97dd8eeecb5d9b86339eedb7662215ebdf0761d17ac26bc31f94b?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/71953beeb6b97dd8eeecb5d9b86339eedb7662215ebdf0761d17ac26bc31f94b?s=96&d=mm&r=g\",\"caption\":\"Salih\"},\"sameAs\":[\"http:\\\/\\\/www.fultek.com.tr\"],\"url\":\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/author\\\/salih\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Web Server ile Rapor olu\u015fturma. - SCADA E\u011fitim Sitesi","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.fultek.com.tr\/scada-yardim\/2017\/11\/web-server-ile-rapor-olusturma\/","twitter_misc":{"Yazan:":"Salih","Tahmini okuma s\u00fcresi":"3 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.fultek.com.tr\/scada-yardim\/2017\/11\/web-server-ile-rapor-olusturma\/#article","isPartOf":{"@id":"https:\/\/www.fultek.com.tr\/scada-yardim\/2017\/11\/web-server-ile-rapor-olusturma\/"},"author":{"name":"Salih","@id":"https:\/\/www.fultek.com.tr\/scada-yardim\/#\/schema\/person\/b439f08807fdc9e273a233976c5eb1be"},"headline":"Web Server ile Rapor olu\u015fturma.","datePublished":"2017-11-03T08:36:03+00:00","dateModified":"2021-12-18T11:30:48+00:00","mainEntityOfPage":{"@id":"https:\/\/www.fultek.com.tr\/scada-yardim\/2017\/11\/web-server-ile-rapor-olusturma\/"},"wordCount":513,"commentCount":0,"keywords":["Rapor","Web Rapor"],"articleSection":["Rapor"],"inLanguage":"tr","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.fultek.com.tr\/scada-yardim\/2017\/11\/web-server-ile-rapor-olusturma\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.fultek.com.tr\/scada-yardim\/2017\/11\/web-server-ile-rapor-olusturma\/","url":"https:\/\/www.fultek.com.tr\/scada-yardim\/2017\/11\/web-server-ile-rapor-olusturma\/","name":"Web Server ile Rapor olu\u015fturma. - SCADA E\u011fitim Sitesi","isPartOf":{"@id":"https:\/\/www.fultek.com.tr\/scada-yardim\/#website"},"datePublished":"2017-11-03T08:36:03+00:00","dateModified":"2021-12-18T11:30:48+00:00","author":{"@id":"https:\/\/www.fultek.com.tr\/scada-yardim\/#\/schema\/person\/b439f08807fdc9e273a233976c5eb1be"},"breadcrumb":{"@id":"https:\/\/www.fultek.com.tr\/scada-yardim\/2017\/11\/web-server-ile-rapor-olusturma\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.fultek.com.tr\/scada-yardim\/2017\/11\/web-server-ile-rapor-olusturma\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.fultek.com.tr\/scada-yardim\/2017\/11\/web-server-ile-rapor-olusturma\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.fultek.com.tr\/scada-yardim\/"},{"@type":"ListItem","position":2,"name":"Web Server ile Rapor olu\u015fturma."}]},{"@type":"WebSite","@id":"https:\/\/www.fultek.com.tr\/scada-yardim\/#website","url":"https:\/\/www.fultek.com.tr\/scada-yardim\/","name":"SCADA E\u011fitim Sitesi","description":"SCADA program\u0131 hakk\u0131nda bilmek istedikleriniz.","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.fultek.com.tr\/scada-yardim\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"tr"},{"@type":"Person","@id":"https:\/\/www.fultek.com.tr\/scada-yardim\/#\/schema\/person\/b439f08807fdc9e273a233976c5eb1be","name":"Salih","image":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/secure.gravatar.com\/avatar\/71953beeb6b97dd8eeecb5d9b86339eedb7662215ebdf0761d17ac26bc31f94b?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/71953beeb6b97dd8eeecb5d9b86339eedb7662215ebdf0761d17ac26bc31f94b?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/71953beeb6b97dd8eeecb5d9b86339eedb7662215ebdf0761d17ac26bc31f94b?s=96&d=mm&r=g","caption":"Salih"},"sameAs":["http:\/\/www.fultek.com.tr"],"url":"https:\/\/www.fultek.com.tr\/scada-yardim\/author\/salih\/"}]}},"_links":{"self":[{"href":"https:\/\/www.fultek.com.tr\/scada-yardim\/wp-json\/wp\/v2\/posts\/874","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.fultek.com.tr\/scada-yardim\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.fultek.com.tr\/scada-yardim\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.fultek.com.tr\/scada-yardim\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.fultek.com.tr\/scada-yardim\/wp-json\/wp\/v2\/comments?post=874"}],"version-history":[{"count":5,"href":"https:\/\/www.fultek.com.tr\/scada-yardim\/wp-json\/wp\/v2\/posts\/874\/revisions"}],"predecessor-version":[{"id":879,"href":"https:\/\/www.fultek.com.tr\/scada-yardim\/wp-json\/wp\/v2\/posts\/874\/revisions\/879"}],"wp:attachment":[{"href":"https:\/\/www.fultek.com.tr\/scada-yardim\/wp-json\/wp\/v2\/media?parent=874"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.fultek.com.tr\/scada-yardim\/wp-json\/wp\/v2\/categories?post=874"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.fultek.com.tr\/scada-yardim\/wp-json\/wp\/v2\/tags?post=874"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}