public JsonResult Query(string title, string qtype, string ynpic, string ynanimal, int page = 1, int rows = 20)
{
Bank bank = new Bank();
PaginModel pm = new PaginModel()
{
page = page,
pagesize = rows
};
bool?ispic = null;
if (!string.IsNullOrEmpty(ynpic))
{
ispic = ynpic == "Y";
}
bool?isanimal = null;
if (!string.IsNullOrEmpty(ynanimal))
{
isanimal = ynanimal == "Y";
}
OperateResultModel orm = bank.QueryBanks(title, qtype, ispic, isanimal, true, null, pm);
return(JsonResultHelper.ConvertToJsonResult(orm));
}
public JsonResult Query(string papername, int page = 1, int rows = 20)
{
Bank bank = new Bank();
PaginModel pm = new PaginModel()
{
page = page,
pagesize = rows
};
OperateResultModel orm = bank.QueryPapers(papername, pm);
return(JsonResultHelper.ConvertToJsonResult(orm));
}
public JsonResult Index(string xueyh, string xingming, int page = 1, int rows = 20)
{
PaginModel pm = new PaginModel()
{
page = page,
pagesize = rows
};
Study study = new Study();
OperateResultModel orm = study.QueryTestRecords(xueyh, xingming, pm);
return(JsonResultHelper.ConvertToJsonResult(orm));
}
/// <summary>
/// 学习记录
/// </summary>
/// <param name="xueyh">学员号</param>
/// <returns></returns>
public JsonResult score(string xueyh, int page = 1)
{
PaginModel pm = new PaginModel()
{
page = page,
pagesize = 15
};
Study study = new Study();
OperateResultModel orm = study.QueryTestRecords(xueyh, "", pm);
return(JsonResultHelper.ConvertToJsonResult(orm));
}
public JsonResult Index(string username, string userno, int page = 1, int pagesize = 30)
{
Permission permission = new Permission();
PaginModel pm = new PaginModel()
{
page = page,
pagesize = pagesize
};
OperateResultModel orm = permission.QueryUsers(userno, username, pm);
return(JsonResultHelper.ConvertToJsonResult(orm));
}
public async Task <IActionResult> GetUsers([FromBody] PaginModel pagin)
{
//var usersdata = _context.Users.OrderBy(m => m.UserName).Skip(pagin.results * (pagin.page - 1))
// .Select(user => new
// {
// name = user.UserName,
// email = user.Email,
// details = user.Details,
// country = user.Country,
// city = user.City,
// address = user.Address,
// startstudy = (user.StartStudy == null) ? null : user.StartStudy.Value.ToShortDateString()
// });
var qry = _context.Users.OrderBy(m => m.UserName)
.Select(user => new
{
name = user.UserName,
email = user.Email,
details = user.Details,
country = user.Country,
city = user.City,
address = user.Address,
startstudy = (user.StartStudy == null) ? null : user.StartStudy.Value.ToShortDateString()
});
if (!string.IsNullOrWhiteSpace(pagin.filter))
{
qry = qry.Where(p => p.name.Contains(pagin.filter));
}
int count = qry.Count();
var model = await PagingList.CreateAsync(
qry, pagin.results, pagin.page, pagin.field, "name");
if (pagin.order == "descend")
{
model.Reverse();
}
// model.RouteValue = new RouteValueDictionary {
//{ "filter", pagin.filter}
// };
return(Ok(new
{
all = count,
users = model
}));
}
/// <summary>
/// 查询数据信息
/// </summary>
/// <param name="xueyh">学员号</param>
/// <param name="xingming">姓名</param>
/// <returns></returns>
public OperateResultModel Query(string xueyh, string xingming, PaginModel pm)
{
List <DBMemberEntity> entities = new List <DBMemberEntity>();
if (!string.IsNullOrEmpty(xueyh))
{
entities.AddMember("xueyh", xueyh, QueryTypeEnum.fruzz);
}
if (!string.IsNullOrEmpty(xingming))
{
entities.AddMember("xingming", xingming, QueryTypeEnum.fruzz);
}
OperateResultModel orm = Query(entities, "createdate desc", pm);
if (orm.rows != null)
{
orm.rows = ModelHelper.ToModel <List <tbl_test_records> >((DataTable)orm.rows);
}
return(orm);
}
/// <summary>
/// 查询数据信息
/// </summary>
/// <param name="userno">用户编号</param>
/// <param name="username">用户姓名</param>
/// <param name="pm">分页信息</param>
/// <returns></returns>
public OperateResultModel Query(string userno, string username, PaginModel pm)
{
List <DBMemberEntity> entitys = new List <DBMemberEntity>();
if (!string.IsNullOrEmpty(userno))
{
entitys.AddMember("userno", userno, QueryTypeEnum.fruzz);
}
if (!string.IsNullOrEmpty(username))
{
entitys.AddMember("username", username, QueryTypeEnum.fruzz);
}
OperateResultModel orm = Query(entitys, "userno", pm);
if (orm.rows != null)
{
orm.rows = ModelHelper.ToModel <List <sysuser> >((DataTable)orm.rows);
}
return(orm);
}
/// <summary>
/// 获取分页List
/// </summary>
/// <param name="model">分页Model</param>
/// <param name="totalCount">记返回总记录数</param>
/// <param name="totalPageCount">返回总页数</param>
/// <returns>数据集</returns>
public DataSet GetPaginList(PaginModel model, out int totalCount, out int totalPageCount)
{
try
{
//Database db = DatabaseFactory.CreateDatabase();
Database db = factory.CreateDefault();
DbCommand dbCommand = db.GetStoredProcCommand("Paging");
db.AddInParameter(dbCommand, "TableName", DbType.AnsiString, model.TableName);
db.AddInParameter(dbCommand, "FieldList", DbType.AnsiString, model.FieldList);
db.AddInParameter(dbCommand, "PrimaryKey", DbType.AnsiString, model.PrimaryKey);
db.AddInParameter(dbCommand, "Where", DbType.AnsiString, model.WhereStr);
db.AddInParameter(dbCommand, "Order", DbType.AnsiString, model.Order);
db.AddInParameter(dbCommand, "SortType", DbType.Int32, model.SortType);
db.AddInParameter(dbCommand, "RecorderCount", DbType.Int32, model.RecorderCount);
db.AddInParameter(dbCommand, "PageSize", DbType.Int32, model.PageSize);
db.AddInParameter(dbCommand, "PageIndex", DbType.Int32, model.PageIndex);
db.AddOutParameter(dbCommand, "TotalCount", DbType.Int32, int.MaxValue);
db.AddOutParameter(dbCommand, "TotalPageCount", DbType.Int32, int.MaxValue);
DataSet ds = db.ExecuteDataSet(dbCommand);
totalCount = (int)db.GetParameterValue(dbCommand, "TotalCount");
totalPageCount = (int)db.GetParameterValue(dbCommand, "TotalPageCount");
return(ds);
}
catch (Exception ex)
{
Shu.Comm.CMMLog.Error(ex.Message);
//HttpContext.Current.Response.Write(ex.Message);
//
//HttpContext.Current.Response.Redirect("~/SessionError.htm");
//throw new Exception(ex.Message);
}
totalCount = 0;
totalPageCount = 0;
return(new DataSet());
}
/// <summary>
/// 查询练习记录
/// </summary>
/// <param name="xueyh">学员号</param>
/// <param name="xingming">姓名</param>
/// <returns></returns>
public OperateResultModel QueryTestRecords(string xueyh, string xingming, PaginModel pm)
{
TblTestRecordsDal dal = new TblTestRecordsDal();
return(dal.Query(xueyh, xingming, pm));
}
/// <summary>
/// 查询数据信息
/// </summary>
/// <param name="jiaolh">教练号</param>
/// <param name="xingming">姓名</param>
/// <param name="shenfhm">身份号码</param>
/// <param name="pm">分页信息</param>
/// <returns></returns>
public OperateResultModel QueryJiaolians(string jiaolh, string xingming, string shenfhm, PaginModel pm)
{
TblJiaolianDal dal = new TblJiaolianDal();
return(dal.Query(jiaolh, xingming, shenfhm, pm));
}
/// <summary>
/// 查询数据信息
/// </summary>
/// <param name="xueyh">学员号</param>
/// <param name="xingming">姓名</param>
/// <param name="shenfhm">身份号码</param>
/// <param name="pm">分页信息</param>
/// <returns></returns>
public OperateResultModel Query(string xueyh, string xingming, string shenfhm, PaginModel pm)
{
List <DBMemberEntity> entities = new List <DBMemberEntity>();
if (!string.IsNullOrEmpty(xueyh))
{
entities.AddMember("xueyh", xueyh);
}
if (!string.IsNullOrEmpty(xingming))
{
entities.AddMember("xingming", xingming);
}
if (!string.IsNullOrEmpty(shenfhm))
{
entities.AddMember("shenfhm", shenfhm);
}
OperateResultModel orm = Query(entities, "xueyh desc", pm);
if (orm.rows != null)
{
orm.rows = ModelHelper.ToModel <List <tbl_xueyuan> >((DataTable)orm.rows);
}
return(orm);
}
/// <summary>
/// 查询数据信息
/// </summary>
/// <param name="title">标题</param>
/// <param name="qtype">题型</param>
/// <param name="ispic">是否图片题</param>
/// <param name="isanimal">是否动画题</param>
/// <param name="isOrder">true:顺序 false:随机</param>
/// <param name="kemu">
/// 科目
/// KM1：科目一
/// KM4：科目四
/// KMA：客车
/// KMB：货车
/// </param>
/// <param name="pm">分页实体</param>
/// <returns></returns>
public OperateResultModel Query(string title, string qtype, bool?ispic, bool?isanimal, bool isOrder, string kemu, PaginModel pm)
{
List <DBMemberEntity> members = new List <DBMemberEntity>();
members.AddMember("title", title, QueryTypeEnum.fruzz);
if (!string.IsNullOrEmpty(qtype))
{
members.AddMember("qtype", qtype);
}
if (ispic != null)
{
members.AddMember("picpath", "", QueryTypeEnum.notequal);
}
if (isanimal != null)
{
members.AddMember("animepath", "", QueryTypeEnum.notequal);
}
if (!string.IsNullOrEmpty(kemu))
{
switch (kemu)
{
case "KM1":
kemu = "C";
break;
case "KM4":
kemu = "D";
break;
case "KMA":
kemu = "A";
break;
case "KMB":
kemu = "B";
break;
default:
break;
}
members.AddMember("belongtype", kemu, QueryTypeEnum.fruzz);
}
string orderby = "id";
if (!isOrder)
{
orderby = " NEWID() ";
}
OperateResultModel orm = Query(members, orderby, pm);
if (orm.rows != null)
{
orm.rows = ModelHelper.ToModel <List <tbl_bank> >((DataTable)orm.rows);
}
return(orm);
}
/// <summary>
/// 获取分页List
/// </summary>
/// <param name="model">分页Model</param>
/// <param name="totalCount">记返回总记录数</param>
/// <param name="totalPageCount">返回总页数</param>
/// <returns>数据集</returns>
public DataSet GetPaginList(PaginModel model, out int totalCount, out int totalPageCount)
{
return(dal.GetPaginList(model, out totalCount, out totalPageCount));
}
/// <summary>
/// 查询用户信息
/// </summary>
/// <param name="username">用户姓名</param>
/// <param name="userno">用户编号</param>
/// <param name="pm">分页信息</param>
/// <returns></returns>
public OperateResultModel QueryUsers(string userno, string username, PaginModel pm)
{
SysUserDal dal = new SysUserDal();
return(dal.Query(userno, username, pm));
}
public OperateResultModel Query(List <DBMemberEntity> entities, string orderby, PaginModel pm)
{
string tablename = typeof(T).Name;
OperateResultModel orm = dbhelper.Query(tablename, entities, orderby, pm);
return(orm);
}
/// <summary>
/// 查询数据信息
/// </summary>
/// <param name="xueyh">学员号</param>
/// <param name="xingming">姓名</param>
/// <param name="shenfhm">身份号码</param>
/// <param name="pm">分页信息</param>
/// <returns></returns>
public OperateResultModel QueryXueyuans(string xueyh, string xingming, string shenfhm, PaginModel pm)
{
TblXueyuanDal dal = new TblXueyuanDal();
return(dal.Query(xueyh, xingming, shenfhm, pm));
}
/// <summary>
/// 查询数据信息
/// </summary>
/// <param name="title">标题</param>
/// <param name="qtype">题型</param>
/// <param name="ispic">是否图片题</param>
/// <param name="isanimal">是否动画题</param>
/// <param name="isorder">true：顺序 false：随机</param>
/// <param name="kemu">科目</param>
/// <param name="pm">分页实体</param>
/// <returns></returns>
public OperateResultModel QueryBanks(string title, string qtype, bool?ispic, bool?isanimal, bool isorder, string kemu, PaginModel pm)
{
TblBankDal dal = new TblBankDal();
return(dal.Query(title, qtype, ispic, isanimal, isorder, kemu, pm));
}
