Exemplo n.º 1
0
        public int TrxVersionAndTerm(string iType, int iestterm_ref_id, int iversion_ref_id, string iversion_name, int itxr_user, DataTable dtVerTerm)
        {
            int           iAffRow = 0;
            int           iRow    = 0;
            IDbConnection con     = DbAgentHelper.CreateDbConnection();

            con.Open();
            IDbTransaction trx = con.BeginTransaction();

            try
            {
                if (iType == "A")
                {
                    iAffRow = this.InsertData(con, trx, iestterm_ref_id, iversion_ref_id, iversion_name, itxr_user);
                }
                else if (iType == "U")
                {
                    iAffRow = this.UpdateData(con, trx, iestterm_ref_id, iversion_ref_id, iversion_name, itxr_user);
                }
                else if (iType == "D")
                {
                    iAffRow = this.DeleteData(con, trx, iestterm_ref_id, iversion_ref_id, itxr_user);
                    Biz_Bsc_Stg_Tree      objSTree = new Biz_Bsc_Stg_Tree();
                    Biz_Bsc_Stg_Tree_Term objSTerm = new Biz_Bsc_Stg_Tree_Term();

                    iAffRow = objSTree.DeleteData(con, trx, iestterm_ref_id, iversion_ref_id, itxr_user);
                    iAffRow = objSTerm.DeleteData(con, trx, iestterm_ref_id, iversion_ref_id, itxr_user);
                }

                if (iType == "A" || iType == "U")
                {
                    iRow = dtVerTerm.Rows.Count;
                    if (base.Transaction_Result == "Y")
                    {
                        Biz_Bsc_Stg_Tree_Term objTerm = new Biz_Bsc_Stg_Tree_Term();
                        for (int i = 0; i < iRow; i++)
                        {
                            objTerm.IEstterm_Ref_Id = base.IEstterm_Ref_Id;
                            objTerm.IVersion_Ref_Id = base.IVersion_Ref_Id;
                            objTerm.IYmd            = dtVerTerm.Rows[i]["YMD"].ToString();
                            iAffRow += objTerm.UpdateData(con, trx, objTerm.IEstterm_Ref_Id, objTerm.IVersion_Ref_Id, objTerm.IYmd, itxr_user);
                        }
                    }
                }

                trx.Commit();
            }
            catch (Exception e)
            {
                base.Transaction_Message = e.Message;
                base.Transaction_Result  = "N";
                trx.Rollback();
            }
            finally
            {
                con.Close();
            }

            return(iAffRow);
        }
Exemplo n.º 2
0
    /// <summary>
    /// 전략트리 설정
    /// </summary>
    public void SetStgTree(TreeView iTreeView)
    {
        iTreeView.Nodes.Clear();
        MicroBSC.BSC.Biz.Biz_Bsc_Stg_Tree objTree = new MicroBSC.BSC.Biz.Biz_Bsc_Stg_Tree();
        DataTable rDt = objTree.GetStgTree(this.IEstTermRefID, this.IVersionRefID);

        TreeNode tnRoot = new TreeNode(PageUtility.GetByTextDropDownList(ddlStgTreeVersion), "0");

        iTreeView.Nodes.Add(tnRoot);
        tnRoot.Checked = true;
        //tnRoot.SelectAction = TreeNodeSelectAction.Expand;

        for (int i = 0; i < rDt.Rows.Count; i++)
        {
            string sID = rDt.Rows[i]["IDX"].ToString();
            string sNM = rDt.Rows[i]["STG_NAME"].ToString();
            string sPT = rDt.Rows[i]["PARENT_IDX"].ToString();

            foreach (TreeNode tnC in iTreeView.CheckedNodes)
            {
                if (tnC.Value == sPT)
                {
                    TreeNode tnNode = new TreeNode(sNM, sID);
                    tnC.ChildNodes.Add(tnNode);
                    tnNode.Checked = true;
                    if (this.IIdx.ToString() == sID)
                    {
                        tnNode.Select();
                    }
                    break;
                }
            }
        }

        if (trvStg.SelectedNode != null && trvStg.SelectedNode.Parent != null)
        {
            this.IIdx            = decimal.Parse(trvStg.SelectedNode.Value);
            this.IIdxParent      = decimal.Parse(trvStg.SelectedNode.Value);
            txtSelStg.Text       = trvStg.SelectedNode.Text;
            txtSelStgParent.Text = trvStg.SelectedNode.Parent.Text;
            trvStg.ExpandAll();
        }
        else
        {
            this.SetInitStgForm();
        }
    }
