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