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