/// <summary>
/// SQL参数化查询
/// </summary>
/// <param name="sql"></param>
/// <param name="parameters">参数名称</param>
/// <param name="parametersValues">参数值</param>
/// <returns></returns>
public static DataTable GetDataTableByParas(string sql, List <string> parameters, List <object> parametersValues)
{
using (DataConnection c = new DataConnection())
{
ProcedureDAL dal = new ProcedureDAL(c.Connection, c.Transaction);
return(dal.GetDataUsingParams(sql, parameters, parametersValues));
}
}
/// <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));
}
