• 设为首页
  • 点击收藏
  • 手机版
    手机扫一扫访问
    迪恩网络手机版
  • 关注官方公众号
    微信扫一扫关注
    迪恩网络公众号

C# Addr_OrganizeCityBLL类代码示例

原作者: [db:作者] 来自: [db:来源] 收藏 邀请

本文整理汇总了C#中Addr_OrganizeCityBLL的典型用法代码示例。如果您正苦于以下问题:C# Addr_OrganizeCityBLL类的具体用法?C# Addr_OrganizeCityBLL怎么用?C# Addr_OrganizeCityBLL使用的例子?那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。



Addr_OrganizeCityBLL类属于命名空间,在下文中一共展示了Addr_OrganizeCityBLL类的20个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于我们的系统推荐出更棒的C#代码示例。

示例1: 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


示例2: 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


示例3: bt_Add_Click

    protected void bt_Add_Click(object sender, EventArgs e)
    {
        if ((int)ViewState["PriceID"] > 0)
        {
            if (tr_OrganizeCity.SelectValue != "0" && tr_OrganizeCity.SelectValue != tr_OrganizeCity.RootValue)
            {
                PDT_StandardPriceBLL bll = new PDT_StandardPriceBLL((int)ViewState["PriceID"]);

                Addr_OrganizeCityBLL selectedcity = new Addr_OrganizeCityBLL(int.Parse(tr_OrganizeCity.SelectValue));
                string[] allparent = selectedcity.GetAllSuperNodeIDs().Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);

                foreach (PDT_StandardPrice_ApplyCity city in bll.ApplyCityItems)
                {
                    if (selectedcity.Model.ID == city.OrganizeCity)
                    {
                        MessageBox.Show(this, "对不起,该区域已在适用区域内,请勿重复添加!");
                        return;
                    }

                    if (allparent.Contains(city.OrganizeCity.ToString()))
                    {
                        MessageBox.Show(this, "对不起,要新增的区域的上级【" + TreeTableBLL.GetFullPathName("MCS_SYS.dbo.Addr_OrganizeCity", city.OrganizeCity) + "】已在适用区域内!");
                        return;
                    }
                }

                PDT_StandardPrice_ApplyCity c = new PDT_StandardPrice_ApplyCity();
                c.OrganizeCity = int.Parse(tr_OrganizeCity.SelectValue);
                bll.AddApplyCity(c);

                BindCheckBoxList();
            }
        }
    }
开发者ID:fuhongliang,项目名称:GraduateProject,代码行数:34,代码来源:PDT_StandardPrice_ApplyCity.aspx.cs


示例4: 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


示例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: 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


示例7: 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


示例8: 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


示例9: btn_Save_Click

    protected void btn_Save_Click(object sender, EventArgs e)
    {
        if ((int)ViewState["ID"] == 1) return;

        Addr_OrganizeCityBLL _bll;
        if ((int)ViewState["ID"] == 0)
        {
            _bll = new Addr_OrganizeCityBLL();
        }
        else
        {
            _bll = new Addr_OrganizeCityBLL((int)ViewState["ID"]);
        }

        _bll.Model.Name = tbx_Name.Text;
        _bll.Model.SuperID = int.Parse(tree_SuperID.SelectValue);
        _bll.Model.Code = tbx_Code.Text;
        _bll.Model.Level = new Addr_OrganizeCityBLL(_bll.Model.SuperID).Model.Level + 1;

        if (select_Manager.SelectValue != "")
            _bll.Model.Manager = int.Parse(select_Manager.SelectValue);

        if (DictionaryBLL.GetDicCollections("Addr_OrganizeCityLevel")[_bll.Model.Level.ToString()] == null)
        {
            lbl_AlertInfo.Text = "添加城市失败,等级超出范围";
            return;
        }

        _bll.Model["ManageRegion"] = tbx_ManageRegion.Text;
        if ((int)ViewState["ID"] == 0)
        {
            if (_bll.Add() < 0)
            {
                lbl_AlertInfo.Text = "添加城市失败。";
                return;
            }
        }
        else
        {
            if (_bll.Model.SuperID == _bll.Model.ID) return;
            int ret = _bll.Update();

            switch (ret)
            {
                case -1:
                    lbl_AlertInfo.Text = "更新城市失败,城市名称已存在";
                    return;
                case -2:
                    lbl_AlertInfo.Text = "更新城市失败,不能将当前城市设置为上级城市";
                    return;
                case -3:
                    lbl_AlertInfo.Text = "更新城市失败,不能将当前城市的子城市设置为上级城市";
                    return;
            }
        }

        DataCache.RemoveCache("Cache-TreeTableBLL-GetAllNode-MCS_SYS.dbo.Addr_OrganizeCity");
        Response.Redirect("OrganizeCityManage.aspx?SuperID=" + _bll.Model.SuperID.ToString());
    }
