public void Katsayi_Tartımdan_Bul(Int32 Tarih, Int16 Vrd, string Kalite, string Ebat, string Boy) { //09.08.2018 hatice tarafından düzenlendi. Katsayi_Tartımdan_Value = 0; string sql2 = "SELECT KATSAYI FROM URTTNM.KATSAYI_TARTIMDAN" + " WHERE CC='" + Kalite + "'" + " AND EBAT='" + Ebat + "'" + " AND BOY='" + Boy + "'" + " AND TARIH=" + Tarih + "" + " AND VRD=" + Vrd + ""; DbConn4.RaporWhile(sql2); while (DbConn4.MyDataReader.Read()) { Katsayi_Tartımdan_Value = Convert.ToInt32(DbConn4.MyDataReader.GetValue(0).ToString()); } if (Katsayi_Tartımdan_Value == 0) { sql2 = "SELECT KATSAYI FROM " + "(" + " SELECT * FROM URTTNM.KATSAYI_TARTIMDAN" + " WHERE CC='" + Kalite + "'" + " AND EBAT='" + Ebat + "'" + " AND BOY='" + Boy + "'" + " ORDER BY TARIH DESC" + " )" + " WHERE ROWNUM = 1"; DbConn3.RaporWhile(sql2); while (DbConn3.MyDataReader.Read()) { Katsayi_Tartımdan_Value = Convert.ToInt32(DbConn3.MyDataReader.GetValue(0).ToString()); } if (Katsayi_Tartımdan_Value == 0) { sql2 = "SELECT KATSAYI FROM " + "(" + " SELECT * FROM URTTNM.KATSAYI_TARTIMDAN" + " WHERE EBAT='" + Ebat + "'" + " AND BOY='" + Boy + "'" + " ORDER BY TARIH DESC" + " )" + " WHERE ROWNUM = 1"; DbConn3.RaporWhile(sql2); while (DbConn3.MyDataReader.Read()) { Katsayi_Tartımdan_Value = Convert.ToInt32(DbConn3.MyDataReader.GetValue(0).ToString()); } } } }
public List <katsayi_kontrol> DokumTip_Gunluk_Degerler(String Tarih_ = "") { List <katsayi_kontrol> veriler = new List <katsayi_kontrol>(); string sql = ""; String DTip = ""; Int16 Adet = 0; Decimal Tonaj_ = 0; decimal Gun_TK_Tnj_ = 0; decimal Gun_ACYK_Tnj_ = 0; Int16 Gun_TK_Top_ = 0; Int16 Gun_ACYK_Top_ = 0; sql = "SELECT DOKUMTIP, COUNT(STDKTKSAY) FROM URTHRK.CH_DOKUMNO_URETIM" + " WHERE DOKUMTAR=" + Convert.ToInt32(Tarih_) + " AND DSNO=1" + " GROUP BY DOKUMTIP"; DbConn.RaporWhile(sql); DbConn.Sayac(sql); while (DbConn.MyDataReader.Read()) { DTip = DbConn.MyDataReader.GetValue(0).ToString(); Adet = Convert.ToInt16(DbConn.MyDataReader.GetValue(1).ToString()); if (DTip == "TK") { Gun_TK_Top_ += Adet; } if (DTip == "AC" || DTip == "YK") { Gun_ACYK_Top_ += Adet; } } /// BURDA GUNUNU TONAJLARINI GETIR sql = "SELECT DOKUMTIP, SUM(STDKTKTON)+SUM(STNKARTON) FROM URTHRK.CH_DOKUMNO_URETIM" + " WHERE DOKUMTAR=" + Convert.ToInt32(Tarih_) + " GROUP BY DOKUMTIP"; DbConn.RaporWhile(sql); DbConn.Sayac(sql); while (DbConn.MyDataReader.Read()) { DTip = DbConn.MyDataReader.GetValue(0).ToString(); Tonaj_ = Convert.ToDecimal(DbConn.MyDataReader.GetValue(1).ToString()); if (DTip == "TK") { Gun_TK_Tnj_ = ++Tonaj_; } if (DTip == "AC" || DTip == "YK") { Gun_ACYK_Tnj_ = ++Tonaj_; } } katsayi_kontrol satir = new katsayi_kontrol(); satir.Gun_TK_Top = Gun_TK_Top_; satir.Gun_ACYK_Top = Gun_ACYK_Top_; satir.Gun_TK_Tnj = Gun_TK_Tnj_; satir.Gun_ACYK_Tnj = Gun_ACYK_Tnj_; veriler.Add(satir); return(veriler); }