C# Addr_OrganizeCityBLL.GetAllChildNodeIDs方法代碼示例

本文整理匯總了C#中Addr_OrganizeCityBLL.GetAllChildNodeIDs方法的典型用法代碼示例。如果您正苦於以下問題：C# Addr_OrganizeCityBLL.GetAllChildNodeIDs方法的具體用法？C# Addr_OrganizeCityBLL.GetAllChildNodeIDs怎麽用？C# Addr_OrganizeCityBLL.GetAllChildNodeIDs使用的例子？那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類Addr_OrganizeCityBLL的用法示例。

在下文中一共展示了Addr_OrganizeCityBLL.GetAllChildNodeIDs方法的15個代碼示例，這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚，您的評價將有助於係統推薦出更棒的C#代碼示例。

示例1: BindData

    public void BindData()
    {
        string condition = "";
        DateTime dtBegin = DateTime.Parse(this.tbx_begin.Text);
        DateTime dtEnd = DateTime.Parse(this.tbx_end.Text).AddDays(1);

        condition = "HR_ZhaoPinApply.InsertTime BETWEEN '" + dtBegin.ToString("yyyy-MM-dd") + "' AND '" + dtEnd.ToString("yyyy-MM-dd") + "' ";
        if (tr_OrganizeCity.SelectValue != "1")
        {
            Addr_OrganizeCityBLL orgcity = new Addr_OrganizeCityBLL(int.Parse(tr_OrganizeCity.SelectValue));
            string orgcitys = orgcity.GetAllChildNodeIDs();
            if (orgcitys != "") orgcitys += ",";
            orgcitys += tr_OrganizeCity.SelectValue;

            condition += " AND HR_ZhaoPinApply.OrganizeCity IN (" + orgcitys + ")";
        }

        if (tr_Position.SelectValue != "0")
        {
            condition += " AND HR_ZhaoPinApply.sqgw =" + tr_Position.SelectValue;
        }

        //Response.Write(condition);
        gv_List.ConditionString = condition;
        gv_List.BindGrid();
    }

開發者ID:fuhongliang，項目名稱:GraduateProject，代碼行數:26，代碼來源:ZhaoPinApplyList.aspx.cs

示例2: Page_Load

    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            ViewState["Type"] = Request.QueryString["Type"] == null ? 0 : int.Parse(Request.QueryString["Type"]); //客戶類型，1:公司倉庫 2：經銷商 3：終端門店

            #region 設置頁麵Title
            if ((int)ViewState["Type"] == 1)
                lb_PageTitle.Text = "辦事處出貨查詢";
            else if ((int)ViewState["Type"] == 2)
                lb_PageTitle.Text = "經銷商出貨查詢";
            else if ((int)ViewState["Type"] == 3)
                lb_PageTitle.Text = "零售商銷量查詢";
            else if ((int)ViewState["Type"] == 4)
                lb_PageTitle.Text = "辦事處進貨查詢";
            #endregion

            AdvancedSearch1.ExtCondition = "SVM_SalesVolume.Type=" + ViewState["Type"].ToString();

            #region 判斷當前可查詢的範圍
            Org_StaffBLL staff = new Org_StaffBLL((int)Session["UserID"], true);

            if (staff.Model.OrganizeCity > 1)
            {
                Addr_OrganizeCityBLL orgcity = new Addr_OrganizeCityBLL(staff.Model.OrganizeCity, true);
                string orgcitys = orgcity.GetAllChildNodeIDs();
                if (orgcitys != "") orgcitys += ",";
                orgcitys += staff.Model.OrganizeCity.ToString();

                AdvancedSearch1.ExtCondition += " AND SVM_SalesVolume.OrganizeCity IN (" + orgcitys + ")";
            }
            #endregion
        }
    }

開發者ID:fuhongliang，項目名稱:GraduateProject，代碼行數:34，代碼來源:SalesVolumeAdvanceFind.aspx.cs

