/// Return a list for admin UI list.
/// </summary>
/// <param name="total"></param>
/// <param name="current"></param>
/// <param name="rowCount"></param>
/// <param name="where"></param>
/// <param name="order"></param>
/// <returns></returns>
public static List <CroResource> TolerantSearch(out int total, int current, int rowCount, APSqlWherePhrase where, APSqlOrderPhrase order)
{
var t = APDBDef.CroResource;
var u = APDBDef.ResUser;
var query = APQuery
.select(t.CrosourceId, t.Title, t.CreatedTime, t.StatePKID, t.ThemeId,
t.ProvinceId, t.AreaId, t.WinLevelPKID, t.Score, t.DeliveryStatus,
t.Author)
.from(t, u.JoinInner(t.Creator == u.UserId))
.where (where);
//.order_by(t.CrosourceId.Desc)
if (order != null)
{
query.order_by_add(order);
}
else
{
query.order_by_add(t.CrosourceId.Desc);
}
query.primary(t.CrosourceId)
.skip((current - 1) * rowCount)
.take(rowCount);
using (APDBDef db = new APDBDef())
{
total = db.ExecuteSizeOfSelect(query);
return(db.Query(query, t.TolerantMap).ToList());
}
}
/// <summary>
/// Return a list for admin UI list.
/// </summary>
/// <param name="total"></param>
/// <param name="current"></param>
/// <param name="rowCount"></param>
/// <param name="where"></param>
/// <param name="order"></param>
/// <returns></returns>
public static List <CroResource> TolerantSearch(out int total, int current, int rowCount, APSqlWherePhrase where, APSqlOrderPhrase order)
{
var t = APDBDef.CroResource;
var u = APDBDef.ResUser;
var query = APQuery
.select(t.CrosourceId, t.Title, u.RealName.As("Author") //TODO:t.MediumTypePKID
, t.CreatedTime, t.StatePKID)
.from(t, u.JoinInner(t.Creator == u.UserId))
.where (where)
.primary(t.CrosourceId)
.skip((current - 1) * rowCount)
.take(rowCount);
if (order != null)
{
query.order_by(order);
}
using (APDBDef db = new APDBDef())
{
total = db.ExecuteSizeOfSelect(query);
return(db.Query(query, t.TolerantMap).ToList());
}
}
/// <summary>
/// Return a list for admin UI list.
/// </summary>
/// <param name="total"></param>
/// <param name="current"></param>
/// <param name="rowCount"></param>
/// <param name="where"></param>
/// <param name="order"></param>
/// <returns></returns>
public static List <ResUser> TolerantSearch(out int total, int current, int rowCount, APSqlWherePhrase where, APSqlOrderPhrase order)
{
var t = APDBDef.ResUser;
var c = APDBDef.ResCompany;
//var r = APDBDef.ResRole;
//var ur = APDBDef.ResUserRole;
var query = APQuery
.select(t.UserId, t.UserName, t.RealName, t.GenderPKID, t.Email, t.RegisterTime, t.LoginCount, t.Actived, t.UserTypePKID,
t.CompanyId, t.ProvinceId, t.AreaId,
c.CompanyName //,r.RoleName
)
.from(t,
c.JoinLeft(t.CompanyId == c.CompanyId)
)
.where (where)
.primary(t.UserId)
.skip((current - 1) * rowCount)
.take(rowCount);
if (order != null)
{
query.order_by(order);
}
using (APDBDef db = new APDBDef())
{
total = db.ExecuteSizeOfSelect(query);
return(db.Query(query, reader =>
{
return new ResUser()
{
UserId = t.UserId.GetValue(reader),
UserTypePKID = t.UserTypePKID.GetValue(reader),
UserName = t.UserName.GetValue(reader),
RealName = t.RealName.GetValue(reader),
GenderPKID = t.GenderPKID.GetValue(reader),
Email = t.Email.GetValue(reader),
RegisterTime = t.RegisterTime.GetValue(reader),
LoginCount = t.LoginCount.GetValue(reader),
Actived = t.Actived.GetValue(reader),
CompanyName = c.CompanyName.GetValue(reader),
ProvinceId = t.ProvinceId.GetValue(reader),
AreaId = t.AreaId.GetValue(reader)
};
}).ToList());
}
}
