public void Bind()
{
String user_grade = Server.UrlDecode(Request.Cookies["Userisgrade"].Value);
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConString"].ToString());
conn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
String str = "";
if (!user_grade.Equals("后勤"))
{
str = "select distinct Lnum,Ltnum,Lname,Ltime,Llong,Lstate from Leave,Work1,Class where Leave.Ltnum=Work1.Wtnum and Work1.Wclnum=Class.Clnum and Class.Clgrade='" + user_grade + "'";
}
else
{
str = "select * from Leave,Work2 where Leave.Ltnum=Work2.Wnum";
}
cmd.CommandText = str;
SqlDataAdapter sda = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
sda.Fill(ds);
GridviewDisplay.DataSource = ds;
GridviewDisplay.DataBind();
conn.Close();
GridviewDisplay.Visible = true;
}
public void bind()
{
applyreason.Attributes.Add("Value", "不要超过20字");
applyreason.Attributes.Add("OnFocus", "if(this.value=='不要超过20字') {this.value=''}");
applyreason.Attributes.Add("OnBlur", "if(this.value==''){this.value='不要超过20字'}");
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConString"].ToString());
conn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
String apply_tnum = Server.UrlDecode(Request.Cookies["Usernum"].Value).Trim();
String str = "select * from Leave where Ltnum='" + apply_tnum + "'";
cmd.CommandText = str;
SqlDataAdapter sda = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
sda.Fill(ds);
GridviewDisplay.DataSource = ds;
GridviewDisplay.DataBind();
conn.Close();
GridviewDisplay.Visible = true;
}
