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