Exemplo n.º 3
0
    /// <summary>
    /// 전략풀 그리드 조회
    /// </summary>
    protected void SetStgGrid()
    {
        if (TypeUtility.GetNumString(PageUtility.GetByValueDropDownList(ddlEstTermInfo)) == "")
        {
            PageUtility.AlertMessage("평가기간을 알 수 없습니다!");
            return;
        }

        MicroBSC.BSC.Biz.Biz_Bsc_Stg_Tree objBSC = new MicroBSC.BSC.Biz.Biz_Bsc_Stg_Tree();
        objBSC.IEstterm_Ref_Id = this.IEstTermRefID;
        objBSC.IVersion_Ref_Id = this.IVersionRefID;

        //DataSet rDs = objBSC.GetAllList(objBSC.Iestterm_ref_id, objBSC.Istg_code, objBSC.Istg_name, objBSC.Iuse_yn);
        DataSet rDs = objBSC.GetUsedStgCount(objBSC.IEstterm_Ref_Id, objBSC.IVersion_Ref_Id);

        ugrdStgList.Clear();

        if (rDs.Tables.Count > 0)
        {
            ugrdStgList.DataSource = rDs;
            ugrdStgList.DataBind();
        }
    }
Exemplo n.º 4
0
 public void SetStgTreeInfo()
 {
     MicroBSC.BSC.Biz.Biz_Bsc_Stg_Tree objTree = new MicroBSC.BSC.Biz.Biz_Bsc_Stg_Tree(this.IIdx);
     txtSORT_ORDER.Text = objTree.ISort_Order.ToString();
 }
Exemplo n.º 5
0
    /// <summary>
    /// 전략트리 데이터 입출력
    /// </summary>
    public bool TrxStgTreeData(bool isChild)
    {
        if (!ValidateStgData())
        {
            return(false);
        }

        this.SetParam();
        MicroBSC.BSC.Biz.Biz_Bsc_Stg_Tree objStg = new MicroBSC.BSC.Biz.Biz_Bsc_Stg_Tree();
        objStg.IEstterm_Ref_Id = this.IEstTermRefID;
        objStg.IVersion_Ref_Id = this.IVersionRefID;
        objStg.IIdx            = this.IIdx;
        objStg.IParent_Idx     = (isChild) ? this.IIdx : this.IIdxParent;
        objStg.IStg_Ref_Id     = (this.ITypeTree == "U" || this.ITypeTree == "D") ? 0 : int.Parse(hdfStgPoolId.Value);
        objStg.ISort_Order     = int.Parse(txtSORT_ORDER.Text);
        objStg.ICreate_User    = gUserInfo.Emp_Ref_ID;

        if (this.ITypeTree == "A")
        {
            int iRtn = objStg.InsertData(null
                                         , null
                                         , this.IEstTermRefID
                                         , this.IVersionRefID
                                         , objStg.IStg_Ref_Id
                                         , objStg.IParent_Idx
                                         , objStg.ISort_Order
                                         , objStg.ICreate_User);

            ltrScript.Text = JSHelper.GetAlertScript(objStg.Transaction_Message, false);
            if (objStg.Transaction_Result == "Y")
            {
                this.IIdx = objStg.IIdx;
                return(true);
            }
        }
        else if (this.ITypeTree == "U")
        {
            int iRtn = objStg.UpdateData(null
                                         , null
                                         , this.IIdx
                                         , this.IEstTermRefID
                                         , this.IVersionRefID
                                         , objStg.IStg_Ref_Id
                                         , objStg.IParent_Idx
                                         , objStg.ISort_Order
                                         , objStg.ICreate_User);
            ltrScript.Text = JSHelper.GetAlertScript(objStg.Transaction_Message, false);
            if (objStg.Transaction_Result == "Y")
            {
                return(true);
            }
        }
        else if (this.ITypeTree == "D")
        {
            decimal[] arrIdx = new decimal[1];
            TreeNode  tn     = trvStg.SelectedNode;
            int       iLoop  = 1;

            //자신
            if (tn != null)
            {
                arrIdx[0] = decimal.Parse(tn.Value);
            }
            //자식
            //foreach (TreeNode trn in tn.ChildNodes)
            //{
            //    decimal dTmp = decimal.Parse(trn.Value);
            //    if (dTmp > 0)
            //    {
            //        iLoop++;
            //        Array.Resize(ref arrIdx, iLoop);
            //        arrIdx[iLoop - 1] = dTmp;
            //    }
            //}

            //상위부모 다 삭제
            //while (tn != null)
            //{
            //    decimal dTmp = decimal.Parse(tn.Value);
            //    if (dTmp > 0)
            //    {
            //        Array.Resize(ref arrIdx, iLoop);
            //        arrIdx[iLoop - 1] = dTmp;
            //        iLoop++;
            //    }
            //    tn = tn.Parent;
            //}

            int iRtn = objStg.DeleteMultiNode(arrIdx, objStg.ICreate_User);
            ltrScript.Text = JSHelper.GetAlertScript(objStg.Transaction_Message, false);
            if (objStg.Transaction_Result == "Y")
            {
                return(true);
            }
        }

        return(false);
    }