/// <summary> /// 更新大量数据 /// </summary> /// <param name="dicDt">数据表字典</param> /// <param name="sErr">错误信息</param> /// <returns>是否成功更新</returns> public static bool AdapterSaveMastData(Dictionary <string, DataTable> dicDt, ref string sErr) => AdapterSaveMastData(DbConn.GetOrcConn(), dicDt, ref sErr);
/// <summary> /// 得到连接适配器 /// </summary> /// <param name="sSql">查询语句</param> /// <returns>Oracle适配器</returns> public static OracleDataAdapter GetAdapter(string sSql) => GetAdapter(DbConn.GetOrcConn(), sSql);
/// <summary> /// 查询得到数据表 /// </summary> /// <param name="sSql">查询语句</param> /// <param name="sErr">错误信息</param> /// <returns>数据表</returns> public static DataTable GetDataTable(string sSql, ref string sErr) => GetDataTable(DbConn.GetOrcConn(), sSql, ref sErr);
/// <summary> /// 执行SQL语句 /// </summary> /// <param name="aPara">Oracle数据库参数</param> /// <param name="sSql">SQL语句</param> /// <param name="sErr">错误信息</param> public static void ExecSql(OracleParameter[] aPara, string sSql, ref string sErr) => ExecSql(DbConn.GetOrcConn(), aPara, sSql, ref sErr);
/// <summary> /// 执行SQL语句 /// </summary> /// <param name="sSql">SQL语句</param> /// <param name="sErr">错误信息</param> /// <returns>查询得到的第一行第一列</returns> public static object ExecSqlScalar(string sSql, ref string sErr) => ExecSqlScalar(DbConn.GetOrcConn(), sSql, ref sErr);
/// <summary> /// 查询得到数据集 /// </summary> /// <param name="sProcName">操作字符串</param> /// <param name="arrPara">Oracle数据库参数</param> /// <param name="sErr">错误信息</param> /// <returns>数据集</returns> public static DataSet ExecProcFillDataSet(string sProcName, OracleParameter[] arrPara, ref string sErr) => ExecProcFillDataSet(DbConn.GetOrcConn(), sProcName, arrPara, ref sErr);
/// <summary> /// 执行SQL语句 /// </summary> /// <param name="sSql">SQL语句</param> /// <param name="sErr">错误信息</param> public static void ExecSql(string sSql, ref string sErr) => ExecSql(DbConn.GetOrcConn(), sSql, ref sErr);
/// <summary> /// 执行操作 /// </summary> /// <param name="sProcName">操作字符串</param> /// <param name="arrPara">Oracle数据库参数</param> /// <param name="sErr">错误信息</param> public static void ExecProcedre(string sProcName, OracleParameter[] arrPara, ref string sErr) => ExecProcedre(DbConn.GetOrcConn(), sProcName, arrPara, ref sErr);
/// <summary> /// 更新数据库 /// </summary> /// <param name="dt">待同步数据表</param> /// <param name="sSql">查询语句</param> /// <param name="sErr">错误信息</param> /// <returns>是否成功更新</returns> public static bool AdapterSaveData(DataTable dt, string sSql, ref string sErr) => AdapterSaveData(DbConn.GetOrcConn(), dt, sSql, ref sErr);
/// <summary> /// 得到连接适配器 /// </summary> /// <param name="sSql">查询语句</param> /// <returns>OleDb适配器</returns> public static OleDbDataAdapter GetAdapter(string sSql) => GetAdapter(DbConn.GetOleConn(), sSql);
/// <summary> /// 执行SQL语句 /// </summary> /// <param name="aPara">OleDb数据库参数</param> /// <param name="sSql">SQL语句</param> /// <param name="sErr">错误信息</param> public static void ExecSql(OleDbParameter[] aPara, string sSql, ref string sErr) => ExecSql(DbConn.GetOleConn(), aPara, sSql, ref sErr);
/// <summary> /// 得到连接适配器 /// </summary> /// <param name="sSql">查询语句</param> /// <returns>SQL适配器</returns> public static SqlDataAdapter GetAdapter(string sSql) => GetAdapter(DbConn.GetSqlConn(), sSql);
/// <summary> /// 查询得到数据表 /// </summary> /// <param name="sProcName">操作字符串</param> /// <param name="arrPara">SQL数据库参数</param> /// <param name="sErr">错误信息</param> /// <returns>数据表</returns> public static DataTable ExecProcFillData(string sProcName, SqlParameter[] arrPara, ref string sErr) => ExecProcFillData(DbConn.GetSqlConn(), sProcName, arrPara, ref sErr);
/// <summary> /// 执行操作 /// </summary> /// <param name="sProcName">操作字符串</param> /// <param name="arrPara">SQL数据库参数</param> /// <param name="sErr">错误信息</param> public static void ExecProcedre(string sProcName, SqlParameter[] arrPara, ref string sErr) => ExecProcedre(DbConn.GetSqlConn(), sProcName, arrPara, ref sErr);