/// <summary>
/// object enum
/// </summary>
/// <param name="dao"></param>
/// <param name="type"></param>
/// <param name="tableviewname"></param>
/// <param name="key"></param>
/// <param name="fields"></param>
/// <param name="collatingSequence"></param>
/// <param name="condition"></param>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <param name="recordCount"></param>
/// <param name="paramDic"></param>
/// <returns></returns>
public static IEnumerable <object> QueryList(this DapperAdo dao, Type type, string tableviewname, string key, string fields, string collatingSequence, string condition, int pageIndex, int pageSize, out int recordCount, object paramDic = null)
{
IDbConnection db = dao.DbConnecttion;
recordCount = 0;
try
{
string sqlcount = dao.SqlBuilder.GetPagingCountSQL(tableviewname, condition);
string sql = dao.SqlBuilder.GetPagingSQL(tableviewname, key, fields, collatingSequence, condition, pageIndex, pageSize);
if (db.State != ConnectionState.Open)
{
db.Open();
}
object obj = db.ExecuteScalar(sqlcount);
if (obj == null)
{
obj = "0";
}
int.TryParse(obj.ToString(), out recordCount);
IEnumerable <object> list = db.Query(type, sql, new DynamicParameters(paramDic), null, true, null, default(CommandType?));
return(list);
}
catch (Exception)
{
throw;
}
finally
{
if (db.State == ConnectionState.Open)
{
db.Close();
}
}
}
public static int Execute(this DapperAdo dao, string sql, object param = null)
{
int rsd = 0;
IDbConnection db = dao.DbConnecttion;
IDbTransaction trans = dao.Trans;
try
{
if (param != null)
{
rsd = db.Execute(sql, new DynamicParameters(param), trans);
}
else
{
rsd = db.Execute(sql, null, trans);
}
}
catch
{
throw;
}
finally { if (db.State == ConnectionState.Open && trans == null)
{
db.Close();
}
}
return(rsd);
}
public static DataTable QueryDataTable(this DapperAdo dao, string tableviewname, string key, string fields, string collatingSequence, string condition, int pageIndex, int pageSize, out int recordcount, object paramDic = null)
{
recordcount = 0;
string sql = dao.SqlBuilder.GetPagingSQL(tableviewname, key, fields, collatingSequence, condition, pageIndex, pageSize);
string sqlcount = dao.SqlBuilder.GetPagingCountSQL(tableviewname, condition);
DataTable dt = new DataTable();
IDbConnection db = dao.DbConnecttion;
try
{
object obj = db.ExecuteScalar(sqlcount);
if (obj == null)
{
obj = "0";
}
int.TryParse(obj.ToString(), out recordcount);
IDataReader reader = null;
reader = db.ExecuteReader(sql, paramDic, null, null, null);
dt = ConvertDataReaderToDataTable(reader);
}
catch { throw; }
finally { if (db.State == ConnectionState.Open)
{
db.Close();
}
}
return(dt);
}
public static IEnumerable <object> QueryList(this DapperAdo dao, Type type, string sql, object paramDic = null, CommandType?commandType = default(CommandType?))
{
IDbConnection db = dao.DbConnecttion;
try
{
if (db.State != ConnectionState.Open)
{
db.Open();
}
IEnumerable <object> list = db.Query(type, sql, new DynamicParameters(paramDic), null, true, null, commandType);
return(list);
}
catch (Exception)
{
throw;
}
finally
{
if (db.State == ConnectionState.Open)
{
db.Close();
}
}
}
public static IEnumerable <T> QueryList <T>(this DapperAdo dao, string sql, object paramDic = null, CommandType?commandType = default(CommandType?))
{
IDbConnection db = dao.DbConnecttion;
try
{
if (db.State != ConnectionState.Open)
{
db.Open();
}
if (paramDic == null)
{
return(db.Query <T>(sql, null, null, true, null, commandType));
}
else
{
return(db.Query <T>(sql, new DynamicParameters(paramDic), null, true, null, commandType));
}
}
catch (Exception)
{
throw;
}
finally
{
if (db.State == ConnectionState.Open)
{
db.Close();
}
}
}
public static T SingleOrDefault <T>(this DapperAdo dao, string sql, object paramDic = null, CommandType?commandType = default(CommandType?))
{
IDbConnection db = dao.DbConnecttion;
try
{
if (db.State != ConnectionState.Open)
{
db.Open();
}
IEnumerable <T> enumt = null;
if (paramDic == null)
{
enumt = db.Query <T>(sql, null, null, true, null, commandType);
}
else
{
enumt = db.Query <T>(sql, new DynamicParameters(paramDic), null, true, null, commandType);
}
var var = enumt.FirstOrDefault();
return(var);
}
catch (Exception)
{
throw;
}
finally
{
if (db.State == ConnectionState.Open)
{
db.Close();
}
}
}
public static void RollbackTrans(this DapperAdo dao)
{
dao.Trans.Rollback();
if (dao.DbConnecttion.State == ConnectionState.Open)
{
dao.DbConnecttion.Close();
}
}
public static void CommitTrans(this DapperAdo dao)
{
dao.Trans.Commit();
if (dao.DbConnecttion.State == ConnectionState.Open)
{
dao.DbConnecttion.Close();
}
}
public static IDbTransaction BeginTrans(this DapperAdo dao)
{
IDbConnection db = dao.DbConnecttion;
if (db.State != ConnectionState.Open)
{
db.Open();
}
dao.Trans = db.BeginTransaction();
return(dao.Trans);
}
public static DataTable QueryDataTable(this DapperAdo dao, string sql, object paramDic = null, CommandType?commandType = default(CommandType?))
{
DataTable dt = new DataTable();
IDbConnection db = dao.DbConnecttion;
try
{
IDataReader reader = null;
reader = db.ExecuteReader(sql, paramDic, null, null, commandType);
dt = ConvertDataReaderToDataTable(reader);
}
catch { throw; }
finally { if (db.State == ConnectionState.Open)
{
db.Close();
}
}
return(dt);
}
public static int Delete <T>(this DapperAdo dao, T t) where T : BaseEntity
{
int rsd = 0;
IDbConnection db = dao.DbConnecttion;
IDbTransaction trans = dao.Trans;
try
{
var p = new DynamicParameters(t);
var sql = dao.SqlBuilder.Delete <T>(t);
rsd = db.Execute(sql, p, trans);
}
catch (Exception)
{
throw;
}
finally { if (db.State == ConnectionState.Open && trans == null)
{
db.Close();
}
}
return(rsd);
}
public static int Update <T>(this DapperAdo dao, T t, CommandType?commandType = default(CommandType?)) where T : BaseEntity
{
int rsd = 0;
IDbConnection db = dao.DbConnecttion;
IDbTransaction trans = dao.Trans;
try
{
var sql = dao.SqlBuilder.Updatet <T>(t);
rsd = db.Execute(sql, new DynamicParameters(t), trans, null, commandType);
}
catch
{
throw;
}
finally { if (db.State == ConnectionState.Open && trans == null)
{
db.Close();
}
}
return(rsd);
}
