/// <summary>
/// 设置当前用户访问的公司
/// </summary>
/// <param name="buguid"></param>
/// <param name="BUName"></param>
/// <param name="IsEndCompany"></param>
/// <returns></returns>
public void SetBU(DDTreeItem item)
{
// if (item.isend == 0) return;
HttpContext context = HttpContext.Current;
context.Session["BUGUID"] = item.id;
context.Session["BUName"] = item.name;
context.Session["IsEndCompany"] = item.isend;
// context.Session["MySessionState"] = Guid.NewGuid().ToString();
// 保存到Cookie
context.Response.Cookies["mycrm_company"].Value = item.id;
context.Response.Cookies["mycrm_company"].Expires = DateTime.Now.AddDays(365);
//是否末级公司
context.Response.Cookies["mycrm_isendcompany"].Value = item.isend.ToString();
context.Response.Cookies["mycrm_isendcompany"].Expires = DateTime.Now.AddDays(365);
////在临时表中保存当前公司
////254类型为 Mysoft.Map.Utility.General
object invokeResult = null;
if (!ReflectionHelper.TryInvokeMethod("Mysoft.Map.Utility.GeneralBase.InsertKeywordValue2myTemp", "Mysoft.Map.Core", out invokeResult, context.Session["UserGUID"] + "_" + context.Session.SessionID, "[当前公司]", item.id))
{
ReflectionHelper.TryInvokeMethod("Mysoft.Map.Utility.General.InsertKeywordValue2myTemp", "Mysoft.Map.Core", out invokeResult, context.Session["UserGUID"] + "_" + context.Session.SessionID, "[当前公司]", item.id);
}
//// 切换公司时清除桌面部件的缓存
//ReflectionHelper.InvokeMethodSafe("Mysoft.Map.Caching.MyCache.ClearDeskTempFile", "Mysoft.Map.Core", context.Session["UserGUID"].ToString());
}
public string SetValue(DDTreeItem item)
{
switch (item.type)
{
case TreeType.Group:
case TreeType.Company:
case TreeType.EndCompany:
SetBU(item);
break;
case TreeType.Project:
case TreeType.EndProject:
SetProject(item);
var bu = DBHelper.First <DDTreeItem>("select BUGUID id,BUName name,IsEndCompany isend from myBusinessUnit where buguid in (select buguid from dbo.p_Project WHERE ProjGUID=@0)", item.id);
SetBU(bu);
break;
case TreeType.Dept:
var bu1 = DBHelper.First <DDTreeItem>("select BUGUID id,BUName name,IsEndCompany isend from myBusinessUnit where buguid in (select CompanyGUID from dbo.myBusinessUnit WHERE buguid=@0)", item.id);
SetBU(bu1);
break;
}
var updateSql = @"delete myCurrArgs where ObjType=@ObjType;
INSERT INTO dbo.myCurrArgs( UserGUID , ObjType , ArgGUID , LastUpdate )
VALUES ( @UserGUID ,@ObjType,@ArgGUID,getdate())";
DBHelper.Execute(updateSql, new { UserGUID = HttpContext.Current.Session["UserGUID"], ObjType = item.type.ToString(), ArgGUID = item.id });
return(string.Empty);
}
public List <IDDTreeItem> GetProject(string userguid, string applySys)
{
var sql = @"SELECT p.ProjGUID,
p.ProjShortName,
p.Level ,
p.IfEnd,
BU.HierarchyCode + '.' + SUBSTRING(P.ProjCode,CHARINDEX('.', P.ProjCode) + 1, 100) AS Code
FROM p_Project p ,
e_myBusinessUnit BU
WHERE P.BUGUID = BU.BUGUID
AND EXISTS ( SELECT 1
FROM p_Project p2
WHERE (1=1)
AND (p2.ProjCode=p.ProjCode OR p2.ProjCode LIKE p.ProjCode+'.%' )
)
order by BU.HierarchyCode,P.ProjCode ";
var projs = (string)ReflectionHelper.InvokeMethod("Mysoft.Map.Data.MyDB.GetProjectString", "Mysoft.Map.Core", userguid, "", applySys, true);
sql = sql.Replace("1=1", " p2.ProjGUID IN ( " + projs + ") ");
var table = DBHelper.GetDataTable(sql);
var list = GetCompany(userguid);
//var TreeType = { Group: 0, Dept: 1, Team: 2, ProjectTeam: 3, Company: 4, EndCompany: 5, Project: 6, EndProject: 7 }
for (int i = 0; i < table.Rows.Count; i++)
{
var item = new DDTreeItem();
var row = table.Rows[i];
item.code = row["Code"].ToString();
item.id = row["ProjGUID"].ToString();
item.name = row["ProjShortName"].ToString();
item.isend = Convert.ToInt32(row["IfEnd"]);
item.type = TreeType.Project;
if (item.isend == 1)
{
item.type = TreeType.EndProject;
}
list.Add(item);
}
return(list);
}
public List <IDDTreeItem> GetDept(string userguid)
{
var sql = @" SELECT BUGUID as DeptGUID,BUName as DeptShortName,HierarchyCode as DeptCode from myBusinessUnit
where BuType in ('1') AND IsFc=0 and (1=1) order by HierarchyCode";
var list = GetCompany(userguid);
var buguids = list.Select(o => o.id).ToArray();
var filter = " CompanyGUID in ('" + string.Join("','", buguids) + "')";
sql = sql.Replace("1=1", filter);
var table = DBHelper.GetDataTable(sql);
for (int i = 0; i < table.Rows.Count; i++)
{
var item = new DDTreeItem();
var row = table.Rows[i];
item.code = row["DeptCode"].ToString();
item.id = row["DeptGUID"].ToString();
item.name = row["DeptShortName"].ToString();
item.type = TreeType.Dept;
list.Add(item);
}
return(list);
}
public void SetProject(DDTreeItem item)
{
}
/// <summary>
/// 获取当前用户可以访问的公司
/// </summary>
/// <param name="userguid"></param>
/// <returns></returns>
public List <IDDTreeItem> GetCompany(string userguid)
{ //整棵公司树
string strSQL = "";
userguid = userguid ?? CurrentUser.Current.UserGUID;
//根据用户岗位获取有权限的公司
if ((bool)ReflectionHelper.InvokeMethod("Mysoft.Map.Application.Security.User.IsAdmin", "Mysoft.Map.Core", userguid))
{
//系统管理员有所属公司所有权限
strSQL = @"SELECT bu.OrderHierarchyCode FROM myBusinessUnit AS bu RIGHT OUTER JOIN myUser AS u ON bu.BUGUID = u.BUGUID WHERE u.UserGUID = '" + userguid + "'";
var strCode = DBHelper.ExecuteScalarString(strSQL);
strSQL = "SELECT myBusinessUnit.BUGUID AS GUID ,BUName AS Name,myBusinessUnit.HierarchyCode AS Code,ISNULL(myBusinessUnit.Level, 0) AS Level,myBusinessUnit.IsEndCompany FROM myBusinessUnit WHERE BUType = 0 AND OrderHierarchyCode + '.' LIKE '" + strCode + ".%' order by OrderHierarchyCode";
}
else
{
// 取用户岗位所属公司
strSQL = @"SELECT b.OrderHierarchyCode FROM myBusinessUnit AS b
RIGHT OUTER JOIN ( SELECT ISNULL(s.CompanyGUID, u.BUGUID) AS BUGUID FROM myStation AS s RIGHT OUTER JOIN myStationUser AS su ON s.StationGUID = su.StationGUID
RIGHT OUTER JOIN myUser AS u ON su.UserGUID = u.UserGUID WHERE u.UserGUID ='" + userguid + "' ) AS ub ON b.BUGUID = ub.BUGUID";
// 取用户物理所属公司
strSQL += @" UNION SELECT b.OrderHierarchyCode FROM myBusinessUnit AS b INNER JOIN myUser AS u ON u.BUGUID=b.BUGUID
WHERE u.UserGUID ='" + userguid + "'";
// strSQL = "SELECT b1.BUGUID AS GUID ,BUName AS Name,b1.HierarchyCode AS Code,ISNULL(b1.Level, 0) AS Level,b1.IsEndCompany FROM myBusinessUnit AS b1 INNER JOIN (" + strSQL + ") AS b2 ON b1.OrderHierarchyCode + '.' LIKE b2.OrderHierarchyCode + '.%' WHERE b1.BUType = 0 order by b1.OrderHierarchyCode";
strSQL = "SELECT b1.BUGUID FROM myBusinessUnit AS b1 INNER JOIN (" + strSQL + ") AS b2 ON b1.OrderHierarchyCode + '.' LIKE b2.OrderHierarchyCode + '.%' WHERE b1.BUType = 0 ";
strSQL = "select BUGUID AS GUID ,BUName AS Name,HierarchyCode AS Code,ISNULL(Level, 0) AS Level,IsEndCompany FROM myBusinessUnit where BUGUID in (" + strSQL + ") order by OrderHierarchyCode";
}
var dtRights = DBHelper.GetDataTable(strSQL);
//创建临时表
var list = new List <IDDTreeItem>();
//var TreeType = { Group: 0, Dept: 1, Team: 2, ProjectTeam: 3, Company: 4, EndCompany: 5, Project: 6, EndProject: 7 }
for (int i = 0; i < dtRights.Rows.Count; i++)
{
var item = new DDTreeItem();
var row = dtRights.Rows[i];
item.code = row["Code"].ToString();
item.id = row["GUID"].ToString();
item.name = row["Name"].ToString();
item.isend = Convert.ToInt32(row["IsEndCompany"]);
if (item.isend == 1)
{
item.type = TreeType.EndCompany;
}
else
{
if (Convert.ToInt32(row["Level"]) == 0)
{
item.type = TreeType.Group;
}
else
{
item.type = TreeType.Company;
}
}
list.Add(item);
}
return(list);
}