public JsonResult Delete(string serialno)
{
CommonBll commbll = new CommonBll();
OperateResultModel orm = commbll.DeleteSerialSet(serialno);
return(JsonResultHelper.ConvertToJsonResult(orm));
}
public JsonResult QueryUserRoles(string userno)
{
Permission permission = new Permission();
OperateResultModel orm = permission.QueryUserRoels(userno);
return(JsonResultHelper.ConvertToJsonResult(orm));
}
public JsonResult Index(string serialno, string serialname)
{
CommonBll commbll = new CommonBll();
OperateResultModel orm = commbll.QuerySerialSetes(serialno, serialname);
return(JsonResultHelper.ConvertToJsonResult(orm));
}
public JsonResult Update(sysserialset model)
{
CommonBll commbll = new CommonBll();
OperateResultModel orm = commbll.UpdateSerialSet(model);
return(JsonResultHelper.ConvertToJsonResult(orm));
}
public JsonResult Delete(string xueyh)
{
JiaxInfo jiaxinfo = new JiaxInfo();
OperateResultModel orm = jiaxinfo.DeleteXueyuan(xueyh);
return(JsonResultHelper.ConvertToJsonResult(orm));
}
public override void OnActionExecuting(ActionExecutingContext filterContext)
{
if (_globalSettings.CurrentUser.UserRoleName.Contains(UserRoleName.Guest))
{
if (filterContext.HttpContext.Request.Headers["X-Requested-With"] == "XMLHttpRequest" || filterContext.HttpContext.Request.Headers["XRequestedWith"] == "ajax")
{
// the controller action was invoked with an AJAX request
JsonResultHelper dataController = new JsonResultHelper
{
Access = false,
success = false,
Msg = new List <string> {
"SessionTimeOut"
},
url = "/Home/Index"
};
filterContext.Result = new JsonResult(new { dataController });
}
else
{
//filterContext.Result = new RedirectToRouteResult(new RouteValueDictionary{
//{ "controller", "Home" },
//{ "action", "Index" },
//{ "area ", "" }
//});
filterContext.Result = new RedirectToRouteResult(new RouteValueDictionary(new
{
action = "Index",
controller = "Home",
area = ""
}));
}
}
}
public ActionResult Login([FromBody] dynamic code)
{
Wx_Login login = WxHelper.Login(code.code.ToString());
if (login.Errcode == 0)
{
var dalWxUser = DalFactory.GetInstance <IDalWxUser>();
var wxUser = dalWxUser.GetByOpenId(login.Openid);
if (wxUser == null)
{
dalWxUser.Insert(new Wx_User
{
Applet_OpenId = login.Openid,
UnionId = login.unionid
});
}
return(JsonResultHelper.Success(login));
}
else
{
return(JsonResultHelper.Error(login));
}
}
public ActionResult UserInfo([FromBody] Wx_User user)
{
long?t = 0;
var dalWxUser = DalFactory.GetInstance <IDalWxUser>();
var wxUser = dalWxUser.GetByOpenId(user.Applet_OpenId);
if (wxUser == null)
{
t = dalWxUser.Insert(user);
}
else
{
user.Id = wxUser.Id;
t = dalWxUser.Update(user);
}
if (t.Value > 0)
{
return(JsonResultHelper.Success(user));
}
else
{
return(JsonResultHelper.Error(user));
}
}
public JsonResult Add(tbl_chexing model)
{
OperateResultModel orm = new OperateResultModel();
orm.message = ValidInput(model);
if (string.IsNullOrEmpty(orm.message))
{
UserModel um = SessionUser;
DateTime dtnow = DateTime.Now;
model.createdate = dtnow;
model.creater = um.UserNo;
model.editdate = dtnow;
model.editer = um.UserNo;
CommonBll common = new CommonBll();
orm = common.InsertCheXing(model);
orm.rows = model;
}
else
{
orm.success = false;
}
return(JsonResultHelper.ConvertToJsonResult(orm));
}
public JsonResult GetInterviews()
{
IInterviewsQuery interviewsQuery = new InterviewsQuery();
List <Interview> questions = interviewsQuery.GetQuestions();
return(JsonResultHelper.GetUnlimitedJsonResult(questions));
}
public JsonResult Query()
{
CommonBll common = new CommonBll();
OperateResultModel orm = common.QueryCheXings();
return(JsonResultHelper.ConvertToJsonResult(orm));
}
public JsonResult Delete(string chexing)
{
CommonBll common = new CommonBll();
OperateResultModel orm = common.DeleteCheXing(chexing);
return(JsonResultHelper.ConvertToJsonResult(orm));
}
public JsonResult Add(tbl_bank bankmodel)
{
OperateResultModel orm = new OperateResultModel();
orm.message = ValidInput(bankmodel);
if (string.IsNullOrEmpty(orm.message))
{
UserModel um = SessionUser;
DateTime dtnow = DateTime.Now;
bankmodel.createdate = dtnow;
bankmodel.creater = um.UserNo;
bankmodel.editdate = dtnow;
bankmodel.editer = um.UserNo;
Bank bank = new Bank();
bankmodel.id = bank.GetNewBankId();
orm = bank.InsertBank(bankmodel);
orm.rows = bankmodel;
}
else
{
orm.success = false;
}
return(JsonResultHelper.ConvertToJsonResult(orm));
}
public JsonResultModel GetGroupMembers(int groupid)
{
var ds = _dal.GetGroupMembers(groupid);
if (ds != null)
{
var rowOwner = ds.Tables[0].Rows[0];
MembersListResult result = new MembersListResult
{
owner = new UserEntity
{
id = rowOwner["userid"].ToInt(),
avatar = rowOwner["avatar"].ToString(),
username = rowOwner["username"].ToString(),
sign = rowOwner["sign"].ToString(),
},
list = ds.Tables[1].Rows.Cast <DataRow>().Select(x => new GroupUserEntity
{
id = x["userid"].ToInt(),
avatar = x["avatar"].ToString(),
groupid = groupid,
remarkname = x["remarkname"].ToString(),
sign = x["sign"].ToString(),
username = x["username"].ToString()
})
};
return(JsonResultHelper.CreateJson(result));
}
return(JsonResultHelper.CreateJson(null, false));
}
public IHttpActionResult Role_MenuFunctionDetails(BasicDetailsModel model)
{
try
{
if (!dbContext.AC_SysRoles.Any(k => k.Id == model.Id))
{
return(JsonResultHelper.JsonResult(1000, "请求失败!角色Id【" + model.Id + "】已不存在, 请刷新界面"));
}
//菜单-功能递归
//List<MenuFunctionModels> data = RecursiveMenuFunction(null);
//读取角色菜单
var datamenucheck = dbContext.AC_SysRoles.FirstOrDefault(k => k.Id == model.Id).BA_SysMenu.Select(k => k.Code).ToList();
//读取角色功能
var datafunctioncheck = dbContext.AC_SysRoles.FirstOrDefault(k => k.Id == model.Id).BA_SysCommand.Select(k => k.Code).ToList();
var data = new
{
datamenucheck,
datafunctioncheck
};
return(JsonResultHelper.JsonResult(data));
}
catch (Exception ex)
{
return(JsonResultHelper.JsonResult(1000, ex.Message));
}
}
public JsonResult Delete(string roleno)
{
Permission permission = new Permission();
OperateResultModel orm = permission.DeleteRole(roleno);
return(JsonResultHelper.ConvertToJsonResult(orm));
}
public JsonResult Query()
{
Permission permission = new Permission();
OperateResultModel orm = permission.QueryRoles();
return(JsonResultHelper.ConvertToJsonResult(orm));
}
public JsonResult Add(sysrole role)
{
OperateResultModel orm = new OperateResultModel();
orm.message = ValidInput(role);
if (string.IsNullOrEmpty(orm.message))
{
UserModel um = SessionUser;
DateTime dtnow = DateTime.Now;
role.createdate = dtnow;
role.creater = um.UserNo;
role.editdate = dtnow;
role.editer = um.UserNo;
Permission permission = new Permission();
orm = permission.InsertRole(role);
orm.rows = role;
}
else
{
orm.success = false;
}
return(JsonResultHelper.ConvertToJsonResult(orm));
}
public IHttpActionResult AllNewPerson(decimal TypeId, bool All)
{
try
{
if (All)
{
//拿到当前客服的现在存在的客户
var oldCust = dbContext.KS_Confirm.Where(p => p.TypeId == TypeId).Select(p => p.IdPerson).ToList();
//过滤不需要新增的客户
var newCust = dbContext.OR_Person.Select(p => p.Id).Where(p => !oldCust.Contains(p)).ToList();
if (newCust.Count == 0)
{
; //如果没有数据就不走下面了。
}
//新增SQL
string add = "";
newCust.ForEach(item =>
{
add += string.Format(@"INSERT dbo.KS_Confirm(IdPerson,TypeId) VALUES ({0}, {1})", item, TypeId);
});
dbContext.Database.ExecuteSqlCommand(add);
return(JsonResultHelper.JsonResult(0, "操作成功"));
}
else
{
string sql = string.Format(@"DELETE FROM KS_Confirm WHERE TypeId={0}", TypeId);
dbContext.Database.ExecuteSqlCommand(sql);
return(JsonResultHelper.JsonResult(0, "操作成功"));
}
}
catch (Exception ex)
{
return(JsonResultHelper.JsonResult(1000, ex.Message, null));
}
}
public IHttpActionResult GetDataList([FromUri] OutputStoreArchiveModel model)
{
string name = model.SearchKey == null?"": model.SearchKey.ToString();
int id = 0;
if (model.SearchKey != null)
{
int.TryParse(model.SearchKey.ToString(), out id);
}
Expression <Func <v_KsType, bool> > where = p => (string.IsNullOrEmpty(name) || p.Name.Contains(name)) ||
(string.IsNullOrEmpty(name) || p.ParentName.Contains(name)) ||
(string.IsNullOrEmpty(name) || p.Memo.Contains(name)) ||
(string.IsNullOrEmpty(name) || p.Id == id);
var list = dbContext.v_KsType.Where(where).Where(where).ToList().Select(p => new
{
p.Id,
p.Name,
p.IdParent,
p.ParentName,
p.Memo
}).OrderByDescending(p => p.Id).ToPagedList(model.PageIndex, model.PageSize);
return(JsonResultHelper.JsonResult(list));
}
public JsonResult Delete(string pkid)
{
Bank bank = new Bank();
OperateResultModel orm = bank.DeletePaperRule(pkid);
return(JsonResultHelper.ConvertToJsonResult(orm));
}
public IHttpActionResult Update(InputSysTypeModel model)
{
try
{
if (string.IsNullOrWhiteSpace(model.Name))
{
//返回错误
return(JsonResultHelper.JsonResult(1000, "名称不能为空"));
}
else
{
var info = dbContext.BA_SysEnType.FirstOrDefault(p => p.Id == model.Id);
if (info == null)
{
LogHelper.WriteLog("该类型已不存在,请刷新！");
return(JsonResultHelper.JsonResult(1000, "该类型已不存在,请刷新！"));
}
else
{
//首先删除中间表中这个类型数据
//var confirm = dbContext.KS_Confirm.Where(p => model.Id == p.TypeId);
//dbContext.KS_Confirm.RemoveRange(confirm);
//dbContext.SaveChanges();
LogHelper.WriteLog("父类");
decimal par = 1;
if (model.IdParent != 0)
{
par = model.IdParent;
}
string sql = $"DELETE FROM KS_Confirm WHERE TypeId={model.Id}";
dbContext.Database.ExecuteSqlCommand(sql);
LogHelper.WriteLog("父类2");
info.IdParent = par;
info.Memo = model.Memo;
info.Name = model.Name;
dbContext.SaveChanges();
//新增类型人员维护
if (model.PersonList != null)
{
foreach (var item in model.PersonList)
{
dbContext.KS_Confirm.Add(new KS_Confirm
{
IdPerson = item,
TypeId = info.Id
});
dbContext.SaveChanges();
}
}
LogHelper.WriteLog("父类3");
return(JsonResultHelper.JsonResult(0, "修改成功"));
}
}
}
catch (Exception ex)
{
LogHelper.WriteLog(ex.Message);
return(JsonResultHelper.JsonResult(1000, ex.Message));
}
}
public JsonResult Query()
{
Bank bank = new Bank();
OperateResultModel orm = bank.QueryPaperRules();
return(JsonResultHelper.ConvertToJsonResult(orm));
}
public JsonResult Add(tbl_paper_rule paperrule)
{
OperateResultModel orm = new OperateResultModel();
orm.message = ValidInput(paperrule);
if (string.IsNullOrEmpty(orm.message))
{
UserModel um = SessionUser;
DateTime dtnow = DateTime.Now;
paperrule.createdate = dtnow;
paperrule.creater = um.UserNo;
paperrule.editdate = dtnow;
paperrule.editer = um.UserNo;
paperrule.pkid = NewGuid;
Bank bank = new Bank();
orm = bank.InsertPaperRule(paperrule);
orm.rows = paperrule;
}
else
{
orm.success = false;
}
return(JsonResultHelper.ConvertToJsonResult(orm));
}
public IHttpActionResult UserMaintain([FromUri] UserMaintainModel model)
{
try
{
string name = model.SearchKey == null ? "" : model.SearchKey.ToString();
Expression <Func <v_Jusoft_PcSysUser, bool> > where = w => (string.IsNullOrEmpty(name) || w.Name.Contains(name)) ||
(string.IsNullOrEmpty(name) || w.PsnMobilePhone.Contains(name)) || (string.IsNullOrEmpty(name) || w.DepName.Contains(name));
var List = dbContext.v_Jusoft_PcSysUser.Where(where);
var Data = List.Select(p => new
{
p.id,
p.Name,
p.DepName,
p.PsnMobilePhone,
p.LockoutEnabled,
Roles = dbContext.AC_SysUsers.Where(o => o.Id == p.id).Select(k => new
{
roles = k.AC_SysRoles.Select(s => new
{
s.Name
}).ToList()
}),
}).OrderBy(p => p.id).ToList().ToPagedList(model.PageIndex, model.PageSize);
return(JsonResultHelper.JsonResult(Data));
}
catch (Exception ex)
{
return(JsonResultHelper.JsonResult(1000, ex.Message));
}
}
public IHttpActionResult UserDistriRole(UserDistriModel model)
{
try
{
var SysUsers = dbContext.AC_SysUsers.FirstOrDefault(p => p.Id == model.UserId);
if (SysUsers == null)
{
return(JsonResultHelper.JsonResult(1000, "未找到用户！"));
}
SysUsers.AC_SysRoles.Clear();
foreach (var item in model.Roles ?? new List <int>())
{
var SysRole = dbContext.AC_SysRoles.FirstOrDefault(p => p.Id == item);
if (SysRole != null)
{
SysUsers.AC_SysRoles.Add(SysRole);
}
}
dbContext.SaveChanges();
return(JsonResultHelper.JsonResult(0, "操作成功"));
}
catch (Exception ex)
{
return(JsonResultHelper.JsonResult(1000, ex.Message));
}
}
public IHttpActionResult BasicMaintain(BasicMaintainModel model)
{
ResultPageData rs = new ResultPageData();
try
{
var List = dbContext.v_Jusoft_PcSysEnType.Where(p => true);
if (model.IdParent != null)
{
List = List.Where(p => p.IdSysEnType == model.IdParent);
}
if (model.IdSysEnType != null)
{
List = List.Where(p => p.IdParent == model.IdSysEnType);
}
if (!string.IsNullOrEmpty(model.SeachKey))
{
List = List.Where(p => p.Name.Contains(model.SeachKey));
}
List <decimal?> Ids = dbContext.f_getEnTypeList(5).Select(p => p.Id).ToList();
List = List.Where(p => Ids.Contains(p.Id));
var Data = List.Select(p => new {
p.Id,
p.ParentName,
p.SysEnTypeName,
p.Name,
p.Memo
}).OrderByDescending(p => p.Id).ToPagedList(model.PageIndex, model.PageSize);
return(JsonResultHelper.JsonResult(Data));
}
catch (Exception ex)
{
return(JsonResultHelper.JsonResult(1000, ex.Message));
}
}
public IHttpActionResult UserEidtPermissions(EditUsers model)
{
var info = dbContext.AC_SysUsers.FirstOrDefault(p => p.Id == model.Id);
if (info == null)
{
return(JsonResultHelper.JsonResult(1000, "该用户已不存在"));
}
else
{
//所有的菜单权限
var menuList = dbContext.BA_SysMenu.Select(p => p.Id).ToList();
var oldMenu = info.AUTH_User_Menu.Where(p => menuList.Contains(p.IdSysMenu)).ToList(); //当前用户存在的菜单权限
oldMenu.ForEach(old => { dbContext.AUTH_User_Menu.Remove(old); }); //删除所有的用户权限
model.Menu.ForEach(news => dbContext.AUTH_User_Menu.Add(new AUTH_User_Menu {
IdSysMenu = news, IdSysUsers = info.Id
})); //新增当前用户的权限
//所有功能权限
var commandList = dbContext.BA_SysCommand.Select(p => p.Code).ToList();
var oldCommand = info.AUTH_User_Command.Where(p => commandList.Contains(p.CodeSysCommand)).ToList();
oldCommand.ForEach(old => { dbContext.AUTH_User_Command.Remove(old); });
model.Command.ForEach(news => dbContext.AUTH_User_Command.Add(new AUTH_User_Command {
IdSysUsers = info.Id, CodeSysCommand = news
}));
dbContext.SaveChanges();
return(JsonResultHelper.JsonResult(0, "操作成功"));
}
}
public override void OnException(ExceptionContext filterContext)
{
string path = filterContext.RequestContext.HttpContext.Server.MapPath($"/log/{DateTime.Now.ToString("yyyy-MM-dd")}.txt");
// This text is added only once to the file.
if (!File.Exists(path))
{
// Create a file to write to.
using (StreamWriter sw = File.CreateText(path))
{
sw.WriteLine("========= " + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + " ============");
}
}
// This text is always added, making the file longer over time
// if it is not deleted.
using (StreamWriter sw = File.AppendText(path))
{
sw.WriteLine("========= " + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + " ============"); sw.WriteLine("This");
sw.WriteLine("Message:" + filterContext.Exception.Message);
sw.WriteLine("StackTrace:" + filterContext.Exception.StackTrace);
};
//如果是ajax请求，返回相应的处理
if (filterContext.RequestContext.HttpContext.Request.IsAjaxRequest())
{
filterContext.Result = new JsonResult
{
Data = JsonResultHelper.CreateJson(null, false, "系统内部错误，请联系管理员")
};
filterContext.ExceptionHandled = true;
}
//否则执行自带方法
base.OnException(filterContext);
}
public IHttpActionResult RoleInfo(RoleInfoModel model)
{
try
{
var SysRole = dbContext.AC_SysRoles.FirstOrDefault(p => p.Id == model.Id);
if (SysRole != null)
{
var SysRoleCode = dbContext.AC_SysRoles.Where(p => p.Code == model.Code).ToList();
if (SysRoleCode.Count() > 0)
{
return(JsonResultHelper.JsonResult(1000, "角色编码已存在，请重新输入！"));
}
SysRole.Name = model.RoleName;
}
else
{
AC_SysRoles Role = new AC_SysRoles();
Role.Code = model.Code;
Role.Name = model.RoleName;
dbContext.AC_SysRoles.Add(Role);
}
dbContext.Configuration.ValidateOnSaveEnabled = false;
dbContext.SaveChanges();
dbContext.Configuration.ValidateOnSaveEnabled = true;
return(JsonResultHelper.JsonResult(0, "操作成功"));
}
catch (Exception ex)
{
return(JsonResultHelper.JsonResult(1000, ex.Message));
}
}
public override void When()
{
resultHelper = new JsonResultHelper<UpdateMatchResponseViewModel>(controller.UpdateMatch(viewModel));
}
public override void When()
{
resultHelper = new JsonResultHelper<AjaxUpdateResponseViewModel>(controller.UpdateName(viewModel));
}
