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