public JsonResult GetCaseEdit(BA_Case result)
{
using (BuyunSiteEntities db = new BuyunSiteEntities())
{
var m = from t in db.BA_Case
where t.Name == result.Name && t.Id != result.Id
select t;
if (m.Count() > 0)
{
return(Json(new { data = "fail", content = "案例名称重复！" }));
}
var BA_Case = from t in db.BA_Case where t.Id == result.Id select t;
var resultInfo = BA_Case.FirstOrDefault();
resultInfo.Name = result.Name;
resultInfo.SubName = result.SubName;
resultInfo.Icon = result.Icon;
resultInfo.Background = result.Background;
resultInfo.Image = result.Image;
resultInfo.ToUrl = result.ToUrl;
resultInfo.Content = result.Content;
resultInfo.Status = result.Status;
resultInfo.AddUser = BasePage.GetCookie("UserNameCookie");
resultInfo.AddTime = DateTime.Now;
db.SaveChanges();
return(Json(new { data = "success", content = "修改案例成功！" }));
}
}
protected override void HandleUnauthorizedRequest(AuthorizationContext context)
{
string User = BasePage.GetCookie("UserInfoCookie");
if (string.IsNullOrEmpty(User))
{
HttpContext.Current.Response.Redirect("/Login/Login");
}
else
{
using (BuyunSiteEntities db = new BuyunSiteEntities())
{
var serializer = new JavaScriptSerializer();
serializer.RegisterConverters(new[] { new DynamicJsonConverter() });
dynamic data = serializer.Deserialize <object>(User);
string UserCode = data.UserCode;
string UserPassword = data.UserPassword;
var UserInfo = db.Cu_User.Where(o => o.UserCode == UserCode && o.UserPassword == UserPassword);
if (UserInfo.Count() <= 0)
{
HttpContext.Current.Response.Redirect("/Login/Login");
}
}
}
}
/// <summary>
/// 获取管理员的所有信息
/// </summary>
/// <returns></returns>
public ActionResult GetAllUserInfo()
{
using (BuyunSiteEntities db = new BuyunSiteEntities())
{
var temp = from a in db.Cu_User
join b in db.Cu_UserAuthority on new { AuthorityId = (Int32)a.AuthorityId } equals new { AuthorityId = b.AuthorityId }
select new
{
a.UserId,
a.UserCode,
a.UserName,
a.UserPhone,
a.UserPassword,
a.IsonLine,
a.Status,
a.AddTime,
a.AddUser,
a.UpdateTime,
a.UpdateUser,
a.UserAuthority,
a.AuthorityId,
a.AgID,
a.IsAdmin,
a.PageSize,
b.UserTypeName
};
var total = temp.Count();
var users = temp.OrderBy(s => s.UserId);
return(Json(new { data = users.ToList(), total = total }));
}
}
/// <summary>
/// 案例查询
/// </summary>
/// <param name="UserInfo"></param>
/// <returns></returns>
public JsonResult GetCaseList()
{
using (BuyunSiteEntities db = new BuyunSiteEntities())
{
int PageSize = Request["length"] == null ? 10 : Convert.ToInt32(Request["length"]); //显示多少数量
int Page = Convert.ToInt32(Request["start"]) == 0 ? 0 : Convert.ToInt32(Request["start"]) / Convert.ToInt32(Request["length"]); //当前页
var search = Request["search"]; //模糊搜索
var draw = Request["draw"]; //datatable固定传值，必需接收再传送，不用赋值
var Code = Request["Code"];
var temp = from a in db.BA_Case select a;
var total = temp.Where(o =>
((o.Name.Contains(Code) || string.IsNullOrEmpty(Code)))
).Count();
var list = temp.OrderByDescending(s => s.Id).Where(o =>
((o.Name.Contains(Code) || string.IsNullOrEmpty(Code)))
).Skip(Page * PageSize).Take(PageSize);
var data = new
{
draw = draw,
recordsTotal = total,
recordsFiltered = total,
data = list.ToList(),
};
return(Json(data));
}
}
/// <summary>
/// 获取菜单信息
/// </summary>
/// <param name="UserInfo"></param>
/// <returns></returns>
public JsonResult MenuList()
{
using (BuyunSiteEntities db = new BuyunSiteEntities())
{
var Menu = db.Cu_Menu;
return(Json(new { data = Menu.ToList() }));
}
}
/// <summary>
/// 获取角色信息
/// </summary>
/// <param name="UserInfo"></param>
/// <returns></returns>
public JsonResult AuthorityList(Cu_User UserInfo)
{
using (BuyunSiteEntities db = new BuyunSiteEntities())
{
var Authority = db.Cu_UserAuthority;
return(Json(new { data = Authority.ToList() }));
}
}
/// <summary>
/// 获取角色信息
/// </summary>
/// <param name="UserInfo"></param>
/// <returns></returns>
public JsonResult RoleById(int AuthorityId)
{
using (BuyunSiteEntities db = new BuyunSiteEntities())
{
var Role = db.Cu_UserAuthority.Where(o => o.AuthorityId == AuthorityId).FirstOrDefault();
return(Json(new { data = Role }));
}
}
/// <summary>
/// 获取网站配置
/// </summary>
/// <returns></returns>
public ActionResult GetAdvertisementInfo()
{
using (BuyunSiteEntities db = new BuyunSiteEntities())
{
var temp = from a in db.BA_Advertisement select a;
var data = temp.OrderBy(s => s.AdvertisementId);
return(Json(new { data = data.FirstOrDefault() }));
}
}
/// <summary>
/// 新增角色信息
/// </summary>
/// <param name="UserInfo"></param>
/// <returns></returns>
public JsonResult AddRole(Cu_UserAuthority Role)
{
using (BuyunSiteEntities db = new BuyunSiteEntities())
{
db.Cu_UserAuthority.Add(Role);
db.SaveChanges();
return(Json(new { data = "success", content = "新增角色成功！" }));
}
}
/// <summary>
/// 禁用启用
/// </summary>
/// <param name="userInfo"></param>
/// <returns></returns>
public JsonResult EditStatus(Cu_User UserInfo)
{
using (BuyunSiteEntities db = new BuyunSiteEntities())
{
Cu_User user = db.Cu_User.First(o => o.UserId == UserInfo.UserId);
user.Status = UserInfo.Status;
db.SaveChanges();
return(Json(new { data = "success" }));
}
}
public JsonResult ContactStatusEdit(int Id)
{
using (BuyunSiteEntities db = new BuyunSiteEntities())
{
var BA_Contact = db.BA_Contact.Where(o => o.Id == Id);
BA_Contact.FirstOrDefault().Status = 1;
db.SaveChanges();
return(Json(new { data = "success", content = "已查看！" }));
}
}
/// <summary>
/// 根据ID查询案例
/// </summary>
/// <param name="Id"></param>
/// <returns></returns>
public JsonResult GetCaseById(int Id)
{
using (BuyunSiteEntities db = new BuyunSiteEntities())
{
var data = from t in db.BA_Case
where t.Id == Id
select t;
return(Json(new { data = data.FirstOrDefault() }));
}
}
/// <summary>
/// 删除管理员
/// </summary>
/// <param name="userInfo"></param>
/// <returns></returns>
public JsonResult DelAdmin(Cu_User UserInfo)
{
using (BuyunSiteEntities db = new BuyunSiteEntities())
{
Cu_User user = db.Cu_User.First(o => o.UserId == UserInfo.UserId);
db.Cu_User.Remove(user);
db.SaveChanges();
return(Json(new { data = "success" }));
}
}
/// <summary>
/// 获取角色信息
/// </summary>
/// <param name="UserInfo"></param>
/// <returns></returns>
public JsonResult AdminByUserIdList(Cu_User UserInfo)
{
int UserId = Convert.ToInt32(Request["UserId"]);
using (BuyunSiteEntities db = new BuyunSiteEntities())
{
var Authority = from a in db.Cu_User where a.UserId == UserId select a;
return(Json(new { data = Authority.ToList() }));
}
}
/// <summary>
/// 编辑角色信息
/// </summary>
/// <param name="UserInfo"></param>
/// <returns></returns>
public JsonResult EditRole(Cu_UserAuthority Role)
{
using (BuyunSiteEntities db = new BuyunSiteEntities())
{
var RoleInfo = from a in db.Cu_UserAuthority where a.AuthorityId == Role.AuthorityId select a;
RoleInfo.FirstOrDefault().Authority = Role.Authority;
RoleInfo.FirstOrDefault().UserTypeName = Role.UserTypeName;
db.SaveChanges();
return(Json(new { data = "success", content = "修改角色成功！" }));
}
}
/// <summary>
/// 删除
/// </summary>
/// <param name="UserInfo"></param>
/// <returns></returns>
public JsonResult CaseDel(string strId)
{
using (BuyunSiteEntities db = new BuyunSiteEntities())
{
var List = strId.Split(',');
foreach (var item in List)
{
var Id = Convert.ToInt32(item);
var dData = from a in db.BA_Case where a.Id == Id select a;
db.BA_Case.Remove(dData.FirstOrDefault());
}
db.SaveChanges();
return(Json(new { data = "success", content = "删除案例成功！" }));
}
}
/// <summary>
/// 删除角色信息
/// </summary>
/// <param name="UserInfo"></param>
/// <returns></returns>
public JsonResult DelRole(string AuthorityId)
{
using (BuyunSiteEntities db = new BuyunSiteEntities())
{
var RemoveId = AuthorityId.Split(',');
foreach (var item in RemoveId)
{
int Id = Convert.ToInt32(item);
var Role = from t in db.Cu_UserAuthority where t.AuthorityId == Id select t;
db.Cu_UserAuthority.Remove(Role.FirstOrDefault());
}
db.SaveChanges();
return(Json(new { data = "success", content = "删除角色成功！" }));
}
}
public JsonResult GetCaseAdd(BA_Case result)
{
using (BuyunSiteEntities db = new BuyunSiteEntities())
{
var m = from t in db.BA_Case
where t.Name == result.Name
select t;
if (m.Count() > 0)
{
return(Json(new { data = "fail", content = "案例名称重复！" }));
}
result.AddUser = BasePage.GetCookie("UserNameCookie");
result.AddTime = DateTime.Now;
db.BA_Case.Add(result);
db.SaveChanges();
return(Json(new { data = "success", content = "新增案例成功！" }));
}
}
public JsonResult GetMenu()
{
using (BuyunSiteEntities db = new BuyunSiteEntities())
{
var strUser = BasePage.GetCookie("UserInfoCookie");
dynamic User = DynamicJsonConverter.ParseJson(strUser);
int UserId = User.UserId;
if (User.IsAdmin == true)
{
var Menu = from t in db.Cu_Menu select t;
return(Json(new { data = Menu.ToList() }));
}
else
{
var Menu = from t in db.Cu_Menu
where
(int?)("," +
((from a in db.Cu_User
join b in db.Cu_UserAuthority on new { AuthorityId = (Int32)a.AuthorityId } equals new { AuthorityId = b.AuthorityId }
where
a.UserId == UserId
select new
{
b.Authority
}).FirstOrDefault().Authority) + ",").ToUpper().IndexOf(("," + t.MenuId.ToString().TrimStart() + ",").ToUpper()) + 1 > 0
select new
{
t.MenuId,
t.FMenuId,
t.MenuName,
t.Imageicon,
t.URLAddress,
t.Status,
t.AddTime,
t.AddUser,
t.UpdateTime,
t.UpdateUser,
t.IsBlank
};
return(Json(new { data = Menu.ToList() }));
}
}
}
/// <summary>
/// 修改网站配置
/// </summary>
/// <param name="UserInfo"></param>
/// <returns></returns>
public JsonResult EditAdvertisement(BA_Advertisement Advertisement)
{
using (BuyunSiteEntities db = new BuyunSiteEntities())
{
var BA_Advertisement = from a in db.BA_Advertisement where a.AdvertisementId == Advertisement.AdvertisementId select a;
var AdvertisementInfo = BA_Advertisement.FirstOrDefault();
AdvertisementInfo.CompanyName = Advertisement.CompanyName;
AdvertisementInfo.CompanyAddress = Advertisement.CompanyAddress;
AdvertisementInfo.CompanyLogo = Advertisement.CompanyLogo;
AdvertisementInfo.CompanyPhone = Advertisement.CompanyPhone;
AdvertisementInfo.CompanyQRCode = Advertisement.CompanyQRCode;
AdvertisementInfo.Image = Advertisement.Image;
AdvertisementInfo.Email = Advertisement.Email;
AdvertisementInfo.UpdateTime = DateTime.Now;
AdvertisementInfo.UpdateUser = BasePage.GetCookie("UserNameCookie");
db.SaveChanges();
}
return(Json(new { data = "success", content = "修改网站配置成功！" }));
}
/// <summary>
/// 增加管理员
/// </summary>
/// <param name="UserInfo"></param>
/// <returns></returns>
public JsonResult AddAdmin(Cu_User UserInfo)
{
using (BuyunSiteEntities db = new BuyunSiteEntities())
{
var chkUserCode = from a in db.Cu_User where a.UserCode == UserInfo.UserCode select a;
if (chkUserCode.Count() > 0)
{
return(Json(new { data = "fail", content = "管理员编码重复！" }));
}
UserInfo.UserPassword = BasePage.Md5Hash(UserInfo.UserPassword);
UserInfo.AddTime = DateTime.Now;
UserInfo.AddUser = BasePage.GetCookie("UserNameCookie");
UserInfo.Status = 1;
UserInfo.IsAdmin = false;
db.Cu_User.Add(UserInfo);
db.SaveChanges();
}
return(Json(new { data = "success", content = "新增管理员成功！" }));
}
/// <summary>
/// 修改
/// </summary>
/// <param name="UserInfo"></param>
/// <returns></returns>
public JsonResult FLinkEdit(BA_FriendshipLink result)
{
using (BuyunSiteEntities db = new BuyunSiteEntities())
{
var m = from t in db.BA_FriendshipLink
where t.Name == result.Name && t.Id != result.Id
select t;
if (m.Count() > 0)
{
return(Json(new { data = "fail", content = "名称重复！" }));
}
var BA_FriendshipLink = from t in db.BA_FriendshipLink where t.Id == result.Id select t;
var resultInfo = BA_FriendshipLink.FirstOrDefault();
resultInfo.Name = result.Name;
resultInfo.Icon = result.Icon;
resultInfo.ToUrl = result.ToUrl;
resultInfo.AddUser = BasePage.GetCookie("UserNameCookie");
resultInfo.AddTime = DateTime.Now;
db.SaveChanges();
return(Json(new { data = "success", content = "修改成功！" }));
}
}
/// <summary>
/// 处理登录的信息
/// </summary>
/// <param name="userInfo"></param>
/// <returns></returns>
public JsonResult CheckUserLogin(Cu_User userInfo)
{
using (BuyunSiteEntities db = new BuyunSiteEntities())
{
//linq查询
userInfo.UserPassword = BasePage.Md5Hash(userInfo.UserPassword);
var users = from p in db.Cu_User
where p.UserCode == userInfo.UserCode && p.UserPassword == userInfo.UserPassword
select p;
if (users.Count() > 0)
{
string strUser = DynamicJsonConverter.GetJson <Cu_User>(users.FirstOrDefault());
BasePage.WriteCookie("UserNameCookie", users.FirstOrDefault().UserName, 0);
BasePage.WriteCookie("UserInfoCookie", strUser, 0);
return(Json(new { result = "success", content = "" }));
}
else
{
return(Json(new { result = "error", content = "用户名密码错误，请您检查" }));
}
}
}
/// <summary>
/// 修改管理员
/// </summary>
/// <param name="UserInfo"></param>
/// <returns></returns>
public JsonResult EditAdmin(Cu_User UserInfo)
{
using (BuyunSiteEntities db = new BuyunSiteEntities())
{
var chkUserCode = from a in db.Cu_User where a.UserCode == UserInfo.UserCode && a.UserId != UserInfo.UserId select a;
if (chkUserCode.Count() > 0)
{
return(Json(new { data = "fail", content = "管理员编码重复！" }));
}
var User = from a in db.Cu_User where a.UserId == UserInfo.UserId select a;
if (!string.IsNullOrEmpty(UserInfo.UserPassword))
{
User.FirstOrDefault().UserPassword = BasePage.Md5Hash(UserInfo.UserPassword);
}
User.FirstOrDefault().UserName = UserInfo.UserName;
User.FirstOrDefault().UserCode = UserInfo.UserCode;
User.FirstOrDefault().UserPhone = UserInfo.UserPhone;
User.FirstOrDefault().AuthorityId = UserInfo.AuthorityId;
User.FirstOrDefault().UpdateTime = DateTime.Now;
User.FirstOrDefault().UpdateUser = BasePage.GetCookie("UserNameCookie");
db.SaveChanges();
}
return(Json(new { data = "success", content = "修改管理员成功！" }));
}