public object ExecuteCustomerSql(string Sqlstring, ParameterCollection prameters)
{
using (OracleDAO dao = new OracleDAO(conn))
{
return(dao.ExecuteScalar(Sqlstring, System.Data.CommandType.Text, prameters));
}
}
/// <summary>
/// 执行sql方法
/// </summary>
/// <param name="Sqlstring"></param>
/// <returns></returns>
public object ExecuteCustomerSql(string Sqlstring)
{
OracleDAO dao = new OracleDAO(conn);
object obj = dao.ExecuteScalar(Sqlstring, System.Data.CommandType.Text);
return(obj);
}
public object ExecuteStoredProcedure(string Sqlstring, ParameterCollection prameters)
{
using (OracleDAO dao = new OracleDAO(conn))
{
return(dao.ExecuteScalar("", System.Data.CommandType.StoredProcedure, prameters));
}
}
public object ExecuteStoredProcedure(string Sqlstring, ParameterCollection prameters)
{
OracleDAO dao = new OracleDAO(conn);
//prameters = new ParameterCollection();
//prameters.Add("parme1", null);
return(dao.ExecuteScalar("", System.Data.CommandType.StoredProcedure, prameters));
}
public object ExecuteCustomerSql(string Sqlstring)
{
OracleDAO dao = new OracleDAO(_conn);
object obj = dao.ExecuteScalar(Sqlstring, System.Data.CommandType.Text);
//ParameterCollection prameters = new ParameterCollection();
//object obj1 = dao.GetDataTable(Sqlstring, System.Data.CommandType.Text, prameters);
return(obj);
}
public object ExecuteCustomerSql(string Sqlstring, ParameterCollection prameters)
{
OracleDAO dao = new OracleDAO(conn);
//prameters = new ParameterCollection();
//prameters.Add("parme1", null);
return(dao.ExecuteScalar(Sqlstring, System.Data.CommandType.Text, prameters));
//return object obj=dao.ExecuteScalar(Sqlstring, System.Data.CommandType.Text);
//prameters = new ParameterCollection();
//object obj1 = dao.GetDataTable(Sqlstring, System.Data.CommandType.Text, prameters);
}
public static object ExecuteCustomerSql(string Sqlstring, ParameterCollection prameters)
{
string conn = ConfigurationManager.AppSettings["ConnectionString"].ToString();
OracleDAO dao = new OracleDAO(conn);
//prameters = new ParameterCollection();
//prameters.Add("parme1", null);
dao.ExecuteScalar(Sqlstring, System.Data.CommandType.Text);
prameters = new ParameterCollection();
dao.GetDataTable(Sqlstring, System.Data.CommandType.Text, prameters);
return null;
}
public static object ExecuteCustomerSql(string Sqlstring, ParameterCollection prameters)
{
string conn = ConfigurationManager.AppSettings["ConnectionString"].ToString();
OracleDAO dao = new OracleDAO(conn);
//prameters = new ParameterCollection();
//prameters.Add("parme1", null);
dao.ExecuteScalar(Sqlstring, System.Data.CommandType.Text);
prameters = new ParameterCollection();
dao.GetDataTable(Sqlstring, System.Data.CommandType.Text, prameters);
return(null);
}
public object ExecuteCustomerSql(string Sqlstring)
{
try
{
OracleDAO dao = new OracleDAO(conn);
object obj = dao.ExecuteScalar(Sqlstring, System.Data.CommandType.Text);
//ParameterCollection prameters = new ParameterCollection();
//object obj1 = dao.GetDataTable(Sqlstring, System.Data.CommandType.Text, prameters);
return(obj);
}
catch (Exception ex)
{
Tracer.Debug(ex.ToString());
return(null);
}
}
/// <summary>
/// 执行sql方法
/// </summary>
/// <param name="Sqlstring"></param>
/// <returns></returns>
public object ExecuteCustomerSql(string Sqlstring)
{
OracleDAO dao = new OracleDAO(conn);
object obj = dao.ExecuteScalar(Sqlstring, System.Data.CommandType.Text);
return obj;
}
protected object ExecuteCustomerSql(string Sqlstring, SMT.Foundation.Core.ParameterCollection prameters)
{
Sqlstring.Replace("\n", "");
Sqlstring.Replace("\r", "");
OracleDAO dao = new OracleDAO(conn);
return dao.ExecuteScalar(Sqlstring, System.Data.CommandType.Text, prameters);
}