Example #1
0
        public JReferMain(string pClassName,
                          int pExternalObject_Code, ClassLibrary.Domains.JAutomation.JObjectType pObjectType,
                          string pDescription, string pTitle, DataTable dtPerson, bool StatePersons)
        {
            InitializeComponent();
            _StatePersons = StatePersons;
            if (pExternalObject_Code < 1)
            {
                Close();
            }

            _ClassName          = pClassName;
            _ExternalObjectCode = pExternalObject_Code;
            _ObjectType         = pObjectType;
            _Description        = ClassLibrary.JLanguages._Text(pDescription);
            _Title = ClassLibrary.JLanguages._Text(pTitle);

            _Refer = new JARefer();
            _SetInterface();
            GetPattern();
            if ((dtPerson != null) && (dtPerson.Rows.Count > 0))
            {
                _FillPerson(dtPerson);
            }

            jArchiveList1.ClassName   = "Automation.JARefer";
            jArchiveList1.SubjectCode = 0;
            jArchiveList1.PlaceCode   = 0;
        }
Example #2
0
        public static bool AutoGoToNextNode(string pClassName, int pObjectCode, int pDynamicClassCode, DataTable pDataTable, JNodeType pGoNode)
        {
            JARefer Refer    = new JARefer();
            int     _refCode = Refer.FindReferByExternalcode(pClassName, pObjectCode, pDynamicClassCode);

            Refer.GetData(_refCode);
            if (_refCode == 0)
            {
                return(false);
            }

            JWorkFlow workflow = new JWorkFlow(pDataTable, _refCode);

            workflow.GetData(Refer.WorkFlowCode, pClassName, pDynamicClassCode);
            JWorkFlow[] workflows = workflow.GetNextNodes(true);
            foreach (JWorkFlow _wf in workflows)
            {
                if (_wf.NodeType == pGoNode)
                {
                    int[] RefCode = Refer.Send(
                        _wf.PostCode.ToString().Split(new char[] { ';' })
                        , "",
                        _wf.Code,
                        pObjectCode,
                        "",
                        pClassName,
                        pDynamicClassCode,
                        pDataTable
                        );
                    return(RefCode.Length > 0);
                }
            }
            return(false);
        }
Example #3
0
        private void btnSend_Click(object sender, EventArgs e)
        {
            JARefer tmp = new JARefer(_ReferCode);

            tmp.ReturnRefer(_ReferCode);
            this.Close();
        }
Example #4
0
        private void cmbSendTypeExternal_SelectedIndexChanged(object sender, EventArgs e)
        {
            JARefer tmpRefer = new JARefer();

            tmpRefer.GetData(_Refer_Code);
            if (tmpRefer.receiver_External_code != 0)
            {
                JOrganization tmporg = new JOrganization(tmpRefer.receiver_External_code);
                if (Convert.ToInt32(cmbSendTypeExternal.SelectedValue) == ClassLibrary.Domains.JCommunication.JSendType.Fax)
                {
                    txtDesc.Text = tmporg.Address.Fax;
                }
                else if (Convert.ToInt32(cmbSendTypeExternal.SelectedValue) == ClassLibrary.Domains.JCommunication.JSendType.Email)
                {
                    txtDesc.Text = tmporg.Address.Email;
                }
                else if (Convert.ToInt32(cmbSendTypeExternal.SelectedValue) == ClassLibrary.Domains.JCommunication.JSendType.Server)
                {
                    txtDesc.Text = tmporg.ConnectionString;
                }
                else
                {
                    txtDesc.Text = tmporg.Address.Address;
                }
            }
        }
Example #5
0
        private void  fillGrid()
        {
            //------------های رخ میداد Thread  فراخوانی تابع افزودن فایل جدید بوسیله دلیگیت ، این کار برای آن صورت گرفته که تداخل   ---------------------
            //AddItem degAddToList = new AddItem(FillPost);
            //this.Invoke(degAddToList);
            JARefer tmprefer = new JARefer();

            dgCentral.Bind(Filldt(tmprefer.FindReferByReceivercodeAndpost(_user_post_code, _user_code, _exp)), JJanusGrid.JSettingKeys.Central);
        }
