Ejemplo n.º 1
0
        //------------------------------------------------------------------------
        protected void BoxDoc003_OnSelectedIndexChanged(object sender, EventArgs e)
        {
            if (BoxDoc003.SelectedValue == "")
            {
                GrfDlg003 = 0;
            }
            else
            {
                GrfDlg003 = Convert.ToInt32(BoxDoc003.SelectedValue);
            }

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

            SdsFio001.SelectCommand = "SELECT BuxKod,SprKdr.FIO " +
                                      "FROM SprBux LEFT OUTER JOIN SprKdr ON SprBux.BuxTab=SprKdr.KOD " +
                                      "WHERE SprBux.BuxDlg=" + GrfDlg003 + " AND ISNULL(SprBux.BuxUbl,0)=0 " +
                                      " AND SprBux.BuxFrm=" + BuxFrm +
                                      " ORDER BY SprKdr.FIO ";
            GrfKod003 = 0;
            getBox003();
        }
Ejemplo n.º 2
0
        protected void BoxDoc003_OnSelectedIndexChanged(object sender, EventArgs e)
        {
            GrfDlg = Convert.ToInt32(BoxDoc003.SelectedValue);

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

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

            GrfKod = 0;
            getBox003();
        }