/** 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);
}
