コード例 #1
0
        //------------------------------------------------------------------------
        protected void BoxDoc002_OnSelectedIndexChanged(object sender, EventArgs e)
        {
            if (BoxDoc002.SelectedValue == "")
            {
                GrfDlg002 = 0;
            }
            else
            {
                GrfDlg002 = Convert.ToInt32(BoxDoc002.SelectedValue);
            }

            BoxFio002.Enabled = true;
            BoxFio002.Items.Clear();
            BoxFio002.SelectedIndex = -1;
            BoxFio002.SelectedValue = "";
            BoxFio002.DataBind();

            SdsFio001.SelectCommand = "SELECT BuxKod,SprKdr.FIO " +
                                      "FROM SprBux LEFT OUTER JOIN SprKdr ON SprBux.BuxTab=SprKdr.KOD " +
                                      "WHERE SprBux.BuxDlg=" + GrfDlg002 + " AND ISNULL(SprBux.BuxUbl,0)=0 " +
                                      " AND SprBux.BuxFrm=" + BuxFrm +
                                      " ORDER BY SprKdr.FIO ";
            GrfKod002 = 0;
            getBox002();
        }
コード例 #2
0
        protected void BoxDoc002_OnSelectedIndexChanged(object sender, EventArgs e)
        {
            GrfDlg = Convert.ToInt32(BoxDoc002.SelectedValue);

            BoxFio002.Enabled = true;
            BoxFio002.Items.Clear();
            BoxFio002.SelectedIndex = -1;
            BoxFio002.SelectedValue = "";
            BoxFio002.DataBind();

            SdsFio.SelectCommand = "SELECT BuxKod,FIO FROM SprBuxKdr " +
                                   "WHERE Isnull(BuxUbl,0)=0 And DlgKod=" + GrfDlg + " AND BuxFrm=" + BuxFrm + " ORDER BY FIO";

            GrfKod = 0;
            getBox002();
        }