示例3: BindGrid

    private void BindGrid()
    {
        string condition = " 1=1 ";

        #region 組織查詢條件
        if (string.IsNullOrEmpty(tr_OrganizeCity.SelectValue) && tr_OrganizeCity.SelectValue != "0")
        {
            //管理片區及所有下屬管理片區
            Addr_OrganizeCityBLL orgcity = new Addr_OrganizeCityBLL(int.Parse(tr_OrganizeCity.SelectValue));
            string orgcitys = orgcity.GetAllChildNodeIDs();
            if (orgcitys != "") orgcitys += ",";
            orgcitys += tr_OrganizeCity.SelectValue;

            condition += " AND ORD_OrderDelivery.OrganizeCity IN (" + orgcitys + ")";
        }

        //會計月條件
        condition += " AND ORD_OrderDelivery.AccountMonth = " + ddl_Month.SelectedValue;

        //申請單號
        if (tbx_SheetCode.Text != "")
        {
            condition += " AND ORD_OrderDelivery.SheetCode like '%" + tbx_SheetCode.Text + "%'";
        }

        //審批狀態
        if (ddl_State.SelectedValue != "0")
        {
            condition += " AND ORD_OrderDelivery.State = " + ddl_State.SelectedValue;
        }
        #endregion
           // gv_List.ConditionString = condition;
        gv_List.BindGrid();
    }

開發者ID:fuhongliang，項目名稱:GraduateProject，代碼行數:34，代碼來源:OrderDeliveryList.aspx.cs

示例4: BindGrid

    private void BindGrid()
    {
        string condition = "1=1";

        #region 組織查詢條件
        //管理片區及所有下屬管理片區
        if (tr_OrganizeCity.SelectValue != "1")
        {
            Addr_OrganizeCityBLL orgcity = new Addr_OrganizeCityBLL(int.Parse(tr_OrganizeCity.SelectValue));
            string orgcitys = orgcity.GetAllChildNodeIDs();
            if (orgcitys != "") orgcitys += ",";
            orgcitys += tr_OrganizeCity.SelectValue;
            condition += " AND FNA_StaffSalary.OrganizeCity IN (" + orgcitys + ")";
        }

        //會計月條件
        condition += " AND FNA_StaffSalary.AccountMonth Between " + ddl_BeginMonth.SelectedValue;
        condition += " AND " + ddl_EndMonth.SelectedValue;

        //審批狀態
        if (ddl_State.SelectedValue != "0")
        {
            condition += " AND FNA_StaffSalary.State = " + ddl_State.SelectedValue;
        }
        #endregion

        gv_List.ConditionString = condition;
        gv_List.BindGrid();
    }

開發者ID:fuhongliang，項目名稱:GraduateProject，代碼行數:29，代碼來源:StaffSalaryList.aspx.cs

示例5: BindGrid

    public void BindGrid()
    {
        string condition = " 1 = 1 ";

        #region 判斷當前可查詢的範圍
        if (tr_OrganizeCity.SelectValue != "1")
        {
            Addr_OrganizeCityBLL orgcity = new Addr_OrganizeCityBLL(int.Parse(tr_OrganizeCity.SelectValue));
            string orgcitys = orgcity.GetAllChildNodeIDs();
            if (orgcitys != "") orgcitys += ",";
            orgcitys += tr_OrganizeCity.SelectValue;

            if (orgcitys != "") condition += " AND OrganizeCity IN (" + orgcitys + ")";
        }

        if (tr_Position.SelectValue != "1")
        {
            Org_PositionBLL org_position = new Org_PositionBLL(int.Parse(tr_Position.SelectValue));
            string positions = org_position.GetAllChildPosition();
            if (positions != "") positions += ",";
            positions += tr_Position.SelectValue;

            if (positions != "") condition += " AND Position IN (" + positions + ")";
        }
        #endregion

        gv_List.BindGrid(Org_StaffNumberLimitBLL.GetModelList(condition));
    }

開發者ID:fuhongliang，項目名稱:GraduateProject，代碼行數:28，代碼來源:Org_StaffNumberLimit.aspx.cs

