public string SetBankRole() { string returnValue = ""; try { string EmployeeID = Request.Form["EmployeeID"]; string BankIDString = Request.Form["BankIDString"]; Panasia.Core.Sys.SystemParameterFunctions sysParameter = new Core.Sys.SystemParameterFunctions(); string userID = sysParameter.GetCurrentUserID("").ToString(); DateTime now = DateTime.Now; bi_Bank_Role entity = new bi_Bank_Role(); System.Data.Entity.DbContext dbSys = new System.Data.Entity.DbContext("PASys"); var result = dbSys.Database.SqlQuery(null, "EXEC sp_CreateSerialCode 'Bank_Role', 'BR' , 6, @Bank_Role_ID", new System.Data.SqlClient.SqlParameter("@Bank_Role_ID", null)); entity.Bank_Role_ID = ""; entity.EmployeesID = EmployeeID; entity.Bank_ID_List = BankIDString; entity.CreatedUser = userID; entity.CreatedTime = now; entity.ModifiedUser = userID; entity.ModifiedTime = now; entity.IsActive = true; db.bi_Bank_Role.Add(entity); if (db.SaveChanges() == 1) { returnValue = "设置成功"; } else { returnValue = "设置失败,请重试"; } } catch { returnValue = "系统出现错误,请联系管理员"; } return(returnValue); }
public ActionResult InitOrgTree() { SysContext db = new SysContext(); defaultDataType = Request.QueryString["defaultDataType"].ToLower(); defaultData = Request.QueryString["defaultData"]; if (!string.IsNullOrEmpty(defaultData) && !string.IsNullOrEmpty(defaultDataType)) { if (defaultData.ToLower() == "[user]") { if (User == null) { defaultData = ""; } else { Panasia.Core.Sys.SystemParameterFunctions sysParameter = new Core.Sys.SystemParameterFunctions(); string userID = sysParameter.GetCurrentUserID("").ToString(); //登录的时候没有把公司部门等ID信息放到登录者信息中去,这里暂时用数据库查询的方式获取,以后可以改 string departmentID = dbsys.hr_Employees.Where(e => e.UserID == userID).Select(e => e.DeptID).ToList()[0]; if (defaultDataType == "c") { defaultData = db.hr_Depts.Find(departmentID).CompanyID; } else if (defaultDataType == "d") { defaultData = departmentID; } } } } List <hr_Company> companies = null; //这里的逻辑是这样的,不管defaultDataType是c还是d,company肯定都只有特定的一个了 if (defaultDataType == "c" || defaultDataType == "d") { if (defaultDataType == "c") { companies = db.hr_Companies.Where(c => c.IsActive && c.CompanyID == defaultData).ToList(); } else if (defaultDataType == "d") { hr_Department dept = db.hr_Depts.Find(defaultData); companies = db.hr_Companies.Where(c => c.IsActive && c.CompanyID == dept.CompanyID).ToList(); } } else { companies = db.hr_Companies.Where(c => c.IsActive).OrderBy(c => c.SortID).ToList(); } List <hr_Department> all_depts = null; List <hr_Job> all_jobs = null; List <hr_Employee> all_emps = null; //type:1、全部呈现,包括公司,部门,职位和员工 2、公司、部门、职位 3、公司、部门 4、公司 int configType = 1; int.TryParse(Request.QueryString["configType"], out configType); if (configType < 4) { if (defaultDataType == "d") { all_depts = new List <hr_Department>(); GetListWithAllParent(defaultData, db.hr_Depts.ToList(), all_depts); } else { all_depts = db.hr_Depts.Where(d => d.IsActive).OrderBy(c => c.SortID).ToList(); } } if (configType < 3) { //因为部门职位需要通过员工来查询,所以<3的就全部信息都需要了 all_jobs = db.hr_Jobs.Where(j => j.IsActive).OrderBy(j => j.SortID).ToList(); all_emps = dbsys.hr_Employees.Where(e => e.IsActive).ToList(); } state = Request.QueryString["defaultState"]; if (state == "1") { state = "open"; } else { state = "closed"; } List <TreeNodeExtend> tree = new List <TreeNodeExtend>(); if (companies.Count > 0) { foreach (hr_Company company in companies) { TreeNodeExtend node = new TreeNodeExtend(); node.id = company.CompanyID; node.text = company.Name; node.type = "c"; node.iconCls = "icon-company"; if (configType < 4) { List <TreeNodeExtend> children = DepartmentChildren(company.CompanyID, "", all_depts, all_jobs, all_emps, configType); if (children.Count > 0) { node.state = state; node.children.AddRange(children); } } tree.Add(node); } } JsonResult json = Json(tree, JsonRequestBehavior.AllowGet); return(json); }