/// <summary> /// 初始化分页存储过程 /// </summary> private static void InitProc(DataBaseOperate oper) { if (isCheck) { return; } string sql = "select * from sysobjects where [xtype]='p' and [name]='" + ProcName + "'"; bool hasProc = false; IDataReader reader = null; try { reader = oper.Query(sql, null, null); if (reader.Read()) { hasProc = true; } reader.Close(); if (!hasProc) { oper.Execute(GetProcCode(), null, null); } } finally { oper.AutoClose(); } isCheck = true; }
/// <summary> /// 执行Sql命令 /// </summary> /// <param name="sql">sql语句</param> /// <param name="list">参数列表</param> /// <param name="commandType">命令类型</param> /// <param name="tables">缓存关联的表</param> public int ExecuteCommand(string sql, ParamList list, CommandType commandType, Dictionary <string, bool> cachetables) { int ret = -1; ret = _oper.Execute(sql, list, commandType, cachetables); return(ret); }
/// <summary> /// 执行Sql命令 /// </summary> /// <param name="BQL">sql语句</param> public int ExecuteCommand(BQLQuery BQL) { AbsCondition con = BQLKeyWordManager.ToCondition(BQL, _oper.DBInfo, null, true); Dictionary <string, bool> cacheTables = null; cacheTables = con.CacheTables; int ret = -1; con.Oper = _oper; ret = _oper.Execute(con.GetSql(true), con.DbParamList, cacheTables); return(ret); }
/// <summary> /// 执行SQL语句 /// </summary> /// <param name="oper">数据库连接</param> /// <param name="lstSQL">SQL语句</param> /// <returns></returns> public static List <string> ExecuteSQL(DataBaseOperate oper, List <string> lstSQL) { List <string> resaults = new List <string>(); using (BatchAction ba = oper.StarBatchAction()) { foreach (string sql in lstSQL) { try { int row = oper.Execute(sql, new Buffalo.DB.DbCommon.ParamList(), null); resaults.Add("执行完毕;"); } catch (Exception ex) { resaults.Add("执行错误:" + ex.Message); } } } return(resaults); }