示例6: bt_Refresh_Click

    protected void bt_Refresh_Click(object sender, EventArgs e)
    {
        string orgcitys = "";
        if (tr_OrganizeCity.SelectValue != "0")
        {
            Addr_OrganizeCityBLL orgcity = new Addr_OrganizeCityBLL(int.Parse(tr_OrganizeCity.SelectValue), true);
            orgcitys = orgcity.GetAllChildNodeIDs();
            if (orgcitys != "") orgcitys += ",";
            orgcitys += tr_OrganizeCity.SelectValue;
        }
        else
        {
            MessageBox.Show(this, "請選擇要查詢的管理片區!");
            return;
        }

        ReportParameter[] _parms = {
            new ReportParameter("OrganizeCitys", orgcitys),
            new ReportParameter("BeginMonth", ddl_BeginMonth.SelectedValue),
            new ReportParameter("EndMonth", ddl_EndMonth.SelectedValue)
        };

        ReportViewer1.ServerReport.ReportServerCredentials = new MCSReportServerCredentials();
        ReportViewer1.ServerReport.ReportPath = ViewState["ReportPath"].ToString();
        ReportViewer1.ServerReport.ReportServerUrl = new Uri(ViewState["ReportServerUrl"].ToString());
        ReportViewer1.ServerReport.SetParameters(_parms);
           // ReportViewer1.ServerReport.Refresh();
    }

開發者ID:fuhongliang，項目名稱:GraduateProject，代碼行數:28，代碼來源:PubReportViewer01.aspx.cs

示例7: BindGrid

    private void BindGrid()
    {
        string condition = "1=1";

        #region 組織查詢條件
        if (chb_ToOrganizecityChild.Checked)
        {
            Addr_OrganizeCityBLL orgcity = new Addr_OrganizeCityBLL(int.Parse(tr_OrganizeCity.SelectValue));
            string orgcitys = orgcity.GetAllChildNodeIDs();
            if (orgcitys != "") orgcitys += ",";
            orgcitys += tr_OrganizeCity.SelectValue;
            condition += " AND PDT_StandardPrice.OrganizeCity IN (" + orgcitys + ")";
        }
        else
        {
            condition += " AND PDT_StandardPrice.OrganizeCity=" + tr_OrganizeCity.SelectValue;
        }
        #endregion
        //if (MCSTabControl1.SelectedIndex == 0)
        //{
        //    condition += " AND PDT_StandardPrice.ActiveFlag=1 AND PDT_StandardPrice.ApproveFlag=1";
        //}
        //else
        //{
        //    condition += " AND (PDT_StandardPrice.ActiveFlag=2 OR PDT_StandardPrice.ApproveFlag=2)";
        //}
        condition += " AND PDT_StandardPrice.ActiveFlag=1 AND PDT_StandardPrice.ApproveFlag=1";
        gv_List.ConditionString = condition;
        gv_List.BindGrid();
    }

開發者ID:fuhongliang，項目名稱:GraduateProject，代碼行數:30，代碼來源:PDT_StandardPrice.aspx.cs

示例8: bt_Refresh_Click

    protected void bt_Refresh_Click(object sender, EventArgs e)
    {
        string orgcitys = "";
        if (tr_OrganizeCity.SelectValue != "0")
        {
            Addr_OrganizeCityBLL orgcity = new Addr_OrganizeCityBLL(int.Parse(tr_OrganizeCity.SelectValue), true);
            orgcitys = orgcity.GetAllChildNodeIDs();
            if (orgcitys != "") orgcitys += ",";
            orgcitys += tr_OrganizeCity.SelectValue;
        }
        else
        {
            MessageBox.Show(this, "請選擇要查詢的管理片區!");
            return;
        }

        ReportViewer1.ServerReport.ReportServerCredentials = new MCSReportServerCredentials();
        ReportViewer1.ServerReport.ReportPath = ViewState["ReportPath"].ToString();
        ReportViewer1.ServerReport.ReportServerUrl = new Uri(ViewState["ReportServerUrl"].ToString());

        if (ReportViewer1.ServerReport.GetParameters().Count == 3)
        {
            int staff = 0;
            int position = new Org_StaffBLL((int)Session["UserID"]).Model.Position;
            string remark = new Org_PositionBLL(position).Model.Remark;
            if (remark != null && remark.Contains("OnlyViewSelfReport"))
            {
                staff = (int)Session["UserID"];
            }
            ReportParameter[] _parms = {
                new ReportParameter("OrganizeCitys", orgcitys),
                new ReportParameter("Month", ddl_Month.SelectedValue),
                new ReportParameter("Staff",staff.ToString())
             };
            ReportViewer1.ServerReport.SetParameters(_parms);
        }
        else
        {
            ReportParameter[] _parms = {
                new ReportParameter("OrganizeCitys", orgcitys),
                new ReportParameter("Month", ddl_Month.SelectedValue)
            };
            ReportViewer1.ServerReport.SetParameters(_parms);
        }
    }

