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(); }
protected void Page_Load(object sender, EventArgs e) { GetGoodsInfo(); 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(); }
//int di; protected void Page_Load(object sender, EventArgs e) { GetGoodsInfo(); Label123.Text = Session["UserName"].ToString(); //DataList1.DataSource = op.SelectInfo(); //DataList1.DataBind(); 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(); }
protected void Page_Load(object sender, EventArgs e) { SqlCommand komut = new SqlCommand("Select *From Tbl_Kategoriler ", bgl.baglanti()); SqlDataReader oku = komut.ExecuteReader(); DataList1.DataSource = oku; DataList1.DataBind(); SqlCommand komutt = new SqlCommand("Select *From Tbl_kahveler WHERE Kahveid=1 ", bgl.baglanti()); SqlDataReader okuu = komutt.ExecuteReader(); DataList3.DataSource = okuu; DataList3.DataBind(); SqlCommand komut2 = new SqlCommand("Select *From Tbl_kahveler WHERE Kahveid=6 ", bgl.baglanti()); SqlDataReader oku2 = komut2.ExecuteReader(); DataList4.DataSource = oku2; DataList4.DataBind(); SqlCommand komut3 = new SqlCommand("Select *From Tbl_kahveler WHERE Kahveid=9 ", bgl.baglanti()); SqlDataReader oku3 = komut3.ExecuteReader(); DataList5.DataSource = oku3; DataList5.DataBind(); SqlCommand komut4 = new SqlCommand("Select *From Tbl_kahveler WHERE Kahveid=11 ", bgl.baglanti()); SqlDataReader oku4 = komut4.ExecuteReader(); DataList6.DataSource = oku4; DataList6.DataBind(); SqlCommand komut5 = new SqlCommand("Select *From Tbl_kahveler WHERE Kahveid=8 ", bgl.baglanti()); SqlDataReader oku5 = komut5.ExecuteReader(); DataList7.DataSource = oku5; DataList7.DataBind(); SqlCommand komut6 = new SqlCommand("Select *From Tbl_kahveler WHERE Kahveid=10 ", bgl.baglanti()); SqlDataReader oku6 = komut6.ExecuteReader(); DataList8.DataSource = oku6; DataList8.DataBind(); SqlCommand komut7 = new SqlCommand("Select *From Tbl_kahveler WHERE Kahveid=7 ", bgl.baglanti()); SqlDataReader oku7 = komut7.ExecuteReader(); DataList9.DataSource = oku7; DataList9.DataBind(); SqlCommand komut8 = new SqlCommand("Select *From Tbl_kahveler WHERE Kahveid=2 ", bgl.baglanti()); SqlDataReader oku8 = komut8.ExecuteReader(); DataList10.DataSource = oku8; DataList10.DataBind(); SqlCommand komut9 = new SqlCommand("Select *From Tbl_kahveler WHERE Kahveid=9 ", bgl.baglanti()); SqlDataReader oku9 = komut9.ExecuteReader(); DataList11.DataSource = oku9; DataList11.DataBind(); SqlCommand komut10 = new SqlCommand("Select *From Tbl_kahveler WHERE Kahveid=7 ", bgl.baglanti()); SqlDataReader oku10 = komut10.ExecuteReader(); DataList12.DataSource = oku10; DataList12.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(); }
protected void Page_Load(object sender, EventArgs e) { if (Page.IsPostBack == false) { //class obj class SqlConnection con22 = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\userside.mdf;Integrated Security=True;User Instance=True"); string str22; str22 = "select * from User_Book_Seats "; SqlCommand cmd22 = new SqlCommand(str22, con22); con22.Open(); SqlDataReader dr22; dr22 = cmd22.ExecuteReader(); // to get one or more rows from table... while (dr22.Read()) { a11.Add(dr22["SeatId"]); } SqlConnection con = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\userside.mdf;Integrated Security=True;User Instance=True"); string str; str = "select * from Screen_managment,TheatreMaster where Screen_managment.movieid = " + Session["movieid"] + " and Screen_managment.TheatreId=TheatreMaster.TheatreId "; SqlCommand cmd = new SqlCommand(str, con); con.Open(); SqlDataReader dr; dr = cmd.ExecuteReader(); lblMoviesDate.Text = Convert.ToString(System.DateTime.Now.Date.ToShortDateString()); while (dr.Read()) { lbltheatre.Text = dr["TheatreName"].ToString(); lblMoviName.Text = dr["moviename"].ToString(); lblShowtime.Text = dr["timing"].ToString(); ViewState["TheatreId"] = dr["TheatreId"]; lblScreen.Text = dr["screenname"].ToString(); } if (lblScreen.Text == "Screen_1") { lblSid.Text = "1"; } if (lblScreen.Text == "Screen_2") { lblSid.Text = "2"; } if (lblScreen.Text == "Screen_3") { lblSid.Text = "3"; } if (lblScreen.Text == "Screen_4") { lblSid.Text = "4"; } //class obj class SqlConnection con1 = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\userside.mdf;Integrated Security=True;User Instance=True"); string str1; str1 = "select * from Screen_managment where movieid = " + Session["movieid"] + " "; SqlCommand cmd1 = new SqlCommand(str1, con1); con1.Open(); SqlDataReader dr1; dr1 = cmd1.ExecuteReader(); ArrayList a1 = new ArrayList(); while (dr1.Read()) { // a1.Add(dr1["Seat_Id"]); } Session["a1"] = a1; //class obj class SqlConnection con2 = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\userside.mdf;Integrated Security=True;User Instance=True"); string str2; str2 = "select * from Seat_Master,Screen_managment where Seat_Master.Seattype = 'Club' and Screen_managment.movieid=" + Session["movieid"] + " and Screen_managment.TheatreId=Seat_Master.TheatreId"; SqlCommand cmd2 = new SqlCommand(str2, con2); con2.Open(); SqlDataReader dr2; dr2 = cmd2.ExecuteReader(); // to get one or more rows from table... DataList7.DataSource = dr2; DataList7.DataBind(); SqlConnection con21 = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\userside.mdf;Integrated Security=True;User Instance=True"); string str21; str21 = "select * from Seat_Master,Screen_managment where Seat_Master.Seattype = 'Gold' and Screen_managment.movieid=" + Session["movieid"] + " and Screen_managment.TheatreId=Seat_Master.TheatreId"; SqlCommand cmd21 = new SqlCommand(str21, con21); con21.Open(); SqlDataReader dr21; dr21 = cmd21.ExecuteReader(); // to get one or more rows from table... DataList5.DataSource = dr21; DataList5.DataBind(); SqlConnection con23 = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\userside.mdf;Integrated Security=True;User Instance=True"); string str23; str23 = "select * from Seat_Master,Screen_managment where Seat_Master.Seattype = 'Silver' and Screen_managment.movieid=" + Session["movieid"] + " and Screen_managment.TheatreId=Seat_Master.TheatreId"; SqlCommand cmd23 = new SqlCommand(str23, con23); con23.Open(); SqlDataReader dr23; dr23 = cmd23.ExecuteReader(); // to get one or more rows from table... DataList8.DataSource = dr23; DataList8.DataBind(); // lblSeatType.Text = "210"; // lblRate.Text = "210"; DataList5.Visible = false; DataList8.Visible = false; } }