/// <summary>
/// 执行单行单字段查询 参数化
/// </summary>
/// <param name="commandType">SQL命令类型</param>
/// <param name="commandText">SQL语句</param>
public static object ExecuteScalar(string sql, DataConnection con)
{
ProcedureDAL dal = new ProcedureDAL(con.Connection, con.Transaction);
object result = dal.ExecuteScalar(sql);
return(result);
}
//更新
public static bool ExecNoObj(string sql)
{
using (DataConnection c = new DataConnection())
{
ProcedureDAL dal = new ProcedureDAL(c.Connection, c.Transaction);
return(dal.ExecUpdata(sql));
}
}
//更新附件状态
public static bool ExecUpdataObj(string sql, DataConnection c)
{
// using (c)
{
ProcedureDAL dal = new ProcedureDAL(c.Connection, c.Transaction);
return(dal.ExecUpdata(sql));
}
}
/// <summary>
/// 参数化查询 返回DataSet
/// </summary>
/// <returns></returns>
public static DataSet GetDataSetParas(string sql, List <string> parameters, List <object> parametersValues)
{
using (DataConnection c = new DataConnection())
{
ProcedureDAL dal = new ProcedureDAL(c.Connection, c.Transaction);
return(dal.GetDataSetUsingParams(sql, parameters, parametersValues));
}
}
/// <summary>
/// 执行单行单字段查询 参数化
/// </summary>
/// <param name="commandType">SQL命令类型</param>
/// <param name="commandText">SQL语句</param>
public static object ExecuteScalar(string sql)
{
using (DataConnection c = new DataConnection())
{
ProcedureDAL dal = new ProcedureDAL(c.Connection, c.Transaction);
object result = dal.ExecuteScalar(sql);
return(result);
}
}
/// <summary>
/// 执行单行单字段查询
/// </summary>
/// <param name="commandType">SQL命令类型</param>
/// <param name="commandText">SQL语句</param>
public static object ExecuteScalar(string sql, List <string> parameters, List <object> parametersValues)
{
using (DataConnection c = new DataConnection())
{
ProcedureDAL dal = new ProcedureDAL(c.Connection, c.Transaction);
object result = dal.ExecuteScalar(sql, parameters, parametersValues);
return(result);
}
}
/// <summary>
/// 执行存储过程（参数无返回值）
/// </summary>
/// <param name="sql">sql参考：exec pro_Test 1,1(pro_Test 1,1)</param>
/// <returns>存储过程返回的对象</returns>
public static DataSet ExecObjSet(string sql)
{
using (DataConnection c = new DataConnection())
{
ProcedureDAL dal = new ProcedureDAL(c.Connection, c.Transaction);
DataSet result = dal.ExecDataSet(sql);
if (result == null)
{
return(new DataSet());
}
return(result);
}
}
/// <summary>
/// 执行存储过程（参数无返回值）
/// </summary>
/// <param name="sql">sql参考：exec pro_Test 1,1(pro_Test 1,1)</param>
/// <param name="c">数据库连接对象</param>
/// <returns></returns>
public static DataTable ExecObj(string sql, DataConnection c)
{
ProcedureDAL dal = new ProcedureDAL(c.Connection, c.Transaction);
return(dal.Exec(sql));
}
/// <summary>
/// 参数化查询
/// </summary>
/// <returns>DataTable</returns>
public static DataTable GetDataTableParas(string sql, List <string> parameters, List <object> parametersValues, DataConnection con)
{
ProcedureDAL dal = new ProcedureDAL(con.Connection, con.Transaction);
return(dal.GetDataUsingParams(sql, parameters, parametersValues));
}
/// <summary>
/// 构造函数
/// </summary>
/// <returns></returns>
public ProcedureBLL(DataConnection con)
: base(con)
{
_dal = new ProcedureDAL(_conn.Connection, _conn.Transaction);
}
/// <summary>
/// 非查询 参数化方法
/// </summary>
/// <param name="sql">查询条件</param>
/// <param name="parameters">参数</param>
/// <param name="parametersValues">参数值</param>
/// <param name="c">连接对象</param>
/// <returns></returns>
public static bool GetBoolByParas(string sql, List <string> parameters, List <object> parameterValues, DataConnection c)
{
ProcedureDAL dal = new ProcedureDAL(c.Connection, c.Transaction);
return(dal.GetBoolUsingParams(sql, parameters, parameterValues));
}