開發者ID:fuhongliang，項目名稱:GraduateProject，代碼行數:45，代碼來源:PubReportViewer04.aspx.cs

示例9: Page_Load

    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            #region 判斷當前可查詢的範圍
            Org_StaffBLL staff = new Org_StaffBLL((int)Session["UserID"], true);

            if (staff.Model.OrganizeCity > 1 && staff.GetStaffOrganizeCity().Select("ID = 1").Length==0)
            {
                Addr_OrganizeCityBLL orgcity = new Addr_OrganizeCityBLL(staff.Model.OrganizeCity, true);
                string orgcitys = orgcity.GetAllChildNodeIDs();
                if (orgcitys != "") orgcitys += ",";
                orgcitys += staff.Model.OrganizeCity.ToString();
                AdvancedSearch1.ExtCondition = " MCS_CM.dbo.CM_Client.OrganizeCity IN (" + orgcitys + ") AND MCS_CM.dbo.CM_Client.ClientType=3";
            }
            #endregion
            AdvancedSearch1.DataKeyNames = new string[] { "CM_Client_ID" };
        }
    }

開發者ID:fuhongliang，項目名稱:GraduateProject，代碼行數:19，代碼來源:AdvanceFind.aspx.cs

示例10: Page_Load

    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            #region 判斷當前可查詢的範圍
            Org_StaffBLL staff = new Org_StaffBLL((int)Session["UserID"], true);

            if (staff.Model.OrganizeCity >1)
            {
                Addr_OrganizeCityBLL orgcity = new Addr_OrganizeCityBLL(staff.Model.OrganizeCity, true);
                string orgcitys = orgcity.GetAllChildNodeIDs();
                if (orgcitys != "") orgcitys += ",";
                orgcitys += staff.Model.OrganizeCity.ToString();
                as_uc_Journal.ExtCondition = " MCS_OA.dbo.JN_Journal.OrganizeCity IN (" + orgcitys + ") order by MCS_OA.dbo.JN_Journal.InsertTime desc";
            }
            #endregion
            as_uc_Journal.DataKeyNames = new string[] { "JN_Journal_ID" };
        }
    }

開發者ID:fuhongliang，項目名稱:GraduateProject，代碼行數:19，代碼來源:AdvanceFind.aspx.cs

示例11: BindDate

    public void BindDate()
    {
        string ConditionStr = "";

        string orgcitys = "";
        #region 判斷當前可查詢的範圍
        if (tr_OrganizeCity.SelectValue != "1")
        {
            Addr_OrganizeCityBLL orgcity = new Addr_OrganizeCityBLL(int.Parse(tr_OrganizeCity.SelectValue));
            orgcitys = orgcity.GetAllChildNodeIDs();
            if (orgcitys != "") orgcitys += ",";
            orgcitys += tr_OrganizeCity.SelectValue;

            if (orgcitys != "") ConditionStr += " MCS_Promotor.dbo.PM_SalaryLevel.OrganizeCity IN (" + orgcitys + ")";
        }
        #endregion
        gv_List.ConditionString = ConditionStr;
        gv_List.BindGrid();
    }

開發者ID:fuhongliang，項目名稱:GraduateProject，代碼行數:19，代碼來源:PM_SalaryLevelList.aspx.cs

