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