public int GetCount(Wuyiju.Model.Order.Query query) { using (var db = new DataContext()) { return(this.GetDao(db).GetCount(query)); } }
/// <summary> /// 获得前几行数据 /// </summary> public IList <Wuyiju.Model.Order> GetList(Wuyiju.Model.Order.Query query, int?limit = null) { using (var db = new DataContext()) { return(this.GetDao(db).GetList(query, limit)); } }
public int TodayNewCount() { var today = DateTime.Now; var query = new Wuyiju.Model.Order.Query { StartDate = new DateTime(today.Year, today.Month, today.Day, 0, 0, 0), EndDate = new DateTime(today.Year, today.Month, today.Day, 23, 59, 59) }; using (var db = new DataContext()) { return(this.GetDao(db).GetCount(query)); } }
/// <summary> /// 获得数据列表 /// </summary> public IList <Wuyiju.Model.Order> GetList(Wuyiju.Model.Order.Query filter) { StringBuilder sql = new StringBuilder(@"select * from ec_order where 1 = 1 "); DynamicParameters param = new DynamicParameters(); sql.AndBetween("add_time", "StartTime", "EndTime") .AndEquals("status") .AndEquals("pay_statu", "pay_status") .AndEquals("add_time") .AndEquals("Uid") .AndEquals("del") .AndEquals("product_id"); if (filter != null) { param.AddDynamicParams(filter); } return(db.GetList <Wuyiju.Model.Order>(sql, param)); }
/// <summary> /// 获得前几行数据 /// </summary> public IList <Wuyiju.Model.Order> GetList(Wuyiju.Model.Order.Query filter, int?limit = null) { StringBuilder sql = new StringBuilder(@"select * from ec_order where 1 = 1 "); if (limit != null) { sql.Append(" limit @rows "); } DynamicParameters param = new DynamicParameters(); if (filter != null) { param.AddDynamicParams(filter); } if (limit != null) { param.Add("rows", limit); } return(db.GetList <Wuyiju.Model.Order>(sql, param)); }
public int GetCount(Wuyiju.Model.Order.Query query) { StringBuilder sql = new StringBuilder(@"select count(*) from ec_order where 1=1 "); sql.AndDateBetween("add_time", "startdate", "enddate") .AndEquals("status") .AndEquals("pay_statu", "pay_status") .AndEquals("add_time") .AndEquals("del") .AndEquals("uid") .AndEquals("product_id"); DynamicParameters param = new DynamicParameters(); if (query != null) { param.AddDynamicParams(query); } return(db.ExecuteScalar <int>(sql.ToString(), param)); }