RM.DataBase/IDbHelper.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using RM.Common.DotNetCode;
using System.Collections;
using System.Data;
using System.Text;

namespace RM.DataBase
{
    public interface IDbHelper
    {
        object GetObjectValue(StringBuilder sql);

        object GetObjectValue(StringBuilder sql, SqlParam[] param);

        int ExecuteBySql(StringBuilder sql);

        int ExecuteBySql(StringBuilder sql, SqlParam[] param);

        int BatchExecuteBySql(StringBuilder[] sql, object[] param);

        DataTable GetDataTable(string TargetTable);

        DataTable GetDataTable(string TargetTable, string orderField, string orderType);

        DataTable GetDataTableBySQL(StringBuilder sql);

        DataTable GetDataTableBySQL(StringBuilder sql, SqlParam[] param);

        DataTable GetDataTableProc(string procName, Hashtable ht);

        DataTable GetDataTableProcReturn(string procName, Hashtable ht, ref Hashtable rs);

        DataSet GetDataSetBySQL(StringBuilder sql);

        DataSet GetDataSetBySQL(StringBuilder sql, SqlParam[] param);

        IList GetDataListBySQL<T>(StringBuilder sql);

        IList GetDataListBySQL<T>(StringBuilder sql, SqlParam[] param);

        int ExecuteByProc(string procName, Hashtable ht);

        int ExecuteByProcNotTran(string procName, Hashtable ht);

        int ExecuteByProcReturnMsg(string procName, Hashtable ht, ref object rs);

        int ExecuteByProcReturn(string procName, Hashtable intputHt, ref Hashtable outputHt);

        bool Submit_AddOrEdit(string tableName, string pkName, string pkVal, Hashtable ht);

        Hashtable GetHashtableById(string tableName, string pkName, string pkVal);

        int IsExist(string tableName, string pkName, string pkVal);

        int InsertByHashtable(string tableName, Hashtable ht);

        int InsertByHashtableReturnPkVal(string tableName, Hashtable ht);

        int UpdateByHashtable(string tableName, string pkName, string pkVal, Hashtable ht);

        int DeleteData(string tableName, string pkName, string pkVal);