public static object ExecScalar(string scrpt, Query.QueryArgs ConArgs)
{
using (Query sql = new Query(ConArgs))
{
return(sql.ExecScalar(scrpt));
}
}
public static System.Data.DataSet ExecQuery(string scrpt, Query.QueryArgs ConArgs)
{
using (Query sql = new Query(ConArgs))
{
return(sql.ExecQuery(scrpt));
}
}
public static void ExecNonQuery(string scrpt, Query.QueryArgs ConArgs)
{
using (Query sql = new Query(ConArgs))
{
sql.ExecNonQuery(scrpt);
}
}
public QueryEx(Query.QueryArgs QryArgs)
{
try{
qrrgs = QryArgs;
conn = new SqlConnection(qrrgs.GetConnectionString());
this.command = new SqlCommand();
this.command.Connection = conn;
this.command.Transaction = tran;
this.command.CommandType = CommandType.Text;
this.command.CommandTimeout = 0;
}catch (Exception ex) {
throw ex;
}
}
public static bool Connect(Query.QueryArgs ConArgs)
{
try
{
bool b = false;
using (Query sql = new Query(ConArgs))
{
b = true;
}
return(b);
}
catch (Exception ex)
{
throw ex;
}
}
public static List <QueryParameters> GetProcedureParameters(string ProcName, Query.QueryArgs Connection)
{
List <QueryParameters> param = new List <QueryParameters>();
using (Query qry = new Query(Connection))
{
DataTable dt = qry.ExecQuery(string.Format("select ORDINAL_POSITION, PARAMETER_NAME, DATA_TYPE from information_schema.parameters where specific_name= {0}", SQLFormat(ProcName))).Tables[0];
foreach (DataRow dr in dt.Rows)
{
param.Add(new QueryParameters()
{
ORDINAL_POSITION = Convert.ToInt32(dr["ORDINAL_POSITION"]),
PARAMETER_NAME = dr["PARAMETER_NAME"].ToString(),
DATA_TYPE = dr["DATA_TYPE"].ToString()
}
);
}
}
return(param);
}
public static System.Data.DataSet ExecQuery(string scrpt, string[] Param, object[] Value, Query.QueryArgs ConArgs)
{
using (Query sql = new Query(ConArgs))
{
return(sql.ExecQuery(scrpt, Param, Value));
}
}
public static object ExecScalar(string scrpt, string[] Param, object[] Value, Query.QueryArgs ConArgs)
{
using (Query sql = new Query(ConArgs))
{
return(sql.ExecScalar(scrpt, Param, Value));
}
}
public static void ExecNonQuery(string scrpt, string[] Param, object[] Value, Query.QueryArgs ConArgs)
{
using (Query sql = new Query(ConArgs))
{
sql.ExecNonQuery(scrpt, Param, Value);
}
}
public static DataTable TableQuery(this string query, string[] parameters, object[] values, Query.QueryArgs args)
{
using (Query qry = new Query(args)) return(qry.TableQuery(query, parameters, values));
}
