using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data.SqlClient;
using System.Data;
using System.Web.Configuration;
namespace FTTQTY.App_Codes
{
public class SQLData
{
#region Data Access Layer
public static SqlConnection SQLConnection()
{
SqlConnection conn = new SqlConnection(WebConfigurationManager.ConnectionStrings["sqlconn"].ConnectionString);
conn.Open();
return conn;
}
static private DataTable GetData(SqlCommand cmd)
{
try
{
if (cmd.Connection != null)
{
using (DataSet ds = new DataSet())
{
using (SqlDataAdapter da = new SqlDataAdapter())
{
da.SelectCommand = cmd;
da.Fill(ds);
return ds.Tables[0];
}
}
}
else
{
using (SqlConnection conn = SQLConnection())
{
try
{
using (DataSet ds = new DataSet())
{
using (SqlDataAdapter da = new SqlDataAdapter())
{
da.SelectCommand = cmd;
da.SelectCommand.Connection = conn;
da.Fill(ds);
conn.Close();
conn.Dispose();
return ds.Tables[0];
}
}
}
finally
{
}
}
}
}
finally
{
}
}
static public DataTable GetData(string sql)
{
try
{
using (SqlConnection conn = SQLConnection())
{
try
{
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandType = CommandType.Text;
cmd.CommandText = sql;
cmd.CommandTimeout = 99999999;
using (DataSet ds = new DataSet())
{
using (SqlDataAdapter da = new SqlDataAdapter())
{
da.SelectCommand = cmd;
da.SelectCommand.Connection = conn;
da.Fill(ds);
conn.Close();
conn.Dispose();
return ds.Tables[0];
}
}
}
}
finally
{
}
}
}
finally
{
}
}
static public void ExecuteNonQuery(SqlCommand cmd)
{
try
{
using (SqlConnection conn = SQLConnection())
{
cmd.Connection = conn;
cmd.CommandTimeout = 99999999;
cmd.ExecuteNonQuery();
conn.Close();
conn.Dispose();
}
}
finally
{
}
}
static public object ExecuteScalar(SqlCommand cmd)
{
try
{
using (SqlConnection conn = SQLConnection())
{
cmd.Connection = conn;
cmd.CommandTimeout = 999999;
object res = cmd.ExecuteScalar();
conn.Close();
conn.Dispose();
return res;
}
}
finally
{
}
}
}
}