public string Opt_GetList()
{
Model.QueryOperationRecord query = new Model.QueryOperationRecord();
query.MID = Request.GetData("MID");
query.RoleCode = Request.GetData("RoleCode");
query.LevelCode = Request.GetData("LevelCode");
query.TypeCode = Request.GetData("TypeCode");
var time = Request.GetData("StartTime");
if (!string.IsNullOrEmpty(time))
{
query.StartTime = DateTime.ParseExact(time, "yyyy-MM-dd", null);
}
time = Request.GetData("EndTime");
if (!string.IsNullOrEmpty(time))
{
query.EndTime = DateTime.ParseExact(time, "yyyy-MM-dd", null);
}
var idx = 0;
var list = BLL.OperationRecordBLL.QueryByPage(query, PageIndex, PageSize, out totalCount).Select(item => new
{
ID = ++idx,
MID = item.MID,
Level = Config.SHMoneyList[item.LevelCode]._MAgencyName,
Role = BLL.Roles.RolsList[item.RoleCode].RName,
Time = item.Time.ToString("yyyy-MM-dd HH:mm:ss"),
OperationType = item.Type.Name(),
Operation = item.Operation
});
return(jss.Serialize(new { PageData = list, TotalPage = TotalPage(PageSize) }));
}
/// <summary>
/// 分页查询
/// </summary>
/// <param name="query"></param>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <param name="totalCount"></param>
/// <returns></returns>
public static IEnumerable <Model.OperationRecord> QueryByPage(Model.QueryOperationRecord query, int pageIndex, int pageSize, out int totalCount)
{
return(DAL.OperationRecordDAL.QueryByPage(query, pageIndex, pageSize, out totalCount));
}
private static string GetWhere(Model.QueryOperationRecord query)
{
StringBuilder sql = new StringBuilder();
var flag = false;
if (!string.IsNullOrEmpty(query.MID))
{
sql.AppendFormat("MID = '{0}'", query.MID);
flag = true;
}
if (!string.IsNullOrEmpty(query.RoleCode))
{
if (flag)
{
sql.AppendFormat(" AND ");
}
sql.AppendFormat("RoleCode = '{0}'", query.RoleCode);
flag = true;
}
if (!string.IsNullOrEmpty(query.LevelCode))
{
if (flag)
{
sql.AppendFormat(" AND ");
}
sql.AppendFormat("LevelCode = '{0}'", query.LevelCode);
flag = true;
}
if (!string.IsNullOrEmpty(query.TypeCode))
{
if (flag)
{
sql.AppendFormat(" AND ");
}
sql.AppendFormat("TypeCode = '{0}'", query.TypeCode);
flag = true;
}
if (query.StartTime != null)
{
if (flag)
{
sql.AppendFormat(" AND ");
}
sql.AppendFormat("Time > '{0}'", query.StartTime.Value.ToString("yyyy-MM-dd HH:mm:ss"));
flag = true;
}
if (query.EndTime != null)
{
if (flag)
{
sql.AppendFormat(" AND ");
}
sql.AppendFormat("Time <= '{0}'", query.EndTime.Value.ToString("yyyy-MM-dd HH:mm:ss"));
flag = true;
}
return(sql.ToString());
}
/// <summary>
/// 分页查询
/// </summary>
/// <param name="query"></param>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <param name="totalCount"></param>
/// <returns></returns>
public static IEnumerable <Model.OperationRecord> QueryByPage(Model.QueryOperationRecord query, int pageIndex, int pageSize, out int totalCount)
{
string where = GetWhere(query);
return(CommonBase.GetTable("Member_OperationRecord", "ID", "ID DESC", where, pageIndex, pageSize, out totalCount).AsEnumerable().Select(row => row.ToEntity <Model.OperationRecord>()));
}