示例12: Page_Load

    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            #region 判斷當前可查詢的範圍
            Org_StaffBLL staff = new Org_StaffBLL((int)Session["UserID"], true);

            if (staff.Model.OrganizeCity > 1 && staff.GetStaffOrganizeCity().Select("ID = 1").Length == 0)
            {
                Addr_OrganizeCityBLL orgcity = new Addr_OrganizeCityBLL(staff.Model.OrganizeCity, true);
                string orgcitys = orgcity.GetAllChildNodeIDs();
                if (orgcitys != "") orgcitys += ",";
                orgcitys += staff.Model.OrganizeCity.ToString();

                as_uc_promotor.ExtCondition = " MCS_Promotor.dbo.PM_Promotor.OrganizeCity IN (" + orgcitys + ")";
            }
            #endregion
            as_uc_promotor.DataKeyNames = new string[] { "PM_Promotor_ID" };
        }
    }

開發者ID:fuhongliang，項目名稱:GraduateProject，代碼行數:20，代碼來源:AdvanceFind.aspx.cs

示例13: BindGrid

    private void BindGrid()
    {
        string condition = " CarNo LIKE '%" + tbx_CarNo.Text + "%' ";

        #region 判斷當前可查詢的管理片區範圍
        if (tr_OrganizeCity.SelectValue != "1")
        {
            string orgcitys = "";
            Addr_OrganizeCityBLL orgcity = new Addr_OrganizeCityBLL(int.Parse(tr_OrganizeCity.SelectValue), true);
            orgcitys = orgcity.GetAllChildNodeIDs();
            if (orgcitys != "") orgcitys += ",";
            orgcitys += tr_OrganizeCity.SelectValue;

            if (orgcitys != "") condition += " AND Car_CarList.OrganizeCity IN (" + orgcitys + ") ";
        }
        #endregion

        gv_List.ConditionString = condition;
        gv_List.BindGrid();
    }

開發者ID:fuhongliang，項目名稱:GraduateProject，代碼行數:20，代碼來源:CarList.aspx.cs

示例14: BindGrid

    private void BindGrid()
    {
        string ConditionStr = " FNA_BudgetTransferApply.AccountMonth = " + ddl_Month.SelectedValue;

        #region 判斷當前可查詢管理片區的範圍
        string orgcitys = "";
        if (tr_OrganizeCity.SelectValue != "0" && tr_OrganizeCity.SelectValue != "1")
        {
            Addr_OrganizeCityBLL orgcity = new Addr_OrganizeCityBLL(int.Parse(tr_OrganizeCity.SelectValue), true);
            orgcitys = orgcity.GetAllChildNodeIDs();
            if (orgcitys != "") orgcitys += ",";
            orgcitys += tr_OrganizeCity.SelectValue;

            if (orgcitys != "") ConditionStr += " AND FNA_BudgetTransferApply.ToOrganizeCity IN (" + orgcitys + ")";
        }
        #endregion

        gv_List.ConditionString = ConditionStr;
        gv_List.BindGrid();
    }

開發者ID:fuhongliang，項目名稱:GraduateProject，代碼行數:20，代碼來源:BudgetTransferApplyList.aspx.cs

示例15: BindGrid

    private void BindGrid()
    {
        string ConditionStr = " 1 = 1 ";

        #region 判斷當前可查詢管理片區的範圍
        string orgcitys = "";
        if (tr_OrganizeCity.SelectValue != "0" && tr_OrganizeCity.SelectValue != "1")
        {
            Addr_OrganizeCityBLL orgcity = new Addr_OrganizeCityBLL(int.Parse(tr_OrganizeCity.SelectValue), true);
            orgcitys = orgcity.GetAllChildNodeIDs();
            if (orgcitys != "") orgcitys += ",";
            orgcitys += tr_OrganizeCity.SelectValue;

            if (orgcitys != "") ConditionStr += " AND dbo.CM_PropertyInTelephone.OrganizeCity IN (" + orgcitys + ")";
        }
        #endregion

        gv_List.ConditionString = ConditionStr;
        gv_List.BindGrid();
    }

開發者ID:fuhongliang，項目名稱:GraduateProject，代碼行數:20，代碼來源:PropertyInTelephoneList.aspx.cs

注：本文中的Addr_OrganizeCityBLL.GetAllChildNodeIDs方法示例由純淨天空整理自Github/MSDocs等開源代碼及文檔管理平台，相關代碼片段篩選自各路編程大神貢獻的開源項目，源碼版權歸原作者所有，傳播和使用請參考對應項目的License；未經允許，請勿轉載。