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));
}