Example #6
0
        public JUC_Refer()
        {
            InitializeComponent();
            JARefer refer = new JARefer();

            //_dtReferTemp = refer.GetDataTablePatern().Copy();
            grdRefers.Bind(_dtReferTemp.Copy(), "Refer");
            _SetComboBoxs();
        }
Example #7
0
        private void frmRecieverSelector_Load(object sender, EventArgs e)
        {
            // Add old descriptions
            dtDescription                   = JARefers.GetDescriptionByPostCode(JMainFrame.CurrentPostCode);
            dgrDescription.DataSource       = dtDescription;
            dgrDescription.Columns[0].Width = dgrDescription.Width * 80 / 100;
            dgrDescription.Columns[1].Width = dgrDescription.Width * 20 / 100;
            // --------------------
            int _ReferCode = 0;

            _workFlowCode = 0;
            if (_ParentRefer > 0)
            {
                JARefer Refer = new JARefer(_ParentRefer);
                _workFlowCode = Refer.WorkFlowCode;
                _ReferCode    = Refer.Code;
            }
            else
            {
                tabControl1.TabPages.RemoveAt(1);
            }
            JWorkFlow WorkFlow = new JWorkFlow(_PublicDataRow, _ReferCode);

            WorkFlow.GetData(_workFlowCode, _ClassName, _DynamicClassName);

            if (WorkFlow.NodeType == JNodeType.PreviousEmployment)
            {
                JARefer _R = new JARefer(_ParentRefer);
                _R.GetData(_R.parent_code);
                if (_R.parent_code != 0)
                {
                    _R.GetData(_R.parent_code);
                    WorkFlow.GetData(_R.WorkFlowCode, "", 0);
                }
                else
                {
                    WorkFlow.GetFirst();
                }
            }

            JWorkFlow[] NextNodes = WorkFlow.GetNextNodes();
            if (NextNodes == null)
            {
                JMessages.Error(" مرحله بعدی برای این وضعیت تعریف نشده است ", "");
            }
            else
            {
                cmbNextNodes.Items.AddRange(NextNodes);
            }

            if (cmbNextNodes.Items.Count > 0)
            {
                cmbNextNodes.SelectedIndex = 0;
            }
        }
Example #8
0
        private void FilldgCentral(string pExp)
        {
            if (jDataTreeView1.TreeView.SelectedNode != null)
            {
                jDataTreeView1.TreeView.SelectedNode.BackColor = Color.Yellow;
            }

            JARefer tmprefer = new JARefer();

            dgCentral.Bind(tmprefer.FindReferByReceivercodeAndpost(_user_post_code, _user_code, pExp), JJanusGrid.JSettingKeys.Central);
        }
Example #9
0
        private void LbPost_SelectedIndexChanged(object sender, EventArgs e)
        {
            JARefer tmprefer = new JARefer();

            if (LbPost.SelectedItem != null)
            {
                _user_post_code = Convert.ToInt32(((DataRowView)(LbPost.SelectedItem))["code"]);
                FillTree();
                FilldgCentral("");
            }
        }
Example #10
0
        private void ReferDetailsForm_Load(object sender, EventArgs e)
        {
            JARefer jaRefer = new JARefer(_ReferCode);

            lblReferCode.Text = "شماره ارجاع: " + jaRefer.Code.ToString();
            lblSender.Text    = "از: " + jaRefer.sender_full_title;
            lblReciever.Text  = "به: " + jaRefer.receiver_full_title;
            lblDate.Text      = "تاریخ: " + JDateTime.FarsiDate(jaRefer.send_date_time) + " " + jaRefer.send_date_time.Hour.ToString("00") + ":" + jaRefer.send_date_time.Minute.ToString() + ":" + jaRefer.send_date_time.Second.ToString();
            jEditor1.InsertText(jaRefer.description);
            jEditor1.ChangeToViewMode();
        }
