private dynamic GETDOVIZKURU(DateTime TARIH, bool isISLEMDOVIZI = false/*VARSAYILAN RAPORLAMA DOVIZI*/, string DOVIZCINSI = "20"/*20EURO*/)
        {

            string RESULT = "0";
            int yil = TARIH.Year;
            int ay = TARIH.Month;
            int gun = TARIH.Day;
            /*CONVERT(datetime, '22.12.1987' ,104 )
*/
            string casteddate = "CONVERT(datetime, '"+gun.ToString()+"."+ay.ToString()+"."+yil.ToString()+"' ,104 )";
            string RATE = isISLEMDOVIZI == true ? "RATES4" : "RATES1";
            RATE = "RATES4";
            try
            {
                //RESULT = SELECT2("SELECT TOP 1 " + RATE + " FROM LG_EXCHANGE_" + CFG.FIRMNR + "  WITH(NOLOCK) WHERE YEAR(EDATE)<=" + yil + " AND MONTH(EDATE)=" + ay + " AND DAY(EDATE)=" + gun + " and CRTYPE=" + DOVIZCINSI + " /*EURO*/  ORDER BY EDATE DESC ", new SqlConnection(CONSTR_LG)).Rows[0][0].ToString();
                RESULT = SELECT2("SELECT TOP 1 " + RATE + " FROM LG_EXCHANGE_" + CFG.FIRMNR + "  WITH(NOLOCK) WHERE  CONVERT(datetime, EDATE ,104 )<="+ casteddate + "  and CRTYPE=" + DOVIZCINSI + " /*EURO*/  ORDER BY EDATE DESC ", new SqlConnection(CONSTR_LG)).Rows[0][0].ToString();
            }
            catch { }
            return RESULT.Replace(",", ".");
        }