//查询指定多条件Note
public IEnumerable <Note> GetNote_Check(string[] arr)
{
string sql = "select * from t_notes where Name in @Name";
return(DapperHelper <Note> .GetEntities(sql, new { Name = arr }));
}
public int InsertTable(string FiledsName, object arrayList)
{
return(DapperHelper.CreateInstance(BaseApplication.DefaultSqlConnectionKey).InsertBatch("PrimaryKeyTest", FiledsName, arrayList));
}
//增删改操作(批量)
public int Execute(string sql, object obj)
{
return(DapperHelper <T> .Execute(sql, obj));
}
public IEnumerable <T> GetEntities(string sql, object obj)
{
return(DapperHelper <T> .GetEntities(sql, obj));
}
public T GetEntity(string sql, object obj)
{
return(DapperHelper <T> .GetEntity(sql, obj));
}
public int Execute(string sql, T t)
{
return(DapperHelper <T> .Execute(sql, t));
}
public List <Users> SimpleQuery(string sql, object whereObj)
{
return(DapperHelper.CreateInstance(BaseApplication.DefaultSqlConnectionKey).SimpleQuery <Users>(sql, whereObj));
}