/// <summary>
/// bulamazsa "-1" değeri döndürür
/// </summary>
/// <param name="TabloAdi"></param>
/// <param name="Sart"></param>
/// <param name="DonecekFieldAdi"></param>
/// <returns></returns>
public static string TekDegerDondur(string TabloAdi, string Sart, string DonecekFieldAdi, SqlParameter[] pCollection)
{
string Donen;
SqlCommand SqlCom = new SqlCommand(ConfigurationSettings.AppSettings["SqlTarihFormat"].ToString() + " select " + DonecekFieldAdi + " from " + TabloAdi + " " + Sart, Baglanti());
SqlCom.Parameters.AddRange(pCollection);
try
{
SqlCom.Connection.Open();
Donen = SqlCom.ExecuteScalar().ToString().TrimEnd();
}
catch (Exception e)
{
Donen = "-1";
// DigerIslemler.HataYaz("AKBclass-TekDegerDondur-1", e.Message, "");
}
if (SqlCom.Connection.State == ConnectionState.Open)
{
SqlCom.Connection.Close();
}
if (string.IsNullOrEmpty(Donen))
{
Donen = "-1";
}
SqlCom.Parameters.Clear();
System.GC.SuppressFinalize(SqlCom);
return(Donen.TrimEnd());
}
/// <summary>
/// "-1" dönerse Yoktur!
/// </summary>
/// <param name="TabloAdi"></param>
/// <param name="Sart"></param>
/// <returns></returns>
public static string Varmi(string TabloAdi, string Sart)
{
string Donen;
SqlCommand SqlCom = new SqlCommand(ConfigurationSettings.AppSettings["SqlTarihFormat"].ToString() + " select Count(ID) as AKB from " + TabloAdi + " " + Sart, Baglanti());
try
{
SqlCom.Connection.Open();
Donen = SqlCom.ExecuteScalar().ToString();
}
catch (Exception e)
{
Donen = "-1";
// DigerIslemler.HataYaz("AKBclass-Varmi-1", e.Message, "");
}
if (SqlCom.Connection.State == ConnectionState.Open)
{
SqlCom.Connection.Close();
}
if (string.IsNullOrEmpty(Donen) || Donen == "0")
{
Donen = "-1";
}
System.GC.SuppressFinalize(SqlCom);
return(Donen.TrimEnd());
}
/// <summary>
/// bulamazsa "-1" değeri döndürür
/// </summary>
/// <param name="TamSorgu"></param>
/// <returns></returns>
public static string TekDegerDondur(string TamSorgu)
{
string Donen;
SqlCommand SqlCom = new SqlCommand(ConfigurationSettings.AppSettings["SqlTarihFormat"].ToString() + " " + TamSorgu, Baglanti());
try
{
SqlCom.Connection.Open();
Donen = SqlCom.ExecuteScalar().ToString().TrimEnd();
}
catch (Exception e)
{
Donen = "-1";
// DigerIslemler.HataYaz("AKBclass-TekDegerDondur-3", e.Message, "");
}
if (SqlCom.Connection.State == ConnectionState.Open)
{
SqlCom.Connection.Close();
}
if (string.IsNullOrEmpty(Donen))
{
Donen = "-1";
}
System.GC.SuppressFinalize(SqlCom);
return(Donen.TrimEnd());
}
/// <summary>
/// "-1" dönerse Yoktur! Parametreleri eklemeyi unutma!
/// </summary>
/// <param name="TabloAdi"></param>
/// <param name="Sart"></param>
/// <param name="pCollection"></param>
/// <returns></returns>
public static string Varmi(string TabloAdi, string Sart, SqlParameter[] pCollection)
{
string Donen;
SqlCommand SqlCom = new SqlCommand(ConfigurationSettings.AppSettings["SqlTarihFormat"].ToString() + " select Count(ID) as AKB from " + TabloAdi + " " + Sart, Baglanti());
SqlCom.Parameters.AddRange(pCollection);
try
{
SqlCom.Connection.Open();
Donen = SqlCom.ExecuteScalar().ToString();
}
catch (Exception e)
{
Donen = "-1";
GlobalHata = e;
}
if (SqlCom.Connection.State == ConnectionState.Open)
{
SqlCom.Connection.Close();
}
if (string.IsNullOrEmpty(Donen) || Donen == "0")
{
Donen = "-1";
}
SqlCom.Parameters.Clear();
System.GC.SuppressFinalize(SqlCom);
return(Donen.TrimEnd());
}
/// <summary>
/// bulamazsa "-1" değeri döndürür
/// </summary>
/// <param name="TabloAdi"></param>
/// <param name="Sart"></param>
/// <param name="DonecekFieldAdi"></param>
/// <returns></returns>
public static string TekDegerDondur(string TabloAdi, string Sart, string DonecekFieldAdi)
{
string Donen;
SqlCommand SqlCom = new SqlCommand(ConfigurationSettings.AppSettings["SqlTarihFormat"].ToString() + " select " + DonecekFieldAdi + " from " + TabloAdi + " " + Sart, Baglanti());
try
{
SqlCom.Connection.Open();
Donen = SqlCom.ExecuteScalar().ToString().TrimEnd();
}
catch (Exception e)
{
Donen = "-1";
GlobalHata = e;
}
if (SqlCom.Connection.State == ConnectionState.Open)
{
SqlCom.Connection.Close();
}
if (string.IsNullOrEmpty(Donen))
{
Donen = "-1";
}
System.GC.SuppressFinalize(SqlCom);
return(Donen.TrimEnd());
}
/// <summary>
/// bulamazsa "-1" değeri döndürür
/// bu TekDegerDondur INSERT işleminde eklenen kayıdın IDsini @@IDENTITY
/// </summary>
/// <param name="TamSorgu"></param>
/// <returns></returns>
public static string TekDegerDondur(string TamSorgu, SqlParameter[] pCollection)
{
string Donen;
SqlCommand SqlCom = new SqlCommand(ConfigurationSettings.AppSettings["SqlTarihFormat"].ToString() + " " + TamSorgu, Baglanti());
SqlCom.Parameters.AddRange(pCollection);
try
{
SqlCom.Connection.Open();
Donen = SqlCom.ExecuteScalar().ToString().TrimEnd();
}
catch (Exception e)
{
Donen = "-1";
GlobalHata = e;
}
if (SqlCom.Connection.State == ConnectionState.Open)
{
SqlCom.Connection.Close();
}
if (string.IsNullOrEmpty(Donen))
{
Donen = "-1";
}
SqlCom.Parameters.Clear();
System.GC.SuppressFinalize(SqlCom);
return(Donen.TrimEnd());
}
