public void SAVE_TREE(string PATTERN_CODE)
{
string NODE_CODE = string.Empty;
if (string.IsNullOrEmpty(PATTERN_CODE))
{
if (dt_Show_Tree.Rows.Count > 0)
{
PATTERN_CODE = Request.QueryString["PATTERN_CODE"];
}
}
for (int i = 0; i <= dt_default_Tree.Rows.Count - 1; i++)
{
NODE_CODE += dt_default_Tree.Rows[i]["NODE_CODE"].ToString() + ",";
}
if (dt_default_Tree.Rows.Count > 0)
{
NODE_CODE = NODE_CODE.Substring(0, NODE_CODE.Length - 1);
}
string sql = "delete from CTLT_TREE_PATTERN where NODE_CODE in (" + NODE_CODE + ")";
OPM_BL BL = new OPM_BL();
if (!string.IsNullOrEmpty(NODE_CODE))
{
Int16 t = Convert.ToInt16(BL.SQL_TREE_PATTERN(sql));
}
for (int i = 0; i <= dt_Show_Tree.Rows.Count - 1; i++)
{
sql = "insert into CTLT_TREE_PATTERN (PATTERN_CODE,NODE_CODE,ITEM_CODE,PARENT_NODE_CODE,USER_ID,LAST_DATE,MA_FLAG,PRINT_FLAG,QUERY_FLAG) values ";
sql += "('" + PATTERN_CODE + "','" + dt_Show_Tree.Rows[i]["NODE_CODE"].ToString() + "','" + dt_Show_Tree.Rows[i]["ITEM_CODE"].ToString() + "',";
sql += "'" + dt_Show_Tree.Rows[i]["PARENT_NODE_CODE"].ToString() + "','" + OPM_BL._Username + "',GETDATE(),'Y','Y','Y')";
Int16 t2 = Convert.ToInt16(BL.SQL_TREE_PATTERN(sql));
}
}
public void CountDate_chkDEL(string nodecode)
{
string _Sub_nodecode = string.Empty;
string PATTERN_CODE = Request.QueryString["PATTERN_CODE"];
DataTable dt = new DataTable();
SqlParameter[] param = new SqlParameter[1];
string SQL = "SELECT CTLT_TREE_PATTERN.NODE_CODE, CTLT_ITEM.ITEM_TYPE, CTLT_TREE_PATTERN.ITEM_CODE, CTLT_ITEM.ITEM_NAME, ";
SQL +="CTLT_TREE_PATTERN.PARENT_NODE_CODE FROM CTLT_TREE_PATTERN INNER JOIN CTLT_ITEM ON CTLT_TREE_PATTERN.ITEM_CODE = CTLT_ITEM.ITEM_CODE";
SQL +=" WHERE (CTLT_TREE_PATTERN.PATTERN_CODE = @PATTERN_CODE)";
param[0] = OPM_BL.setParameter("@PATTERN_CODE", SqlDbType.VarChar, PATTERN_CODE);
dt = OPM_BL.GetDatatable(SQL, param);
dt.DefaultView.RowFilter = " PARENT_NODE_CODE = '" + nodecode + "'";
for (int i = 0; i <= dt.DefaultView.Count - 1; i++)
{
if (dt.DefaultView[i]["ITEM_TYPE"].ToString() == "M")
{
CountDate_chkDEL(dt.DefaultView[i]["NODE_CODE"].ToString());
}
_Sub_nodecode += dt.DefaultView[i]["NODE_CODE"].ToString() + ",";
}
_Sub_nodecode = _Sub_nodecode.Substring(0, _Sub_nodecode.Length - 1);
param = new SqlParameter[1];
string _SQL = "DELETE FROM CTLT_TREE_PATTERN WHERE NODE_CODE in (" + _Sub_nodecode + ")";
OPM_BL BL = new OPM_BL();
string Del_chk = Convert.ToString(BL.SQL_TREE_PATTERN(_SQL));
//param[0] = OPM_BL.setParameter("@nodecode", SqlDbType.VarChar, _Sub_nodecode);
//string _ret = OPM_BL.ExecuteNoneQuery(_SQL, param);
//_chk_Delete = _ret;
}