Example #11
0
        public void MouseDBClickKartable(System.Data.DataRow pDR, JAFolderTypeEnum pAFolderTypeEnum)
        {
            JARefer tmpRefer = new JARefer((int)pDR["Code"]);

            if (pAFolderTypeEnum == JAFolderTypeEnum.Inbox && tmpRefer.view_date_time == DateTime.MinValue &&
                (JMainFrame.CurrentPostCode != tmpRefer.sender_post_code ||
                 (JMainFrame.CurrentPostCode == tmpRefer.sender_post_code && JMainFrame.CurrentPostCode == tmpRefer.receiver_post_code)))
            {
                tmpRefer.view_date_time = (new JDataBase().GetCurrentDateTime());
                tmpRefer.Update();
            }
            JAction editAction = new JAction("Open...", pDR["action"].ToString(), new object[] { Convert.ToInt32(pDR["ObjectCode"]), (int)pDR["Code"] }, null);

            editAction.run();
        }
Example #12
0
        public bool SaveViewDate(int pReferCode)
        {
            JARefer tmpRefer = new JARefer(pReferCode);

            if (tmpRefer.view_date_time != DateTime.MinValue)
            {
                return(true);
            }
            if ((tmpRefer.view_date_time == DateTime.MinValue) &&
                (JMainFrame.CurrentPostCode != tmpRefer.sender_post_code ||
                 (JMainFrame.CurrentPostCode == tmpRefer.sender_post_code && JMainFrame.CurrentPostCode == tmpRefer.receiver_post_code))
                )
            {
                tmpRefer.view_date_time = (new JDataBase().GetCurrentDateTime());
                return(tmpRefer.Update());
            }
            return(false);
        }
Example #13
0
        /// <summary>
        ///برای ارجاعات ارسالی کد ارجاع دریافتی را بر می گرداند
        /// </summary>
        /// <returns></returns>
        private int GetMainReferCode(int pReferCode)
        {
            JARefer _R = new JARefer(pReferCode);

            if (_R.GetData(_R.parent_code))
            {
                if (_R.receiver_post_code == JMainFrame.CurrentPostCode)
                {
                    return(_R.Code);
                }
                else
                if (_R.parent_code != 0)
                {
                    GetMainReferCode(_R.parent_code);
                }
            }
            return(_ReferCode);
        }
Example #14
0
        public int AfterReferRun(JARefer pRefer, JDataBase pDB)
        {
            int retEvent = 0;

            try
            {
                if (AfterRefer != null && AfterRefer.Length > 0)
                {
                    ClassLibrary.JAction Action = new JAction("AfterRefer", AfterRefer, new object[] { pRefer, pDB }, null);
                    retEvent = (int)Action.run();
                }
            }
            catch
            {
                return(retEvent);
            }
            return(retEvent);
        }
Example #15
0
        public JReferMain(int pReferCode, DataTable dtPerson, bool StatePersons)
        {
            InitializeComponent();
            _StatePersons         = StatePersons;
            _ReferCode            = pReferCode;
            _Refer                = new JARefer(_ReferCode);
            _AutomationObjectCode = _Refer.object_code;
            _SetInterface();
            GetPattern();
            if ((dtPerson != null) && (dtPerson.Rows.Count > 0))
            {
                _FillPerson(dtPerson);
            }

            jArchiveList1.ClassName   = "Automation.JARefer";
            jArchiveList1.ObjectCode  = pReferCode;
            jArchiveList1.SubjectCode = 0;
            jArchiveList1.PlaceCode   = 0;
            //if (pReferCode == 0)
            //    btnReturn.Enabled = false;
        }
