/** Haddehane */ public List <Genel_uretim> genel_uretim_data_read(string tarih, string firma = "DILER", string unite = "HH", string tablotip = "URETIM") { List <Genel_uretim> genel_uretimler = new List <Genel_uretim>(); this.sql = "SELECT BILGITNM,K1,K2,K3,K4,K5,K6 FROM API_DB_001_Y " + "WHERE TARIH=" + tarih + " AND FIRMA='" + firma + "' AND UNITE='" + unite + "' AND TABLOTIP='" + tablotip + "' " + "ORDER BY CAST(BILGISIRANO AS INT)"; this.cmd.CommandText = this.sql; this.dr = this.cmd.ExecuteReader(); if (!this.dr.HasRows) { //kayit bulunamadiysa Genel_uretim gu = new Genel_uretim(); gu.Gu_bilgitnm = "Listelenecek kayıt bulunamadı."; gu.Gu_id = 0; genel_uretimler.Add(gu); } else { while (this.dr.Read()) { Genel_uretim gu = new Genel_uretim(); gu.Gu_id = 1; gu.Gu_bilgitnm = this.dr[0].ToString(); //if (firma != "YAZICI") //{ // gu.Gu_gunluk = Convert.ToDouble(this.dr[1].ToString().Equals("") ? 0 : this.dr[1]).ToString("###,###.##"); // gu.Gu_gunluk_ort = Convert.ToDouble(this.dr[2].ToString().Equals("") ? 0 : this.dr[2]).ToString("###,###.##"); // gu.Gu_aylik = Convert.ToDouble(this.dr[3].ToString().Equals("") ? 0 : this.dr[3]).ToString("###,###.##"); // gu.Gu_aylik_ort = Convert.ToDouble(this.dr[4].ToString().Equals("") ? 0 : this.dr[4]).ToString("###,###.##"); // gu.Gu_yillik = Convert.ToDouble(this.dr[5].ToString().Equals("") ? 0 : this.dr[5]).ToString("###,###.##"); // gu.Gu_yillik_ort = Convert.ToDouble(this.dr[6].ToString().Equals("") ? 0 : this.dr[6]).ToString("###,###.##"); //} //else //{ gu.Gu_gunluk = this.dr[1].ToString(); gu.Gu_gunluk_ort = this.dr[2].ToString(); gu.Gu_aylik = this.dr[3].ToString(); gu.Gu_aylik_ort = this.dr[4].ToString(); gu.Gu_yillik = this.dr[5].ToString(); gu.Gu_yillik_ort = this.dr[6].ToString(); genel_uretimler.Add(gu); } } this.dr.Close(); this.dr.Dispose(); return(genel_uretimler); }
/** Haddehane **/ public List <Genel_uretim> genel_uretim_data_read(string tarih) { List <Genel_uretim> genel_uretimler = new List <Genel_uretim>(); string yil = tarih.Substring(0, 4); string yil_baslangic = yil + "0101"; string yil_ay = tarih.Substring(0, 6); string su_anki_ay_gunu = tarih.Substring(6, 2); // ayın kaçıncı günü string ay = tarih.Substring(4, 2); string ay_baslangic = yil_ay + "01"; DateTime baslangictarihi = new DateTime(Convert.ToInt32(yil), 01, 01); DateTime bitistarihi = new DateTime(Convert.ToInt32(yil), Convert.ToInt32(ay), Convert.ToInt32(su_anki_ay_gunu)); TimeSpan arasindakigunler = bitistarihi - baslangictarihi; double days = arasindakigunler.TotalDays + 1; this.sql = "SELECT " + "(SELECT SUM(KUTUKTONAJI)+SUM(EGRIKTKTON) FROM URTHRK.VERIM WHERE TARIH = " + tarih + ") AS GUN, " + "(SELECT SUM(KUTUKTONAJI)+SUM(EGRIKTKTON) FROM URTHRK.VERIM WHERE TARIH BETWEEN '" + ay_baslangic + "' AND '" + tarih + "') AS AY, " + "(SELECT SUM(KUTUKTONAJI)+SUM(EGRIKTKTON) FROM URTHRK.VERIM WHERE TARIH BETWEEN '" + yil_baslangic + "' AND '" + tarih + "') AS YIL " + "FROM URTHRK.VERIM WHERE ROWNUM = 1"; this.cmd.CommandText = this.sql; this.dr = this.cmd.ExecuteReader(); while (this.dr.Read()) { Genel_uretim gu = new Genel_uretim(); gu.Gu_id = 1; gu.Gu_bilgitnm = "Kütük"; gu.Gu_gunluk = Convert.ToDouble(this.dr[0].ToString().Equals("") ? 0 : this.dr[0]).ToString("###,###.##"); gu.Gu_gunluk_ort = "0"; gu.Gu_aylik = Convert.ToDouble(this.dr[1].ToString().Equals("") ? 0 : this.dr[1]).ToString("###,###.##"); gu.Gu_aylik_ort = (Convert.ToDouble(gu.Gu_aylik) / Convert.ToDouble(su_anki_ay_gunu)).ToString("###,###.##"); gu.Gu_yillik = Convert.ToDouble(this.dr[2].ToString().Equals("") ? 0 : this.dr[2]).ToString("###,###.##"); gu.Gu_yillik_ort = (Convert.ToDouble(gu.Gu_yillik) / days).ToString("###,###.##"); genel_uretimler.Add(gu); } this.sql = "SELECT " + "(SELECT SUM(TPAKTON)+ SUM(TSTDPAKTON) FROM URTHRK.VERIM WHERE TARIH = " + tarih + ") AS GUN, " + "(SELECT SUM(TPAKTON)+ SUM(TSTDPAKTON) FROM URTHRK.VERIM WHERE TARIH BETWEEN '" + ay_baslangic + "' AND '" + tarih + "') AS AY, " + "(SELECT SUM(TPAKTON)+ SUM(TSTDPAKTON) FROM URTHRK.VERIM WHERE TARIH BETWEEN '" + yil_baslangic + "' AND '" + tarih + "') AS YIL " + "FROM URTHRK.VERIM WHERE ROWNUM = 1"; this.cmd.CommandText = this.sql; this.dr = this.cmd.ExecuteReader(); while (this.dr.Read()) { Genel_uretim gu = new Genel_uretim(); gu.Gu_id = 1; gu.Gu_bilgitnm = "Yuvarlak"; gu.Gu_gunluk = Convert.ToDouble(this.dr[0].ToString().Equals("") ? 0 : this.dr[0]).ToString("###,###.##"); yuvarlak_gunluk = gu.Gu_gunluk; gu.Gu_gunluk_ort = "0"; gu.Gu_aylik = Convert.ToDouble(this.dr[1].ToString().Equals("") ? 0 : this.dr[1]).ToString("###,###.##"); yuvarlak_aylik = gu.Gu_aylik; gu.Gu_aylik_ort = (Convert.ToDouble(gu.Gu_aylik) / Convert.ToDouble(su_anki_ay_gunu)).ToString("###,###.##"); gu.Gu_yillik = Convert.ToDouble(this.dr[2].ToString().Equals("") ? 0 : this.dr[2]).ToString("###,###.##"); yuvarlak_yillik = gu.Gu_yillik; gu.Gu_yillik_ort = (Convert.ToDouble(gu.Gu_yillik) / days).ToString("###,###.##"); genel_uretimler.Add(gu); } this.sql = "SELECT " + "(SELECT SUM(KISAPARCA)/1000 FROM URTHRK.HHTARTHBKP WHERE TARIH = " + tarih + ") AS GUN, " + "(SELECT SUM(KISAPARCA)/1000 FROM URTHRK.HHTARTHBKP WHERE TARIH BETWEEN '" + ay_baslangic + "' AND '" + tarih + "') AS AY, " + "(SELECT SUM(KISAPARCA)/1000 FROM URTHRK.HHTARTHBKP WHERE TARIH BETWEEN '" + yil_baslangic + "' AND '" + tarih + "') AS YIL " + "FROM URTHRK.HHTARTHBKP WHERE ROWNUM = 1"; this.cmd.CommandText = this.sql; this.dr = this.cmd.ExecuteReader(); while (this.dr.Read()) { Genel_uretim gu = new Genel_uretim(); gu.Gu_id = 1; gu.Gu_bilgitnm = "Kısa Mamul"; gu.Gu_gunluk = Convert.ToDouble(this.dr[0].ToString().Equals("") ? 0 : this.dr[0]).ToString("###,###.##"); kisa_gunluk = gu.Gu_gunluk; gu.Gu_gunluk_ort = "0"; gu.Gu_aylik = Convert.ToDouble(this.dr[1].ToString().Equals("") ? 0 : this.dr[1]).ToString("###,###.##"); kisa_aylik = gu.Gu_aylik; gu.Gu_aylik_ort = (Convert.ToDouble(gu.Gu_aylik) / Convert.ToDouble(su_anki_ay_gunu)).ToString("###,###.##"); gu.Gu_yillik = Convert.ToDouble(this.dr[2].ToString().Equals("") ? 0 : this.dr[2]).ToString("###,###.###"); kisa_yillik = gu.Gu_yillik; gu.Gu_yillik_ort = (Convert.ToDouble(gu.Gu_yillik) / days).ToString("###,###.##"); genel_uretimler.Add(gu); } this.sql = "SELECT " + "(SELECT SUM(TPAKTON) + SUM(TSTDPAKTON) from URTHRK.VERIM WHERE TARIH = " + tarih + ") AS GUNLUK," + "(SELECT SUM(TPAKTON) + SUM(TSTDPAKTON) from URTHRK.VERIM WHERE TARIH BETWEEN '" + ay_baslangic + "' AND '" + tarih + "') AS AYLIK," + "(SELECT SUM(TPAKTON) + SUM(TSTDPAKTON) from URTHRK.VERIM WHERE TARIH BETWEEN '" + yil_baslangic + "' AND '" + tarih + "') AS YILLIK," + "(SELECT SUM(KISAPARCA) / 1000 from URTHRK.HHTARTHBKP WHERE TARIH = " + tarih + ") AS GUNLUK," + "(SELECT SUM(KISAPARCA) / 1000 from URTHRK.HHTARTHBKP WHERE TARIH BETWEEN '" + ay_baslangic + "' AND '" + tarih + "') AS AYLIK," + "(SELECT SUM(KISAPARCA) / 1000 from URTHRK.HHTARTHBKP WHERE TARIH BETWEEN '" + yil_baslangic + "' AND '" + tarih + "') AS YILLIK," + "(SELECT SUM(KUTUKTONAJI) from URTHRK.VERIM WHERE TARIH = " + tarih + ") AS GUNLUK," + "(SELECT SUM(KUTUKTONAJI) from URTHRK.VERIM WHERE TARIH BETWEEN '" + ay_baslangic + "' AND '" + tarih + "') AS AYLIK," + "(SELECT SUM(KUTUKTONAJI) from URTHRK.VERIM WHERE TARIH BETWEEN '" + yil_baslangic + "' AND '" + tarih + "') AS YILLIK " + "FROM URTHRK.HHTARTHBKP WHERE ROWNUM = 1"; this.cmd.CommandText = this.sql; this.dr = this.cmd.ExecuteReader(); while (this.dr.Read()) { Genel_uretim gu = new Genel_uretim(); gu.Gu_id = 1; gu.Gu_bilgitnm = "Fire %"; gu.Gu_gunluk = ((1 - ((Convert.ToDouble(this.dr[0].ToString().Equals("") ? 0 : this.dr[0]) + Convert.ToDouble(this.dr[3].ToString().Equals("") ? 0 : this.dr[3])) / Convert.ToDouble(this.dr[6].ToString().Equals("") ? 0 : this.dr[6]))) * 100).ToString("###,###.##"); if (gu.Gu_gunluk == "NaN") { gu.Gu_gunluk = "0"; } gu.Gu_gunluk_ort = "0"; gu.Gu_aylik = ((1 - ((Convert.ToDouble(this.dr[1].ToString().Equals("") ? 0 : this.dr[1]) + Convert.ToDouble(this.dr[4].ToString().Equals("") ? 0 : this.dr[4])) / Convert.ToDouble(this.dr[7].ToString().Equals("") ? 0 : this.dr[7]))) * 100).ToString("###,###.##"); gu.Gu_aylik_ort = "0"; gu.Gu_yillik = ((1 - ((Convert.ToDouble(this.dr[2].ToString().Equals("") ? 0 : this.dr[2]) + Convert.ToDouble(this.dr[5].ToString().Equals("") ? 0 : this.dr[5])) / Convert.ToDouble(this.dr[8].ToString().Equals("") ? 0 : this.dr[8]))) * 100).ToString("###,###.##"); gu.Gu_yillik_ort = "0"; genel_uretimler.Add(gu); } this.sql = "SELECT " + "(SELECT SUM(HBTONAJ) FROM URTHRK.HHTARTHBKP WHERE TARIH = " + tarih + ") AS GUN," + "(SELECT SUM(HBTONAJ) FROM URTHRK.HHTARTHBKP WHERE TARIH BETWEEN '" + ay_baslangic + "' AND '" + tarih + "') AS AY," + "(SELECT SUM(HBTONAJ) FROM URTHRK.HHTARTHBKP WHERE TARIH BETWEEN '" + yil_baslangic + "' AND '" + tarih + "') AS YIL, " + //hddebozugu "(SELECT SUM(TARTIM1)/1000 FROM URTHRK.HHTARTKIRP WHERE TARIH = " + tarih + ") AS GUN," + "(SELECT SUM(TARTIM1)/1000 FROM URTHRK.HHTARTKIRP WHERE TARIH BETWEEN '" + ay_baslangic + "' AND '" + tarih + "') AS AY," + "(SELECT SUM(TARTIM1)/1000 FROM URTHRK.HHTARTKIRP WHERE TARIH BETWEEN '" + yil_baslangic + "' AND '" + tarih + "') AS YIL " + //ucbas "FROM URTHRK.HHTARTKIRP WHERE ROWNUM = 1"; this.cmd.CommandText = this.sql; this.dr = this.cmd.ExecuteReader(); while (this.dr.Read()) { Genel_uretim gu = new Genel_uretim(); gu.Gu_id = 1; gu.Gu_bilgitnm = "Hadde b. + Uçbaş"; gu.Gu_gunluk = (Convert.ToDouble(this.dr[0].ToString().Equals("") ? 0 : this.dr[0]) + Convert.ToDouble(this.dr[3].ToString().Equals("") ? 0 : this.dr[3])).ToString("###,###.##"); gu.Gu_gunluk_ort = "0"; gu.Gu_aylik = (Convert.ToDouble(this.dr[1].ToString().Equals("") ? 0 : this.dr[1]) + Convert.ToDouble(this.dr[4].ToString().Equals("") ? 0 : this.dr[4])).ToString("###,###.##"); gu.Gu_aylik_ort = (Convert.ToDouble(gu.Gu_aylik) / Convert.ToDouble(su_anki_ay_gunu)).ToString("###,###.##"); gu.Gu_yillik = (Convert.ToDouble(this.dr[2].ToString().Equals("") ? 0 : this.dr[2]) + Convert.ToDouble(this.dr[5].ToString().Equals("") ? 0 : this.dr[5])).ToString("###,###.##"); gu.Gu_yillik_ort = (Convert.ToDouble(gu.Gu_yillik) / days).ToString("###,###.##"); genel_uretimler.Add(gu); } this.sql = "SELECT " + "(SELECT GUNLUKTUKETIM FROM URTHRK.ELK_HHAOCH_SERVIS WHERE TARIH = " + tarih + " AND YER = 'Haddehane') AS GUN," + "(SELECT SUM(GUNLUKTUKETIM) FROM URTHRK.ELK_HHAOCH_SERVIS WHERE TARIH BETWEEN '" + ay_baslangic + "' AND '" + tarih + "' AND YER = 'Haddehane') AS AY," + "(SELECT SUM(GUNLUKTUKETIM) FROM URTHRK.ELK_HHAOCH_SERVIS WHERE TARIH BETWEEN '" + yil_baslangic + "' AND '" + tarih + "' AND YER = 'Haddehane') AS YIL, " + "(SELECT GUNLUKTUKETIM FROM URTHRK.ELK_HHAOCH_SERVIS WHERE TARIH = " + tarih + " AND YER = 'JoyKompPompa') AS GUN," + "(SELECT SUM(GUNLUKTUKETIM) FROM URTHRK.ELK_HHAOCH_SERVIS WHERE TARIH BETWEEN '" + ay_baslangic + "' AND '" + tarih + "' AND YER = 'JoyKompPompa') AS AY," + "(SELECT SUM(GUNLUKTUKETIM) FROM URTHRK.ELK_HHAOCH_SERVIS WHERE TARIH BETWEEN '" + yil_baslangic + "' AND '" + tarih + "' AND YER = 'JoyKompPompa') AS YIL, " + "(SELECT GUNLUKTUKETIM FROM URTHRK.ELK_HHAOCH_SERVIS WHERE TARIH = " + tarih + " AND YER = 'HaddeKompA') AS GUN," + "(SELECT SUM(GUNLUKTUKETIM) FROM URTHRK.ELK_HHAOCH_SERVIS WHERE TARIH BETWEEN '" + ay_baslangic + "' AND '" + tarih + "' AND YER = 'HaddeKompA') AS AY," + "(SELECT SUM(GUNLUKTUKETIM) FROM URTHRK.ELK_HHAOCH_SERVIS WHERE TARIH BETWEEN '" + yil_baslangic + "' AND '" + tarih + "' AND YER = 'HaddeKompA') AS YIL," + "(SELECT GUNLUKTUKETIM FROM URTHRK.ELK_HHAOCH_SERVIS WHERE TARIH = " + tarih + " AND YER = 'HaddeKompB') AS GUN," + "(SELECT SUM(GUNLUKTUKETIM) FROM URTHRK.ELK_HHAOCH_SERVIS WHERE TARIH BETWEEN '" + ay_baslangic + "' AND '" + tarih + "' AND YER = 'HaddeKompB') AS AY," + "(SELECT SUM(GUNLUKTUKETIM) FROM URTHRK.ELK_HHAOCH_SERVIS WHERE TARIH BETWEEN '" + yil_baslangic + "' AND '" + tarih + "' AND YER = 'HaddeKompB') AS YIL, " + "(SELECT GUNLUKTUKETIM FROM URTHRK.ELK_HHAOCH_SERVIS WHERE TARIH = " + tarih + " AND YER = 'Atelyeler') AS GUN," + "(SELECT SUM(GUNLUKTUKETIM) FROM URTHRK.ELK_HHAOCH_SERVIS WHERE TARIH BETWEEN '" + ay_baslangic + "' AND '" + tarih + "' AND YER = 'Atelyeler') AS AY," + "(SELECT SUM(GUNLUKTUKETIM) FROM URTHRK.ELK_HHAOCH_SERVIS WHERE TARIH BETWEEN '" + yil_baslangic + "' AND '" + tarih + "' AND YER = 'Atelyeler') AS YIL " + "FROM URTHRK.ELK_HHAOCH_SERVIS WHERE ROWNUM = 1"; //HaddeKompA,HaddeKompB,Atelyeler this.cmd.CommandText = this.sql; this.dr = this.cmd.ExecuteReader(); if (!this.dr.HasRows) { //kayit bulunamadiysa Genel_uretim gu = new Genel_uretim(); gu.Gu_bilgitnm = "Listelenecek kayıt bulunamadı."; gu.Gu_id = 0; genel_uretimler.Add(gu); } else { while (this.dr.Read()) { Genel_uretim gu = new Genel_uretim(); gu.Gu_id = 1; gu.Gu_bilgitnm = "Enerji(Kwh)"; gu.Gu_gunluk = ((Convert.ToDouble(this.dr[0].ToString().Equals("") ? 0 : this.dr[0]) - Convert.ToDouble(this.dr[3].ToString().Equals("") ? 0 : this.dr[3])) + Convert.ToDouble(this.dr[6].ToString().Equals("") ? 0 : this.dr[6]) + Convert.ToDouble(this.dr[9].ToString().Equals("") ? 0 : this.dr[9]) + Convert.ToDouble(this.dr[12].ToString().Equals("") ? 0 : this.dr[12])).ToString("###,###.###"); if ((gu.Gu_gunluk != "" && gu.Gu_gunluk != "0") && (yuvarlak_gunluk != "" && kisa_gunluk != "")) { gu.Gu_gunluk_ort = (Convert.ToDouble(gu.Gu_gunluk) / (Convert.ToDouble(yuvarlak_gunluk) + Convert.ToDouble(kisa_gunluk))).ToString("###,###.##"); } gu.Gu_aylik = ((Convert.ToDouble(this.dr[1].ToString().Equals("") ? 0 : this.dr[1]) - Convert.ToDouble(this.dr[4].ToString().Equals("") ? 0 : this.dr[4])) + Convert.ToDouble(this.dr[7].ToString().Equals("") ? 0 : this.dr[7]) + Convert.ToDouble(this.dr[10].ToString().Equals("") ? 0 : this.dr[10]) + Convert.ToDouble(this.dr[13].ToString().Equals("") ? 0 : this.dr[13])).ToString("###,###.###"); if (gu.Gu_aylik != "" && gu.Gu_aylik != "0") { gu.Gu_aylik_ort = (Convert.ToDouble(gu.Gu_aylik) / (Convert.ToDouble(yuvarlak_aylik) + Convert.ToDouble(kisa_aylik))).ToString("###,###.##"); } gu.Gu_yillik = ((Convert.ToDouble(this.dr[2].ToString().Equals("") ? 0 : this.dr[2]) - Convert.ToDouble(this.dr[5].ToString().Equals("") ? 0 : this.dr[5])) + Convert.ToDouble(this.dr[8].ToString().Equals("") ? 0 : this.dr[8]) + Convert.ToDouble(this.dr[11].ToString().Equals("") ? 0 : this.dr[11]) + Convert.ToDouble(this.dr[14].ToString().Equals("") ? 0 : this.dr[14])).ToString("###,###.###"); if (gu.Gu_yillik != "" && gu.Gu_yillik != "0") { gu.Gu_yillik_ort = (Convert.ToDouble(gu.Gu_yillik) / (Convert.ToDouble(yuvarlak_yillik) + Convert.ToDouble(kisa_yillik))).ToString("###,###.##"); } genel_uretimler.Add(gu); } } this.sql = "SELECT " + "(SELECT HH_DOGALGAZ FROM URTHRK.OKSIJEN_GIRIS WHERE TARIH = " + tarih + " ) AS GUN," + "(SELECT SUM(HH_DOGALGAZ) FROM URTHRK.OKSIJEN_GIRIS WHERE TARIH BETWEEN '" + ay_baslangic + "' AND '" + tarih + "') AS AY," + "(SELECT SUM(HH_DOGALGAZ) FROM URTHRK.OKSIJEN_GIRIS WHERE TARIH BETWEEN '" + yil_baslangic + "' AND '" + tarih + "') AS YIL " + "FROM URTHRK.OKSIJEN_GIRIS WHERE ROWNUM = 1"; this.cmd.CommandText = this.sql; this.dr = this.cmd.ExecuteReader(); if (!this.dr.HasRows) { //kayit bulunamadiysa Genel_uretim gu = new Genel_uretim(); gu.Gu_bilgitnm = "Listelenecek kayıt bulunamadı."; gu.Gu_id = 0; genel_uretimler.Add(gu); } else { while (this.dr.Read()) { Genel_uretim gu = new Genel_uretim(); gu.Gu_id = 1; gu.Gu_bilgitnm = "Doğal gaz(m3)"; gu.Gu_gunluk = Convert.ToDouble(this.dr[0].ToString().Equals("") ? 0 : this.dr[0]).ToString("###,###.###"); if ((gu.Gu_gunluk != "" && gu.Gu_gunluk != "0") && (yuvarlak_gunluk != "" && kisa_gunluk != "")) { gu.Gu_gunluk_ort = (Convert.ToDouble(gu.Gu_gunluk) / (Convert.ToDouble(yuvarlak_gunluk) + Convert.ToDouble(kisa_gunluk))).ToString("###,###.##"); } gu.Gu_aylik = Convert.ToDouble(this.dr[1].ToString().Equals("") ? 0 : this.dr[1]).ToString("###,###.###"); if (gu.Gu_aylik != "" && gu.Gu_aylik != "0") { gu.Gu_aylik_ort = (Convert.ToDouble(gu.Gu_aylik) / (Convert.ToDouble(yuvarlak_aylik) + Convert.ToDouble(kisa_aylik))).ToString("###,###.##"); } gu.Gu_yillik = Convert.ToDouble(this.dr[2].ToString().Equals("") ? 0 : this.dr[2]).ToString("###,###.###"); if (gu.Gu_yillik != "" && gu.Gu_yillik != "0") { gu.Gu_yillik_ort = (Convert.ToDouble(gu.Gu_yillik) / (Convert.ToDouble(yuvarlak_yillik) + Convert.ToDouble(kisa_yillik))).ToString("###,###.##"); } genel_uretimler.Add(gu); } } this.dr.Close(); this.dr.Dispose(); return(genel_uretimler); }