//查询指定多条件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 }));
        }
Example #2
0
 public int InsertTable(string FiledsName, object arrayList)
 {
     return(DapperHelper.CreateInstance(BaseApplication.DefaultSqlConnectionKey).InsertBatch("PrimaryKeyTest", FiledsName, arrayList));
 }
Example #3
0
 //增删改操作(批量)
 public int Execute(string sql, object obj)
 {
     return(DapperHelper <T> .Execute(sql, obj));
 }
Example #4
0
 public IEnumerable <T> GetEntities(string sql, object obj)
 {
     return(DapperHelper <T> .GetEntities(sql, obj));
 }
Example #5
0
 public T GetEntity(string sql, object obj)
 {
     return(DapperHelper <T> .GetEntity(sql, obj));
 }
Example #6
0
 public int Execute(string sql, T t)
 {
     return(DapperHelper <T> .Execute(sql, t));
 }
Example #7
0
 public List <Users> SimpleQuery(string sql, object whereObj)
 {
     return(DapperHelper.CreateInstance(BaseApplication.DefaultSqlConnectionKey).SimpleQuery <Users>(sql, whereObj));
 }