Example #16
0
        private void btnConfirm_Click(object sender, EventArgs e)
        {
            JARefer tmpRefer = new JARefer();

            tmpRefer.GetData(_Refer_Code);
            JAExternalRefer tmp = new JAExternalRefer();

            tmp.ConfirmReceiver        = false;
            tmp.Send_Type              = Convert.ToInt32(cmbSendTypeExternal.SelectedValue);
            tmp.Refer_Code             = _Refer_Code;
            tmp.receiver_external_code = tmpRefer.receiver_External_code;
            tmp.receiver_full_title    = tmpRefer.receiver_full_title;
            tmp.Description            = txtDesc.Text;
            if (tmp.Insert() > 0)
            {
                JMessages.Message("Register Successfully ", "Register", JMessageType.Information);
            }
            else
            {
                JMessages.Message("Register Not Successfully ", "Register", JMessageType.Information);
            }
        }
Example #17
0
        public ClassLibrary.JNode GetNode(System.Data.DataRow DR)
        {
            JARefer R = new JARefer((int)DR["Code"]);

            if (R.receiver_post_code == JMainFrame.CurrentPostCode && R.status == (int)ClassLibrary.Domains.JAutomation.JReferStatus.Current)
            {
                CurrentKartable = JAFolderTypeEnum.Inbox;
            }
            else
            {
                CurrentKartable = JAFolderTypeEnum.SendItem;
            }


            ClassLibrary.JNode node = new JNode((int)DR["Code"], 0);
            node.ClassName = "Automation.JKartable";

            Nodes.hidColumns = "R.Code,ObjectCode,externalcode,action,Objecttype";

            /// اکشن باز کردن
            JAction editAction = new JAction("Open...", "Automation.JKartable.MouseDBClickKartable", new object[] { DR, CurrentKartable }, null);

            node.MouseDBClickAction = editAction;
            node.EnterClickAction   = editAction;
            node.Popup.Insert(editAction);
            // اکشن ارسال به پوشه
            JAction MoveToFolder = new JAction("SendToFolder...", "Automation.JKartable.MoveToFolder", new object[] { DR }, null);

            node.Popup.Insert(MoveToFolder);
            // اکشن حذف از پوشه
            JAction DeleteToFolder = new JAction("DeleteFromFolder...", "Automation.JKartable.DeleteFromFolder", new object[] { (int)DR["Code"] }, null);

            node.Popup.Insert(DeleteToFolder);

            // اکشن برگشت از ارجاع برای ارسال شده ها
            JARefer jaRefer = (new JARefer((int)DR["Code"]));

            if (jaRefer.status == 1 && jaRefer.sender_post_code == JMainFrame.CurrentPostCode)
            {
                if (JARefers.isReferView((int)DR["Code"]) == false)
                {
                    JAction ReturnRefer = new JAction("ReturnRefer...", "Automation.JKartable.ReturnRefer", new object[] { DR }, null);
                    node.Popup.Insert(ReturnRefer);
                }
            }

            // ارجا مجدد
            JAObject O = new JAObject(jaRefer.object_code);

            {
                JAction reRefer = new JAction("ReRefer...", O.ClassName + ".reRefer", new object[] { O.ObjectCode, jaRefer.Code }, null);
                node.Popup.Insert(reRefer);
            }



            //JAction SendReferAgain = new JAction("Open...", "Automation.JKartable.SendReferAgain", new object[] { (int)DR["Code"] }, null);
            //node.Popup.Insert(editAction);

            node.GetPanel = new JAction("GetPanel...", DR["ClassName"].ToString() + ".GetPanel", new object[] { DR["DynamicClassCode"], DR["ObjectCode"], DR["Code"] }, null);

            return(node);
        }
Example #18
0
        private void JfrmReturn_Load(object sender, EventArgs e)
        {
            JARefer tmp = new JARefer(_ReferCode);

            lblReceiver.Text = tmp.sender_full_title;
        }
