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