/// <summary> /// 根据大类获取小类 /// </summary> /// <param name="lg_Id"></param> /// <returns></returns> public static List <SmClass> GetSm(int lg_Id) { using (WorkOfUnit work = new WorkOfUnit()) { var query = work.CreateRepository <SmClass>().GetList(m => m.Lg.Id == lg_Id && m.Lock == 0).ToList(); return(query); } }
public static List <UserInfo> GetUserId(Expression <Func <UserInfo, bool> > where) { using (WorkOfUnit work = new WorkOfUnit()) { var model = work.CreateRepository <UserInfo>().GetList(where).ToList(); return(model); } }
/// <summary> /// 获取所有大类 /// </summary> /// <returns></returns> public static List <LgClass> GetAllLg() { using (WorkOfUnit work = new WorkOfUnit()) { var query = work.CreateRepository <LgClass>().GetList(m => m.Lock == 0).ToList(); return(query); } }
/// <summary> /// 根据表达式树获取资讯数量 /// </summary> /// <returns></returns> public static int GetCountByWhere(Expression <Func <Information, bool> > where) { using (WorkOfUnit work = new WorkOfUnit()) { var query = work.CreateRepository <Information>().GetList(where).ToList(); return(query.Count); } }
/// <summary> /// 判断用户是否存在 /// </summary> /// <param name="where"></param> /// <returns></returns> public static int GetNameAndPwdByWhere(Expression <Func <UserInfo, bool> > where) { using (WorkOfUnit work = new WorkOfUnit()) { //判断用户是否存在 var model = work.CreateRepository <UserInfo>().GetList(where).ToList(); return(model.Count); } }
public ActionResult GetLogin(string username, string password, string vercode, string remember) { Expression <Func <UserInfo, bool> > where = null; string userPwd = MD5Encrypt(password.Trim()); password = userPwd = "123456"; using (WorkOfUnit work = new WorkOfUnit()) { //判断验证码是否正确 if (vercode.ToLower() == Session["code"].ToString().ToLower()) { where = m => m.LoginName == username && m.LoginPwd == password; int a = UserManage.GetNameAndPwdByWhere(where); if (a > 0) { int id = 0; List <UserInfo> list = UserManage.GetUserId(where); for (int i = 0; i < list.Count; i++) { id = list[i].Id; } if (remember == "on") { HttpCookie cookie = new HttpCookie("UserName", username); HttpCookie cookiepwd = new HttpCookie("Password", password); cookie.Expires = System.DateTime.Now.AddSeconds(-1); //Expires过期时间 cookiepwd.Expires = System.DateTime.Now.AddSeconds(-1); //Expires过期时间 //如果存在cookie if (Request.Cookies.AllKeys.Contains(username) && Request.Cookies.AllKeys.Contains(password)) { cookie.Values.Add("UserName", username); cookiepwd.Values.Add("Password", password); cookie.Expires = System.DateTime.Now.AddDays(7.0); cookiepwd.Expires = System.DateTime.Now.AddDays(7.0); Request.Cookies.Add(cookie); Request.Cookies.Add(cookiepwd); var cookietest = Request.Cookies["UserName"]; var cookietestp = Request.Cookies["Password"]; } return(Json(new { success = 1, id = id }, JsonRequestBehavior.AllowGet)); } else { return(Json(new { success = 1, id = id }, JsonRequestBehavior.AllowGet)); } } else { return(Json(new { success = 3 }, JsonRequestBehavior.AllowGet)); } } else { return(Json(new { success = 4 }, JsonRequestBehavior.AllowGet)); } } }
public static List <Information> GetMationPageByWhere( Expression <Func <Information, bool> > where, string order, int pageIndex, int pageSize) { using (WorkOfUnit work = new WorkOfUnit()) { var query = work.CreateRepository <Information>().GetPageList( where, order: order, pageIndex: pageIndex, pageSize: pageSize).ToList(); return(query); } }
/// <summary> /// 根据id删除资讯实体 /// </summary> /// <param name="id"></param> public static ReturnInfo DeleteConsultById(int id) { ReturnInfo rif = new ReturnInfo(); StringBuilder sb = new StringBuilder(); using (WorkOfUnit work = new WorkOfUnit()) { try { //假如存在外键约束则先删除关联数据 var img = work.CreateRepository <RmationImg>().GetList(m => m.Information.Id == id); if (img.Count() != 0) { foreach (var item in img) { try { work.CreateRepository <RmationImg>().Delete(item.Id); rif.IsSuccess = work.Save() >= 1; } catch (Exception ex) { item.Lock = 1; work.CreateRepository <RmationImg>().Update(item); rif.IsSuccess = work.Save() >= 1; sb.Append("删除失败" + item.Id + ":" + ex.Message); continue; } } } work.CreateRepository <Information>().Delete(id); rif.IsSuccess = work.Save() >= 1; } catch (Exception ex) { rif.IsSuccess = false; sb.Append(ex.Message); } } rif.ErrorInfo = sb.ToString(); return(rif); }
/// <summary> /// 删除资讯分类 /// </summary> /// <param name="p_id"></param> /// <param name="f_id"></param> /// <returns></returns> public static ReturnInfo DeleteClassById(int p_id, int f_id)//需考虑情况:可能操作者选择了大类,现在情况操作者选择了小类 { ReturnInfo rif = new ReturnInfo(); StringBuilder sb = new StringBuilder(); List <int> arrId = new List <int>(); using (WorkOfUnit work = new WorkOfUnit()) { try { //判断是否是父级 如果不是父级 if (f_id != 0) { //假如存在外键约束则先删除关联数据 var smQuery = work.CreateRepository <SmClass>().GetList(m => m.Id == p_id); if (smQuery.Count() != 0) { foreach (var item in smQuery.ToList()) { #region 获取资讯 //var mQuery = work.CreateRepository<Information>().GetList(m => m.Sm.Id == item.Id); if (item.Information.Count() != 0) { foreach (var mation in item.Information.ToList()) { arrId.Add(mation.Id); } } #endregion } if (arrId.Count() != 0) { foreach (var item in arrId) { //删除资讯 var query = DeleteConsultById(item); rif.IsSuccess = query.IsSuccess; sb.Append(query.ErrorInfo); } } foreach (var sm in smQuery.ToList()) { try { //删除资讯小类 work.CreateRepository <SmClass>().Delete(sm); rif.IsSuccess = work.Save() >= 1; } catch (Exception ex) { sm.Lock = 1; work.CreateRepository <SmClass>().Update(sm); work.Save(); sb.Append("删除失败" + sm.Id + ":" + ex.Message); continue; } } } } //如果是父级 if (f_id == 0) { var lgQuery = work.CreateRepository <LgClass>().GetEntityById(p_id); //假如存在外键约束则先删除关联数据 var smQuery = work.CreateRepository <SmClass>().GetList(m => m.Lg.Id == lgQuery.Id); if (smQuery.Count() != 0) { foreach (var item in smQuery.ToList()) { #region 获取资讯 //var mQuery = work.CreateRepository<Information>().GetList(m => m.Sm.Id == item.Id); if (item.Information.Count() != 0) { foreach (var mation in item.Information.ToList()) { arrId.Add(mation.Id); } } #endregion } if (arrId.Count() != 0) { foreach (var item in arrId) { //删除资讯 var query = DeleteConsultById(item); rif.IsSuccess = query.IsSuccess; sb.Append(query.ErrorInfo); } } foreach (var sm in smQuery.ToList()) { try { //删除资讯小类 work.CreateRepository <SmClass>().Delete(sm); rif.IsSuccess = work.Save() >= 1; } catch (Exception ex) { sm.Lock = 1; work.CreateRepository <SmClass>().Update(sm); work.Save(); sb.Append("删除失败" + sm.Id + ":" + ex.Message); continue; } } } try { //删除资讯大类 work.CreateRepository <LgClass>().Delete(lgQuery); rif.IsSuccess = work.Save() >= 1; } catch (Exception ex) { rif.IsSuccess = false; sb.Append(ex.Message); } } } catch (Exception ex) { rif.IsSuccess = false; sb.Append(ex.Message); } rif.ErrorInfo = sb.ToString(); } return(rif); }