public void ViewImg()
{
SqlCommand command = new SqlCommand("SELECT HImgName,ID from [IM] where ID='" + lblEnrolment.Text.ToString() + "'", con);
SqlDataAdapter daimages = new SqlDataAdapter(command);
DataTable dt = new DataTable();
daimages.Fill(dt);
DataList1.DataSource = dt;
DataList1.DataBind();
SqlCommand cmdhsign = new SqlCommand("SELECT HSignName,ID from [IM] where ID='" + lblEnrolment.Text.ToString() + "'", con);
SqlDataAdapter dasign = new SqlDataAdapter(cmdhsign);
DataTable dtsign = new DataTable();
dasign.Fill(dtsign);
dlsign.DataSource = dtsign;
dlsign.DataBind();
SqlCommand cmd2 = new SqlCommand("SELECT AImgName,ID from [IM] where ID='" + lblEnrolment.Text.ToString() + "'", con);
SqlDataAdapter da2 = new SqlDataAdapter(cmd2);
DataTable dt22 = new DataTable();
da2.Fill(dt22);
DataList3.DataSource = dt22;
DataList3.DataBind();
SqlCommand cmd3 = new SqlCommand("SELECT ASignName,ID from [IM] where ID='" + lblEnrolment.Text.ToString() + "'", con);
SqlDataAdapter da3 = new SqlDataAdapter(cmd3);
DataTable dt23 = new DataTable();
da3.Fill(dt23);
DataList4.DataSource = dt23;
DataList4.DataBind();
imgDefault.Visible = false;
panelImage.Visible = true;
Image2.Visible = false;
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
int StuId = ((Model.Login)Session["CurrentUser"]).UserName;
int CourseId = Convert.ToInt32(Request.Params["CourseId"]);
coursename.Text = (new CourseManege().queryCourseById(CourseId)).CourseName;
//绑定未完成作业
List <Homework> ufhkList = new HomeworkManage().queryUnfinishedHw(CourseId, StuId);
DataList1.DataSource = ufhkList;
DataList1.DataBind();
//绑定已完成作业
List <Homework> fhkList = new HomeworkManage().queryfinishedHw(CourseId, StuId);
DataList3.DataSource = fhkList;
DataList3.DataBind();
//绑定已审批作业
List <Homework> chkList = new HomeworkManage().querycheckedHw(CourseId, StuId);
DataList4.DataSource = chkList;
DataList4.DataBind();
//绑定考勤
List <KQ> KqList = new KqManage().queryAllKq(CourseId);
foreach (KQ kq in KqList)
{
int State = new KqManage().HasChecked(StuId, kq.KQId);
if (State > 0)
{
kq.state = "已签到";
}
else
{
kq.state = "<span style='color:red;'>未签到<span>";
}
}
DataList2.DataSource = KqList;
DataList2.DataBind();
//绑定公告
List <JXGG> gglist = new GGManage().LookJXGG(CourseId);
Repeater3.DataSource = gglist;
Repeater3.DataBind();
}
}
protected void DataList4_UpdateCommand(object sender, DataListCommandEventArgs e)
{
string numRow = DataList4.DataKeys[e.Item.ItemIndex].ToString();
TextBox txtVcCallRefNo = e.Item.FindControl("txtVcCallRefNo") as TextBox;
TextBox txtVcFuComment = e.Item.FindControl("txtVcFuComment") as TextBox;
TextBox txtVcContactName = e.Item.FindControl("txtVcContactName") as TextBox;
TextBox txtVcContactPhone = e.Item.FindControl("txtVcContactPhone") as TextBox;
TextBox txtVcContactEmail = e.Item.FindControl("txtVcContactEmail") as TextBox;
TextBox txtDatFollowUp = e.Item.FindControl("txtDatFollowUp") as TextBox;
String UpdateQuery = string.Format(
"UPDATE FollowUp SET "
+ "vcCallRefNo={0},"
+ "vcFuComment={1},"
+ "vcContactName={2},"
+ "vcContactPhone={3},"
+ "vcContactEmail={4},"
+ "datFollowUp={5} "
+ "WHERE numRowFu={6}",
txtVcCallRefNo.Text.Equals("") ? "NULL" : "'" + txtVcCallRefNo.Text + "'",
txtVcFuComment.Text.Equals("") ? "NULL" : "'" + txtVcFuComment.Text + "'",
txtVcContactName.Text.Equals("") ? "NULL" : "'" + txtVcContactName.Text + "'",
txtVcContactPhone.Text.Equals("") ? "NULL" : "'" + txtVcContactPhone.Text + "'",
txtVcContactEmail.Text.Equals("") ? "NULL" : "'" + txtVcContactEmail.Text + "'",
txtDatFollowUp.Text.Equals("") ? "NULL" : "'" + Convert.ToDateTime(txtDatFollowUp.Text) + "'",
Convert.ToInt32(numRow)
);
DataList4.EditItemIndex = -1;
DataSet ds = GridDataTable(UpdateQuery);
Session["AccountsTable"] = ds.Tables[0];
GridView1.DataSource = ds.Tables[0];
GridView1.DataBind();
DataList4.DataSource = ds.Tables[2];
DataList4.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DataList4.DataSource = data.GetDataReader("select * from dbo.LanMu ");
DataList4.DataBind();
if (Request.QueryString["BID"] == null)
{
TD1.Visible = false;
TD2.Visible = false;
}
else
{
TD1.Visible = true;
TD2.Visible = true;
DataList1.DataSource = data.GetDataReader("select * from NewType where Bid='" + Request.QueryString["BID"].ToString() + "' order by id desc ");
DataList1.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)
{
if (!IsPostBack)
{
int id = 1;
DataTable dt = new DataTable();
dt = bus.Show8AProduct(id);
DataTable dt2 = new DataTable();
DataTable dt3 = new DataTable();
dt2 = bus.Show8AProduct(2);
dt3 = bus.Show8AProduct(3);
DataList1.DataSource = dt;
DataList1.DataBind();
DataList2.DataSource = dt2;
DataList2.DataBind();
DataList3.DataSource = dt3;
DataList3.DataBind();
DataTable dt4 = new DataTable();
dt4 = bus.Show3Product();
DataList4.DataSource = dt4;
DataList4.DataBind();
}
}
public void load_data()
{
try
{
string mablog = Request.QueryString["MaSP"].ToString();
string sql = "SELECT BinhLuanSP.MaSP, BinhLuanSP.NgayBL, BinhLuanSP.NoiDungBL, TaiKhoan.TenTK FROM BinhLuanSP INNER JOIN TaiKhoan ON BinhLuanSP.MaTK = TaiKhoan.MaTK where binhluansp.MaSP=" + mablog + " order by binhluansp.NgayBL desc";
p.DataSource = XLDL.GetData(sql).DefaultView;
p.PageSize = 5;
p.CurrentPageIndex = trangthu;
p.AllowPaging = true;
btnDau.Enabled = true;
btnTruoc.Enabled = true;
btnSau.Enabled = true;
btnCuoi.Enabled = true;
if (p.IsFirstPage == true)
{
btnDau.Enabled = false;
btnTruoc.Enabled = false;
btnSau.Enabled = true;
btnCuoi.Enabled = true;
}
if (p.IsLastPage == true)
{
btnDau.Enabled = true;
btnTruoc.Enabled = true;
btnSau.Enabled = false;
btnCuoi.Enabled = false;
}
if (p.PageCount == 1)
{
btnDau.Visible = false;
btnTruoc.Visible = false;
btnSau.Visible = false;
btnCuoi.Visible = false;
tbTrang.Visible = false;
}
tbTrang.Text = (trangthu + 1) + " / " + p.PageCount;
DataList4.DataSource = p;
DataList4.DataBind();
}
catch
{
Response.Redirect("~/Default.aspx");
}
}
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();
}
protected void Timer1_Tick(object sender, EventArgs e)
{
DataList1.DataBind();
DataList3.DataBind();
DataList4.DataBind();
}
private void ProveriLattestVesti()
{
// Izminuvanje na novite neprocitani vesti i odreduvanje na nivniot broj:
SqlConnection konekcija = new SqlConnection();
konekcija.ConnectionString = ConfigurationManager.ConnectionStrings["Konekcija"].ConnectionString;
string sqlString = @"SELECT COUNT(Vest_Id) AS Broj, V.Tip
FROM Vest AS V
WHERE V.Datum_Objava > '" + DateTime.Now.AddDays(-2).ToString("dd-MMM-yyyy", CultureInfo.InvariantCulture) + @"'
AND V.Tip=1 AND V.Vest_Id NOT IN
(SELECT Vest_Id FROM Vest_MAC_Poseta AS VMP
WHERE Tip = 1 AND MAC_Add='" + Session["MAC"] + @"'
) GROUP BY V.Tip
UNION SELECT COUNT(Vest_Id) AS Broj, V.Tip
FROM Vest AS V
WHERE V.Datum_Objava > '" + DateTime.Now.AddDays(-2).ToString("dd-MMM-yyyy", CultureInfo.InvariantCulture) + @"'
AND V.Tip=2 AND V.Vest_Id NOT IN
(SELECT Vest_Id FROM Vest_MAC_Poseta AS VMP
WHERE Tip = 2 AND MAC_Add='" + Session["MAC"] + @"'
) GROUP BY V.Tip
UNION SELECT COUNT(Vest_Id) AS Broj, V.Tip
FROM Vest AS V
WHERE V.Datum_Objava > '" + DateTime.Now.AddDays(-2).ToString("dd-MMM-yyyy", CultureInfo.InvariantCulture) + @"'
AND V.Tip=3 AND V.Vest_Id NOT IN
(SELECT Vest_Id FROM Vest_MAC_Poseta AS VMP
WHERE Tip = 3 AND MAC_Add='" + Session["MAC"] + @"'
) GROUP BY V.Tip
UNION SELECT COUNT(Vest_Id) AS Broj, V.Tip
FROM Vest AS V
WHERE V.Datum_Objava > '" + DateTime.Now.AddDays(-2).ToString("dd-MMM-yyyy", CultureInfo.InvariantCulture) + @"'
AND V.Tip=4 AND V.Vest_Id NOT IN
(SELECT Vest_Id FROM Vest_MAC_Poseta AS VMP
WHERE Tip = 4 AND MAC_Add='" + Session["MAC"] + @"'
) GROUP BY V.Tip ";
SqlCommand komanda = new SqlCommand(sqlString, konekcija);
try
{
konekcija.Open();
SqlDataReader citac = komanda.ExecuteReader();
while (citac.Read())
{
// Zapisuvanje na brojot na neprocitani vesti:
if (citac["Tip"].ToString() == "1")
{
lblFudbalLattest.Text = citac["Broj"].ToString();
}
if (citac["Tip"].ToString() == "2")
{
lblKosarkaLattest.Text = citac["Broj"].ToString();
}
if (citac["Tip"].ToString() == "3")
{
lblRakometLattest.Text = citac["Broj"].ToString();
}
if (citac["Tip"].ToString() == "4")
{
lblOstanatoLattest.Text = citac["Broj"].ToString();
}
}
citac.Close();
// Fudbal - Disabled ako nema novi
if (lblFudbalLattest.Text == "0")
{
pnlFudbalLattest.Visible = false;
lblFudbalDDLInfo.Visible = true;
imgFudbalLattest.ImageUrl = "~/Images/fudbal_topka-disabled.png";
}
else
{
// Fudbal - Ispolnuvanje samo so novite vesti :
sqlDSFudbalDDL.SelectCommand = @"SELECT *
FROM Vest AS V
WHERE V.Datum_Objava > '" + DateTime.Now.AddDays(-2).ToString("dd-MMM-yyyy", CultureInfo.InvariantCulture) + @"'
AND V.Tip=1 AND V.Vest_Id NOT IN
(SELECT Vest_Id FROM Vest_MAC_Poseta AS VMP
WHERE Tip = 1 AND MAC_Add='" + Session["MAC"] + @"'
)";
DataList2.DataSource = sqlDSFudbalDDL;
DataList2.DataBind();
}
// Kosarka - Disabled ako nema novi
if (lblKosarkaLattest.Text == "0")
{
pnlKosarkaLattest.Visible = false;
lblKosarkaDDLInfo.Visible = true;
imgKosarkaLattest.ImageUrl = "~/Images/basket_topka_disabled.png";
}
else
{
// Kosarka - Ispolnuvanje samo so novite vesti :
sqlDSKosarkaDDL.SelectCommand = @"SELECT *
FROM Vest AS V
WHERE V.Datum_Objava > '" + DateTime.Now.AddDays(-2).ToString("dd-MMM-yyyy", CultureInfo.InvariantCulture) + @"'
AND V.Tip=2 AND V.Vest_Id NOT IN
(SELECT Vest_Id FROM Vest_MAC_Poseta AS VMP
WHERE Tip = 2 AND MAC_Add='" + Session["MAC"] + @"'
)";
DataList3.DataSource = sqlDSKosarkaDDL;
DataList3.DataBind();
}
// Rakomet - Disabled ako nema novi
if (lblRakometLattest.Text == "0")
{
pnlRakometLattest.Visible = false;
lblRakometDDLInfo.Visible = true;
imgRakometLattest.ImageUrl = "~/Images/rakomet_topka_disabled.png";
}
else
{
// Rakomet - Ispolnuvanje samo so novite vesti :
sqlDSRakometDDL.SelectCommand = @"SELECT *
FROM Vest AS V
WHERE V.Datum_Objava > '" + DateTime.Now.AddDays(-2).ToString("dd-MMM-yyyy", CultureInfo.InvariantCulture) + @"'
AND V.Tip = 3 AND V.Vest_Id NOT IN
(SELECT Vest_Id FROM Vest_MAC_Poseta AS VMP
WHERE Tip = 3 AND MAC_Add='" + Session["MAC"] + @"'
)";
DataList4.DataSource = sqlDSRakometDDL;
DataList4.DataBind();
}
// Ostanato - Disabled ako nema novi
if (lblOstanatoLattest.Text == "0")
{
pnlOstanatoLattest.Visible = false;
lblOstanatoDDLInfo.Visible = true;
imgOstanatoLattest.ImageUrl = "~/Images/ostanati_sportovi_disabled.png";
}
else
{
// Ostanato - Ispolnuvanje samo so novite vesti :
sqlDSOstanatoDDL.SelectCommand = @"SELECT *
FROM Vest AS V
WHERE V.Datum_Objava > '" + DateTime.Now.AddDays(-2).ToString("dd-MMM-yyyy", CultureInfo.InvariantCulture) + @"'
AND V.Tip = 4 AND V.Vest_Id NOT IN
(SELECT Vest_Id FROM Vest_MAC_Poseta AS VMP
WHERE Tip = 4 AND MAC_Add='" + Session["MAC"] + @"'
)";
DataList5.DataSource = sqlDSOstanatoDDL;
DataList5.DataBind();
}
}
catch (Exception err) { }
finally
{
konekcija.Close();
}
}
protected void Page_Load(object sender, EventArgs e)
{
Data_con dc = new Data_con();
SqlConnection con = dc.SQL_con();
con.Open();
SqlDataAdapter da1 = new SqlDataAdapter("SELECT top 7 * FROM [Down_1] where soft_type='热门专题' ", con);
DataSet ds1 = new DataSet();
da1.Fill(ds1, "Down_1");
con.Close();
DataList1.DataSource = ds1;
DataList1.DataBind();
con.Open();
SqlDataAdapter da2 = new SqlDataAdapter("SELECT top 7 * FROM [Down_1] where soft_type='热门专题1' ", con);
DataSet ds2 = new DataSet();
da2.Fill(ds2, "Down_1");
con.Close();
DataList2.DataSource = ds2;
DataList2.DataBind();
con.Open();
SqlDataAdapter da3 = new SqlDataAdapter("SELECT top 7 * FROM [Down_1] where soft_type='软件专题' ", con);
DataSet ds3 = new DataSet();
da3.Fill(ds3, "Down_1");
con.Close();
DataList3.DataSource = ds3;
DataList3.DataBind();
con.Open();
SqlDataAdapter da4 = new SqlDataAdapter("SELECT top 7 * FROM [Down_1] where soft_type='热门专题1' ", con);
DataSet ds4 = new DataSet();
da4.Fill(ds4, "Down_1");
con.Close();
DataList4.DataSource = ds4;
DataList4.DataBind();
con.Open();
SqlDataAdapter da5 = new SqlDataAdapter("SELECT top 7 * FROM [Down_1] where soft_type='游戏专题' ", con);
DataSet ds5 = new DataSet();
da5.Fill(ds5, "Down_1");
con.Close();
DataList5.DataSource = ds5;
DataList5.DataBind();
con.Open();
SqlDataAdapter da6 = new SqlDataAdapter("SELECT top 7 * FROM [Down_1] where soft_type='热门专题1' ", con);
DataSet ds6 = new DataSet();
da6.Fill(ds6, "Down_1");
con.Close();
DataList6.DataSource = ds6;
DataList6.DataBind();
}
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
if (DropDownList1.Text == "All")
{
Panel2.Visible = true;
Panel3.Visible = true;
Panel4.Visible = true;
Panel5.Visible = true;
cn.Open();
cmd = new SqlCommand("Select * from house", cn);
dr = cmd.ExecuteReader();
DataList1.DataSource = dr;
DataList1.DataBind();
cn.Close();
cn.Open();
cmd = new SqlCommand("Select * from room", cn);
dr = cmd.ExecuteReader();
DataList2.DataSource = dr;
DataList2.DataBind();
cn.Close();
cn.Open();
cmd = new SqlCommand("Select * from hall", cn);
dr = cmd.ExecuteReader();
DataList3.DataSource = dr;
DataList3.DataBind();
cn.Close();
cn.Open();
cmd = new SqlCommand("Select * from ground", cn);
dr = cmd.ExecuteReader();
DataList4.DataSource = dr;
DataList4.DataBind();
cn.Close();
}
else
{
if (DropDownList1.Text == "HOUSE")
{
Panel2.Visible = true;
Panel3.Visible = false;
Panel4.Visible = false;
Panel5.Visible = false;
cn.Open();
cmd = new SqlCommand("Select * from house", cn);
dr = cmd.ExecuteReader();
DataList1.DataSource = dr;
DataList1.DataBind();
cn.Close();
}
else if (DropDownList1.Text == "ROOM")
{
Panel2.Visible = false;
Panel3.Visible = true;
Panel4.Visible = false;
Panel5.Visible = false;
cn.Open();
cmd = new SqlCommand("Select * from room", cn);
dr = cmd.ExecuteReader();
DataList2.DataSource = dr;
DataList2.DataBind();
cn.Close();
}
else if (DropDownList1.Text == "HALL")
{
Panel2.Visible = false;
Panel3.Visible = false;
Panel4.Visible = true;
Panel5.Visible = false;
cn.Open();
cmd = new SqlCommand("Select * from hall", cn);
dr = cmd.ExecuteReader();
DataList3.DataSource = dr;
DataList3.DataBind();
cn.Close();
}
else if (DropDownList1.Text == "GROUND")
{
Panel2.Visible = false;
Panel3.Visible = false;
Panel4.Visible = false;
Panel5.Visible = true;
cn.Open();
cmd = new SqlCommand("Select * from ground", cn);
dr = cmd.ExecuteReader();
DataList4.DataSource = dr;
DataList4.DataBind();
cn.Close();
}
}
}
protected void DdlDoctors_SelectedIndexChanged(object sender, EventArgs e)
{
DataList2.Visible = false;
DataList4.Visible = true;
try
{
var Query = from item in db.doctor_availabilities where item.d_id == DdlDoctors.SelectedValue.ToString() orderby item.a_date ascending select item;
DataList4.DataSource = Query;
DataList4.DataBind();
foreach (DataListItem dli in DataList4.Items)
{
var Query4 = from item in db.doctor_availabilities where item.d_id == DdlDoctors.SelectedValue.ToString() select item;
Label lbl6 = dli.FindControl("Label6") as Label;
DataList dl3 = dli.FindControl("DataList5") as DataList;
var Query2 = from item in db.view_doc_available_times where item.a_date == lbl6.Text && item.d_hakkimid == DdlDoctors.SelectedValue.ToString() select item;
DataTable dt = new DataTable();
dt.Columns.AddRange(new DataColumn[3] {
new DataColumn("date"), new DataColumn("time"), new DataColumn("d_hakkimid")
});
foreach (var ss in Query2)
{
if (ss.time == "")
{
}
else
{
string ab1 = "", ab2 = "", timet = "";
int l = ss.time.ToString().Count();
ab1 = ss.time.ToString().Substring(0, l - 2);
ab2 = ss.time.ToString().Substring(l - 2, 2);
timet = ab1.ToString() + " " + ab2.ToString();
dt.Rows.Add(ss.a_date, timet, ss.d_hakkimid);
}
}
dl3.DataSource = dt;
dl3.DataBind();
lbl6.Text = DateTime.Parse(lbl6.Text).ToString("yyy d MMM");
foreach (DataListItem dl3i in dl3.Items)
{
//Button btn2 = dl3i.FindControl("Button2") as Button;
LinkButton lnk2 = dl3i.FindControl("LinkButton2") as LinkButton;
string date = DateTime.Parse(lbl6.Text).ToString("yyyy-MM-dd");
var Query3 = from item in db.tbl_doctor_appointments
where
item.d_id == DdlDoctors.SelectedValue.ToString() && item.a_date == date && item.a_time == lnk2.Text
select item;
if (Query3.Count() > 0)
{
foreach (var tt in Query3)
{
if (tt.a_status == 0)
{
//if (Session["Speciality"].ToString() == "Auto")
//{
lnk2.BackColor = System.Drawing.Color.Orange; lnk2.Enabled = false; lnk2.ToolTip = "Waiting for confirmation";
//}
//else
//{
// lnk2.BackColor = System.Drawing.Color.Orange; lnk2.Enabled = false; lnk2.ToolTip = "في انتظار التأكيد";
//}
}
if (tt.a_status == 1 || tt.a_status == 4)
{
//if (Session["Speciality"].ToString() == "Auto")
//{
lnk2.BackColor = System.Drawing.Color.IndianRed; lnk2.Enabled = false; lnk2.ToolTip = "Booked";
//}
//else
//{
// lnk2.BackColor = System.Drawing.Color.IndianRed; lnk2.Enabled = false; lnk2.ToolTip = "حجز";
//}
}
}
}
else
{
//lnk2.BackColor = System.Drawing.Color.Green;
//if (Session["Speciality"].ToString() == "Auto")
//{
lnk2.ToolTip = "Available";
//}
//else
//{
// lnk2.ToolTip = "متاح";
//}
}
}
}
}
catch (Exception ex) { }
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
//fetch data from database display in datalist1 code
SqlCommand cmd = new SqlCommand("select * from ProductRegi", con);
con.Open();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
DataSet ds = new DataSet();
da.Fill(ds);
DataList1.DataSource = ds;
DataList1.DataBind();
//select Last 10 Record from database display datalist2
SqlDataAdapter top = new SqlDataAdapter("select TOP 8 * from ProductRegi order by PR_Id desc", con);
DataTable ds1 = new DataTable();
top.Fill(ds1);
DataList2.DataSource = ds1;
DataList2.DataBind();
SqlDataAdapter top1 = new SqlDataAdapter("select TOP 5 * from ProductRegi order by PR_Id desc", con);
DataTable ds2 = new DataTable();
top1.Fill(ds2);
DataList3.DataSource = ds2;
DataList3.DataBind();
SqlDataAdapter adp = new SqlDataAdapter("select * from Notifications", con);
DataTable ds3 = new DataTable();
adp.Fill(ds3);
DataList4.DataSource = ds3;
DataList4.DataBind();
con.Close();
//fetch data form database malls name in pune
SqlDataAdapter pune = new SqlDataAdapter("select Distinct(M_Name) from Mall_Regi where M_city='Pune' ", con);
DataTable dp = new DataTable();
pune.Fill(dp);
DropDownList1.DataSource = dp;
DropDownList1.DataTextField = "M_Name";
DropDownList1.DataValueField = "M_Name";
DropDownList1.DataBind();
DropDownList1.Items.Insert(0, "Select Pune Malls");
//fetch data form database malls name in Mumbai
SqlDataAdapter mumbai = new SqlDataAdapter("select Distinct(M_Name) from Mall_Regi where M_city='Mumbai' ", con);
DataTable dm = new DataTable();
mumbai.Fill(dm);
DropDownList2.DataSource = dm;
DropDownList2.DataTextField = "M_Name";
DropDownList2.DataValueField = "M_Name";
DropDownList2.DataBind();
DropDownList2.Items.Insert(0, "Select Mumbai Malls");
//fetch data form database malls name in Ahmedabad
SqlDataAdapter Ahmedabad = new SqlDataAdapter("select Distinct(M_Name) from Mall_Regi where M_city='Ahmedabad' ", con);
DataTable dah = new DataTable();
Ahmedabad.Fill(dah);
DropDownList3.DataSource = dah;
DropDownList3.DataTextField = "M_Name";
DropDownList3.DataValueField = "M_Name";
DropDownList3.DataBind();
DropDownList3.Items.Insert(0, "Select Ahmedabad Malls");
//fetch data form database malls name in Baroda
SqlDataAdapter Baroda = new SqlDataAdapter("select Distinct(M_Name) from Mall_Regi where M_city='Baroda' ", con);
DataTable db = new DataTable();
Baroda.Fill(db);
DropDownList4.DataSource = db;
DropDownList4.DataTextField = "M_Name";
DropDownList4.DataValueField = "M_Name";
DropDownList4.DataBind();
DropDownList4.Items.Insert(0, "Select Baroda Malls");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string MALOAI = Request.QueryString["MALOAI"];
DataTable dt = new DataTable();
if (MALOAI == null)
{
dt = x.GetData("select* from SANPHAM WHERE MALOAI=1");
if (dt.Rows.Count > 0)
{
DataList.DataSource = dt;
DataList.DataBind();
dt.Clear();
dt = x.GetData("SELECT TEN FROM LOAI WHERE MALOAI=1");
title.DataSource = dt;
title.DataBind();
}
dt.Clear();
dt = x.GetData("select* from SANPHAM WHERE MALOAI=2");
if (dt.Rows.Count > 0)
{
DataList1.DataSource = dt;
DataList1.DataBind();
dt.Clear();
dt = x.GetData("SELECT TEN FROM LOAI WHERE MALOAI=2");
title1.DataSource = dt;
title1.DataBind();
}
dt.Clear();
dt = x.GetData("select* from SANPHAM WHERE MALOAI=3");
if (dt.Rows.Count > 0)
{
DataList2.DataSource = dt;
DataList2.DataBind();
dt.Clear();
dt = x.GetData("SELECT TEN FROM LOAI WHERE MALOAI=3");
title2.DataSource = dt;
title2.DataBind();
}
dt.Clear();
dt = x.GetData("select* from SANPHAM WHERE MALOAI=4");
if (dt.Rows.Count > 0)
{
DataList3.DataSource = dt;
DataList3.DataBind();
dt.Clear();
dt = x.GetData("SELECT TEN FROM LOAI WHERE MALOAI=4");
title3.DataSource = dt;
title3.DataBind();
}
dt.Clear();
dt = x.GetData("select* from SANPHAM WHERE MALOAI=5");
if (dt.Rows.Count > 0)
{
DataList4.DataSource = dt;
DataList4.DataBind();
dt.Clear();
dt = x.GetData("SELECT TEN FROM LOAI WHERE MALOAI=5");
title4.DataSource = dt;
title4.DataBind();
}
dt.Clear();
dt = x.GetData("select* from SANPHAM WHERE MALOAI=6");
if (dt.Rows.Count > 0)
{
DataList5.DataSource = dt;
DataList5.DataBind();
dt.Clear();
dt = x.GetData("SELECT TEN FROM LOAI WHERE MALOAI=6");
title5.DataSource = dt;
title5.DataBind();
}
}
else
{
dt = x.GetData("select* from SANPHAM WHERE MALOAI=" + MALOAI);
if (dt.Rows.Count > 0)
{
DataList.DataSource = dt;
DataList.DataBind();
dt.Clear();
dt = x.GetData("SELECT TEN FROM LOAI WHERE MALOAI=" + MALOAI);
title.DataSource = dt;
title.DataBind();
}
}
/*
* if (dt.Rows.Count > 0)
* {
* DataList.DataSource = dt;
* DataList.DataBind();
* }*/
}
}
protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
{
int xyz = 0;
DataList2.DataSource = "";
DataList2.DataBind();
DataList3.DataSource = "";
DataList3.DataBind();
DataList4.DataSource = "";
DataList4.DataBind();
if (DropDownList1.Text == "All" && TextBox2.Text == "")
{
Panel2.Visible = true;
Panel3.Visible = true;
Panel4.Visible = true;
Panel5.Visible = true;
cn.Open();
cmd = new SqlCommand("Select * from house", cn);
dr = cmd.ExecuteReader();
DataList1.DataSource = dr;
DataList1.DataBind();
cn.Close();
cn.Open();
cmd = new SqlCommand("Select * from room", cn);
dr = cmd.ExecuteReader();
DataList2.DataSource = dr;
DataList2.DataBind();
cn.Close();
cn.Open();
cmd = new SqlCommand("Select * from hall", cn);
dr = cmd.ExecuteReader();
DataList3.DataSource = dr;
DataList3.DataBind();
cn.Close();
cn.Open();
cmd = new SqlCommand("Select * from ground", cn);
dr = cmd.ExecuteReader();
DataList4.DataSource = dr;
DataList4.DataBind();
cn.Close();
}
else
{
if (DropDownList1.Text == "HOUSE" && TextBox2.Text == "")
{
Panel2.Visible = true;
Panel3.Visible = false;
Panel4.Visible = false;
Panel5.Visible = false;
DataTable dt = new DataTable();
cn.Open();
da = new SqlDataAdapter("Select * from house", cn);
ds = new DataSet();
da.Fill(ds);
int colCount = ds.Tables[0].Rows.Count;
DataTable ta = new DataTable();
String abc;
for (int i = 0; i < colCount; i++)
{
for (int j = 0; j < 5; j++)
{
String s = (ds.Tables[0].Rows[i][j + 9].ToString().ToUpper()).Trim();
String l = (TextBox2.Text.ToUpper()).Trim();
for (int k = 0, a = 0; k < s.Length; k++)
{
if (l[a] == s[k] && l.Length <= s.Substring(k).Length)
{
if (String.Compare(l, (s.Substring(k, l.Length))) == 0)
{
abc = "select * from house where " + ds.Tables[0].Columns[j + 9].ColumnName + " = '" + ds.Tables[0].Rows[i][j + 9].ToString() + "'";
xyz++;
cn.Close();
cn.Open();
cmd = new SqlCommand(abc, cn);
dr = cmd.ExecuteReader();
DataList4.DataSource = dr;
DataList4.DataBind();
cn.Close();
}
}
}
}
}
}
else if (DropDownList1.Text == "ROOM" && TextBox2.Text == "")
{
Panel2.Visible = false;
Panel3.Visible = true;
Panel4.Visible = false;
Panel5.Visible = false;
DataTable dt = new DataTable();
cn.Open();
da = new SqlDataAdapter("Select * from ground", cn);
ds = new DataSet();
da.Fill(ds);
int colCount = ds.Tables[0].Rows.Count;
DataTable ta = new DataTable();
String abc;
for (int i = 0; i < colCount; i++)
{
for (int j = 0; j < 5; j++)
{
String s = (ds.Tables[0].Rows[i][j + 9].ToString().ToUpper()).Trim();
String l = (TextBox2.Text.ToUpper()).Trim();
for (int k = 0, a = 0; k < s.Length; k++)
{
if (l[a] == s[k] && l.Length <= s.Substring(k).Length)
{
if (String.Compare(l, (s.Substring(k, l.Length))) == 0)
{
abc = "select * from room where " + ds.Tables[0].Columns[j + 9].ColumnName + " = '" + ds.Tables[0].Rows[i][j + 9].ToString() + "'";
cn.Close();
cn.Open();
cmd = new SqlCommand(abc, cn);
dr = cmd.ExecuteReader();
DataList4.DataSource = dr;
DataList4.DataBind();
cn.Close();
}
}
}
}
}
}
else if (DropDownList1.Text == "HALL" && TextBox2.Text == "")
{
Panel2.Visible = false;
Panel3.Visible = false;
Panel4.Visible = true;
Panel5.Visible = false;
DataTable dt = new DataTable();
cn.Open();
da = new SqlDataAdapter("Select * from ground", cn);
ds = new DataSet();
da.Fill(ds);
int colCount = ds.Tables[0].Rows.Count;
DataTable ta = new DataTable();
String abc;
for (int i = 0; i < colCount; i++)
{
for (int j = 0; j < 5; j++)
{
String s = (ds.Tables[0].Rows[i][j + 9].ToString().ToUpper()).Trim();
String l = (TextBox2.Text.ToUpper()).Trim();
for (int k = 0, a = 0; k < s.Length; k++)
{
if (l[a] == s[k] && l.Length <= s.Substring(k).Length)
{
if (String.Compare(l, (s.Substring(k, l.Length))) == 0)
{
abc = "select * from hall where " + ds.Tables[0].Columns[j + 9].ColumnName + " = '" + ds.Tables[0].Rows[i][j + 9].ToString() + "'";
cn.Close();
cn.Open();
cmd = new SqlCommand(abc, cn);
dr = cmd.ExecuteReader();
DataList4.DataSource = dr;
DataList4.DataBind();
cn.Close();
}
}
}
}
}
}
else if (DropDownList1.Text == "GROUND" && TextBox2.Text == "")
{
Panel2.Visible = false;
Panel3.Visible = false;
Panel4.Visible = false;
Panel5.Visible = true;
DataTable dt = new DataTable();
cn.Open();
da = new SqlDataAdapter("Select * from ground", cn);
ds = new DataSet();
da.Fill(ds);
int colCount = ds.Tables[0].Rows.Count;
DataTable ta = new DataTable();
String abc;
for (int i = 0; i < colCount; i++)
{
for (int j = 0; j < 5; j++)
{
String s = (ds.Tables[0].Rows[i][j + 9].ToString().ToUpper()).Trim();
String l = (TextBox2.Text.ToUpper()).Trim();
for (int k = 0, a = 0; k < s.Length; k++)
{
if (l[a] == s[k] && l.Length <= s.Substring(k).Length)
{
if (String.Compare(l, (s.Substring(k, l.Length))) == 0)
{
abc = "select * from ground where " + ds.Tables[0].Columns[j + 9].ColumnName + " = '" + ds.Tables[0].Rows[i][j + 9].ToString() + "'";
cn.Close();
cn.Open();
cmd = new SqlCommand(abc, cn);
dr = cmd.ExecuteReader();
DataList4.DataSource = dr;
DataList4.DataBind();
cn.Close();
}
}
}
}
}
}
}
}
public void load_data()
{
try
{
string mablog = Request.QueryString["MaBlog"].ToString();
string sql = "select MaBLB,MaBlog,NguoiBL,NgayBL,NoiDungBL from BinhLuanBlog where MaBlog='" + mablog + "' order by NgayBL desc";
p.DataSource = XLDL.GetData(sql).DefaultView;
p.PageSize = 5;
p.CurrentPageIndex = trangthu;
p.AllowPaging = true;
btnDau.Enabled = true;
btnTruoc.Enabled = true;
btnSau.Enabled = true;
btnCuoi.Enabled = true;
if (p.IsFirstPage == true)
{
btnDau.Enabled = false;
btnTruoc.Enabled = false;
btnSau.Enabled = true;
btnCuoi.Enabled = true;
}
if (p.IsLastPage == true)
{
btnDau.Enabled = true;
btnTruoc.Enabled = true;
btnSau.Enabled = false;
btnCuoi.Enabled = false;
}
if (p.PageCount == 1)
{
btnDau.Visible = false;
btnTruoc.Visible = false;
btnSau.Visible = false;
btnCuoi.Visible = false;
tbTrang.Visible = false;
}
tbTrang.Text = (trangthu + 1) + " / " + p.PageCount;
DataList4.DataSource = p;
DataList4.DataBind();
}
catch
{
Response.Redirect("~/TrangChu.aspx");
}
}
protected void Page_Load(object sender, EventArgs e)
{
Label11.Text = "Whelcom:" + Session["UserName"] + Session["AdminName"];
//实例化SqlConnection对象
string fid = "";
if (Request.QueryString["fid"] == null)
{
fid = "1";
}
else
{
fid = Request.QueryString["fid"];
}
SqlConnection sqlCon = new SqlConnection();
//实例化SqlConnection对象连接数据库的字符串
sqlCon.ConnectionString = "server=.;database=flowershop;Integrated Security=True;";
//定义SQL语句
string SqlStr = "select * from flower where fid='" + fid + "'";
//实例化SqlDataAdapter对象
SqlDataAdapter da = new SqlDataAdapter(SqlStr, sqlCon);
//实例化数据集DataSet
DataSet ds = new DataSet();
da.Fill(ds, "flower");
//绑定DataList控件
DataList1.DataSource = ds; //设置数据源，用于填充控件中的项的值列表
DataList1.DataBind(); //将控件及其所有子控件绑定到指定的数据源
string SqlStr1 = "select top(4)* from flower ";
//实例化SqlDataAdapter对象
SqlDataAdapter da1 = new SqlDataAdapter(SqlStr1, sqlCon);
//实例化数据集DataSet
DataSet ds1 = new DataSet();
da1.Fill(ds1, "flower");
//绑定DataList控件
DataList2.DataSource = ds1; //设置数据源，用于填充控件中的项的值列表
DataList2.DataBind(); //将控件及其所有子控件绑定到指定的数据源
string SqlStr2 = "select * from flower where fid='" + fid + "' ";
//实例化SqlDataAdapter对象
SqlDataAdapter da2 = new SqlDataAdapter(SqlStr2, sqlCon);
//实例化数据集DataSet
DataSet ds2 = new DataSet();
da2.Fill(ds2, "flower");
//绑定DataList控件
DataList3.DataSource = ds2; //设置数据源，用于填充控件中的项的值列表
DataList3.DataBind(); //将控件及其所有子控件绑定到指定的数据源
string SqlStr3 = "select top(7)* from flower WHERE SORT='婚庆系列' or SORT='情侣系列'";
//实例化SqlDataAdapter对象
SqlDataAdapter da3 = new SqlDataAdapter(SqlStr3, sqlCon);
//实例化数据集DataSet
DataSet ds3 = new DataSet();
da3.Fill(ds3, "flower");
//绑定DataList控件
DataList4.DataSource = ds3; //设置数据源，用于填充控件中的项的值列表
DataList4.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();
}