开发者ID:fuhongliang,项目名称:GraduateProject,代码行数:59,代码来源:OrganizeCityManage.aspx.cs


示例10: btn_Delete_Click

 protected void btn_Delete_Click(object sender, EventArgs e)
 {
     Addr_OrganizeCityBLL _bll = new Addr_OrganizeCityBLL(int.Parse(lbl_ID.Text));
     if (_bll.Delete() < 0)
     {
         lbl_AlertInfo.Text = "该片区包含下级片区,请勿删除";
         return;
     }
     lbl_AlertInfo.Text = "";
     Response.Redirect("OrganizeCityManage.aspx?SuperID=" + _bll.Model.SuperID.ToString());
 }
开发者ID:fuhongliang,项目名称:GraduateProject,代码行数:11,代码来源:OrganizeCityManage.aspx.cs


示例11: bt_Generate_Click

    protected void bt_Generate_Click(object sender, EventArgs e)
    {
        int month = int.Parse(ddl_Month.SelectedValue);
        int organizecity = 0;
        int client = 0;

        int.TryParse(tr_OrganizeCity.SelectValue, out organizecity);
        int.TryParse(select_Client.SelectValue, out client);

        if (organizecity == 0)
        {
            MessageBox.Show(this, "请正确选择管理片区");
            return;
        }

        if (client == 0)
        {
            MessageBox.Show(this, "请正确选择经销商");
            return;
        }

        #region 判断指定区域下是否还有门店销量未审核
        string citys = new Addr_OrganizeCityBLL(organizecity).GetAllChildNodeIDs();
        if (citys == "")
            citys = organizecity.ToString();
        else
            citys += "," + organizecity.ToString();
        string condition = "Type=3 AND Supplier=" + client.ToString() + " AND AccountMonth=" + month.ToString() +
            " AND OrganizeCity IN (" + citys + ") AND ApproveFlag=2 AND Flag=1 AND EXISTS (SELECT 1 FROM MCS_CM.dbo.CM_Client WHERE ClientType=3 AND CM_Client.ID=SVM_SalesVolume.Client)";

        int counts = SVM_SalesVolumeBLL.GetModelList(condition).Count;
        if (counts > 0)
        {
            MessageBox.Show(this, "对不起,您区域还有" + counts.ToString() + "条门店销量未审核");
            return;
        }
        #endregion

        int FeeType = 0;
        FeeType = ConfigHelper.GetConfigInt("ContractFeeType-FL");

        int id = CM_ContractBLL.CreateFLFeeApply(organizecity, month, client, (int)Session["UserID"], FeeType);

        if (id > 0)
            MessageBox.ShowAndRedirect(this, "返利费用申请单生成成功!", "FeeApplyDetail3.aspx?ID=" + id.ToString());
        else if (id == 0)
            MessageBox.Show(this, "对不起,目前尚无返利合同需要申请费用!");
        else if (id == -1)
            MessageBox.Show(this, "对不起,无返利费用生成!请检查是否有返利店有销量,或是之前已经生成该月的返利费用!");
        else
            MessageBox.Show(this, "对不起,返利合同费用申请单生成失败!错误码:" + id.ToString());
    }
开发者ID:fuhongliang,项目名称:GraduateProject,代码行数:52,代码来源:FeeApply_FLContract.aspx.cs


示例12: tr_OrganizeCity_Selected

 protected void tr_OrganizeCity_Selected(object sender, MCSControls.MCSWebControls.SelectedEventArgs e)
 {
     int c = 0;
     if (int.TryParse(tr_OrganizeCity.SelectValue, out c))
     {
         Addr_OrganizeCity city = new Addr_OrganizeCityBLL(c).Model;
         if (city.Level == 5)
             ddl_CityLevel.SelectedValue = "5";
         else if (city.Level > 2)
             ddl_CityLevel.SelectedValue = "4";
         else
             ddl_CityLevel.SelectedValue = "2";
     }
 }
开发者ID:fuhongliang,项目名称:GraduateProject,代码行数:14,代码来源:BudgetSourceAssignInfo.aspx.cs


