/// <summary> /// 查询数据信息 /// </summary> /// <param name="menuno">菜单编号</param> /// <returns></returns> public OperateResultModel Query(string menuno) { List <DBMemberEntity> entities = new List <DBMemberEntity>(); entities.AddMember("menuno", menuno); OperateResultModel orm = Query(entities, null, null); orm.rows = ModelHelper.ToModel <List <sysmenu_object> >((DataTable)orm.rows); return(orm); }
/// <summary> /// 查询数据信息 /// </summary> /// <returns></returns> public OperateResultModel Query() { OperateResultModel orm = Query(null, null, null); if (orm.rows != null) { orm.rows = ModelHelper.ToModel <List <tbl_section> >((DataTable)orm.rows); } return(orm); }
public JsonResult InsertObject(sysmenu_object menuobject) { menuobject.pkid = NewGuid; menuobject.creater = SessionUser.UserNo; menuobject.createdate = DateTime.Now; Permission permission = new Permission(); OperateResultModel orm = permission.InsertMenuObject(menuobject); return(JsonResultHelper.ConvertToJsonResult(orm)); }
/// <summary> /// 查询数据信息 /// </summary> /// <returns></returns> public OperateResultModel Query() { List <DBMemberEntity> entities = new List <DBMemberEntity>(); OperateResultModel orm = Query(entities, "chexing", null); if (orm.rows != null) { orm.rows = ModelHelper.ToModel <List <tbl_chexing> >((DataTable)orm.rows); } return(orm); }
public JsonResult Add(tbl_xueyuan model) { model.creater = SessionUser.UserNo; model.createdate = DateTime.Now; model.editer = model.creater; model.editdate = model.createdate; JiaxInfo jiaxinfo = new JiaxInfo(); OperateResultModel orm = jiaxinfo.InsertXueyuan(model); return(JsonResultHelper.ConvertToJsonResult(orm)); }
public JsonResult Add(tbl_areainfo model) { model.creater = SessionUser.UserNo; model.createdate = DateTime.Now; model.editer = model.creater; model.editdate = model.createdate; CommonBll commbll = new CommonBll(); OperateResultModel orm = commbll.InsertAreaInfo(model); 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 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)); }
/// <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 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)); }
public JsonResult Index(string xueyh, string xingming, string shenfhm, int page = 1, int rows = 20) { PaginModel pm = new PaginModel() { page = page, pagesize = rows }; JiaxInfo jiaxinfo = new JiaxInfo(); OperateResultModel orm = jiaxinfo.QueryXueyuans(xueyh, xingming, shenfhm, pm); return(JsonResultHelper.ConvertToJsonResult(orm)); }
public JsonResult Test(string serialno, string specialword) { CommonBll bll = new CommonBll(); string result = bll.GetSerialNo(serialno, specialword); OperateResultModel orm = new OperateResultModel() { success = true, message = result }; return(JsonResultHelper.ConvertToJsonResult(orm)); }
public JsonResult InserRoleModule(string info, string roleno, string menuno, string powerno, string rolepowers, string roleobjects) { UserModel um = SessionUser; DateTime dtNow = DateTime.Now; List <sysrole_menu> rolemenus = ModelHelper.ToModel <List <sysrole_menu> >(info); foreach (sysrole_menu rolemenu in rolemenus) { rolemenu.pkid = NewGuid; rolemenu.creater = um.UserNo; rolemenu.createdate = dtNow; rolemenu.roleno = roleno; } List <sysrole_menu_power> rolepowerlist = new List <sysrole_menu_power>(); string[] powers = rolepowers.Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries); foreach (string power in powers) { rolepowerlist.Add(new sysrole_menu_power() { roleno = roleno, menuno = menuno, createdate = dtNow, creater = um.UserNo, pkid = NewGuid, powerno = power }); } List <sysrole_menu_power_object> roleobjectlist = new List <sysrole_menu_power_object>(); string[] objects = roleobjects.Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries); foreach (string obj in objects) { roleobjectlist.Add(new sysrole_menu_power_object() { createdate = dtNow, creater = um.UserNo, forobject = obj, menuno = menuno, pkid = NewGuid, powerno = powerno, roleno = roleno }); } Permission permission = new Permission(); OperateResultModel orm = permission.InsertRolePowers(roleno, menuno, powerno, rolemenus, rolepowerlist, roleobjectlist); return(JsonResultHelper.ConvertToJsonResult(orm)); }
/// <summary> /// 查询数据信息 /// </summary> /// <param name="papername">试卷名称</param> /// <param name="pm">分页实体</param> /// <returns></returns> public OperateResultModel Query(string papername, PaginModel pm) { List <DBMemberEntity> members = new List <DBMemberEntity>(); members.AddMember("papername", papername, QueryTypeEnum.fruzz); OperateResultModel orm = Query(members, "papername", pm); if (orm.rows != null) { orm.rows = ModelHelper.ToModel <List <tbl_paper> >((DataTable)orm.rows); } return(orm); }
/// <summary> /// 查询数据信息 /// </summary> /// <param name="userno">用户编号</param> /// <returns></returns> public OperateResultModel Query(string userno) { List <DBMemberEntity> entitys = new List <DBMemberEntity>(); entitys.AddMember("userno", userno); OperateResultModel orm = Query(entitys, null, null); if (orm.rows != null) { orm.rows = ModelHelper.ToModel <List <sysuser_role> >((DataTable)orm.rows); } return(orm); }
public JsonResult InsertPaperBank(int paperid, string bankids) { string[] bankidarr = bankids.Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries); List <int> banklist = new List <int>(); foreach (string bankid in bankidarr) { banklist.Add(Convert.ToInt32(bankid)); } Bank bank = new Bank(); OperateResultModel orm = bank.InsertPaperBanks(paperid, banklist, SessionUser.UserNo); return(JsonResultHelper.ConvertToJsonResult(orm)); }
public static JsonResult ConvertToJsonResult(this OperateResultModel orm) { JsonResult jr = new JsonResult() { Data = new { success = orm.success, rows = orm.rows, total = orm.total, message = orm.message } }; return(jr); }
/// <summary> /// 查询数据信息 /// </summary> /// <returns></returns> public OperateResultModel Query() { OperateResultModel orm = Query(null, null, null); if (orm.rows != null) { List <sysmenu> menus = ModelHelper.ToModel <List <sysmenu> >((DataTable)orm.rows); var topmenus = menus.Where(p => p.parentno == "0"); foreach (sysmenu menu in topmenus) { BuildMenuTree(menus, menu); } orm.rows = topmenus; } return(orm); }
public PartialViewResult Edit(int?id) { Bank bank = new Bank(); tbl_bank bankmodel = null; if (id != null) { bankmodel = bank.QueryBank(id.Value); } OperateResultModel orm = bank.QuerySections(); List <tbl_section> sections = (List <tbl_section>)orm.rows; SelectList sectionlist = new SelectList(sections, "sid", "sectionname", bankmodel == null ? "" : bankmodel.section); ViewData["sectionlist"] = sectionlist; return(PartialView(bankmodel)); }
/// <summary> /// 查询数据信息 /// </summary> /// <param name="testno">测试编号</param> /// <returns></returns> public OperateResultModel Query(string testno, int?qid) { List <DBMemberEntity> entities = new List <DBMemberEntity>(); entities.AddMember("testno", testno); if (qid != null) { entities.AddMember("qid", qid.Value); } OperateResultModel orm = Query(entities, "seq", null); if (orm.rows != null) { orm.rows = ModelHelper.ToModel <List <tbl_test_records_details> >((DataTable)orm.rows); } return(orm); }
/// <summary> /// 查询数据信息 /// </summary> /// <param name="errortype">错题类型</param> /// <param name="xueyh">学员号</param> /// <returns></returns> public OperateResultModel Query(string errortype, string xueyh) { List <DBMemberEntity> entities = new List <DBMemberEntity>(); entities.AddMember("errortype", errortype); if (!string.IsNullOrEmpty(xueyh)) { entities.AddMember("xueyh", xueyh); } OperateResultModel orm = Query(entities, "qid", null); if (orm.rows != null) { orm.rows = ModelHelper.ToModel <List <tbl_error_bank> >((DataTable)orm.rows); } return(orm); }
public JsonResult Update(tbl_chexing model) { OperateResultModel orm = new OperateResultModel(); orm.message = ValidInput(model); if (string.IsNullOrEmpty(orm.message)) { model.editdate = DateTime.Now; model.editer = SessionUser.UserNo; CommonBll common = new CommonBll(); orm = common.UpdateCheXing(model); orm.rows = model; } else { orm.success = false; } return(JsonResultHelper.ConvertToJsonResult(orm)); }
public JsonResult RolePowers(string roleno, string menuno) { OperateResultModel orm = new OperateResultModel(); try { Permission permission = new Permission(); List <syspower> rolepowers = permission.QueryRolePowers(roleno, menuno); orm.rows = rolepowers; orm.total = rolepowers.Count; orm.success = true; } catch (Exception ex) { orm.success = false; orm.message = ex.Message; } return(JsonResultHelper.ConvertToJsonResult(orm)); }
public JsonResult Update(sysrole role) { OperateResultModel orm = new OperateResultModel(); orm.message = ValidInput(role); if (string.IsNullOrEmpty(orm.message)) { role.editdate = DateTime.Now; role.editer = SessionUser.UserNo; Permission permission = new Permission(); orm = permission.UpdateRole(role); orm.rows = role; } else { orm.success = false; } return(JsonResultHelper.ConvertToJsonResult(orm)); }
public JsonResult Update(tbl_section section) { OperateResultModel orm = new OperateResultModel(); orm.message = ValidInput(section); if (string.IsNullOrEmpty(orm.message)) { section.editdate = DateTime.Now; section.editer = SessionUser.UserNo; Bank bank = new Bank(); orm = bank.UpdateSection(section); orm.rows = section; } else { orm.success = false; } return(JsonResultHelper.ConvertToJsonResult(orm)); }
public JsonResult Update(tbl_paper_rule paperrule) { OperateResultModel orm = new OperateResultModel(); orm.message = ValidInput(paperrule); if (string.IsNullOrEmpty(orm.message)) { paperrule.editdate = DateTime.Now; paperrule.editer = SessionUser.UserNo; Bank bank = new Bank(); orm = bank.UpdatePaperRule(paperrule); orm.rows = paperrule; } else { orm.success = false; } return(JsonResultHelper.ConvertToJsonResult(orm)); }
/// <summary> /// 添加角色对应的菜单的权限 /// </summary> /// <param name="updbhelper">数据库连接对象</param> /// <param name="roleno">角色编号</param> /// <param name="menuno">角单编号</param> /// <param name="powerno">权限编号</param> /// <param name="roleobjects">角色权限信息</param> /// <returns></returns> public bool InsertRoleObjects(DBFactory updbhelper, string roleno, string menuno, string powerno, List <sysrole_menu_power_object> roleobjects) { OperateResultModel orm = new OperateResultModel(); List <DBMemberEntity> entities = new List <DBMemberEntity>(); entities.AddMember("roleno", roleno); entities.AddMember("menuno", menuno); entities.AddMember("powerno", powerno); orm = Query(entities, null, null); DataTable oldroleobjects = orm.rows as DataTable; foreach (sysrole_menu_power_object roleobject in roleobjects) { if (oldroleobjects == null || oldroleobjects.AsEnumerable().Count(p => p.Field <string>("roleno") == roleobject.roleno && p.Field <string>("menuno") == roleobject.menuno && p.Field <string>("powerno") == roleobject.powerno && p.Field <string>("forobject") == roleobject.forobject) == 0) { if (!updbhelper.Insert(updbhelper.Connection(), updbhelper.Transaction(), roleobject)) { throw new Exception("插入角色对应菜单权限【" + roleobject.menuno + "|" + roleobject.powerno + "|" + roleobject.forobject + "】失败"); } } } if (oldroleobjects != null) { foreach (DataRow roleobject in oldroleobjects.Rows) { if (roleobjects.Count(p => p.roleno == roleobject["roleno"].ToString() && p.menuno == roleobject["menuno"].ToString() && p.powerno == roleobject["powerno"].ToString() && p.forobject == roleobject["forobject"].ToString()) == 0) { sysrole_menu_power_object roleobjectmodel = new sysrole_menu_power_object() { pkid = roleobject["pkid"].ToString() }; if (updbhelper.Delete(updbhelper.Connection(), updbhelper.Transaction(), roleobjectmodel) != 1) { throw new Exception("删除角色对应菜单【" + roleobject["menuno"] + "|" + roleobject["powerno"] + "|" + roleobject["forobject"] + "】失败"); } } } } return(true); }
public JsonResult RoleObjects(string roleno, string menuno, string powerno) { OperateResultModel orm = new OperateResultModel(); try { Permission permission = new Permission(); List <sysmenu_object> roleobjects = permission.QueryRoleObjects(roleno, menuno, powerno); var objects = roleobjects.Where(p => p.haspower != 0); orm.rows = objects; orm.total = objects.Count(); orm.success = true; } catch (Exception ex) { orm.success = false; orm.message = ex.Message; } return(JsonResultHelper.ConvertToJsonResult(orm)); }
public JsonResult Folder() { JsonTree jsontree = new JsonTree() { id = "imageinfo", text = "图片信息" }; string imagepath = Server.MapPath("~/Resource/BankImages"); buildJsonTree(imagepath, jsontree, imagepath); OperateResultModel orm = new OperateResultModel() { rows = jsontree.children, success = true, total = 1, message = "" }; return(JsonResultHelper.ConvertToJsonResult(orm)); }
/// <summary> /// 查询数据信息 /// </summary> /// <param name="jiaxname">驾校ID</param> /// <param name="areano">区域代码</param> /// <returns></returns> public OperateResultModel Query(string jiaxname, string areano) { List <DBMemberEntity> entities = new List <DBMemberEntity>(); if (!string.IsNullOrEmpty(jiaxname)) { entities.AddMember("jiaxname", jiaxname, QueryTypeEnum.fruzz); } if (!string.IsNullOrEmpty(areano)) { entities.AddMember("areano", areano); } OperateResultModel orm = Query(entities, "jiaxname", null); if (orm.rows != null) { orm.rows = ModelHelper.ToModel <List <tbl_jiax> >((DataTable)orm.rows); } return(orm); }