public JsonResult Edit(WN_WarningCond entity)
{
if (entity != null && ModelState.IsValid)
{
using (MBREntities db = new MBREntities())
{
WarningCondService us = new WarningCondService(db);
if (us.Edit(ref errors, entity))
{
LogHandler.WriteServiceLog(LogonUser.RealName, "WarningCondID:" + entity.WarningCondID, Resource.EditSucceed, Resource.Edit, "预警条件设置");
return(Json(JsonHandler.CreateMessage(1, Resource.EditSucceed)));
}
else
{
string ErrorCol = errors.Error;
LogHandler.WriteServiceLog(LogonUser.RealName, "WarningCondID:" + entity.WarningCondID, Resource.EditFail, Resource.Edit, "预警条件设置");
return(Json(JsonHandler.CreateMessage(0, Resource.EditFail + ErrorCol)));
}
}
}
else
{
return(Json(JsonHandler.CreateMessage(0, Resource.EditFail)));
}
}
public ActionResult Create(int WarningCondID)
{
WN_ParamSett entity = new WN_ParamSett();
entity.WarningCondID = WarningCondID;
List <SelectListItem> ParamNameList = new List <SelectListItem>();
SYS_ParamInfoService sysParamInfoService = new SYS_ParamInfoService();
using (MBREntities db = new MBREntities())
{
var list = db.SYS_ParamInfo.OrderBy(m => m.ParamName).ToList();
if (list != null)
{
foreach (var item in list)
{
ParamNameList.Add(new SelectListItem()
{
Text = item.Title,
Value = item.ParamName
});
}
}
}
ViewBag.ParamID = ParamNameList;
return(View(entity));
}
public ActionResult Edit(int id)
{
WN_ParamSett entity = null;
using (MBREntities db = new MBREntities())
{
entity = db.WN_ParamSett.Where(m => m.ParamSetID == id).FirstOrDefault();
List <SelectListItem> ParamNameList = new List <SelectListItem>();
SYS_ParamInfoService sysParamInfoService = new SYS_ParamInfoService();
var list = db.SYS_ParamInfo.OrderBy(m => m.ParamName).ToList();
if (list != null)
{
foreach (var item in list)
{
var selected = entity.ParamID.Equals(item.ParamName);
ParamNameList.Add(new SelectListItem()
{
Text = item.Title,
Value = item.ParamName,
Selected = selected
});
}
}
ViewBag.ParamID = ParamNameList;
}
return(View(entity));
}
public ViewResult ANIndex(int?InfoID)
{
MBR_Info Info = null;
if (InfoID.HasValue)
{
using (MBREntities db = new MBREntities())
{
Info = db.MBR_Info.Find(InfoID.Value);
}
}
if (Info == null)
{
throw new Exception("请选择膜");
}
ViewBag.MBRInfo = Info;
ANInfoModel model = new ANInfoModel();
using (MBREntities db = new MBREntities())
{
model.CLCurve = db.AN_CLCurve.Find(InfoID.Value);
model.HighCurve = db.AN_HighCurve.Find(InfoID.Value);
model.LowCurve = db.AN_LowCurve.Find(InfoID.Value);
}
model.InfoID = (int)InfoID;
return(View(model));
}
public JsonResult ModifyPass(LocalPasswordModel model)
{
using (MBREntities db = new MBREntities())
{
UserService us = new UserService(db);
if (model != null && ModelState.IsValid)
{
if (us.ModifyPass(ref errors, LogonUser.UserID, model.OldPassword, model.NewPassword))
{
LogHandler.WriteServiceLog(LogonUser.RealName, "UserID:" + LogonUser.UserID, Resource.EditSucceed, Resource.Edit, "修改密码");
return(Json(JsonHandler.CreateMessage(1, Resource.EditSucceed)));
}
else
{
string ErrorCol = errors.Error;
LogHandler.WriteServiceLog(LogonUser.RealName, "UserID:" + LogonUser.UserID, Resource.EditFail, Resource.Edit, "修改密码");
return(Json(JsonHandler.CreateMessage(0, Resource.EditFail + ErrorCol)));
}
}
else
{
return(Json(JsonHandler.CreateMessage(0, Resource.EditFail)));
}
}
}
public JsonResult GetList(GridPager pager)
{
Expression <Func <Knowlege, bool> > predicate = null;
if (!string.IsNullOrEmpty(Request["search[value]"]))
{
string value = Request["search[value]"];
predicate = m => m.AllContent.Contains(value);
}
using (MBREntities db = new MBREntities())
{
KnowlegeService us = new KnowlegeService(db);
var query = us.GetList(ref pager, predicate);
var json = new
{
draw = pager.draw,
recordsTotal = pager.recordsFiltered,
recordsFiltered = pager.recordsTotal,
data = query.Select(m => new { m.KnowlegeID, m.Title, m.KeyWords, m.Content, m.Author, m.UpdateTime, m.AllContent, m.Summary })
};
return(Json(json, JsonRequestBehavior.AllowGet));
}
}
public JsonResult GetList(GridPager pager, string beginDate = null, string endDate = null)
{
Expression <Func <MBR_RunningInfo, bool> > predicate = null;
if (!string.IsNullOrEmpty(beginDate) && !string.IsNullOrEmpty(endDate))
{
DateTime dBeginDate = Convert.ToDateTime(beginDate);
DateTime dEndDate = Convert.ToDateTime(endDate);
predicate = m => m.UpdateTime >= dBeginDate && m.UpdateTime <= dEndDate;
}
using (MBREntities db = new MBREntities())
{
RunningInfoService us = new RunningInfoService(db);
var query = us.GetList(ref pager, predicate);
var json = new
{
draw = pager.draw,
recordsTotal = pager.recordsFiltered,
recordsFiltered = pager.recordsTotal,
data = query.Select(m => new { m.UpdateTime, m.ChanShuiLL, m.ChanShuiYL, m.DanChiMCXQL, m.WuNiND, m.RongJieY, m.KuaMoYC, m.TouShuiL, m.QiShuiB, m.ShuiWen, m.WenDuJZTSL })
};
return(Json(json, JsonRequestBehavior.AllowGet));
}
}
public JsonResult Create(Knowlege entity)
{
if (entity != null)
{
string Title = entity.Title;
string Author = entity.Author;
string UpdateTime = entity.UpdateTime.Value.ToShortDateString();
string KeyWords = entity.KeyWords;
string Content = entity.Content;
entity.AllContent = string.Format("{0}|{1}|{2}|{3}", Title, Author, KeyWords, Content);
if (Content != null && Content.Length > 300)
{
Content = Content.Substring(0, 300);
}
entity.Summary = string.Format("{0}<br/>{1}<br/>{2} {3} {4}", Content, KeyWords, Title, Author, UpdateTime);
}
using (MBREntities db = new MBREntities())
{
KnowlegeService us = new KnowlegeService(db);
if (us.Create(ref errors, entity))
{
LogHandler.WriteServiceLog(LogonUser.RealName, "KnowlegeID:" + entity.KnowlegeID + ",Title:" + entity.Title, Resource.InsertSucceed, Resource.Create, "专家库管理");
return(Json(JsonHandler.CreateMessage(1, Resource.InsertSucceed), JsonRequestBehavior.AllowGet));
}
else
{
string ErrorCol = errors.Error;
LogHandler.WriteServiceLog(LogonUser.RealName, "KnowlegeID:" + entity.KnowlegeID + ",Title:" + entity.Title, Resource.InsertFail, Resource.Create, "专家库管理");
return(Json(JsonHandler.CreateMessage(0, Resource.InsertFail + ErrorCol), JsonRequestBehavior.AllowGet));
}
}
}
public Dictionary <string, string> GetDicValuesByCode(string code)
{
if (string.IsNullOrEmpty(code))
{
return(null);
}
code = code.Trim();
Dictionary <string, string> dic = new Dictionary <string, string>();
if (DicMap.ContainsKey(code))
{
return(DicMap[code]);
}
else
{
using (MBREntities db = new MBREntities())
{
var dicList = db.DATADICTIONARY.Include("DATADICTIONARYDETAIL").Where(m => m.CODE == code).ToList();
if (dicList == null || dicList.Count() != 1)
{
return(dic);
}
dic = dicList.First().DATADICTIONARYDETAIL.OrderBy(m => m.SORTCODE).OrderBy(m => m.DATADICTIONARYDETAILID).ToDictionary(m => m.CODE, v => v.FULLNAME);
}
}
return(dic);
}
internal bool ModifyPass(ref ValidationErrors errors, int UserID, string OldPassword, string NewPassword)
{
try
{
using (MBREntities db = new MBREntities())
{
User entity = GetById(UserID);
if (entity == null)
{
errors.Add("实体不存在");
return(false);
}
string MD5pwd = Encrypt.MD5(OldPassword);
if (string.Equals(entity.Password, MD5pwd, StringComparison.OrdinalIgnoreCase))
{
entity.Password = Encrypt.MD5(NewPassword);
return(Edit(entity));
}
else
{
errors.Add("旧密码不正确");
return(false);
}
}
}
catch (Exception ex)
{
errors.Add(ex.Message);
ExceptionHander.WriteException(ex);
return(false);
}
}
public JsonResult GetList(GridPager pager, int WarningCondID)
{
Expression <Func <WN_ParamSett, bool> > predicate = null;
using (MBREntities db = new MBREntities())
{
//var query = db.WN_ParamSett.Where(m => m.WarningCondID == WarningCondID).AsQueryable();
var query = from m in db.WN_ParamSett
join n in db.SYS_ParamInfo on m.ParamID equals n.ParamName
where m.WarningCondID == WarningCondID
select new
{
m.ParamSetID,
ParamID = n.Title,
m.High,
m.Low,
m.WaitTime
};
var list = query.ToList();
var json = new
{
draw = pager.draw,
recordsTotal = list.Count(),
recordsFiltered = list.Count(),
data = list.Select(m => new { m.ParamSetID, m.ParamID, m.High, m.Low, m.WaitTime })
};
return(Json(json, JsonRequestBehavior.AllowGet));
}
}
public ActionResult Edit(int id)
{
WN_WarningSett entity = null;
using (MBREntities db = new MBREntities())
{
entity = db.WN_WarningSett.Find(id);
}
List <SelectListItem> WarningLevelList = new List <SelectListItem>();
DATADICTIONARYService DATADICTIONARYService = new DATADICTIONARYService();
var dicValues = DATADICTIONARYService.GetDicValuesByCode("WarningLevel");
if (dicValues != null)
{
foreach (var item in dicValues)
{
bool selected = item.Key.Equals((entity.WarningLevel ?? 0).ToString());
WarningLevelList.Add(new SelectListItem()
{
Text = item.Value,
Value = item.Key,
Selected = selected
});
}
}
ViewBag.WarningLevel = WarningLevelList;
return(View(entity));
}
public JsonResult WarningSettEdit(WarningSettModel entity)
{
if (entity == null && entity.Settings == null)
{
return(Json(JsonHandler.CreateMessage(0, Resource.InsertFail)));
}
if (!ModelState.IsValid)
{
return(Json(JsonHandler.CreateMessage(0, Resource.InsertFail)));
}
using (MBREntities db = new MBREntities())
{
SettingsService us = new SettingsService(db);
if (us.Create(ref errors, entity.Settings))
{
LogHandler.WriteServiceLog(LogonUser.RealName, "SettingsID:" + entity.Settings.SettingsID, Resource.InsertSucceed, Resource.Create, "预警设置管理");
return(Json(JsonHandler.CreateMessage(1, Resource.InsertSucceed), JsonRequestBehavior.AllowGet));
}
else
{
string ErrorCol = errors.Error;
LogHandler.WriteServiceLog(LogonUser.RealName, "SettingsID:" + entity.Settings.SettingsID, Resource.InsertFail, Resource.Create, "预警设置管理");
return(Json(JsonHandler.CreateMessage(0, Resource.InsertFail + ErrorCol), JsonRequestBehavior.AllowGet));
}
}
}
public JsonResult Edit(MBR_Info entity)
{
if (entity != null && ModelState.IsValid)
{
using (MBREntities db = new MBREntities())
{
MBRInfoService us = new MBRInfoService(db);
if (us.Edit(ref errors, entity))
{
LogHandler.WriteServiceLog(LogonUser.RealName, "InfoID:" + entity.InfoID + ",Title:" + entity.Title, Resource.EditSucceed, Resource.Edit, "MBR膜管理");
return(Json(JsonHandler.CreateMessage(1, Resource.EditSucceed)));
}
else
{
string ErrorCol = errors.Error;
LogHandler.WriteServiceLog(LogonUser.RealName, "InfoID:" + entity.InfoID + ",Title:" + entity.Title, Resource.EditFail, Resource.Edit, "MBR膜管理");
return(Json(JsonHandler.CreateMessage(0, Resource.EditFail + ErrorCol)));
}
}
}
else
{
return(Json(JsonHandler.CreateMessage(0, Resource.EditFail)));
}
}
public JsonResult GetAllDataByParam(string beginDate = null, string endDate = null)
{
Expression <Func <MBR_RunningInfo, bool> > predicate = null;
if (!string.IsNullOrEmpty(beginDate) && !string.IsNullOrEmpty(endDate))
{
DateTime dBeginDate = Convert.ToDateTime(beginDate);
DateTime dEndDate = Convert.ToDateTime(endDate);
predicate = m => m.UpdateTime >= dBeginDate && m.UpdateTime <= dEndDate;
}
using (MBREntities db = new MBREntities())
{
var query = db.MBR_RunningInfo.AsQueryable().Where(predicate).ToList();
var json = query.Select(m => new
{
UpdateTime = GetIntFromTime(m.UpdateTime.Value),
m.ChanShuiLL,
m.ChanShuiYL,
m.DanChiMCXQL,
m.WuNiND,
m.RongJieY,
m.KuaMoYC,
m.TouShuiL,
m.QiShuiB,
m.ShuiWen,
m.WenDuJZTSL
});
return(Json(json, JsonRequestBehavior.AllowGet));
}
}
/// <summary>
/// 获取所有菜单
/// </summary>
/// <returns></returns>
internal List <MBR.Models.Module> GetAllMenuList()
{
using (MBREntities db = new MBREntities())
{
var query = db.Module.Where(m => m.Enabled.HasValue && m.Enabled.Value).AsQueryable();
return(query.OrderBy(m => m.OrderBy).ThenBy(m => m.Code).ToList());
}
}
public ActionResult Details(int id)
{
using (MBREntities db = new MBREntities())
{
MBRInfoService us = new MBRInfoService(db);
MBR_Info entity = us.GetById(id);
return(View(entity));
}
}
public ActionResult Details(int id)
{
using (MBREntities db = new MBREntities())
{
KnowlegeService us = new KnowlegeService(db);
Knowlege entity = us.GetById(id);
return(View(entity));
}
}
public ActionResult Edit(int id)
{
MBR_Info entity = null;
using (MBREntities db = new MBREntities())
{
entity = db.MBR_Info.Include("MBR_Pool").Where(m => m.InfoID == id).FirstOrDefault();
}
return(View(entity));
}
public ActionResult Edit(int id)
{
WN_WarningCond entity = null;
using (MBREntities db = new MBREntities())
{
entity = db.WN_WarningCond.Include("WN_ParamSett").Where(m => m.WarningCondID == id).FirstOrDefault();
}
return(View(entity));
}
public ActionResult Edit(int id)
{
Knowlege entity = null;
using (MBREntities db = new MBREntities())
{
entity = db.Knowlege.Find(id);
}
return(View(entity));
}
public ActionResult Edit(int id)
{
using (MBREntities db = new MBREntities())
{
var Roles = db.Role.ToList();
ViewBag.Roles = Roles;
User entity = db.User.Include(m => m.Role).Where(m => m.UserID == id).FirstOrDefault();
return(View(entity));
}
}
public ViewResult WarningSettEdit()
{
WarningSettModel model = new WarningSettModel();
using (MBREntities db = new MBREntities())
{
model.Settings = db.Settings.AsQueryable().FirstOrDefault();
}
return(View(model));
}
/// <summary>
/// 获取用户角色列表
/// </summary>
/// <param name="UserID"></param>
/// <returns></returns>
internal List <MBR.Models.Role> GetUserRoleList(int UserID)
{
using (MBREntities db = new MBREntities())
{
var queryRole = db.Role.AsQueryable();
var query = from t1 in queryRole
from t2 in t1.User
where t2.UserID == UserID
select t1;
return(query.ToList());
}
}
public override bool Edit(ref ValidationErrors errors, User model)
{
try
{
using (MBREntities db = new MBREntities())
{
User entity = db.User.Where(m => m.UserID == model.UserID).FirstOrDefault();
if (entity == null)
{
errors.Add("实体不存在");
return(false);
}
//全部删除
if (entity.Role != null && entity.Role.Count() > 0)
{
entity.Role.Clear();
}
entity.Role = new List <Role>();
entity.RealName = model.RealName;
entity.Remark = model.Remark;
foreach (var item in model.Role)
{
var Role = db.Role.Find(item.RoleID);
if (Role != null)
{
entity.Role.Add(Role);
}
}
if (Edit(entity))
{
return(true);
}
else
{
errors.Add("编辑失败");
return(false);
}
}
}
catch (Exception ex)
{
errors.Add(ex.Message);
ExceptionHander.WriteException(ex);
return(false);
}
}
public JsonResult Create(WN_WarningCond entity)
{
using (MBREntities db = new MBREntities())
{
WarningCondService us = new WarningCondService(db);
if (us.Create(ref errors, entity))
{
LogHandler.WriteServiceLog(LogonUser.RealName, "WarningCondID:" + entity.WarningCondID, Resource.InsertSucceed, Resource.Create, "预警条件设置");
return(Json(JsonHandler.CreateMessage(1, Resource.InsertSucceed), JsonRequestBehavior.AllowGet));
}
else
{
string ErrorCol = errors.Error;
LogHandler.WriteServiceLog(LogonUser.RealName, "WarningCondID:" + entity.WarningCondID, Resource.InsertFail, Resource.Create, "预警条件设置");
return(Json(JsonHandler.CreateMessage(0, Resource.InsertFail + ErrorCol), JsonRequestBehavior.AllowGet));
}
}
}
public JsonResult DeleteParamSett(int id)
{
using (MBREntities db = new MBREntities())
{
ParamSettService us = new ParamSettService(db);
if (us.Delete(ref errors, id))
{
LogHandler.WriteServiceLog(LogonUser.RealName, "WarningCondID:" + id, Resource.DeleteSucceed, Resource.Delete, "预警条件设置");
return(Json(JsonHandler.CreateMessage(1, Resource.DeleteSucceed)));
}
else
{
string ErrorCol = errors.Error;
LogHandler.WriteServiceLog(LogonUser.RealName, "WarningCondID:" + id, Resource.DeleteFail, Resource.Delete, "预警条件设置");
return(Json(JsonHandler.CreateMessage(0, Resource.DeleteFail + ErrorCol)));
}
}
}
public JsonResult GetConditonList(GridPager pager, int WarningSettID = 0)
{
Expression <Func <WN_WarningCond, bool> > predicate = null;
using (MBREntities db = new MBREntities())
{
var query = db.WN_WarningCond.Where(m => m.WarningSettID == WarningSettID).AsQueryable();
var list = query.ToList();
var json = new
{
draw = pager.draw,
recordsTotal = list.Count(),
recordsFiltered = list.Count(),
data = list.Select(m => new { m.WarningCondID, m.WarningCondDesc })
};
return(Json(json, JsonRequestBehavior.AllowGet));
}
}
public JsonResult Create(MBR_Info entity)
{
using (MBREntities db = new MBREntities())
{
MBRInfoService us = new MBRInfoService(db);
if (us.Create(ref errors, entity))
{
LogHandler.WriteServiceLog(LogonUser.RealName, "InfoID:" + entity.InfoID + ",Title:" + entity.Title, Resource.InsertSucceed, Resource.Create, "MBR膜管理");
return(Json(JsonHandler.CreateMessage(1, Resource.InsertSucceed), JsonRequestBehavior.AllowGet));
}
else
{
string ErrorCol = errors.Error;
LogHandler.WriteServiceLog(LogonUser.RealName, "InfoID:" + entity.InfoID + ",Title:" + entity.Title, Resource.InsertFail, Resource.Create, "MBR膜管理");
return(Json(JsonHandler.CreateMessage(0, Resource.InsertFail + ErrorCol), JsonRequestBehavior.AllowGet));
}
}
}
public JsonResult Delete(int id)
{
using (MBREntities db = new MBREntities())
{
MBRInfoService us = new MBRInfoService(db);
if (us.Delete(ref errors, id))
{
LogHandler.WriteServiceLog(LogonUser.RealName, "InfoID:" + id, Resource.DeleteSucceed, Resource.Delete, "MBR膜管理");
return(Json(JsonHandler.CreateMessage(1, Resource.DeleteSucceed)));
}
else
{
string ErrorCol = errors.Error;
LogHandler.WriteServiceLog(LogonUser.RealName, "InfoID:" + id, Resource.DeleteFail, Resource.Delete, "MBR膜管理");
return(Json(JsonHandler.CreateMessage(0, Resource.DeleteFail + ErrorCol)));
}
}
}
