//------------------------------------------------------------------------ protected void BoxDoc001_OnSelectedIndexChanged(object sender, EventArgs e) { if (BoxDoc001.SelectedValue == "") { GrfDlg001 = 0; } else { GrfDlg001 = Convert.ToInt32(BoxDoc001.SelectedValue); } BoxFio001.Enabled = true; BoxFio001.Items.Clear(); BoxFio001.SelectedIndex = -1; BoxFio001.SelectedValue = ""; BoxFio001.DataBind(); // SdsFio001.SelectCommand = "SELECT BuxKod,FIO FROM SprBux LEFT OUTER JOIN SprKdr ON SprBux.BuxTab=SprKdr.KOD " + // "WHERE SprBux.BuxDlg=" + GrfDlg001 + " ORDER BY SprKdr.FIO"; SdsFio001.SelectCommand = "SELECT BuxKod,SprKdr.FIO " + "FROM SprBux LEFT OUTER JOIN SprKdr ON SprBux.BuxTab=SprKdr.KOD " + "WHERE SprBux.BuxDlg=" + GrfDlg001 + " AND ISNULL(SprBux.BuxUbl,0)=0 " + " AND SprBux.BuxFrm=" + BuxFrm + " ORDER BY SprKdr.FIO "; GrfKod001 = 0; getBox001(); }
protected void BoxDoc001_OnSelectedIndexChanged(object sender, EventArgs e) { GrfDlg = Convert.ToInt32(BoxDoc001.SelectedValue); BoxFio001.Enabled = true; BoxFio001.Items.Clear(); BoxFio001.SelectedIndex = -1; BoxFio001.SelectedValue = ""; BoxFio001.DataBind(); SdsFio.SelectCommand = "SELECT BuxKod,FIO FROM SprBuxKdr " + "WHERE Isnull(BuxUbl,0)=0 And DlgKod=" + GrfDlg + " AND BuxFrm=" + BuxFrm + " ORDER BY FIO"; GrfKod = 0; getBox001(); }