//------------------------------------------------------------------------
protected void BoxObl_OnSelectedIndexChanged(object sender, EventArgs e)
{
string KeyObl;
string SqlCnt;
string connectionString = WebConfigurationManager.ConnectionStrings[MdbNam].ConnectionString;
SqlConnection con = new SqlConnection(connectionString);
con.Open();
if (Convert.ToInt32(BoxObl.SelectedValue) > 0)
{
KeyObl = Convert.ToInt32(BoxObl.SelectedValue).ToString("D5");
//============================= читать дату договора ====================================================================
SqlCnt = "SELECT STRSKLKEY AS RAIKOD,STRSKLNAM AS RAINAM FROM SPRSTRSKL WHERE STRSKLLVL=2 " +
" AND LEFT(STRSKLKEY,5)='" + KeyObl + "' ORDER BY STRSKLNAM";
// ------------------------------------------------------------------------------заполняем второй уровень
// создание команды
DataSet dsCnt = new DataSet();
SqlCommand cmdCnt = new SqlCommand(SqlCnt, con);
SqlDataAdapter daCnt = new SqlDataAdapter(cmdCnt);
daCnt.Fill(dsCnt, "Cnt");
BoxRai.Items.Clear();
BoxRai.DataSource = dsCnt;
BoxRai.DataBind();
//===============================================================================================================
con.Close();
}
}
// ============================ чтение заголовка таблицы а оп ==============================================
void getDocNum()
{
string KeyObl;
string SqlCnt;
GlvDocIdn = Convert.ToInt32(Session["GLVDOCIDN"]);
DataSet ds = new DataSet();
string connectionString = WebConfigurationManager.ConnectionStrings[MdbNam].ConnectionString;
// создание соединение Connection
SqlConnection con = new SqlConnection(connectionString);
// создание команды
SqlCommand cmd = new SqlCommand("SELECT * FROM TABDOC WHERE DOCIDN=" + GlvDocIdn, con);
con.Open();
// создание DataAdapter
SqlDataAdapter da = new SqlDataAdapter(cmd);
// заполняем DataSet из хран.процедуры.
da.Fill(ds, "GetDocNum");
con.Close();
DOCDAT.Text = Convert.ToDateTime(ds.Tables[0].Rows[0]["DOCDAT"]).ToString("dd.MM.yyyy");
DOCNUM.Text = Convert.ToString(ds.Tables[0].Rows[0]["DOCNUM"]);
DOCKOL.Text = Convert.ToString(ds.Tables[0].Rows[0]["DOCKOL"]);
if (Convert.ToString(ds.Tables[0].Rows[0]["DOCDEBSPRVAL"]).Length > 4)
{
BoxObl.SelectedValue = Convert.ToString(ds.Tables[0].Rows[0]["DOCDEBSPRVAL"]).Substring(0, 5);
//============================= читать дату договора ====================================================================
// KeyObl = Convert.ToInt32(BoxObl.SelectedValue).ToString("D5");
//============================= читать дату договора ====================================================================
// SqlCnt = "SELECT STRSKLKEY AS RAIKOD,STRSKLNAM AS RAINAM FROM SPRSTRSKL WHERE STRSKLLVL=2 " + " AND LEFT(STRSKLKEY,5)='" + KeyObl + "' ORDER BY STRSKLNAM";
SqlCnt = "SELECT STRSKLKEY AS RAIKOD,STRSKLNAM AS RAINAM FROM SPRSTRSKL WHERE STRSKLLVL=2 ORDER BY STRSKLNAM";
// ------------------------------------------------------------------------------заполняем второй уровень
// создание команды
DataSet dsCnt = new DataSet();
SqlCommand cmdCnt = new SqlCommand(SqlCnt, con);
SqlDataAdapter daCnt = new SqlDataAdapter(cmdCnt);
daCnt.Fill(dsCnt, "Cnt");
BoxRai.Items.Clear();
BoxRai.DataSource = dsCnt;
BoxRai.DataBind();
//===============================================================================================================
con.Close();
BoxRai.SelectedValue = Convert.ToString(ds.Tables[0].Rows[0]["DOCDEBSPRVAL"]);
}
/*
* // создание командыISNULL(STRKLTUBL,0)=0 AND
* DataSet dsCnt = new DataSet();
* SqlCommand cmdCnt = new SqlCommand("SELECT STRSKLKEY AS RAIKOD,STRSKLNAM AS RAINAM FROM SPRSTRSKL WHERE STRSKLLVL=2 ORDER BY STRSKLNAM", con);
* SqlDataAdapter daCnt = new SqlDataAdapter(cmdCnt);
* daCnt.Fill(dsCnt, "Cnt");
* BoxRai.Items.Clear();
*
* if (dsCnt.Tables[0].Rows.Count > 0)
* {
* BoxRai.DataSource = dsCnt;
* BoxRai.DataBind();
* }
* //===============================================================================================================
* con.Close();
*/
}
