private void RefreshGrd()
{
string islem = "C";
if (ISLEM.GetString() != "")
{
islem = ISLEM.GetString();
}
grdRapor.SQLText = "SELECT STOK_ADI AS STOK_ADI, SUM(MIKTAR) AS MIKTAR, SUM(TUTAR) AS TUTAR, SUM(KAR) AS KAR FROM (SELECT STOK.STOK_ADI, CASE WHEN GC = '" + islem + "' THEN HAR.MIKTAR " +
"ELSE 0.0 END AS MIKTAR , ";
if (islem == "C")
{
grdRapor.SQLText += "HAR.BIRIM_FIYAT* MIKTAR AS TUTAR, ";
}
else
{
grdRapor.SQLText += "STOK.ALIS_FIYAT * MIKTAR AS TUTAR, ";
}
if (islem == "C")
{
grdRapor.SQLText += "((STOK.SATIS_FIYAT * MIKTAR) - (STOK.ALIS_FIYAT * MIKTAR)) AS KAR ";
}
else
{
grdRapor.SQLText += "0 AS KAR ";
}
grdRapor.SQLText += "FROM[TBLSTOKHAR] HAR, TBLSTOK STOK " +
"WHERE /*WS*/TARIH BETWEEN '" + BAS_TAR.GetSQLDataStr() + " 00:00:00' AND '" + BIT_TAR.GetSQLDataStr() + " 23:59:59' AND STOK.STOK_KODU = HAR.STOK_KODU " +
"AND GC = '" + islem + "' " +
"/*WE*/) AS RAPOR " +
"GROUP BY STOK_ADI";
grdRapor.Open();
}
private void SatisRaporu_Load(object sender, EventArgs e)
{
ISLEM.SetString("C");
RefreshGrd();
}
