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);
}