Example #19
0
        private void SendRefer()
        {
            JDataBase db = JGlobal.MainFrame.GetDBO();

            try
            {
                if (_dt.Rows.Count == 0)
                {
                    if ((cdbReferInternal.SelectedValue != null) && (Convert.ToInt32(cdbReferInternal.SelectedValue) != -1))
                    {
                        if (rchDesc.Text.Trim() == "")
                        {
                            JMessages.Error("لطفا توضیحات را وارد کنید.", "Error");
                            return;
                        }
                        btnAddRefer_Click(null, null);
                    }
                    else
                    {
                        JMessages.Error("Please Add One Refer", "Error");
                        return;
                    }
                }

                JARefer tmprefer = new JARefer();
                if (_AutomationObjectCode == 0)
                {
                    _AutomationObjectCode = tmprefer.SendToAutomation(_ExternalObjectCode, _ObjectType, _Description, _Title, _ClassName, db,
                                                                      JMainFrame.CurrentPostTitle, JMainFrame.CurrentPostCode, JMainFrame.CurrentUserCode, false);
                }
                int Code = 0;
                tmprefer.parent_code = GetMainReferCode(_ReferCode);
                // در صورتیکه اولین بار ارجاع شود
                if (_Refer.object_code != 0)
                {
                    tmprefer.object_code = _Refer.object_code;
                }
                else
                {
                    tmprefer.object_code = _AutomationObjectCode;
                }
                //btnAddRefer_Click(null, null);
                foreach (DataRow dr in _dt.Rows)
                {
                    db.beginTransaction("ReferRegister");
                    //ارسال به داخل سازمان
                    //if (tbcReferType.TabPages[tbcReferType.SelectedIndex].Name == "tbpInternalrefer")
                    //{
                    tmprefer.receiver_post_code  = Convert.ToInt32(dr["receiver_post_code"]); //Convert.ToInt32(cdbReferInternal.SelectedItem["code"]);
                    tmprefer.receiver_code       = Convert.ToInt32(dr["receiver_code"]);      //Convert.ToInt32(cdbReferInternal.SelectedItem["user_code"]);
                    tmprefer.receiver_full_title = dr["receiver_full_title"].ToString();      //cdbReferInternal.SelectedItem["full_title"].ToString();
                    tmprefer.refertype           = Convert.ToInt32(dr["refertype"]);          //ClassLibrary.Domains.JAutomation.JReferType.Internal;
                    //}
                    //ارسال به خارج از سازمان
                    //else
                    //{
                    //    tmprefer.receiver_post_code = Convert.ToInt32(cdbReferExternal.SelectedItem["code"]);
                    //    tmprefer.receiver_code = Convert.ToInt32(cdbReferExternal.SelectedItem["user_code"]);
                    //    tmprefer.receiver_full_title = cdbReferExternal.SelectedItem["full_title"].ToString();
                    //    tmprefer.refertype = ClassLibrary.Domains.JAutomation.JReferType.External;
                    //}

                    tmprefer.task_code = 0;
                    // ارسال کننده
                    JUser user = new JUser(JMainFrame.CurrentUserCode);
                    tmprefer.sender_post_code  = JMainFrame.CurrentPostCode;
                    tmprefer.sender_code       = JMainFrame.CurrentUserCode;
                    tmprefer.sender_full_title = JMainFrame.CurrentPostTitle;

                    tmprefer.send_date_time = JMainFrame.GlobalDataBase.GetCurrentDateTime();
                    tmprefer.status         = ClassLibrary.Domains.JAutomation.JReferStatus.Current;
                    tmprefer.secret_level   = Convert.ToInt32(dr["secret_level"]);//Convert.ToInt32(cmbsecuritylevel.SelectedValue);
                    tmprefer.is_active      = true;

                    if ((dr["respite_date_time"] != "") && (Convert.ToDateTime(dr["respite_date_time"]) != DateTime.MinValue))
                    {
                        tmprefer.respite_date_time = JDateTime.GregorianDate(dr["respite_date_time"].ToString());
                    }
                    //if (!nedPersuit.EmptyDate)
                    //    tmprefer.respite_date_time = Convert.ToDateTime(nedPersuit.Text);

                    tmprefer.urgency        = Convert.ToInt32(dr["urgency"]);  //Convert.ToInt32(cmbUrgency.SelectedValue);
                    tmprefer.message        = dr["message"].ToString();        //txtNormalEmperise.Text.Trim();
                    tmprefer.message_secret = dr["message_secret"].ToString(); //txtSecretEmperise.Text.Trim();
                    tmprefer.description    = dr["description"].ToString();    //rchDesc.Text;

                    tmprefer.register_user_code = JMainFrame.CurrentUserCode;
                    tmprefer.register_Date_Time = JMainFrame.GlobalDataBase.GetCurrentDateTime();

                    Code = tmprefer.Send(db);
                    if (Code > 0)
                    {
                        if (_ReferCode > 0)
                        {
                            _Refer.status = ClassLibrary.Domains.JAutomation.JReferStatus.Sent;
                            if (_Refer.Save(db))
                            {
                                if (db.Commit())
                                {
                                    isSendRefer               = true;
                                    jArchiveList1.ClassName   = "Automation.JARefer";
                                    jArchiveList1.SubjectCode = 0;
                                    jArchiveList1.ObjectCode  = Code;
                                    jArchiveList1.ArchiveList();

                                    JMessages.Message(JLanguages._Text("Send With Number ") + "  " + Code.ToString() + " " + JLanguages._Text("Successfuly"), "Send", JMessageType.Information);

                                    if ((JSystem.Nodes.CurrentNode != null) && (JSystem.Nodes.CurrentNode.ClassName == "Automation.JKartable"))
                                    {
                                        JSystem.Nodes.Delete(JSystem.Nodes.CurrentNode);
                                    }


                                    //----Refresh Kartabl
                                    //JKartable tmp = new JKartable();
                                    //tmp.GetInBoxRefer();
                                }
                                else
                                {
                                    db.Rollback(db.TransactionName);
                                    JMessages.Message("Send Not Successfully", "", JMessageType.Error);
                                }
                            }
                            else
                            {
                                db.Rollback(db.TransactionName);
                                JMessages.Message("Send Not Successfully", "", JMessageType.Error);
                            }
                        }
                        else
                        if ((_ReferCode < 0) && (_AutomationObjectCode < 0))
                        {
                            db.Rollback(db.TransactionName);
                            JMessages.Message("Send Not Successfully", "", JMessageType.Information);
                        }
                        else
                        if (db.Commit())
                        {
                            isSendRefer               = true;
                            jArchiveList1.ClassName   = "Automation.JARefer";
                            jArchiveList1.SubjectCode = 0;
                            jArchiveList1.ObjectCode  = Code;
                            jArchiveList1.ArchiveList();

                            JMessages.Message(JLanguages._Text("Send With Number ") + "  " + Code.ToString() + " " + JLanguages._Text("Successfuly"), "Send", JMessageType.Information);

                            if ((JSystem.Nodes.CurrentNode != null) && (JSystem.Nodes.CurrentNode.ClassName == "Automation.JKartable"))
                            {
                                JSystem.Nodes.Delete(JSystem.Nodes.CurrentNode);
                            }
                            //----Refresh Kartabl
                            //JKartable tmp = new JKartable();
                            //tmp.GetInBoxRefer();
                        }
                        else
                        {
                            JMessages.Message("Send Not Successfully", "", JMessageType.Information);
                        }
                    }
                    else
                    {
                        db.Rollback(db.TransactionName);
                        JMessages.Message("Send Not Successfully", "", JMessageType.Information);
                    }
                }
                if (jdgvRefer.Rows.Count > 0)
                {
                    this.DialogResult = DialogResult.OK;
                }
                this.Close();
            }
            catch (Exception ex)
            {
                JBase.Except.AddException(ex);
            }
        }
