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