private void PopulateScheduleTree(DataRow dbRow
, TreeNode node
, string valueStr
, string textStr
, string imageUrlDir
, string iconStr
, TreeNodeSelectAction treeNodeSelectAction
, bool expanded
, bool isCheckBox
, DataTable callbackDataTable
)
{
foreach (DataRow childRow in dbRow.GetChildRows("NodeRelation"))
{
TreeNode childNode = CreateNode(childRow
, imageUrlDir + "tasks.gif"
, expanded
, treeNodeSelectAction
, isCheckBox);
if (isCheckBox && callbackDataTable != null)
{
TreeNodeCheck(childNode, callbackDataTable);
}
node.ChildNodes.Add(childNode);
PopulateScheduleTree(childRow, childNode, valueStr, textStr, imageUrlDir, iconStr, treeNodeSelectAction, expanded, isCheckBox, callbackDataTable);
}
}
private static void PopulateEstTreeJob(DataRow dbRow
, TreeNode node
, string valueStr
, string textStr
, string imageUrlDir
, string iconStr
, TreeNodeSelectAction treeNodeSelectAction
, bool expanded
, bool isCheckBox
, DataTable callbackDataTable)
{
foreach (DataRow childRow in dbRow.GetChildRows("NodeRelation"))
{
TreeNode childNode = CreateNode(childRow[valueStr].ToString()
, childRow[textStr].ToString()
, imageUrlDir + ((childRow["EST_ID"].ToString().Length != 0) ? "blue/E.gif" : "blue/S.gif")
, expanded
, treeNodeSelectAction
, isCheckBox);
if (isCheckBox && callbackDataTable != null)
{
TreeNodeCheck(childNode, callbackDataTable);
}
node.ChildNodes.Add(childNode);
PopulateEstTree(childRow, childNode, valueStr, textStr, imageUrlDir, iconStr, treeNodeSelectAction, expanded, isCheckBox, callbackDataTable);
}
}
private static void PopulateEstDeptTree(DataRow dbRow
, TreeNode node
, string valueStr
, string textStr
, string imageUrlDir
, string iconStr
, TreeNodeSelectAction treeNodeSelectAction
, bool expanded
, bool isCheckBox
, DataTable callbackDataTable)
{
foreach (DataRow childRow in dbRow.GetChildRows("NodeRelation"))
{
TreeNode childNode = CreateNode(childRow[valueStr].ToString()
, childRow[textStr].ToString()
, imageUrlDir + string.Format("{0}_2.gif", childRow[iconStr].ToString().PadLeft(2, '0'), "07")
, expanded
, treeNodeSelectAction
, isCheckBox);
if (isCheckBox && callbackDataTable != null)
{
TreeNodeCheck(childNode, callbackDataTable);
}
node.ChildNodes.Add(childNode);
PopulateEstDeptTree(childRow, childNode, valueStr, textStr, imageUrlDir, iconStr, treeNodeSelectAction, expanded, isCheckBox, callbackDataTable);
}
}
public CustomTreeNode(TreeNodeSelectAction selectAction, string text, string productId, string productName, string catId, string catName) : base(text, productId)
{
SelectAction = selectAction;
this.CatId = catId;
this.CatName = catName;
this.ProductId = productId;
this.ProductName = productName;
}
public static void BindDept(TreeView treeView, bool isCheckBox)
{
TreeNodeSelectAction treeNodeSelectAction = TreeNodeSelectAction.None;
if (!isCheckBox)
{
treeNodeSelectAction = TreeNodeSelectAction.Select;
}
BindDept(treeView, isCheckBox, treeNodeSelectAction, null);
}
public static void BindEst(TreeView treeView, bool isCheckBox, int comp_id)
{
TreeNodeSelectAction treeNodeSelectAction = TreeNodeSelectAction.None;
if (!isCheckBox)
{
treeNodeSelectAction = TreeNodeSelectAction.Select;
}
BindEst(treeView, isCheckBox, treeNodeSelectAction, null, comp_id);
}
public void BindSchedule(TreeView treeView
, bool isCheckBox
, TreeNodeSelectAction treeNodeSelectAction
, string checkedValues)
{
string valueStr = "TASK_REF_ID";
string up_valueStr = "UP_TASK_REF_ID";
string textStr = "TASK_NAME";
string iconStr = "TASK_TYPE";
string imageUrlDir = "../images/treeview/";
bool isExtended = true;
DataTable dataTable = null;
Biz_Prj_Schedule objSchedule = new Biz_Prj_Schedule();
DataSet ds = objSchedule.GetAllList(PRJ_REF_ID, 0);
ds.Relations.Add("NodeRelation"
, ds.Tables[0].Columns[valueStr]
, ds.Tables[0].Columns[up_valueStr]
, false);
treeView.Nodes.Clear();
foreach (DataRow dbRow in ds.Tables[0].Rows)
{
if (DataTypeUtility.GetToInt32(dbRow[up_valueStr]) == 0)
{
TreeNode rootNode = CreateNode(dbRow
, imageUrlDir + "root.gif"
, isExtended
, treeNodeSelectAction
, isCheckBox);
if (isCheckBox && (checkedValues != null || checkedValues == ""))
{
TreeNodeCheck(rootNode, dataTable);
}
treeView.Nodes.Add(rootNode);
PopulateScheduleTree(dbRow, rootNode, valueStr, textStr, imageUrlDir, iconStr, treeNodeSelectAction, isExtended, isCheckBox, dataTable);
}
}
}
private static TreeNode CreateNode(string value
, string text
, string imageurl
, bool expanded
, TreeNodeSelectAction treeNodeSel
, bool showChk)
{
TreeNode node = new TreeNode();
node.Value = value;
node.Text = text;
node.ImageUrl = imageurl;
node.SelectAction = treeNodeSel;
node.Expanded = expanded;
node.ShowCheckBox = showChk;
return(node);
}
private TreeNode CreateNode(DataRow row
, string imageurl
, bool expanded
, TreeNodeSelectAction treeNodeSel
, bool showChk
)
{
TreeNode node = new TreeNode();
node.Value = row["TASK_REF_ID"].ToString();
node.Text = row["TASK_NAME"].ToString();
node.ImageUrl = imageurl;
node.SelectAction = treeNodeSel;
node.Expanded = expanded;
node.ShowCheckBox = showChk;
return(node);
}
private static void PopulateSubTree(DataRow dbRow
, TreeNode node
, string valueStr
, string textStr
, string imageUrlDir
, TreeNodeSelectAction treeNodeSelectAction
, bool expanded
, bool isCheckBox)
{
foreach (DataRow childRow in dbRow.GetChildRows("NodeRelation"))
{
TreeNode childNode = CreateNode(childRow[valueStr].ToString()
, childRow[textStr].ToString()
, imageUrlDir + "blue/E.gif"
, expanded
, treeNodeSelectAction
, isCheckBox);
node.ChildNodes.Add(childNode);
PopulateSubTree(childRow, childNode, valueStr, textStr, imageUrlDir, treeNodeSelectAction, expanded, isCheckBox);
}
}
public static void BindJobs(TreeView treeView
, bool isCheckBox
, TreeNodeSelectAction treeNodeSelectAction
, string checkedValues
, int comp_id)
{
string valueStr = "EST_SCHE_ID";
string up_valueStr = "UP_EST_SCHE_ID";
string textStr = "EST_SCHE_NAME";
string iconStr = "EST_SCHE_ID";
string imageUrlDir = "../images/dept_icon/";
bool isExtended = true;
DataTable dataTable = null;
// 부모 페이지에서 값이 수정되었을 경우를 위해서 체크박스에 대한 값을 처리하기
// 위해서 추가 되는 부분
if (isCheckBox && (checkedValues != null || checkedValues == ""))
{
dataTable = new DataTable();
DataRow dr = null;
dataTable.Columns.Add("VALUE", typeof(string));
dataTable.Columns.Add("OK_YN", typeof(string));
string[] values = checkedValues.Split(',');
foreach (string val in values)
{
dr = dataTable.NewRow();
dr["VALUE"] = val;
dr["OK_YN"] = "N";
dataTable.Rows.Add(dr);
}
}
Biz_ScheInfos scheInfos = new Biz_ScheInfos();
DataSet ds = scheInfos.GetScheInfo(comp_id);
ds.Relations.Add("NodeRelation"
, ds.Tables[0].Columns[valueStr]
, ds.Tables[0].Columns[up_valueStr]
, false);
treeView.Nodes.Clear();
foreach (DataRow dbRow in ds.Tables[0].Rows)
{
if (dbRow[up_valueStr] == DBNull.Value)
{
TreeNode rootNode = CreateNode(dbRow[valueStr].ToString()
, dbRow[textStr].ToString()
, imageUrlDir + ((dbRow["EST_ID"].ToString().Length != 0) ? "blue/E.gif" : "blue/S.gif")
, isExtended
, treeNodeSelectAction
, isCheckBox);
if (isCheckBox && (checkedValues != null || checkedValues == ""))
{
TreeNodeCheck(rootNode, dataTable);
}
treeView.Nodes.Add(rootNode);
PopulateEstTreeJob(dbRow, rootNode, valueStr, textStr, imageUrlDir, iconStr, treeNodeSelectAction, isExtended, isCheckBox, dataTable);
}
}
}
public static void BindMenu(TreeView treeView
, bool isCheckBox
, TreeNodeSelectAction treeNodeSelectAction
, string checkedValues)
{
string valueStr = "MENU_REF_ID";
string up_valueStr = "UP_MENU_ID";
string textStr = "MENU_NAME";
string iconStr = "EST_STYLE_ID";
string imageUrlDir = "../images/treeview/";
bool isExtended = true;
DataTable dataTable = null;
// 부모 페이지에서 값이 수정되었을 경우를 위해서 체크박스에 대한 값을 처리하기
// 위해서 추가 되는 부분
if (isCheckBox && (checkedValues != null || checkedValues == ""))
{
dataTable = new DataTable();
DataRow dr = null;
dataTable.Columns.Add("VALUE", typeof(string));
dataTable.Columns.Add("OK_YN", typeof(string));
string[] values = checkedValues.Split(',');
foreach (string val in values)
{
dr = dataTable.NewRow();
dr["VALUE"] = val;
dr["OK_YN"] = "N";
dataTable.Rows.Add(dr);
}
}
Biz_MenuInfo objMenuInfo = new Biz_MenuInfo();
DataSet ds = objMenuInfo.GetMenuInfos();
ds.Relations.Add("NodeRelation"
, ds.Tables[0].Columns[valueStr]
, ds.Tables[0].Columns[up_valueStr]
, false);
treeView.Nodes.Clear();
foreach (DataRow dbRow in ds.Tables[0].Rows)
{
if (dbRow[up_valueStr] == DBNull.Value || DataTypeUtility.GetToInt32(dbRow[up_valueStr]) == 0)
{
TreeNode rootNode = CreateNode(dbRow[valueStr].ToString()
, dbRow[textStr].ToString()
, imageUrlDir + "folder.gif"
, isExtended
, treeNodeSelectAction
, isCheckBox);
if (isCheckBox && (checkedValues != null || checkedValues == ""))
{
TreeNodeCheck(rootNode, dataTable);
}
treeView.Nodes.Add(rootNode);
PopulateMenuTree(dbRow, rootNode, valueStr, textStr, imageUrlDir, iconStr, treeNodeSelectAction, isExtended, isCheckBox, dataTable);
}
}
}
public static void BindJobs(TreeView treeView, TreeNodeSelectAction treeNodeSelectAction, int comp_id)
{
BindJobs(treeView, false, treeNodeSelectAction, null, comp_id);
}
public static void BindDept(TreeView treeView
, bool isCheckBox
, TreeNodeSelectAction treeNodeSelectAction
, string checkedValues)
{
string valueStr = "DEPT_REF_ID";
string up_valueStr = "UP_DEPT_ID";
string textStr = "DEPT_NAME";
string iconStr = "DEPT_TYPE";
string imageUrlDir = "../images/icon/";
bool isExtended = true;
DataTable dataTable = null;
// 부모 페이지에서 값이 수정되었을 경우를 위해서 체크박스에 대한 값을 처리하기
// 위해서 추가 되는 부분
if (isCheckBox && (checkedValues != null || checkedValues == ""))
{
dataTable = new DataTable();
DataRow dr = null;
dataTable.Columns.Add("VALUE", typeof(string));
dataTable.Columns.Add("OK_YN", typeof(string));
string[] values = checkedValues.Split(',');
foreach (string val in values)
{
dr = dataTable.NewRow();
dr["VALUE"] = val;
dr["OK_YN"] = "N";
dataTable.Rows.Add(dr);
}
}
Biz_DeptInfos estDeptInfo = new Biz_DeptInfos();
DataSet ds = estDeptInfo.GetDeptInfos();
ds.Relations.Add("NodeRelation"
, ds.Tables[0].Columns[valueStr]
, ds.Tables[0].Columns[up_valueStr]
, false);
treeView.Nodes.Clear();
foreach (DataRow dbRow in ds.Tables[0].Rows)
{
if (DataTypeUtility.GetToInt32(dbRow[up_valueStr]) == 0)
{
TreeNode rootNode = CreateNode(dbRow[valueStr].ToString()
, dbRow[textStr].ToString()
, imageUrlDir + string.Format("{0}_2.gif", dbRow[iconStr].ToString().PadLeft(2, '0'), "07")
, isExtended
, treeNodeSelectAction
, isCheckBox);
if (isCheckBox && (checkedValues != null || checkedValues == ""))
{
TreeNodeCheck(rootNode, dataTable);
}
treeView.Nodes.Add(rootNode);
PopulateEstDeptTree(dbRow, rootNode, valueStr, textStr, imageUrlDir, iconStr, treeNodeSelectAction, isExtended, isCheckBox, dataTable);
}
}
}
public static void BindDept(TreeView treeView, TreeNodeSelectAction treeNodeSelectAction)
{
BindDept(treeView, false, treeNodeSelectAction, null);
}
private TreeNode AddChildNode(TreeNode Parent, string Caption, string Value, string NodeValue, TreeNodeSelectAction SelectAction)
{
TreeNode subChild = new TreeNode();
subChild.Text = (Caption + " " + Value).Trim();
subChild.SelectAction = SelectAction;
if (NodeValue != null)
{
subChild.Value = NodeValue; //El separador del indicador de nodos hijos es el caracter ":", la cadena antes del caracter ":"
}
//indica la operación a realizar.
Parent.ChildNodes.Add(subChild);
return(subChild);
}
