/// <summary>
///
/// </summary>
/// <param name="adminID"></param>
/// <returns></returns>
public JsonResult DeleteAdmin(int adminID)
{
try
{
Models.Administrator administrator = dataContext.Administrator.Where(m => m.ID == adminID).FirstOrDefault();
if (administrator != null)
{
//删除管理员绑定的系统
List <Models.AdminSys> adminSyses = dataContext.AdminSys.Where(m => m.AdminID == administrator.ID).ToList();
dataContext.AdminSys.DeleteAllOnSubmit(adminSyses);
dataContext.Administrator.DeleteOnSubmit(administrator);
dataContext.SubmitChanges();
}
else
{
errorCode = 20001;
}
}
catch (Exception ex)
{
errorCode = 10001;
new BLL.ServiceException().AddExceptionLog(ex);
}
if (errorCode != 0)
{
error = new BLL.ServiceError().GetErrorInfo(errorCode);
}
return(Json(errorCode, error, null, true));
}
public JsonResult UploadImage(HttpPostedFileBase file)
{
int errorCode = 0;
string error = string.Empty;
string result = string.Empty;
try
{
DateTime now = DateTime.Now;
string imgName = string.Format("{0}.jpg", now.ToString("yyyyMMddHHmmss"));
string folder = string.Format(@"{0}Resources\Images\{1}", Models.SharedData.ProjectPath, now.ToString("yyyyMMdd"));
//检查是否有该文件夹，没有则创建
Common.HandleFiles.CreateDirectory(folder);
string localPath = string.Format(@"{0}\{1}", folder, imgName);
file.SaveAs(localPath);
string webPath = string.Format(@"{0}\Resources\Images\{1}\{2}", Models.SharedData.DomainName, now.ToString("yyyyMMdd"), imgName);
result = webPath;
}
catch (Exception ex)
{
errorCode = 10001;
error = new BLL.ServiceError().GetErrorInfo(errorCode);
new BLL.ServiceException().AddExceptionLog(ex);
}
return(Json(errorCode, error, result, true));
}
public JsonResult GetOtherSys(int adminID)
{
object result = new object();
try
{
List <int> bindSysID = dataContext.AdminSys.Where(m => m.AdminID == adminID).Select(m => m.SysID).ToList();
List <int> allSysID = dataContext.AuthoritySys.Where(m => m.Status == (int)Models.Enums.SharedStatus.Normal).Select(m => m.ID).ToList();
List <int> noBindSysID = allSysID.Except(bindSysID).ToList();
List <Models.AuthoritySys> authoritySyses = dataContext.AuthoritySys.Where(m => noBindSysID.Contains(m.ID) && m.Status == (int)Models.Enums.SharedStatus.Normal).ToList();
List <object> list = new List <object>();
if (authoritySyses.Count > 0)
{
foreach (Models.AuthoritySys item in authoritySyses)
{
list.Add(new
{
item.ID,
item.Name
});
}
result = new
{
list
};
}
}
catch (Exception ex)
{
errorCode = 10001;
error = new BLL.ServiceError().GetErrorInfo(errorCode);
new BLL.ServiceException().AddExceptionLog(ex);
}
return(Json(errorCode, error, result, true));
}
public JsonResult DeleteAdminSys(int adminSysID)
{
try
{
Models.AdminSys adminSys = dataContext.AdminSys.Where(m => m.ID == adminSysID).FirstOrDefault();
if (adminSys != null)
{
dataContext.AdminSys.DeleteOnSubmit(adminSys);
dataContext.SubmitChanges();
}
else
{
errorCode = 30001;
}
}
catch (Exception ex)
{
errorCode = 10001;
new BLL.ServiceException().AddExceptionLog(ex);
}
if (errorCode != 0)
{
error = new BLL.ServiceError().GetErrorInfo(errorCode);
}
return(Json(errorCode, error, null, true));
}
public JsonResult AddAdminSys(Models.AdminSys formObj)
{
try
{
Models.AdminSys adminSys = dataContext.AdminSys.Where(m => m.ID == formObj.ID).FirstOrDefault();
if (adminSys == null)
{
adminSys = new Models.AdminSys
{
AdminID = formObj.AdminID,
SysID = formObj.SysID,
AuthorityTime = DateTime.Now,
Status = formObj.Status
};
dataContext.AdminSys.InsertOnSubmit(adminSys);
}
else
{
adminSys.Status = formObj.Status;
}
dataContext.SubmitChanges();
}
catch (Exception ex)
{
errorCode = 10001;
error = new BLL.ServiceError().GetErrorInfo(errorCode);
new BLL.ServiceException().AddExceptionLog(ex);
}
return(Json(errorCode, error, null, true));
}
public JsonResult GetBlogs(string keyword, int status = 0, int page = 1)
{
object result = null;
try
{
var query = PredicateBuilder.True<Models.Blog>();
if (!string.IsNullOrEmpty(keyword))
{
query = query.And(m => m.Title.Contains(keyword) || m.Author.Contains(keyword));
}
if (status != 0)
{
query = query.And(m => m.Status == status);
}
int pageSize = Models.SharedData.PageSize;
int pagePre = page * pageSize - pageSize;
int totalCount = dataContext.Blog.Where(query).Count();
int mod = totalCount % pageSize;
int pageCout = totalCount / pageSize + (mod == 0 ? 0 : 1);
int totalPage = totalCount / pageSize + (totalCount % pageSize == 0 ? 0 : 1);
List<Models.Blog> blogs = dataContext.Blog.Where(query).OrderByDescending(m => m.CreateTime).Skip(pagePre).Take(pageSize).ToList();
List<object> list = new List<object>();
if (blogs.Count > 0)
{
foreach (Models.Blog item in blogs)
{
list.Add(new
{
item.ID,
item.Title,
item.Cover,
CreateTime = Common.ConvertData.ConvertDateTimeToStr(item.CreateTime, 2),
item.Status,
item.Author,
item.Content
});
}
}
result = new
{
list,
page,
totalCount,
totalPage,
pageSize
};
}
catch (Exception ex)
{
errorCode = 10001;
error = new BLL.ServiceError().GetErrorInfo(errorCode);
new BLL.ServiceException().AddExceptionLog(ex);
}
return Json(errorCode, error, result, true);
}
public JsonResult LoginSystem(string name, string password)
{
int errorCode = 0;
string error = string.Empty;
object result = null;
try
{
Models.Administrator administrator = dataContext.Administrator.Where(m => m.Name == name && m.Status == (int)Models.Enums.RoleStatus.Normal).FirstOrDefault();
if (administrator != null)
{
//验证用户密码
if (administrator.Password != Common.HandleString.MD5(password + administrator.Token))
{
errorCode = 20002;
}
}
else
{
errorCode = 20001;
}
if (errorCode == 0)
{
//更新管理员登陆时间
administrator.LoginTime = DateTime.Now;
dataContext.SubmitChanges();
result = new
{
administrator.ID,
administrator.Name,
administrator.Token,
administrator.Type,
administrator.Avatar,
administrator.Status,
administrator.Password,
Menus = administrator.Type == (int)Models.Enums.AdminType.SuperAdmin ? null : new BLL.ServiceAuthority().GetAdminMenu(administrator.ID)
};
}
}
catch (Exception ex)
{
errorCode = 10001;
new BLL.ServiceException().AddExceptionLog(ex);
}
if (errorCode != 0)
{
error = new BLL.ServiceError().GetErrorInfo(errorCode);
}
return(Json(errorCode, error, result, true));
}
/// <summary>
///
/// </summary>
/// <param name="formAdmin"></param>
/// <returns></returns>
public JsonResult ModifyAdmin(Models.Administrator formAdmin)
{
try
{
Models.Administrator objAdmin = dataContext.Administrator.Where(m => m.ID == formAdmin.ID).FirstOrDefault();
//对象为空，则增加
if (objAdmin == null)
{
//生成管理员Token
string token = BLL.ServiceAdministrator.GetAdminToken();
objAdmin = new Models.Administrator
{
Name = formAdmin.Name,
Token = token,
//密码进行md5加密
Password = Common.HandleString.MD5(formAdmin.Password + token),
Avatar = formAdmin.Avatar,
Type = formAdmin.Type,
Status = formAdmin.Status,
LoginTime = Models.SharedData.MinTime
};
dataContext.Administrator.InsertOnSubmit(objAdmin);
}
//否则为修改
else
{
//如果密码不为空则是修改密码
if (formAdmin.Password != null)
{
objAdmin.Password = Common.HandleString.MD5(formAdmin.Password + objAdmin.Token);
}
//否则为修改信息
else
{
objAdmin.Name = formAdmin.Name;
objAdmin.Avatar = formAdmin.Avatar;
objAdmin.Status = formAdmin.Status;
objAdmin.Type = formAdmin.Type;
}
}
//数据入库
dataContext.SubmitChanges();
}
catch (Exception ex)
{
errorCode = 10001;
new BLL.ServiceException().AddExceptionLog(ex);
error = new BLL.ServiceError().GetErrorInfo(errorCode);
}
return(Json(errorCode, error, null, true));
}
/// <summary>
///
/// </summary>
/// <param name="adminID"></param>
/// <param name="page"></param>
/// <returns></returns>
public JsonResult GetAdminSys(int adminID, int page = 1)
{
object result = new object();
try
{
List <Models.AdminSys> adminSyses = dataContext.AdminSys.Where(m => m.AdminID == adminID).ToList();
int pageSize = Models.SharedData.PageSize;
int pagePre = page * pageSize - pageSize;
int totalCount = adminSyses.Count;
int mod = totalCount % pageSize;
int pageCout = totalCount / pageSize + (mod == 0 ? 0 : 1);
int totalPage = totalCount / pageSize + (totalCount % pageSize == 0 ? 0 : 1);
adminSyses = adminSyses.OrderByDescending(m => m.AuthorityTime).Skip(pagePre).Take(pageSize).ToList();
List <object> list = new List <object>();
if (adminSyses.Count > 0)
{
foreach (Models.AdminSys adminSys in adminSyses)
{
list.Add(new
{
adminSys.ID,
AdminName = adminSys.Administrator.Name,
SysName = adminSys.AuthoritySys.Name,
AuthorityTime = Common.ConvertData.ConvertDateTimeToStr(adminSys.AuthorityTime, 2),
adminSys.Status
});
}
}
result = new
{
list,
page,
totalCount,
totalPage,
pageSize
};
}
catch (Exception ex)
{
errorCode = 10001;
error = new BLL.ServiceError().GetErrorInfo(errorCode);
new BLL.ServiceException().AddExceptionLog(ex);
}
return(Json(errorCode, error, result, true));
}
public JsonResult DeleteBlog(int blogID)
{
try
{
Models.Blog blog = dataContext.Blog.Where(m => m.ID == blogID).FirstOrDefault();
if (blog != null)
{
dataContext.Blog.DeleteOnSubmit(blog);
dataContext.SubmitChanges();
}
}
catch (Exception ex)
{
errorCode = 10001;
error = new BLL.ServiceError().GetErrorInfo(errorCode);
new BLL.ServiceException().AddExceptionLog(ex);
}
return Json(errorCode, error, null, true);
}
//当表单提交东内容是包含图片和文字是会出现表单提交错误
public JsonResult ModifyBlog(Models.Blog formObj)
{
try
{
Models.Blog blog = dataContext.Blog.Where(m => m.ID == formObj.ID).FirstOrDefault();
if (blog == null)
{
blog = new Models.Blog
{
Title = formObj.Title,
Cover = formObj.Cover,
Content = formObj.Content,
CreateTime = DateTime.Now,
Author = formObj.Author,
Status = formObj.Status
};
dataContext.Blog.InsertOnSubmit(blog);
}
else
{
blog.Title = formObj.Title;
blog.Cover = formObj.Cover;
blog.Content = formObj.Content;
blog.Author = formObj.Author;
blog.Status = formObj.Status;
}
dataContext.SubmitChanges();
}
catch (Exception ex)
{
errorCode = 10001;
error = new BLL.ServiceError().GetErrorInfo(errorCode);
new BLL.ServiceException().AddExceptionLog(ex);
}
return Json(errorCode, error, null, true);
}
public JsonResult GetWeather()
{
object result = null;
try
{
//参数ip是淘宝ip地址库特定的参数
string strRegion = Common.HandleHttp.HttpGet("http://ip.taobao.com/service/getIpInfo.php", "ip=myip");
//将json数据转化为动态类型
dynamic ObjRegion = Common.HandleJson.JsonToDynamic(strRegion);
//获取城市
string city = string.Format("{0}{1}", ObjRegion.data.region, ObjRegion.data.city);
//读取xml，获取城市的代码
string path = string.Format(@"{0}\Models\weatherConfig.xml", Models.SharedData.ProjectPath);
XDocument document = XDocument.Load(path);
XElement element = document.Descendants("City").Where(m => m.Attribute("FullName").Value == city).FirstOrDefault();
//根据城市代码获取天气
string url = string.Format("http://t.weather.sojson.com/api/weather/city/{0}", element.Attribute("Code").Value);
string strWeather = Common.HandleHttp.HttpGet(url, null);
//将天气信息转换为实体数据
Models.Weather.Root weatherInfo = Common.HandleJson.DeserializeJsonToObject <Models.Weather.Root>(strWeather);
//图表数据
List <string> date = new List <string>();
List <int> hight = new List <int>();
List <int> low = new List <int>();
//表格数据
List <object> list = new List <object>();
foreach (var item in weatherInfo.data.forecast)
{
date.Add(item.ymd);
hight.Add(int.Parse(new BLL.ServiceOther().GetTemperature(item.high)));
low.Add(int.Parse(new BLL.ServiceOther().GetTemperature(item.low)));
list.Add(new
{
date = item.ymd,
item.week,
item.sunrise,
item.sunset,
item.fx,
item.fl,
item.aqi,
item.type
});
}
result = new
{
city,
map = new
{
date,
hight,
low
},
table = list
};
}
catch (Exception ex)
{
errorCode = 10001;
new BLL.ServiceException().AddExceptionLog(ex);
}
if (errorCode != 0)
{
error = new BLL.ServiceError().GetErrorInfo(errorCode);
}
return(Json(errorCode, error, result, true));
}
/// <summary>
///
/// </summary>
/// <param name="startTime">开始时间</param>
/// <param name="endTime">结束时间</param>
/// <param name="page">页码</param>
/// <returns></returns>
public JsonResult GetExceptionLogList(string startTime, string endTime, int page = 1)
{
object result = new object();
try
{
DateTime?sTime = Common.ConvertData.StrToDateTime(startTime);
DateTime?eTime = Common.ConvertData.StrToDateTime(endTime);
if (sTime == null)
{
sTime = Models.SharedData.MinTime;
}
if (eTime == null)
{
eTime = Models.SharedData.MaxTime;
}
List <Models.ExceptionLog> exceptionLogs = dataContext.ExceptionLog.Where(m => m.Time >= sTime && m.Time < eTime).ToList();
int pageSize = 10;
int pagePre = page * pageSize - pageSize;
int totalCount = exceptionLogs.Count;
int mod = totalCount % pageSize;
int pageCout = totalCount / pageSize + (mod == 0 ? 0 : 1);
int totalPage = totalCount / pageSize + (totalCount % pageSize == 0 ? 0 : 1);
exceptionLogs = exceptionLogs.OrderByDescending(m => m.Time).Skip(pagePre).Take(pageSize).ToList();
List <object> list = new List <object>();
if (exceptionLogs.Count > 0)
{
foreach (var exceptionLog in exceptionLogs)
{
list.Add(new
{
exceptionLog.ID,
exceptionLog.Source,
exceptionLog.Message,
exceptionLog.StackTrace,
Time = Common.ConvertData.ConvertDateTimeToStr(exceptionLog.Time, 2)
});
}
}
result = new
{
list,
page,
totalCount,
totalPage,
pageSize
};
}
catch (Exception ex)
{
errorCode = 10001;
new BLL.ServiceException().AddExceptionLog(ex);
error = new BLL.ServiceError().GetErrorInfo(errorCode);
}
return(Json(errorCode, error, result, true));
}
/// <summary>
///
/// </summary>
/// <param name="name">名字</param>
/// <param name="type">管理员类型</param>
/// <param name="status">角色状态</param>
/// <param name="page">页码</param>
/// <returns></returns>
public JsonResult GetAdmins(string name = null, int type = 0, int status = 0, int page = 1)
{
object result = null;
try
{
var query = PredicateBuilder.True <Models.Administrator>();
if (!string.IsNullOrEmpty(name))
{
query = query.And(m => m.Name.Contains(name));
}
if (type != 0)
{
query = query.And(m => m.Type == type);
}
if (status != 0)
{
query = query.And(m => m.Status == status);
}
int pageSize = Models.SharedData.PageSize;
int pagePre = page * pageSize - pageSize;
int totalCount = dataContext.Administrator.Where(query).Count();
int mod = totalCount % pageSize;
int pageCout = totalCount / pageSize + (mod == 0 ? 0 : 1);
int totalPage = totalCount / pageSize + (totalCount % pageSize == 0 ? 0 : 1);
List <Models.Administrator> administrators = dataContext.Administrator.Where(query).OrderByDescending(m => m.ID).Skip(pagePre).Take(pageSize).ToList();
List <object> list = new List <object>();
if (administrators.Count > 0)
{
foreach (Models.Administrator administrator in administrators)
{
list.Add(new
{
administrator.ID,
administrator.Name,
administrator.Avatar,
administrator.Status,
administrator.Type,
LoginTime = Common.ConvertData.ConvertDateTimeToStr(administrator.LoginTime, 2)
});
}
}
result = new
{
list,
page,
totalCount,
totalPage,
pageSize
};
}
catch (Exception ex)
{
errorCode = 10001;
error = new BLL.ServiceError().GetErrorInfo(errorCode);
new BLL.ServiceException().AddExceptionLog(ex);
}
return(Json(errorCode, error, result, true));
}
