{"id":702,"date":"2015-04-02T10:34:06","date_gmt":"2015-04-02T08:34:06","guid":{"rendered":"http:\/\/www.fultek.com.tr\/scada-yardim\/?p=702"},"modified":"2021-12-18T13:30:49","modified_gmt":"2021-12-18T11:30:49","slug":"script-ile-grafik-cizme","status":"publish","type":"post","link":"https:\/\/www.fultek.com.tr\/scada-yardim\/2015\/04\/script-ile-grafik-cizme\/","title":{"rendered":"Script ile Grafik \u00c7izme"},"content":{"rendered":"

WinTr Scada grafikleri realtime ve historical olarak \u00e7al\u0131\u015f\u0131r. Grafikler t\u00fcm datalar\u0131 lokal veya uzak database’lerden oldu\u011fu gibi getirir. \u00d6zel grafik \u00e7izimleri i\u00e7in xy grafikler kullan\u0131labilir fakat bunlar sadece realtime olarak kullan\u0131l\u0131r. Bu konuda script ile database’den veri \u00e7ekip bu veriyi grafik \u00fczerinde g\u00f6stermeyi anlataca\u011f\u0131m. B\u00f6ylece database’deki verilerden \u00f6zel hesaplamalar ile \u00fcretece\u011finiz t\u00fcm datalar grafiklerde g\u00f6sterilebilir.<\/p>\n

Bu i\u015flemin yap\u0131labilmesi i\u00e7in a\u015fa\u011f\u0131daki script’i haz\u0131rlad\u0131m. Bu scripti grafi\u011fin bulundu\u011fu sayfada refresh fonksiyonunda se\u00e7tim. B\u00f6ylece sayfa refresh zaman\u0131nda(default 1000 ms.) bu script \u00e7al\u0131\u015farak grafik yeniden \u00e7iziliyor.<\/p>\n

Imports<\/span> System<\/span><\/p>\n

Imports<\/span><\/span> System.IO<\/span><\/p>\n

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

Imports<\/span><\/span> Microsoft.VisualBasic<\/span><\/p>\n

Imports<\/span><\/span> System.Data.SqlClient<\/span><\/p>\n

Imports<\/span><\/span> System.Globalization<\/span><\/p>\n

Namespace<\/span><\/span> WinTr<\/span><\/p>\n

Public<\/span><\/span> Class<\/span><\/span> MainClass<\/span><\/p>\n

Public<\/span><\/span> ObjectNameOfActiveScreen <\/span>As<\/span><\/span> System.Collections.ArrayList<\/span><\/p>\n

Public<\/span><\/span> ObjectOfActiveScreen <\/span>As<\/span><\/span> System.Collections.ArrayList<\/span><\/p>\n

Public<\/span><\/span> QT250_eff_hour_dt <\/span>As<\/span><\/span> DateTime<\/span><\/span><\/p>\n

Public<\/span><\/span> Sub<\/span><\/span> Load()<\/span><\/p>\n

Try<\/p>\n

QT250_eff_hour_dt = now.AddHours(-1)<\/p>\n

Dim<\/span><\/span> Index <\/span>As<\/span><\/span> Integer<\/span><\/span><\/p>\n

Index = ObjectNameOfActiveScreen.IndexOf(<\/span>“Chart_0”<\/span><\/span>)<\/span><\/p>\n

If<\/span><\/span> Index = -1 <\/span>Then<\/span><\/span><\/p>\n

MsgBox(<\/span>“Chart_0 cannot found!”<\/span><\/span>)<\/span><\/p>\n

Exit<\/span><\/span> Sub<\/span><\/span><\/p>\n

End<\/span><\/span> If<\/span><\/span><\/p>\n

Dim<\/span><\/span> MyChart <\/span>As<\/span><\/span> Object<\/span><\/span> = ObjectOfActiveScreen(Index) <\/span>\u2018Acces<\/span><\/span> WinTr Chart <\/span>object<\/span><\/span><\/p>\n

MyChart.ChartAreas(0).AxisX.Minimum = QT250_eff_hour_dt.AddHours(-1).ToOADate<\/p>\n

MyChart.ChartAreas(0).AxisX.Maximum = QT250_eff_hour_dt.ToOADate<\/p>\n

Dim<\/span><\/span> FirstTime <\/span>As<\/span><\/span> String<\/span><\/span> = QT250_eff_hour_dt.AddHours(-1).ToString(<\/span>“G”, CultureInfo.CreateSpecificCulture(“en-US”<\/span><\/span>))<\/span><\/p>\n

Dim<\/span><\/span> LastTime <\/span>As<\/span><\/span> String<\/span><\/span> = QT250_eff_hour_dt.ToString(<\/span>“G”, CultureInfo.CreateSpecificCulture(“en-US”<\/span><\/span>))<\/span><\/p>\n

Dim<\/span><\/span> Query <\/span>As<\/span><\/span> String<\/span><\/span> = <\/span>“SELECT [QT250_eff_hour_dt],[QT250_eff_hour] FROM Table1 WHERE [QT250_eff_hour_dt] between <\/span><\/span>\u2018”<\/span><\/span><\/span> & FirstTime & <\/span>“<\/span><\/span>\u2018<\/span><\/span><\/span> and <\/span><\/span>\u2018”<\/span><\/span><\/span> & LastTime & <\/span>“<\/span><\/span>\u2018”<\/span><\/span><\/span><\/p>\n

Dim<\/span><\/span> SQL_cn <\/span>As<\/span><\/span> New<\/span><\/span> SqlConnection()<\/span><\/p>\n

SQL_cn.ConnectionString = <\/span>“Server=(local)\\WinTr;uid=sa;pwd=WinTr@2013;database=Stef”<\/span><\/span><\/p>\n

Dim<\/span><\/span> command <\/span>As<\/span><\/span> SqlCommand = <\/span>New<\/span><\/span> SqlCommand(Query, SQL_cn)<\/span><\/p>\n

MyChart.DataSource = command<\/p>\n

MyChart.Series(0).ValueMemberX = <\/span>“QT250_eff_hour_dt”<\/span><\/span><\/p>\n

MyChart.Series(0).ValueMembersY = <\/span>“QT250_eff_hour”<\/span><\/span><\/p>\n

MyChart.DataBind()<\/p>\n

MyChart.Tag = now & <\/span>“”<\/span><\/span> & now & <\/span>“bitti”<\/span><\/span> \u2018Blocking<\/span><\/span> WinTr refresh.<\/span><\/p>\n

command.Connection.Close()<\/p>\n

SQL_cn.Close()<\/p>\n

Catch<\/span><\/span> ex <\/span>As<\/span><\/span> Exception<\/span><\/p>\n

MessageBox.Show(Ex.ToString, <\/span>” Chart Script”<\/span><\/span> & Ex.Message)<\/span><\/p>\n

End<\/span><\/span> Try<\/span><\/span><\/p>\n

End<\/span><\/span> Sub<\/span><\/span><\/p>\n

End<\/span><\/span> Class<\/span><\/span><\/p>\n

End<\/span><\/span> Namespace<\/span><\/span><\/p>\n

 <\/p>\n

\u00d6rnek projeyi buradan<\/a> indirebilirsiniz.<\/p>\n","protected":false},"excerpt":{"rendered":"

WinTr Scada grafikleri realtime ve historical olarak \u00e7al\u0131\u015f\u0131r. Grafikler t\u00fcm datalar\u0131 lokal veya uzak database’lerden oldu\u011fu gibi getirir. \u00d6zel grafik \u00e7izimleri i\u00e7in xy grafikler kullan\u0131labilir fakat bunlar sadece realtime olarak kullan\u0131l\u0131r. Bu konuda script ile database’den veri \u00e7ekip bu veriyi grafik \u00fczerinde g\u00f6stermeyi anlataca\u011f\u0131m. B\u00f6ylece database’deki verilerden \u00f6zel hesaplamalar ile \u00fcretece\u011finiz t\u00fcm datalar grafiklerde g\u00f6sterilebilir. […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[33,20],"tags":[292,291,117],"class_list":["post-702","post","type-post","status-publish","format-standard","hentry","category-scada-grafik","category-scada-script","tag-grafik-cizme","tag-ozel-grafik","tag-scada-grafik-2"],"yoast_head":"\nScript ile Grafik \u00c7izme - 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\/2015\/04\/script-ile-grafik-cizme\/\" \/>\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=\"2 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\\\/2015\\\/04\\\/script-ile-grafik-cizme\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/2015\\\/04\\\/script-ile-grafik-cizme\\\/\"},\"author\":{\"name\":\"Salih\",\"@id\":\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/#\\\/schema\\\/person\\\/b439f08807fdc9e273a233976c5eb1be\"},\"headline\":\"Script ile Grafik \u00c7izme\",\"datePublished\":\"2015-04-02T08:34:06+00:00\",\"dateModified\":\"2021-12-18T11:30:49+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/2015\\\/04\\\/script-ile-grafik-cizme\\\/\"},\"wordCount\":363,\"commentCount\":1,\"keywords\":[\"Grafik \u00e7izme\",\"\u00d6zel grafik\",\"Scada Grafik\"],\"articleSection\":[\"Grafik\",\"Script Writer\"],\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/2015\\\/04\\\/script-ile-grafik-cizme\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/2015\\\/04\\\/script-ile-grafik-cizme\\\/\",\"url\":\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/2015\\\/04\\\/script-ile-grafik-cizme\\\/\",\"name\":\"Script ile Grafik \u00c7izme - SCADA E\u011fitim Sitesi\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/#website\"},\"datePublished\":\"2015-04-02T08:34:06+00:00\",\"dateModified\":\"2021-12-18T11:30:49+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/#\\\/schema\\\/person\\\/b439f08807fdc9e273a233976c5eb1be\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/2015\\\/04\\\/script-ile-grafik-cizme\\\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/2015\\\/04\\\/script-ile-grafik-cizme\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/2015\\\/04\\\/script-ile-grafik-cizme\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Script ile Grafik \u00c7izme\"}]},{\"@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":"Script ile Grafik \u00c7izme - 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\/2015\/04\/script-ile-grafik-cizme\/","twitter_misc":{"Yazan:":"Salih","Tahmini okuma s\u00fcresi":"2 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.fultek.com.tr\/scada-yardim\/2015\/04\/script-ile-grafik-cizme\/#article","isPartOf":{"@id":"https:\/\/www.fultek.com.tr\/scada-yardim\/2015\/04\/script-ile-grafik-cizme\/"},"author":{"name":"Salih","@id":"https:\/\/www.fultek.com.tr\/scada-yardim\/#\/schema\/person\/b439f08807fdc9e273a233976c5eb1be"},"headline":"Script ile Grafik \u00c7izme","datePublished":"2015-04-02T08:34:06+00:00","dateModified":"2021-12-18T11:30:49+00:00","mainEntityOfPage":{"@id":"https:\/\/www.fultek.com.tr\/scada-yardim\/2015\/04\/script-ile-grafik-cizme\/"},"wordCount":363,"commentCount":1,"keywords":["Grafik \u00e7izme","\u00d6zel grafik","Scada Grafik"],"articleSection":["Grafik","Script Writer"],"inLanguage":"tr","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.fultek.com.tr\/scada-yardim\/2015\/04\/script-ile-grafik-cizme\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.fultek.com.tr\/scada-yardim\/2015\/04\/script-ile-grafik-cizme\/","url":"https:\/\/www.fultek.com.tr\/scada-yardim\/2015\/04\/script-ile-grafik-cizme\/","name":"Script ile Grafik \u00c7izme - SCADA E\u011fitim Sitesi","isPartOf":{"@id":"https:\/\/www.fultek.com.tr\/scada-yardim\/#website"},"datePublished":"2015-04-02T08:34:06+00:00","dateModified":"2021-12-18T11:30:49+00:00","author":{"@id":"https:\/\/www.fultek.com.tr\/scada-yardim\/#\/schema\/person\/b439f08807fdc9e273a233976c5eb1be"},"breadcrumb":{"@id":"https:\/\/www.fultek.com.tr\/scada-yardim\/2015\/04\/script-ile-grafik-cizme\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.fultek.com.tr\/scada-yardim\/2015\/04\/script-ile-grafik-cizme\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.fultek.com.tr\/scada-yardim\/2015\/04\/script-ile-grafik-cizme\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.fultek.com.tr\/scada-yardim\/"},{"@type":"ListItem","position":2,"name":"Script ile Grafik \u00c7izme"}]},{"@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\/702","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=702"}],"version-history":[{"count":5,"href":"https:\/\/www.fultek.com.tr\/scada-yardim\/wp-json\/wp\/v2\/posts\/702\/revisions"}],"predecessor-version":[{"id":1012,"href":"https:\/\/www.fultek.com.tr\/scada-yardim\/wp-json\/wp\/v2\/posts\/702\/revisions\/1012"}],"wp:attachment":[{"href":"https:\/\/www.fultek.com.tr\/scada-yardim\/wp-json\/wp\/v2\/media?parent=702"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.fultek.com.tr\/scada-yardim\/wp-json\/wp\/v2\/categories?post=702"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.fultek.com.tr\/scada-yardim\/wp-json\/wp\/v2\/tags?post=702"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}