public void Load()
{
DataList3.DataSource = op.SelectImage("手机", 5);
DataList3.DataBind();
DataList4.DataSource = op.SelectImage("电器城", 5);
DataList4.DataBind();
DataList5.DataSource = op.SelectImage("西西超市", 5);
DataList5.DataBind();
DataList6.DataSource = op.SelectImage("西西生活", 5);
DataList6.DataBind();
DataList7.DataSource = op.SelectImage("有我你更美", 5);
DataList7.DataBind();
DataList8.DataSource = op.SelectImage("智能硬件", 5);
DataList8.DataBind();
midImage.DataSource = op.SelectImage("pimage", 5);
midImage.DataBind();
DataList9.DataSource = op.SelectImage("手机", 10);
DataList9.DataBind();
DataList10.DataSource = op.SelectImage("电器城", 10);
DataList10.DataBind();
DataList11.DataSource = op.SelectImage("西西超市", 10);
DataList11.DataBind();
DataList12.DataSource = op.SelectImage("西西生活", 10);
DataList12.DataBind();
DataList13.DataSource = op.SelectImage("智能硬件", 10);
DataList13.DataBind();
DataList14.DataSource = op.SelectImage("有我你更美", 10);
DataList14.DataBind();
DataList15.DataSource = op.SelectImage("办公设备", 10);
DataList15.DataBind();
DataList16.DataSource = op.SelectImage("西西商城", 10);
DataList16.DataBind();
DataList17.DataSource = op.SelectNewInfo(10);
DataList17.DataBind();
Phone.DataSource = op.SelectPhone(10);
Phone.DataBind();
Life.DataSource = op.SelectImage("西西生活", 10);
Life.DataBind();
Electric.DataSource = op.SelectImage("电器城", 10);
Electric.DataBind();
Beauty.DataSource = op.SelectImage("有我你更美", 10);
Beauty.DataBind();
}
//void partiyalar()
//{
// DataTable meqsed = klas.getdatatable("Select PartiyaID,Adi from PartiyalarSiyahi order by PartiyaID");
// partiya.DataTextField = "Adi";
// partiya.DataValueField = "PartiyaID";
// partiya.DataSource = meqsed;
// partiya.DataBind();
// partiya.Items.Insert(0, new ListItem("Seçin", "-1"));
//}
protected void btnAxtar_Click(object sender, EventArgs e)
{
vizual();
DataList1.DataSource = klas.getdatatable("select ROW_NUMBER() OVER (order by t.TesnifatID) SN,c.adi,c.Proqramteminat,c.Lisenziya,c.Sair,Proqramteminat+Lisenziya+Sair as Cemi " +
"from Tesnifatlar t left join IQQeyrimaddiaktiv c on t.TesnifatID=c.TesnifatID where t.Tesnifattipi=2 and c.Hesabatili=" + DropDownListyear.SelectedValue.ToString() + " and c.PartiyaID=" + Session["PartiyaID"].ToString());
DataList1.DataBind();
DataList3.DataSource = klas.getdatatable("select ROW_NUMBER() OVER (order by t.TesnifatID) SN,t.Tesnifatadi adi,c.Binatikili,c.Avadanliq, c.Neqliyyatvas,c.Invertar,c.Sair, c.Avadanliq + c.Neqliyyatvas +c.Binatikili+ c.Invertar + c.Sair as Cemi from Tesnifatlar t left join IQTorpaq c on t.TesnifatID=c.TesnifatID where t.Tesnifattipi=3 and c.Hesabatili=" + DropDownListyear.SelectedValue.ToString() + " and c.PartiyaID=" + Session["PartiyaID"].ToString());
DataList3.DataBind();
DataList4.DataSource = klas.getdatatable("select ROW_NUMBER() OVER (order by t.TesnifatID) SN,t.Tesnifatadi adi,c.Depozit, c.Sair,c.Depozit + c.Sair as Cemi from " +
"Tesnifatlar t left join IQSairuzunmudaktiv c on t.TesnifatID=c.TesnifatID where t.Tesnifattipi=4 and c.Hesabatili=" + DropDownListyear.SelectedValue.ToString() + " and c.PartiyaID=" + Session["PartiyaID"].ToString());
DataList4.DataBind();
DataList5.DataSource = klas.getdatatable(" select ROW_NUMBER() OVER (order by t.TesnifatID) SN,c.Adi,c.Defterxana,c.Yanacaq,c.Sair,c.Defterxana + c.Yanacaq + c.Sair as Cemi from " +
"Tesnifatlar t left join IQEhtiyat c on t.TesnifatID=c.TesnifatID where t.Tesnifattipi=5 and c.Hesabatili=" + DropDownListyear.SelectedValue.ToString() + " and c.PartiyaID=" + Session["PartiyaID"].ToString());
DataList5.DataBind();
DataList6.DataSource = klas.getdatatable(" select ROW_NUMBER() OVER (order by c.IQqisamdebitor) SN,* from " +
" IQQisamudDebitor c where c.Hesabatili=" + DropDownListyear.SelectedValue.ToString() + " and c.PartiyaID=" + Session["PartiyaID"].ToString());
DataList6.DataBind();
DataList7.DataSource = klas.getdatatable(" select ROW_NUMBER() OVER (order by t.TesnifatID) SN,* from " +
"Tesnifatlar t left join IQSairqisamudaktiv c on t.TesnifatID=c.TesnifatID where t.Tesnifattipi=7 and c.Hesabatili=" + DropDownListyear.SelectedValue.ToString() + " and c.PartiyaID=" + Session["PartiyaID"].ToString());
DataList7.DataBind();
DataList8.DataSource = klas.getdatatable(" select ROW_NUMBER() OVER (order by t.TesnifatID) SN,*,Bankkredit + Lizinq as Cemi from " +
"Tesnifatlar t left join IQUzunmudfaizxerc c on t.TesnifatID=c.TesnifatID where t.Tesnifattipi=8 and c.Hesabatili=" + DropDownListyear.SelectedValue.ToString() + " and c.PartiyaID=" + Session["PartiyaID"].ToString());
DataList8.DataBind();
DataList9.DataSource = klas.getdatatable("select ROW_NUMBER() OVER (order by t.TesnifatID) SN,*,Bankkredit + Lizinq as Cemi from " +
"Tesnifatlar t left join IQQisamudfaizxerc c on t.TesnifatID=c.TesnifatID where t.Tesnifattipi=9 and c.Hesabatili=" + DropDownListyear.SelectedValue.ToString() + " and c.PartiyaID=" + Session["PartiyaID"].ToString());
DataList9.DataBind();
DataList10.DataSource = klas.getdatatable("select ROW_NUMBER() OVER (order by t.TesnifatID) SN,* from " +
"Tesnifatlar t left join IQMecburiodenis c on t.TesnifatID=c.TesnifatID where t.Tesnifattipi=10 and c.Hesabatili=" + DropDownListyear.SelectedValue.ToString() + " and c.PartiyaID=" + Session["PartiyaID"].ToString());
DataList10.DataBind();
DataList11.DataSource = klas.getdatatable("select ROW_NUMBER() OVER (order by t.TesnifatID) SN,* from " +
"Tesnifatlar t left join IQQisamudkreditor c on t.TesnifatID=c.TesnifatID where t.Tesnifattipi=11 and c.Hesabatili=" + DropDownListyear.SelectedValue.ToString() + " and c.PartiyaID=" + Session["PartiyaID"].ToString());
DataList11.DataBind();
DataList12.DataSource = klas.getdatatable("select ROW_NUMBER() OVER (order by t.TesnifatID) SN,* from " +
"Tesnifatlar t left join IQSairqisamudohdelik c on t.TesnifatID=c.TesnifatID where t.Tesnifattipi=12 and c.Hesabatili=" + DropDownListyear.SelectedValue.ToString() + " and c.PartiyaID=" + Session["PartiyaID"].ToString());
DataList12.DataBind();
DataList13.DataSource = klas.getdatatable("select ROW_NUMBER() OVER (order by t.TesnifatID) SN,* from " +
"Tesnifatlar t left join IQUzvlukhaqlari c on t.TesnifatID=c.TesnifatID where t.Tesnifattipi=13 and c.Hesabatili=" + DropDownListyear.SelectedValue.ToString() + " and c.PartiyaID=" + Session["PartiyaID"].ToString());
DataList13.DataBind();
DataList14.DataSource = klas.getdatatable("select ROW_NUMBER() OVER (order by IQAlinmisianeID) SN,IQAlinmisianeID," +
"PartiyaID, UserID, Hesabatili, Adi+' '+Soyad+' '+Ataadi adsoyad, Ianekodu, Seriyasi+', '+Nomresi+', '+ " +
"convert(nvarchar,Verilmetarixi,104) seriyanomretarix, convert(nvarchar,Dogumtarixi,104) Dogumtarixi, Unvan, Esasvesait, Malmaterial," +
" Pulformasinda, Esasvesait+Malmaterial+Pulformasinda Cemi, DaxiletmeTarixi, DeyishmeTarixi from IQAlinmisIaneler where Hesabatili=" + DropDownListyear.SelectedValue.ToString() + " and PartiyaID=" + Session["PartiyaID"].ToString());
DataList14.DataBind();
DataList15.DataSource = klas.getdatatable("select ROW_NUMBER() OVER (order by t.TesnifatID) SN,* from " +
"Tesnifatlar t left join IQPulvesait c on t.TesnifatID=c.TesnifatID where t.Tesnifattipi=15 and c.Hesabatili=" + DropDownListyear.SelectedValue.ToString() + " and c.PartiyaID=" + Session["PartiyaID"].ToString());
DataList15.DataBind();
}