protected void Page_Load(object sender, EventArgs e)
{
if (Session["User"] == null)
{
Response.Redirect("frmLogin.aspx");
}
if (!IsPostBack)
{
if (Request["Text"] != null)
{
LblPaid.Visible = true;
LblPaid.Text = Request["Text"].ToString();
LblPaid.Visible = true;
}
if (Request["Text2"] != null)
{
LblPaid.Text = Request["Text2"].ToString();
LblPaid.Visible = true;
}
obj.BookingId = Convert.ToInt32(Request["BookingId"]);
DataSet ds = obj.ShowBookingConform();
LblMessage.Visible = true;
LblMessage.Text = "For Amount Paying Click On Amount! ";
GridViewDisplay.DataSource = ds.Tables[0];
GridViewDisplay.DataBind();
}
}
public void bind()
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConString"].ToString());
conn.Open();
string str;
str = "select * from Work2,Teacher where Work2.Wnum=Teacher.Tnum";
SqlCommand cmd = new SqlCommand(str, conn);
SqlDataAdapter sda = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
sda.Fill(ds);
GridViewDisplay.DataSource = ds;
GridViewDisplay.DataBind();
conn.Close();
}
public void bind()
{
String user_num = Server.UrlDecode(Request.Cookies["Userisgrade"].Value);
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConString"].ToString());
conn.Open();
string str = "select * from Teacher,Class,Crouse,Work1 where Teacher.Tnum = Work1.Wtnum AND Work1.Wclnum = Class.Clnum AND Work1.Wcrnum = Crouse.Crnum AND Class.Clgrade = '" + user_num + "' order by Class.Clnum , Crouse.Crnum";
SqlCommand cmd = new SqlCommand(str, conn);
SqlDataAdapter sda = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
sda.Fill(ds);
GridViewDisplay.DataSource = ds;
GridViewDisplay.DataBind();
GridViewDisplay.Visible = true;
conn.Close();
}
public void bind2()
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConString"].ToString());
conn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
String str;
str = "select distinct Tnum,Tname,Pterm,Pmonth,Ptimes,Pposition,Pmanager,Paward,Pabsent,Paddelse,Preduceelse,Pservice from Teacher,Pay where Teacher.Tnum=Pay.Ptnum";
cmd.CommandText = str;
SqlDataAdapter sda = new SqlDataAdapter(cmd);
dsk = new DataSet();
sda.Fill(dsk);
GridViewDisplay.DataSource = dsk;
GridViewDisplay.DataBind();
conn.Close();
}
public void bind()
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConString"].ToString());
conn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
String str;
str = "select * from Teacher";
cmd.CommandText = str;
SqlDataAdapter sda = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
sda.Fill(ds);
GridViewDisplay.DataSource = ds;
GridViewDisplay.DataBind();
conn.Close();
}
protected void search_Click(object sender, EventArgs e)
{
String search_way = Way.SelectedItem.Value.Trim();
String str = "";
String choose_item = choose.SelectedItem.Value.Trim();
if (search_way.Equals("按年级查询"))
{
str = "select distinct Tnum,Tname,Pterm,Pmonth,Ptimes,Pposition,Pmanager,Paward,Pabsent,Paddelse,Preduceelse,Pservice from Teacher,Pay,Work1,Class where Teacher.Tnum=Pay.Ptnum and Teacher.Tnum=Work1.Wtnum and Work1.Wclnum=Class.Clnum and Class.Clgrade='" + choose_item + "'";
}
else if (search_way.Equals("按月份查询"))
{
int i = int.Parse(choose_item);
str = "select distinct Tnum,Tname,Pterm,Pmonth,Ptimes,Pposition,Pmanager,Paward,Pabsent,Paddelse,Preduceelse,Pservice from Teacher,Pay where Pay.Ptnum=Teacher.Tnum and Pay.Pmonth='" + i + "'";
}
else if (search_way.Equals("按教师类型查询"))
{
if (choose.SelectedItem.Value.ToString().Equals("后勤"))
{
str = "select distinct Tnum,Tname,Pterm,Pmonth,Ptimes,Pposition,Pmanager,Paward,Pabsent,Paddelse,Preduceelse,Pservice from Teacher,Pay,Work2 where Teacher.Tnum=Pay.Ptnum and Teacher.Tnum=Work2.Wnum ";
}
else
{
str = "select distinct Tnum,Tname,Pterm,Pmonth,Ptimes,Pposition,Pmanager,Paward,Pabsent,Paddelse,Preduceelse,Pservice from Teacher,Pay,Work1 where Teacher.Tnum=Pay.Ptnum and Teacher.Tnum=Work1.Wtnum ";
}
}
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConString"].ToString());
conn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = str;
SqlDataAdapter sda = new SqlDataAdapter(cmd);
dsk = new DataSet();
sda.Fill(dsk);
GridViewDisplay.DataSource = dsk;
GridViewDisplay.DataBind();
conn.Close();
}
public void bind(String key)
{
key = keyname.Text.Trim();
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConString"].ToString());
conn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
String str;
str = "select * from Teacher where Tname='" + key + "' or Tnum='" + key + "'";
cmd.CommandText = str;
SqlDataAdapter sda = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
sda.Fill(ds);
GridViewDisplay.DataSource = ds;
GridViewDisplay.DataBind();
conn.Close();
}