示例13: BtnSave_Click

    protected void BtnSave_Click(object sender, EventArgs e)
    {
        Addr_OrganizeCity mcity = new Addr_OrganizeCityBLL(int.Parse(tr_OrganizeCity.SelectValue)).Model;
        if (MCSTabControl1.SelectedTabItem.Value == "1" && mcity != null && mcity.Level != ConfigHelper.GetConfigInt("OrganizePartCity-CityLevel"))
        {
            MessageBox.Show(this, "请选择营业部再调整!");
            return;
        }
        if (MCSTabControl1.SelectedTabItem.Value == "2" && mcity != null && mcity.Level != ConfigHelper.GetConfigInt("OrganizeCity-CityLevel"))
        {
            MessageBox.Show(this, "请选择办事处再调整!");
            return;
        }
        FNA_StaffSalaryDataObjectBetaBLL bll = new FNA_StaffSalaryDataObjectBetaBLL();
        if (!CheckSalesTargetAdujst())
        {
            return;
        }
        foreach (GridViewRow row in gv_List.Rows)
        {
            int id = (int)gv_List.DataKeys[row.RowIndex]["FNA_StaffSalaryDataObjectBeta_ID"];
            TextBox txt_SalesTargetAdjust = gv_List.Rows[row.RowIndex].FindControl("tbx_SalesTargetAdujst") == null ? null : (TextBox)gv_List.Rows[row.RowIndex].FindControl("tbx_SalesTargetAdujst");
            TextBox txt_SalesTargetAdjustRate = gv_List.Rows[row.RowIndex].FindControl("tbx_SalesTargetAdujstRate") == null ? null : (TextBox)gv_List.Rows[row.RowIndex].FindControl("tbx_SalesTargetAdujstRate");
            decimal SalesTargetAdujst = 0, SalesTargetAdujstRate = 0;
            TextBox tbx_Remark = gv_List.Rows[row.RowIndex].FindControl("tbx_Remark") == null ? null : (TextBox)gv_List.Rows[row.RowIndex].FindControl("tbx_Remark");
            DropDownList ddl_Flag = row.FindControl("ddl_Flag") == null ? null : (DropDownList)row.FindControl("ddl_Flag");
            if (txt_SalesTargetAdjust != null && txt_SalesTargetAdjustRate != null && decimal.TryParse(txt_SalesTargetAdjust.Text.Trim(), out SalesTargetAdujst)
                && decimal.TryParse(txt_SalesTargetAdjustRate.Text.Trim(), out SalesTargetAdujstRate))
            {
                bll = new FNA_StaffSalaryDataObjectBetaBLL(id);
                decimal oldAdujstRate = bll.Model.Data08;
                bll.Model.SalesTargetAdjust = SalesTargetAdujst;
                bll.Model.Data08 = SalesTargetAdujstRate;
                bll.Model.UpdateStaff = (int)Session["UserID"];
                bll.Model.UpdateTime = DateTime.Now;
                bll.Model["Remark"] = tbx_Remark.Text.Trim();
                bll.Model.Flag = int.Parse(ddl_Flag.SelectedValue);
                bll.Update();
                if (bll.Model.ApproveFlag == 2 && oldAdujstRate != SalesTargetAdujstRate)
                {
                    FNA_StaffSalaryDataObjectBetaBLL.Adjust(bll.Model.AccountMonth, SalesTargetAdujst, bll.Model.Staff);
                }
            }

        }
        BindGrid();
    }
开发者ID:fuhongliang,项目名称:GraduateProject,代码行数:47,代码来源:StaffSalaryDataObjectBetaList.aspx.cs


示例14: 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


示例15: 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


示例16: 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


示例17: 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


示例18: 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


示例19: 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


示例20: 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



注:本文中的Addr_OrganizeCityBLL类示例整理自Github/MSDocs等源码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。


鲜花

握手

雷人

路过

鸡蛋
该文章已有0人参与评论

请发表评论

全部评论

专题导读
上一篇:
C# Address类代码示例发布时间:2022-05-24
下一篇:
C# AddTagsRequestMarshaller类代码示例发布时间:2022-05-24
热门推荐
阅读排行榜

扫描微信二维码

查看手机版网站

随时了解更新最新资讯

139-2527-9053

在线客服(服务时间 9:00~18:00)

在线QQ客服
地址:深圳市南山区西丽大学城创智工业园
电邮:jeky_zhao#qq.com
移动电话:139-2527-9053

Powered by 互联科技 X3.4© 2001-2213 极客世界.|Sitemap