/// <summary>
/// 注册地区树形结构展开
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void RegionTreeView_TreeNodePopulate(object sender, EpointTreeNodeEventArgs e)
{
EpointTreeNode nodeArg = e.Node;
EpointTreeNode nodeVar;
DataView dv;
int i = 0;
dv = DataBaseFunc.Instace.GetTreeLevelTwo(nodeArg.Value, "f7f84f2a-de8a-4bc2-b13d-e541f73b12a8", "");
for (i = 0; i < dv.Count; i++)
{
nodeVar = new EpointTreeNode(dv[i]["ItemText"].ToString(), dv[i]["ItemCode"].ToString()); //实例化一个节点
DataView dv2 = DataBaseFunc.Instace.GetTreeLevelTwo(dv[i]["ItemCode"].ToString(), "f7f84f2a-de8a-4bc2-b13d-e541f73b12a8", "");
if (dv2.Count > 0)
{
nodeVar.ShowInputCtrl = false;
nodeVar.PopulateOnDemand = true;
nodeVar.ExpandOnCheckedChanged = false;
nodeVar.SelectLeafForTextTreeView = false;
nodeVar.ShowImage = false;
}
else
{
nodeVar.ShowInputCtrl = true;
nodeVar.PopulateOnDemand = false;
nodeVar.ShowImage = false;
nodeVar.SelectLeafForTextTreeView = true;
nodeVar.CanSelectForTextTreeView = true;
nodeVar.ReturnFullPath = true;
}
nodeArg.ChildNodes.Add(nodeVar);
}
}
protected void TreeView1_TreeNodePopulate1(object sender, EpointTreeNodeEventArgs e)
{
EpointTreeNode pNode = e.Node;
DataView dvMa = null;
EpointTreeNode node;
//Boolean IsApp = Epoint.MisBizLogic2.DB.ExecuteToInt("select count(RowGuid) from RG_Application where RowGuid='" + pNode.Value + "'") == 1;//节点是否是子系统
dvMa = NextFloor(pNode.Value);
for (int i = 0; i < dvMa.Count; i++)
{
node = new EpointTreeNode();
node.Text = dvMa[i]["MatterName"].ToString();
node.Value = dvMa[i]["RowGuid"].ToString();
if (IsLeaf(node))
{
node.PopulateOnDemand = false;
}
else
{
node.PopulateOnDemand = true;
}
node.NavigateUrl = "Matter_List.aspx?ParentGuid=" + node.Value;
pNode.ChildNodes.Add(node);
}
}
protected void TreeView1_TreeNodePopulate1(object sender, EpointTreeNodeEventArgs e)
{
EpointTreeNode pNode = e.Node;
DataView dvMo = SelectSecond(pNode.Value);
EpointTreeNode node;
for (int i = 0; i < dvMo.Count; i++)
{
node = new EpointTreeNode();
node.Text = dvMo[i]["ModuleName"].ToString();
node.Value = dvMo[i]["RowGuid"].ToString();
//if (!Convert.ToBoolean(Dv_Category[i]["IsLeaf"]))
if (IsLeaf(node))
{
node.PopulateOnDemand = false;
}
else
{
node.PopulateOnDemand = true;
}
node.NavigateUrl = "Record_List.aspx?IsBelongtoApp=0&ParentGuid=" + node.Value;
pNode.ChildNodes.Add(node);
}
}
protected void TreeView1_TreeNodePopulate1(object sender, EpointTreeNodeEventArgs e)
{
EpointTreeNode pNode = e.Node;
DataView dv = ous.Select(pNode.Value);
EpointTreeNode node;
// string argsGuid = Request["argsGuid"].ToLower();
int HasChildOu = 0;
for (int i = 0; i < dv.Count; i++)
{
node = new EpointTreeNode();
node.Text = dv[i]["OUName"].ToString();
node.Value = dv[i]["OUGuid"].ToString();
HasChildOu = Epoint.Common.Functions.IntNull(Convert.ToString(dv[i]["HasChildOu"]));
if (HasChildOu > 0)
{
node.PopulateOnDemand = true;
node.RunClickEvtOnInit = false; //是否在生成checkbox的时候运行click事件
node.ExpandOnCheckedChanged = false; //是否在checkbox变化的时候自动展开
}
node.ShowInputCtrl = true;
node.CtrlClickFunction = "AutoSetOuValue(this,'" + node.Text + "','" + node.Value + "');";
pNode.ChildNodes.Add(node);
}
}
/// <summary>
/// 注册地区树形结构展开
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void RegionTreeView_TreeNodePopulate(object sender, EpointTreeNodeEventArgs e)
{
EpointTreeNode nodeArg = e.Node;
EpointTreeNode nodeVar;
string strLeft = "";
DataView dv;
int i = 0;
dv = DataBaseFunc.Instace.GetTreeLevelTwo(nodeArg.Value, "29b7967e-8098-42d5-8b40-ec757b0865a5", "");
for (i = 0; i < dv.Count; i++)
{
nodeVar = new EpointTreeNode(dv[i]["ItemText"].ToString(), dv[i]["ItemCode"].ToString()); //实例化一个节点
//nodeVar.Checked = false;
nodeVar.ShowInputCtrl = true;
nodeVar.PopulateOnDemand = false;
nodeVar.ReturnFullPath = true;
nodeVar.ShowImage = false;
//判断下是否已经被选中
if (RegionTreeView.Value.IndexOf(nodeVar.Value+";") >= 0)
{
nodeVar.Checked = true;
}
nodeArg.ChildNodes.Add(nodeVar);
}
}
protected void TreeView1_TreeNodePopulate1(object sender, EpointTreeNodeEventArgs e)
{
EpointTreeNode pNode = e.Node;
DataView dv = ous.Select(pNode.Value);
EpointTreeNode node;
// string argsGuid = Request["argsGuid"].ToLower();
int HasChildOu = 0;
for (int i = 0; i < dv.Count; i++)
{
node = new EpointTreeNode();
node.Text = dv[i]["OUName"].ToString();
node.Value = dv[i]["OUGuid"].ToString();
HasChildOu = Epoint.Common.Functions.IntNull(Convert.ToString(dv[i]["HasChildOu"]));
if (HasChildOu > 0)
{
node.PopulateOnDemand = true;
node.RunClickEvtOnInit = false;//�Ƿ�������checkbox��ʱ������click�¼�
node.ExpandOnCheckedChanged = false;//�Ƿ���checkbox�仯��ʱ���Զ�չ��
}
node.ShowInputCtrl = true;
node.CtrlClickFunction = "AutoSetOuValue(this,'" + node.Text + "','" + node.Value + "');";
pNode.ChildNodes.Add(node);
}
}
/// <summary>
/// 注册地区树形结构展开
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void RegionTreeView_TreeNodePopulate(object sender, EpointTreeNodeEventArgs e)
{
EpointTreeNode nodeArg = e.Node;
EpointTreeNode nodeVar;
string strLeft = "";
DataView dv;
int i = 0;
dv = DataBaseFunc.Instace.GetTreeLevelTwo(nodeArg.Value, "29b7967e-8098-42d5-8b40-ec757b0865a5", "");
for (i = 0; i < dv.Count; i++)
{
nodeVar = new EpointTreeNode(dv[i]["ItemText"].ToString(), dv[i]["ItemCode"].ToString()); //实例化一个节点
//nodeVar.Checked = false;
nodeVar.ShowInputCtrl = true;
nodeVar.PopulateOnDemand = false;
nodeVar.ReturnFullPath = true;
nodeVar.ShowImage = false;
//判断下是否已经被选中
if (RegionTreeView.Value.IndexOf(nodeVar.Value + ";") >= 0)
{
nodeVar.Checked = true;
}
nodeArg.ChildNodes.Add(nodeVar);
}
}
protected void TreeView1_TreeNodePopulate1(object sender, EpointTreeNodeEventArgs e)
{
EpointTreeNode pNode = e.Node;
Boolean IsApp = Epoint.MisBizLogic2.DB.ExecuteToInt("select count(RowGuid) from RG_Application where RowGuid='" + pNode.Value + "'") == 1;//pNode是否子系统
DataView dvMo = NextFloor(pNode.Value, IsApp);
EpointTreeNode node;
for (int i = 0; i < dvMo.Count; i++)
{
node = new EpointTreeNode();
node.Text = dvMo[i]["ModuleName"].ToString();
node.Value = dvMo[i]["RowGuid"].ToString();
if (IsLeafextra(node))
{
node.PopulateOnDemand = false;
}
else
{
node.PopulateOnDemand = true;
}
node.NavigateUrl = "../RG_Module/Record_List.aspx?IsBelongtoApp=1&ParentGuid=" + node.Value + "&AppGuid=" + dvMo[i]["AppGuid"].ToString();
pNode.ChildNodes.Add(node);
}
}
protected void TreeView1_TreeNodePopulate1(object sender, EpointTreeNodeEventArgs e)
{
try
{
EpointTreeNode pNode = e.Node;
DataView dv = mana.BoxSelectByBoxGroupID(pNode.Value);//选择组别下所有的邮箱
DataView dvRight = mana.SelectHandleUser();//选择权限
string FilterStr = "(HandleType='P' and HandleDetail='" + Session["UserGuid"].ToString() + "') ";
string OuGuid = Session["OuGuid"].ToString();
while (OuGuid != "")
{
FilterStr += " or (HandleType='D' and HandleDetail='" + OuGuid + "') ";
OuGuid = dept.GetDetail(OuGuid).ParentOUGuid;
}
dvRight.RowFilter = FilterStr;
EpointTreeNode node;
for (int i = 0; i < dv.Count; i++)
{
for (int j = 0; j < dvRight.Count; j++)
{
if (dvRight[j]["BoxGuid"].ToString() == dv[i]["BoxGuid"].ToString())
{
node = new EpointTreeNode();
node.Text = dv[i]["BoxName"].ToString();
node.Value = dv[i]["BoxGuid"].ToString();
node.PopulateOnDemand = false;
node.NavigateUrl = "ConsultBoxListMana.aspx?BoxGuid=" + dv[i]["BoxGuid"];
EpointTreeNode node2 = new EpointTreeNode();
node2.Text = "未处理";
node2.Value = "未处理";
node2.PopulateOnDemand = false;
node2.NavigateUrl = "ConsultBoxListMana.aspx?BoxGuid=" + dv[i]["BoxGuid"] + "&jpdProcesstype=0";
node.ChildNodes.Add(node2);
node2 = new EpointTreeNode();
node2.Text = "已处理";
node2.Value = "已处理";
node2.PopulateOnDemand = false;
node2.NavigateUrl = "ConsultBoxListMana.aspx?BoxGuid=" + dv[i]["BoxGuid"] + "&jpdProcesstype=1";
node.ChildNodes.Add(node2);
pNode.ChildNodes.Add(node);
break;
}
}
}
}
catch (Exception er)
{
Epoint.Common.Log.WriteLog(er.ToString());
}
}
protected void TreeViewUserList_TreeNodePopulate(object sender, EpointTreeNodeEventArgs e)
{
EpointTreeNode pNode = e.Node;
//DataView dvMo = Epoint.MisBizLogic2.DB.ExecuteDataView("select RoleName,RowGuid from RG_Role where UserType='" + pNode.Value + "'");
//DataView dvMo2 = Epoint.MisBizLogic2.DB.ExecuteDataView("select S.DispName,S.RowGuid from RG_User as S inner join RG_User_Role as C on(S.RowGuid=C.RGUserGuid) where C.RoleGuid='" + pNode.Value + "' and S.UserStatus=002 and S.IsValid=1 and DelFlag=0");
//DataView dvMo3 = Epoint.MisBizLogic2.DB.ExecuteDataView("select S.DispName,S.RowGUid from RG_User as S where not exists(select * from RG_User_Role where S.RowGuid=RG_User_Role.RGUserGuid) and UserType='" + pNode.Value + "' and S.UserStatus=002 and S.IsValid=1 and DelFlag=0");
DataView dvMo = Epoint.MisBizLogic2.DB.ExecuteDataView("select DispName,RowGuid from RG_User where usertype like '%" + pNode.Value + ";%'");
EpointTreeNode node;
if (dvMo.Count > 0)
{
for (int i = 0; i < dvMo.Count; i++)
{
node = new EpointTreeNode();
node.Text = dvMo[i]["DispName"].ToString();
node.Value = dvMo[i]["RowGuid"].ToString();
//Boolean isleaf = Epoint.MisBizLogic2.DB.ExecuteToInt("select count(S.RowGuid) from RG_User as S inner join RG_User_Role as C on(S.RowGuid=C.RGUserGuid) where C.RoleGuid='" + node.Value + "' and S.UserStatus=002 and S.IsValid=1 and DelFlag=0") == 0;
//if (isleaf)
node.PopulateOnDemand = false;
//else
// node.PopulateOnDemand = true;
node.ShowInputCtrl = true;
node.CtrlClickFunction = "AutoSetPValue(this, '" + node.Text + "', '" + node.Value + "')";
//node.CtrlClickFunction = "AutoSetPValue(this, '" + node.Text + "', '" + node.Value + "')";
pNode.ChildNodes.Add(node);
}
}
//else if (dvMo2.Count > 0)
//{
// for (int j = 0; j < dvMo2.Count; j++)
// {
// node = new EpointTreeNode();
// node.Text = dvMo2[j]["DispName"].ToString();
// node.Value = dvMo2[j]["RowGuid"].ToString();
// node.PopulateOnDemand = false;
// node.CtrlClickFunction = "AutoSetPValue(this, '" + node.Text + "', '" + node.Value + "')";
// pNode.ChildNodes.Add(node);
// }
//}
//if (dvMo3.Count > 0)
//{
// for (int k = 0; k < dvMo3.Count; k++)
// {
// node = new EpointTreeNode();
// node.Text = dvMo3[k]["DispName"].ToString();
// node.Value = dvMo3[k]["RowGuid"].ToString();
// node.PopulateOnDemand = false;
// node.ShowInputCtrl = true;
// node.CtrlClickFunction = "AutoSetPValue(this, '" + node.Text + "', '" + node.Value + "')";
// pNode.ChildNodes.Add(node);
// }
//}
}
/// <summary>
/// 注册地区树形结构展开
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void RegionTreeView_TreeNodePopulate(object sender, EpointTreeNodeEventArgs e)
{
EpointTreeNode nodeArg = e.Node;
EpointTreeNode nodeVar;
TextTreeView ttv = (TextTreeView)sender;
string strLeft = "";
DataView dv;
int i = 0;
if (CommonFunc.Right(nodeArg.Value, 4) == "0000") //第一级加载第二级
{
strLeft = CommonFunc.Left(nodeArg.Value, 2);
dv = DataBaseFunc.Instace.GetCityLevelTwo(strLeft, nodeArg.Value);
for (i = 0; i < dv.Count; i++)
{
nodeVar = new EpointTreeNode(dv[i]["CityName"].ToString(), dv[i]["CityCode"].ToString()); //实例化一个节点
nodeVar.ExpandOnCheckedChanged = true;
nodeVar.Checked = false;
nodeVar.ShowInputCtrl = false;
nodeVar.RunClickEvtOnInit = true;
nodeVar.PopulateOnDemand = true;
nodeVar.ReturnFullPath = true;
nodeVar.ShowImage = true;
nodeVar.SelectLeafForTextTreeView = false;
nodeArg.ChildNodes.Add(nodeVar);
}
}
if (CommonFunc.Right(nodeArg.Value, 2) == "00") //第二级加载第三级
{
strLeft = CommonFunc.Left(nodeArg.Value, 4);
dv = DataBaseFunc.Instace.GetCityLevelThree(strLeft);
for (i = 0; i < dv.Count; i++)
{
nodeVar = new EpointTreeNode(dv[i]["CityName"].ToString(), dv[i]["CityCode"].ToString()); //实例化一个节点
nodeVar.ExpandOnCheckedChanged = true;
nodeVar.ShowInputCtrl = true;
if (nodeVar.Value == ttv.Value)
{
nodeVar.Checked = true;
}
else
{
nodeVar.Checked = false;
}
nodeVar.RunClickEvtOnInit = true;
nodeVar.PopulateOnDemand = false;
nodeVar.ReturnFullPath = true;
nodeVar.ShowImage = false;
nodeArg.ChildNodes.Add(nodeVar);
}
}
}
protected void TreeViewUserList_TreeNodePopulate(object sender, EpointTreeNodeEventArgs e)
{
EpointTreeNode pNode = e.Node;
//DataView dvMo = Epoint.MisBizLogic2.DB.ExecuteDataView("select RoleName,RowGuid from RG_Role where UserType='" + pNode.Value + "'");
//DataView dvMo2 = Epoint.MisBizLogic2.DB.ExecuteDataView("select S.DispName,S.RowGuid from RG_User as S inner join RG_User_Role as C on(S.RowGuid=C.RGUserGuid) where C.RoleGuid='" + pNode.Value + "' and S.UserStatus=002 and S.IsValid=1 and DelFlag=0");
//DataView dvMo3 = Epoint.MisBizLogic2.DB.ExecuteDataView("select S.DispName,S.RowGUid from RG_User as S where not exists(select * from RG_User_Role where S.RowGuid=RG_User_Role.RGUserGuid) and UserType='" + pNode.Value + "' and S.UserStatus=002 and S.IsValid=1 and DelFlag=0");
DataView dvMo = Epoint.MisBizLogic2.DB.ExecuteDataView("select DispName,RowGuid from RG_User where usertype like '%" + pNode.Value + ";%'");
EpointTreeNode node;
if (dvMo.Count > 0)
{
for (int i = 0; i < dvMo.Count; i++)
{
node = new EpointTreeNode();
node.Text = dvMo[i]["DispName"].ToString();
node.Value = dvMo[i]["RowGuid"].ToString();
//Boolean isleaf = Epoint.MisBizLogic2.DB.ExecuteToInt("select count(S.RowGuid) from RG_User as S inner join RG_User_Role as C on(S.RowGuid=C.RGUserGuid) where C.RoleGuid='" + node.Value + "' and S.UserStatus=002 and S.IsValid=1 and DelFlag=0") == 0;
//if (isleaf)
node.PopulateOnDemand = false;
//else
// node.PopulateOnDemand = true;
node.ShowInputCtrl = true;
node.CtrlClickFunction = "AutoSetPValue(this, '" + node.Text + "', '" + node.Value + "')";
//node.CtrlClickFunction = "AutoSetPValue(this, '" + node.Text + "', '" + node.Value + "')";
pNode.ChildNodes.Add(node);
}
}
//else if (dvMo2.Count > 0)
//{
// for (int j = 0; j < dvMo2.Count; j++)
// {
// node = new EpointTreeNode();
// node.Text = dvMo2[j]["DispName"].ToString();
// node.Value = dvMo2[j]["RowGuid"].ToString();
// node.PopulateOnDemand = false;
// node.CtrlClickFunction = "AutoSetPValue(this, '" + node.Text + "', '" + node.Value + "')";
// pNode.ChildNodes.Add(node);
// }
//}
//if (dvMo3.Count > 0)
//{
// for (int k = 0; k < dvMo3.Count; k++)
// {
// node = new EpointTreeNode();
// node.Text = dvMo3[k]["DispName"].ToString();
// node.Value = dvMo3[k]["RowGuid"].ToString();
// node.PopulateOnDemand = false;
// node.ShowInputCtrl = true;
// node.CtrlClickFunction = "AutoSetPValue(this, '" + node.Text + "', '" + node.Value + "')";
// pNode.ChildNodes.Add(node);
// }
//}
}
protected void TreeView1_TreeNodePopulate1(object sender, EpointTreeNodeEventArgs e)
{
try
{
EpointTreeNode pNode = e.Node;
DataView dv = mana.BoxSelectByBoxGroupID(pNode.Value); //选择组别下所有的邮箱
DataView dvRight = mana.SelectHandleUser(); //选择权限
string FilterStr = "(HandleType='P' and HandleDetail='" + Session["UserGuid"].ToString() + "') ";
string OuGuid = Session["OuGuid"].ToString();
while (OuGuid != "")
{
FilterStr += " or (HandleType='D' and HandleDetail='" + OuGuid + "') ";
OuGuid = dept.GetDetail(OuGuid).ParentOUGuid;
}
dvRight.RowFilter = FilterStr;
EpointTreeNode node;
for (int i = 0; i < dv.Count; i++)
{
for (int j = 0; j < dvRight.Count; j++)
{
if (dvRight[j]["BoxGuid"].ToString() == dv[i]["BoxGuid"].ToString())
{
node = new EpointTreeNode();
node.Text = dv[i]["BoxName"].ToString();
node.Value = dv[i]["BoxGuid"].ToString();
node.PopulateOnDemand = false;
node.NavigateUrl = "ConsultBoxListMana.aspx?BoxGuid=" + dv[i]["BoxGuid"];
EpointTreeNode node2 = new EpointTreeNode();
node2.Text = "未处理";
node2.Value = "未处理";
node2.PopulateOnDemand = false;
node2.NavigateUrl = "ConsultBoxListMana.aspx?BoxGuid=" + dv[i]["BoxGuid"] + "&jpdProcesstype=0";
node.ChildNodes.Add(node2);
node2 = new EpointTreeNode();
node2.Text = "已处理";
node2.Value = "已处理";
node2.PopulateOnDemand = false;
node2.NavigateUrl = "ConsultBoxListMana.aspx?BoxGuid=" + dv[i]["BoxGuid"] + "&jpdProcesstype=1";
node.ChildNodes.Add(node2);
pNode.ChildNodes.Add(node);
break;
}
}
}
}
catch (Exception er)
{
Epoint.Common.Log.WriteLog(er.ToString());
}
}
/// <summary>
///
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void AppManager_TreeNodePopulate(object sender, EpointTreeNodeEventArgs e)
{
EpointTreeNode pNode = e.Node;
DataView dvMo = Epoint.MisBizLogic2.DB.ExecuteDataView("select DisplayName,UserGuid from Frame_User where OUGuid='" + pNode.Value + "'");
EpointTreeNode node;
for (int i = 0; i < dvMo.Count; i++)
{
node = new EpointTreeNode();
node.Text = dvMo[i]["DisplayName"].ToString();
node.Value = dvMo[i]["UserGuid"].ToString();
node.PopulateOnDemand = false;
pNode.ChildNodes.Add(node);
}
}
/// <summary>
///
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void AppManager_TreeNodePopulate(object sender, EpointTreeNodeEventArgs e)
{
EpointTreeNode pNode = e.Node;
DataView dvMo = Epoint.MisBizLogic2.DB.ExecuteDataView("select DisplayName,UserGuid from Frame_User where OUGuid='" + pNode.Value + "'");
EpointTreeNode node;
for (int i = 0; i < dvMo.Count; i++)
{
node = new EpointTreeNode();
node.Text = dvMo[i]["DisplayName"].ToString();
node.Value = dvMo[i]["UserGuid"].ToString();
node.PopulateOnDemand = false;
pNode.ChildNodes.Add(node);
}
}
/// <summary>
/// 添加信箱
/// </summary>
protected void TextTreeView1_TreeNodePopulate(object sender, EpointTreeNodeEventArgs e)
{
EpointTreeNode PNode = e.Node;
PNode.ShowInputCtrl = true;
DataView dv = BoxMana.BoxSelectByBoxGroupID(PNode.Value);//选择组别下所有的邮箱
EpointTreeNode node;
for (int i = 0; i < dv.Count; i++)
{
node = new EpointTreeNode();
node.ShowInputCtrl = true;
node.Text = dv[i]["BoxName"].ToString();
node.Value = dv[i]["BoxGuid"].ToString();
PNode.ChildNodes.Add(node);
}
}
/// <summary>
/// 加载会员角色
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void TreeViewRoleList_TreeNodePopulate(object sender, EpointTreeNodeEventArgs e)
{
EpointTreeNode pNode = e.Node;
DataView dvMo = Epoint.MisBizLogic2.DB.ExecuteDataView("select RoleName,RowGuid from RG_Role where UserType='" + pNode.Value.Split('@')[0] + "'");
EpointTreeNode node;
for (int i = 0; i < dvMo.Count; i++)
{
node = new EpointTreeNode();
node.Text = dvMo[i]["RoleName"].ToString();
node.Value = dvMo[i]["RowGuid"].ToString() + "@Role";
node.PopulateOnDemand = false;
node.CtrlClickFunction = "AutoSetPValue(this, '" + node.Text + "', '" + node.Value + "')";
pNode.ChildNodes.Add(node);
}
}
protected void TreeViewOUUserList_TreeNodePopulate(object sender, EpointTreeNodeEventArgs e)
{
EpointTreeNode pNode = e.Node;
EpointTreeNode node;
// 判断父节点是不是会员单位类别
string[] nodevalues = e.Node.Value.Split('&');
if (nodevalues.Length == 2 && nodevalues[1] == "0")
{
// 加载单位类别下的所有单位
string sql = "SELECT RG_OuInfo.EnterpriseName, RG_OuInfo.RowGuid,RG_OuType_Relate.OuType FROM RG_OuInfo INNER JOIN RG_OuType_Relate ON RG_OuInfo.rowguid=RG_OuType_Relate.relatedguid WHERE RG_OuType_Relate.RelatedType='Ou' AND RG_OuType_Relate.OuType='" + Epoint.Frame.Bizlogic.common.strReplaceSql(nodevalues[0]) + "'";
DataView dvOu = Epoint.MisBizLogic2.DB.ExecuteDataView(sql);
for (int i = 0; i < dvOu.Count; i++)
{
node = new EpointTreeNode();
node.Text = dvOu[i]["EnterpriseName"].ToString();
node.Value = dvOu[i]["RowGuid"].ToString() + "&" + dvOu[i]["OuType"].ToString();
node.PopulateOnDemand = true;
node.ShowInputCtrl = true;
pNode.ChildNodes.Add(node);
}
}
else
{
// 加载单位下的会员账号
string sql = "SELECT RG_User.DispName, RG_User.RowGuid, RG_User.UserType from RG_User INNER JOIN RG_OuType_Relate ON RG_User.RowGuid=RG_OuType_Relate.RelatedGuid WHERE DanWeiGuid='" + Epoint.Frame.Bizlogic.common.strReplaceSql(nodevalues[0]) + "' AND RG_OuType_Relate.OuType='" + Epoint.Frame.Bizlogic.common.strReplaceSql(nodevalues[1]) + "'";
// 判断是否需要加载 单位子帐号 的会员帐号
if (!Convert.ToBoolean(Epoint.Frame.Bizlogic.Frame_Config.GetConfigValue("RegisterUser_RGMail_ShowAllDanWeiUser", "true")))
{
sql += " AND RG_User.UserType='002'";// 仅仅显示单位管理员会员帐号
}
DataView dvOuUser = Epoint.MisBizLogic2.DB.ExecuteDataView(sql);
for (int j = 0; j < dvOuUser.Count; j++)
{
node = new EpointTreeNode();
node.Text = dvOuUser[j]["DispName"].ToString();
node.Value = dvOuUser[j]["RowGuid"].ToString() + "&" + nodevalues[1];
node.PopulateOnDemand = false;
node.CtrlClickFunction = "AutoSetPValue(this, '" + node.Text + "', '" + node.Value + "')";
pNode.ChildNodes.Add(node);
}
}
}
/// <summary>
/// 添加信箱
/// </summary>
protected void TextTreeView1_TreeNodePopulate(object sender, EpointTreeNodeEventArgs e)
{
EpointTreeNode PNode = e.Node;
PNode.ShowInputCtrl = true;
DataView dv = BoxMana.BoxSelectByBoxGroupID(PNode.Value);//选择组别下所有的邮箱
EpointTreeNode node;
for (int i = 0; i < dv.Count; i++)
{
node = new EpointTreeNode();
node.ShowInputCtrl = true;
node.Text = dv[i]["BoxName"].ToString();
node.Value = dv[i]["BoxGuid"].ToString();
PNode.ChildNodes.Add(node);
}
}
protected void TreeViewOUUserList_TreeNodePopulate(object sender, EpointTreeNodeEventArgs e)
{
EpointTreeNode pNode = e.Node;
EpointTreeNode node;
// 判断父节点是不是会员单位类别
string[] nodevalues = e.Node.Value.Split('&');
if (nodevalues.Length == 2 && nodevalues[1] == "0")
{
// 加载单位类别下的所有单位
string sql = "SELECT RG_OuInfo.EnterpriseName, RG_OuInfo.RowGuid,RG_OuType_Relate.OuType FROM RG_OuInfo INNER JOIN RG_OuType_Relate ON RG_OuInfo.rowguid=RG_OuType_Relate.relatedguid WHERE RG_OuType_Relate.RelatedType='Ou' AND RG_OuType_Relate.OuType='" + Epoint.Frame.Bizlogic.common.strReplaceSql(nodevalues[0]) + "'";
DataView dvOu = Epoint.MisBizLogic2.DB.ExecuteDataView(sql);
for (int i = 0; i < dvOu.Count; i++)
{
node = new EpointTreeNode();
node.Text = dvOu[i]["EnterpriseName"].ToString();
node.Value = dvOu[i]["RowGuid"].ToString() + "&" + dvOu[i]["OuType"].ToString();
node.PopulateOnDemand = true;
node.ShowInputCtrl = true;
pNode.ChildNodes.Add(node);
}
}
else
{
// 加载单位下的会员账号
string sql = "SELECT RG_User.DispName, RG_User.RowGuid, RG_User.UserType from RG_User INNER JOIN RG_OuType_Relate ON RG_User.RowGuid=RG_OuType_Relate.RelatedGuid WHERE DanWeiGuid='" + Epoint.Frame.Bizlogic.common.strReplaceSql(nodevalues[0]) + "' AND RG_OuType_Relate.OuType='" + Epoint.Frame.Bizlogic.common.strReplaceSql(nodevalues[1]) + "'";
// 判断是否需要加载 单位子帐号 的会员帐号
if (!Convert.ToBoolean(Epoint.Frame.Bizlogic.Frame_Config.GetConfigValue("RegisterUser_RGMail_ShowAllDanWeiUser", "true")))
{
sql += " AND RG_User.UserType='002'";// 仅仅显示单位管理员会员帐号
}
DataView dvOuUser = Epoint.MisBizLogic2.DB.ExecuteDataView(sql);
for (int j = 0; j < dvOuUser.Count; j++)
{
node = new EpointTreeNode();
node.Text = dvOuUser[j]["DispName"].ToString();
node.Value = dvOuUser[j]["RowGuid"].ToString() + "&" + nodevalues[1];
node.PopulateOnDemand = false;
node.CtrlClickFunction = "AutoSetPValue(this, '" + node.Text + "', '" + node.Value + "')";
pNode.ChildNodes.Add(node);
}
}
}
/// <summary>
/// 加载会员角色
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void TreeViewRoleList_TreeNodePopulate(object sender, EpointTreeNodeEventArgs e)
{
EpointTreeNode pNode = e.Node;
DataView dvMo = Epoint.MisBizLogic2.DB.ExecuteDataView("select RoleName,RowGuid from RG_Role where UserType='" + pNode.Value.Split('@')[0] + "'");
EpointTreeNode node;
for (int i = 0; i < dvMo.Count; i++)
{
node = new EpointTreeNode();
node.Text = dvMo[i]["RoleName"].ToString();
node.Value = dvMo[i]["RowGuid"].ToString() + "@Role";
node.PopulateOnDemand = false;
node.CtrlClickFunction = "AutoSetPValue(this, '" + node.Text + "', '" + node.Value + "')";
pNode.ChildNodes.Add(node);
}
}
protected void TreeView1_TreeNodePopulate1(object sender, EpointTreeNodeEventArgs e)
{
EpointTreeNode pNode = e.Node;
DataView dvOu = ous.Select(pNode.Value);
DataView dvUser = user.Select(pNode.Value);
EpointTreeNode node;
for (int j = 0; j < dvUser.Count; j++)
{
node = new EpointTreeNode();
node.Text = dvUser[j]["DisplayName"].ToString();
node.Value = dvUser[j]["userGuid"].ToString();
//当节点为人员时,添加选择框事件
node.CtrlClickFunction = "AutoSetUserValue(this,'" + node.Text + "','" + node.Value + "');";
node.ImageUrl = "../../Images/TreeImages/person.gif";
//节点为人员时,不能展开
node.RunClickEvtOnInit = true;//是否在生成checkbox的时候运行click事件
node.PopulateOnDemand = false;
node.ShowInputCtrl = true;
node.Checked = pNode.Checked;
pNode.ChildNodes.Add(node);
}
int HasChildOu = 0, HasChildUser = 0;
for (int i = 0; i < dvOu.Count; i++)
{
node = new EpointTreeNode();
node.Text = dvOu[i]["OUName"].ToString();
node.Value = dvOu[i]["OUGuid"].ToString();
HasChildOu = Epoint.Common.Functions.IntNull(Convert.ToString(dvOu[i]["HasChildOu"]));
HasChildUser = Epoint.Common.Functions.IntNull(Convert.ToString(dvOu[i]["HasChildUser"]));
if (HasChildOu + HasChildUser > 0)
{
node.PopulateOnDemand = true;
node.CtrlClickFunction = "AutoSetPValue_OuGuid(this,'" + node.Value + "')";
}
node.ShowInputCtrl = true;
node.Checked = pNode.Checked;
pNode.ChildNodes.Add(node);
}
}
protected void TreeView1_TreeNodePopulate1(object sender, EpointTreeNodeEventArgs e)
{
EpointTreeNode pNode = e.Node;
DataView dvMo = SelectSecond(pNode.Value);
EpointTreeNode node;
for (int i = 0; i < dvMo.Count; i++)
{
node = new EpointTreeNode();
node.Text = dvMo[i]["GroupName"].ToString();
node.Value = dvMo[i]["RowGuid"].ToString();
if (IsLeaf(node))
node.PopulateOnDemand = false;
else
node.PopulateOnDemand = true;
node.NavigateUrl = "DataGroup_List.aspx?ParentGuid=" + node.Value;
pNode.ChildNodes.Add(node);
}
}
protected void TreeView1_TreeNodePopulate1(object sender, EpointTreeNodeEventArgs e)
{
EpointTreeNode pNode = e.Node;
DataView dvOu = ous.Select(pNode.Value);
DataView dvUser = user.Select(pNode.Value);
EpointTreeNode node;
for (int j = 0; j < dvUser.Count; j++)
{
node = new EpointTreeNode();
node.Text = dvUser[j]["DisplayName"].ToString();
node.Value = dvUser[j]["userGuid"].ToString();
//���ڵ�Ϊ��Աʱ,���ѡ����¼�
node.CtrlClickFunction = "AutoSetUserValue(this,'" + node.Text + "','" + node.Value + "');";
node.ImageUrl = "../../Images/TreeImages/person.gif";
//�ڵ�Ϊ��Աʱ,����չ��
node.RunClickEvtOnInit = true;//�Ƿ�������checkbox��ʱ������click�¼�
node.PopulateOnDemand = false;
node.ShowInputCtrl = true;
node.Checked = pNode.Checked;
pNode.ChildNodes.Add(node);
}
int HasChildOu = 0, HasChildUser = 0;
for (int i = 0; i < dvOu.Count; i++)
{
node = new EpointTreeNode();
node.Text = dvOu[i]["OUName"].ToString();
node.Value = dvOu[i]["OUGuid"].ToString();
HasChildOu = Epoint.Common.Functions.IntNull(Convert.ToString(dvOu[i]["HasChildOu"]));
HasChildUser = Epoint.Common.Functions.IntNull(Convert.ToString(dvOu[i]["HasChildUser"]));
if (HasChildOu + HasChildUser > 0)
{
node.PopulateOnDemand = true;
node.CtrlClickFunction = "AutoSetPValue_OuGuid(this,'" + node.Value + "')";
}
node.ShowInputCtrl = true;
node.Checked = pNode.Checked;
pNode.ChildNodes.Add(node);
}
}
protected void TreeView1_TreeNodePopulate1(object sender, EpointTreeNodeEventArgs e)
{
EpointTreeNode pNode = e.Node;
DataView dvMo = SelectSecond(pNode.Value);
EpointTreeNode node;
for (int i = 0; i < dvMo.Count; i++)
{
node = new EpointTreeNode();
node.Text = dvMo[i]["ModuleName"].ToString();
node.Value = dvMo[i]["RowGuid"].ToString();
//if (!Convert.ToBoolean(Dv_Category[i]["IsLeaf"]))
if (IsLeaf(node))
node.PopulateOnDemand = false;
else
node.PopulateOnDemand = true;
node.NavigateUrl = "Record_List.aspx?IsBelongtoApp=0&ParentGuid=" + node.Value;
pNode.ChildNodes.Add(node);
}
}
protected void TreeView1_TreeNodePopulate1(object sender, EpointTreeNodeEventArgs e)
{
bool canSelect = false;
EpointTreeNode node = e.Node;
string itemCode = this.CodeItem.GetDetail_ItemValue(this.ViewState["MainGuid"].ToString(), node.Value).ItemCode;
DataView view = this.CodeItem.SelectNextOneLevel(this.ViewState["MainGuid"].ToString(), itemCode, out canSelect);
for (int i = 0; i < view.Count; i++)
{
EpointTreeNode child = new EpointTreeNode
{
Text = view[i]["ItemText"].ToString(),
Value = view[i]["ItemValue"].ToString()
};
if (this.CodeItem.SelectNextOneLevel(this.ViewState["MainGuid"].ToString(), view[i]["ItemCode"].ToString(), out canSelect).Count > 0)
{
child.PopulateOnDemand = true;
}
child.NavigateUrl = "ZZZYGX_List.aspx?ItemCode=" + view[i]["ItemCode"].ToString() + "&MainGuid=" + this.ViewState["MainGuid"].ToString();
node.ChildNodes.Add(child);
}
}
protected void TreeView1_TreeNodePopulate1(object sender, EpointTreeNodeEventArgs e)
{
bool canSelect = false;
EpointTreeNode node = e.Node;
string itemCode = this.CodeItem.GetDetail_ItemValue(this.ViewState["MainGuid"].ToString(), node.Value).ItemCode;
DataView view = this.CodeItem.SelectNextOneLevel(this.ViewState["MainGuid"].ToString(), itemCode, out canSelect);
for (int i = 0; i < view.Count; i++)
{
EpointTreeNode child = new EpointTreeNode
{
Text = view[i]["ItemText"].ToString(),
Value = view[i]["ItemValue"].ToString()
};
if (this.CodeItem.SelectNextOneLevel(this.ViewState["MainGuid"].ToString(), view[i]["ItemCode"].ToString(), out canSelect).Count > 0)
{
child.PopulateOnDemand = true;
}
child.NavigateUrl = "ZZZYGX_List.aspx?ItemCode=" + view[i]["ItemCode"].ToString() + "&MainGuid=" + this.ViewState["MainGuid"].ToString();
node.ChildNodes.Add(child);
}
}
protected void TreeView1_TreeNodePopulate1(object sender, EpointTreeNodeEventArgs e)
{
EpointTreeNode pNode = e.Node;
DataView dvMa = null;
EpointTreeNode node;
//Boolean IsApp = Epoint.MisBizLogic2.DB.ExecuteToInt("select count(RowGuid) from RG_Application where RowGuid='" + pNode.Value + "'") == 1;//节点是否是子系统
dvMa = NextFloor(pNode.Value);
for (int i = 0; i < dvMa.Count; i++)
{
node = new EpointTreeNode();
node.Text = dvMa[i]["MatterName"].ToString();
node.Value = dvMa[i]["RowGuid"].ToString();
if (IsLeaf(node))
node.PopulateOnDemand = false;
else
node.PopulateOnDemand = true;
node.NavigateUrl = "Matter_List.aspx?ParentGuid=" + node.Value;
pNode.ChildNodes.Add(node);
}
}
protected void TreeView1_TreeNodePopulate1(object sender, EpointTreeNodeEventArgs e)
{
EpointTreeNode pNode = e.Node;
Boolean IsApp = Epoint.MisBizLogic2.DB.ExecuteToInt("select count(RowGuid) from RG_Application where RowGuid='" + pNode.Value + "'") == 1;//pNode是否子系统
DataView dvMo = NextFloor(pNode.Value, IsApp);
EpointTreeNode node;
for (int i = 0; i < dvMo.Count; i++)
{
node = new EpointTreeNode();
node.Text = dvMo[i]["ModuleName"].ToString();
node.Value = dvMo[i]["RowGuid"].ToString();
if (IsLeafextra(node))
node.PopulateOnDemand = false;
else
node.PopulateOnDemand = true;
node.NavigateUrl = "../RG_Module/Record_List.aspx?IsBelongtoApp=1&ParentGuid=" + node.Value + "&AppGuid=" + dvMo[i]["AppGuid"].ToString();
pNode.ChildNodes.Add(node);
}
}
protected void TreeView1_TreeNodePopulate1(object sender, EpointTreeNodeEventArgs e)
{
EpointTreeNode pNode = e.Node;
DataView dvMo = SelectSecond(pNode.Value);
EpointTreeNode node;
for (int i = 0; i < dvMo.Count; i++)
{
node = new EpointTreeNode();
node.Text = dvMo[i]["GroupName"].ToString();
node.Value = dvMo[i]["RowGuid"].ToString();
if (IsLeaf(node))
{
node.PopulateOnDemand = false;
}
else
{
node.PopulateOnDemand = true;
}
node.NavigateUrl = "DataGroup_List.aspx?ParentGuid=" + node.Value;
pNode.ChildNodes.Add(node);
}
}
/// <summary>
/// ע��������νṹչ��
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void RegionTreeView_TreeNodePopulate(object sender, EpointTreeNodeEventArgs e)
{
EpointTreeNode nodeArg = e.Node;
EpointTreeNode nodeVar;
TextTreeView ttv = (TextTreeView)sender;
string strLeft = "";
DataView dv;
int i = 0;
if (CommonFunc.Right(nodeArg.Value, 4) == "0000") //��һ�����صڶ���
{
strLeft = CommonFunc.Left(nodeArg.Value, 2);
dv = DataBaseFunc.Instace.GetCityLevelTwo(strLeft, nodeArg.Value);
for (i = 0; i < dv.Count; i++)
{
nodeVar = new EpointTreeNode(dv[i]["CityName"].ToString(), dv[i]["CityCode"].ToString()); //ʵ����һ���ڵ�
nodeVar.ExpandOnCheckedChanged = true;
nodeVar.Checked = false;
nodeVar.ShowInputCtrl = false;
nodeVar.RunClickEvtOnInit = true;
nodeVar.PopulateOnDemand = true;
nodeVar.ReturnFullPath = true;
nodeVar.ShowImage = true;
nodeVar.SelectLeafForTextTreeView = false;
nodeArg.ChildNodes.Add(nodeVar);
}
}
if (CommonFunc.Right(nodeArg.Value, 2) == "00") //�ڶ������ص�����
{
strLeft = CommonFunc.Left(nodeArg.Value, 4);
dv = DataBaseFunc.Instace.GetCityLevelThree(strLeft);
for (i = 0; i < dv.Count; i++)
{
nodeVar = new EpointTreeNode(dv[i]["CityName"].ToString(), dv[i]["CityCode"].ToString()); //ʵ����һ���ڵ�
nodeVar.ExpandOnCheckedChanged = true;
nodeVar.ShowInputCtrl = true;
if (nodeVar.Value == ttv.Value)
{
nodeVar.Checked = true;
}
else
{
nodeVar.Checked = false;
}
nodeVar.RunClickEvtOnInit = true;
nodeVar.PopulateOnDemand = false;
nodeVar.ReturnFullPath = true;
nodeVar.ShowImage = false;
nodeArg.ChildNodes.Add(nodeVar);
}
}
}
/// <summary>
/// ע��������νṹչ��
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void RegionTreeView_TreeNodePopulate(object sender, EpointTreeNodeEventArgs e)
{
EpointTreeNode nodeArg = e.Node;
EpointTreeNode nodeVar;
DataView dv;
int i = 0;
dv = DataBaseFunc.Instace.GetTreeLevelTwo(nodeArg.Value, "f7f84f2a-de8a-4bc2-b13d-e541f73b12a8", "");
for (i = 0; i < dv.Count; i++)
{
nodeVar = new EpointTreeNode(dv[i]["ItemText"].ToString(), dv[i]["ItemCode"].ToString()); //ʵ����һ���ڵ�
DataView dv2 = DataBaseFunc.Instace.GetTreeLevelTwo(dv[i]["ItemCode"].ToString(), "f7f84f2a-de8a-4bc2-b13d-e541f73b12a8", "");
if (dv2.Count > 0)
{
nodeVar.ShowInputCtrl = false;
nodeVar.PopulateOnDemand = true;
nodeVar.ExpandOnCheckedChanged = false;
nodeVar.SelectLeafForTextTreeView = false;
nodeVar.ShowImage = false;
}
else
{
nodeVar.ShowInputCtrl = true;
nodeVar.PopulateOnDemand = false;
nodeVar.ShowImage = false;
nodeVar.SelectLeafForTextTreeView = true;
nodeVar.CanSelectForTextTreeView = true;
nodeVar.ReturnFullPath = true;
}
nodeArg.ChildNodes.Add(nodeVar);
}
}
