/// <summary>
/// 获取输出的信息
/// </summary>
/// <param name="sql"></param>
/// <param name="prmList"></param>
/// <returns></returns>
private static string GetMessage(string sql, ParamList prmList, DBInfo db)
{
StringBuilder sbRet = new StringBuilder(512);
sbRet.Append("SQLError:");
sbRet.Append(sql);
sbRet.Append(";");
if (prmList != null)
{
sbRet.Append(prmList.GetParamString(db, db.ExceptionOption.ShowBinary, db.ExceptionOption.HideTextLength));
}
return(sbRet.ToString());
}
/// <summary>
/// 获取缓存中的DataSet
/// </summary>
/// <param name="tables">表</param>
/// <param name="sql">SQL语句</param>
/// <param name="lstParam">变量集合</param>
/// <returns></returns>
public bool SetDataSet(DataSet ds, IDictionary <string, bool> tables,
string sql, ParamList lstParam, DataBaseOperate oper)
{
if (_cache == null)
{
return(false);
}
StringBuilder sbSql = new StringBuilder();
sbSql.Append(sql);
sbSql.Append(";");
sbSql.Append(lstParam.GetParamString(_db, oper));
return(_cache.SetData(tables, sbSql.ToString(), ds, oper));
}
/// <summary>
/// 获取缓存中的DataSet
/// </summary>
/// <param name="tables">表</param>
/// <param name="sql">SQL语句</param>
/// <param name="lstParam">变量集合</param>
/// <returns></returns>
public DataSet GetDataSet(IDictionary <string, bool> tables,
string sql, ParamList lstParam, DataBaseOperate oper)
{
if (_cache == null)
{
return(null);
}
CheckTable(tables);
StringBuilder sbSql = new StringBuilder();
sbSql.Append(sql);
sbSql.Append(";");
sbSql.Append(lstParam.GetParamString(_db, oper));
DataSet ds = _cache.GetData(tables, sbSql.ToString(), oper);
return(ds);
}
