//------------------------------------------------------------------------
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();
}