Example #20
0
        public DataTable GetPosts()
        {
            int CurrentPostCode = 0;

            if (ReferCode == 0 && _PublicDataRow.Columns.IndexOf("PostCode") != -1 && _PublicDataRow.Rows.Count > 0)
            {
                CurrentPostCode = int.Parse(_PublicDataRow.Rows[0]["PostCode"].ToString());
            }
            else
            {
                CurrentPostCode = ClassLibrary.JMainFrame.CurrentPostCode;
            }
            Employment.JEOrganizationChart OC = new Employment.JEOrganizationChart();
            switch (NodeType)
            {
            case JNodeType.Employment:
                DataTable  DT  = Employment.JEOrganizationChart.GetPost(GetPostCode(PostCode), false);
                JDataTable _DT = new JDataTable();

                _DT.Columns.Add("Job");
                _DT.Columns.Add("Code");
                _DT.Columns.Add("Full_Title");
                _DT.Columns.Add("Ordered");
                DataRow _DR  = _DT.NewRow();
                string  Semi = "";
                foreach (DataRow DR in DT.Rows)
                {
                    _DR["Job"]        += Semi + DR["Job"].ToString();
                    _DR["Code"]       += Semi + DR["Code"].ToString();
                    _DR["Full_Title"] += Semi + DR["Full_Title"].ToString();
                    Semi = ";";
                }
                _DT.Rows.Add(_DR);
                _DT.AcceptChanges();
                return(_DT);

                break;

            case JNodeType.SepratedEmployment:
                DataTable  DT2  = Employment.JEOrganizationChart.GetPost(GetPostCode(PostCode), false);
                JDataTable _DT2 = new JDataTable();

                _DT2.Columns.Add("Job");
                _DT2.Columns.Add("Code");
                _DT2.Columns.Add("Full_Title");
                foreach (DataRow DR2 in DT2.Rows)
                {
                    DataRow _DR2 = _DT2.NewRow();
                    _DR2["Job"]        = DR2["Job"].ToString();
                    _DR2["Code"]       = DR2["Code"].ToString();
                    _DR2["Full_Title"] = DR2["Full_Title"].ToString();
                    _DT2.Rows.Add(_DR2);
                }
                _DT2.AcceptChanges();
                return(_DT2);

                break;

            case JNodeType.EmploymentManager:
                return(Employment.JEOrganizationChart.GetPost(CurrentPostCode, true));

                break;

            case JNodeType.End:
                return(Employment.JEOrganizationChart.GetPost(PostCode, false));

                break;

            case JNodeType.NonEmployment:
                return(OC.GetChart(CurrentPostCode, 1));

                break;

            case JNodeType.NonEmploymentWithOutUnit:
                return(OC.GetChart(CurrentPostCode, 1, false));

                break;

            case JNodeType.Start:
                return(null);

                break;

            case JNodeType.FirstEmployment:
                JARefer Ref = JARefer.FirstRefer(ReferCode);
                return(Employment.JEOrganizationChart.GetPost(Ref.sender_post_code, false));

                break;

            case JNodeType.FlowEmployment:
                break;

            case JNodeType.PreviousEmployment:
                JARefer _Refer = new JARefer(ReferCode);
                return(Employment.JEOrganizationChart.GetPost(_Refer.sender_post_code, false));

                break;

            case JNodeType.Trash:
                return(Employment.JEOrganizationChart.GetPost(PostCode, false));

                break;

            case JNodeType.Chart:
                return(Employment.JEOrganizationChart.GetAllData());

                break;

            case JNodeType.SQL:
                string    sql = PostCode;  // in this state PostCode is used for SQL Query
                JDataBase db  = new JDataBase();
                try
                {
                    db.setQuery(sql);
                    if (_PublicDataRow != null && _PublicDataRow.Rows.Count > 0)
                    {
                        foreach (DataColumn col in _PublicDataRow.Columns)
                        {
                            db.AddParams(col.ColumnName, _PublicDataRow.Rows[0][col.ColumnName].ToString());
                        }
                    }
                    return(db.Query_DataTable());
                }
                finally
                {
                    db.Dispose();
                }
                break;
            }
            return(null);
        }