/// <summary> /// 删除单条数据 /// </summary> /// <typeparam name="T"></typeparam> /// <param name="dicParam"></param> /// <param name="DbConnectStr"></param> /// <returns></returns> public int DeleteSigerData <T>(Dictionary <string, Object> dicParam, string DbConnectStr = "") { if (DbConnectStr == "") { return(DapperHelper.CreateInstance(BaseApplication.DefaultSqlConnectionKey).DeleteSigerData <T>(dicParam)); } else { return(DapperHelper.CreateInstance(DbConnectStr).DeleteSigerData <T>(dicParam)); } }
/// <summary> /// 批量插入数据 /// </summary> /// <typeparam name="T"></typeparam> /// <param name="dataList"></param> /// <returns></returns> public int InsertBatch <T>(object dataList, string DbConnectStr = "") { if (DbConnectStr == "") { return(DapperHelper.CreateInstance(BaseApplication.DefaultSqlConnectionKey).InsertBatch <T>(typeof(T).Name, (List <T>)dataList)); } else { return(DapperHelper.CreateInstance(DbConnectStr).InsertBatch <T>(typeof(T).Name, (List <T>)dataList)); } }
/// <summary> /// 简单查询 /// </summary> /// <typeparam name="T"></typeparam> /// <param name="sql"></param> /// <param name="DbConnectStr"></param> /// <returns></returns> public List <T> SelectData <T>(string sql, string DbConnectStr = "") { if (DbConnectStr == "") { return(DapperHelper.CreateInstance(BaseApplication.DefaultSqlConnectionKey).SimpleQuery <T>(sql)); } else { return(DapperHelper.CreateInstance(DbConnectStr).SimpleQuery <T>(sql)); } }
/// <summary> /// 分页查询 /// </summary> /// <typeparam name="T"></typeparam> /// <param name="PageSize"></param> /// <param name="PageIndex"></param> /// <param name="OrderBy"></param> /// <param name="TotalCount"></param> /// <param name="sql"></param> /// <param name="whereObj"></param> /// <param name="DbConnectStr"></param> /// <returns></returns> public List <T> SimplePageQuery <T>(int PageSize, int PageIndex, String OrderBy, out int TotalCount, string sql, object whereObj = null, string DbConnectStr = "") { if (DbConnectStr == "") { return(DapperHelper.CreateInstance(BaseApplication.DefaultSqlConnectionKey).SimplePageQuery <T>(PageSize, PageIndex, OrderBy, out TotalCount, sql, whereObj)); } else { return(DapperHelper.CreateInstance(DbConnectStr).SimplePageQuery <T>(PageSize, PageIndex, OrderBy, out TotalCount, sql, whereObj)); } }
/// <summary> /// 跟新数据 /// </summary> /// <typeparam name="T"></typeparam> /// <param name="Param"></param> /// <param name="dataList"></param> /// <param name="DbConnectStr"></param> /// <returns></returns> public int UpdateTable <T>(object data, Dictionary <string, object> Param = null, string DbConnectStr = "") { if (DbConnectStr == "") { return(DapperHelper.CreateInstance(BaseApplication.DefaultSqlConnectionKey).UpdateTable <T>(typeof(T).Name, (T)data, Param)); } else { return(DapperHelper.CreateInstance(DbConnectStr).UpdateTable <T>(typeof(T).Name, (T)data, Param)); } }
public int InsertTable(string FiledsName, object arrayList) { return(DapperHelper.CreateInstance(BaseApplication.DefaultSqlConnectionKey).InsertBatch("PrimaryKeyTest", FiledsName, arrayList)); }
public List <Users> SimpleQuery(string sql, object whereObj) { return(DapperHelper.CreateInstance(BaseApplication.DefaultSqlConnectionKey).SimpleQuery <Users>(sql, whereObj)); }