コード例 #1
0
        protected void FillBusinessUnitsForLoginType3()
        {
            DataTable dt    = new DataTable();
            string    query = "select distinct bm.bu_code,bu_desc from ax.acxsitebumapping sbp join ax.ACXBUMASTER bm on bm.bu_code = sbp.BU_CODE where SITEID in ('" + GetStringValueCommaSeparted(ucRoleFilters.GetCommaSepartedSiteId()) + "')";

            dt = new DataTable();

            dt = baseObj.GetData(query);
            ChkBunt.Items.Clear();
            ChkBunt.DataSource     = dt;
            ChkBunt.DataTextField  = "bu_desc";
            ChkBunt.DataValueField = "bu_code";
            ChkBunt.DataBind();
        }
コード例 #2
0
        protected void FillBusinessUnits()
        {
            DataTable dt    = new DataTable();
            string    query = "select bm.bu_code,bu_desc from ax.acxsitebumapping sbp join ax.ACXBUMASTER bm on bm.bu_code = sbp.BU_CODE where SITEID in ('" + ddlSiteId.SelectedItem.Value.ToString() + "')";

            dt = new DataTable();

            dt = baseObj.GetData(query);
            ChkBunt.Items.Clear();
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                ChkBunt.DataSource     = dt;
                ChkBunt.DataTextField  = "bu_desc";
                ChkBunt.DataValueField = "bu_code";

                ChkBunt.DataBind();
            }
        }