📄 classview.aspx.cs
字号:
using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
public partial class ClassView : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
// this.TextBox1.Text = getday(5, 15 );
// this.SqlDataSource2.s
if (Session["UserID"]==null)
Response.Redirect("index.aspx");
this.UserID.Text = Session["UserID"].ToString();
if (!this.Page.IsPostBack)
{
if (Session["classname"] == null )
{
chkregclass();
}
// Session["classname"] = "04软件工程 ";
object source = Session["UserID"];
string UserId = source.ToString();
GetClass(UserId);
bindbirthday();
bindGy();
for (int i = 0; i < this.ClassList.Items.Count; i++)
{
if (this.ClassList.Items[i].Text.Trim() == Session["classname"].ToString().Trim())
ClassList.Items[i].Selected = true;
}
}
}
private bool chkregclass()
{
SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);
conn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = "select Num ,ClassName from UserToClass where UserID='" + Session["UserID"].ToString().Trim() + "'";
SqlDataReader sdr = cmd.ExecuteReader();
if (sdr.Read() )
{
Session["classname"] = sdr["ClassName"];
conn.Close();
return true;
}
else
{
conn.Close();
Response.Redirect("RegClass.aspx");
return false;
}
}
private void bindGy()
{
string cmd = "SELECT Gyuan, Tgao, ClassNum, ClassName, Teacher, Monitor, classyear, manager, url FROM ClassInfo WHERE (ClassName = '" + Session["classname"].ToString().Trim() + "')"; //设置SQL命令
SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["connectionString"]);
conn.Open();
SqlCommand myCommand = new SqlCommand(cmd, conn);
SqlDataReader chen = myCommand.ExecuteReader();
if (chen.Read())
{
this.gy.Text = chen["Gyuan"].ToString();
this.tg.Text = chen["Tgao"].ToString();
this.cname.Text = chen["ClassName"].ToString().Trim();
this.Enter.Text = chen["classyear"].ToString().Trim();
this.monitor.Text = chen["Monitor"].ToString().Trim();
this.Teacher.Text = chen["Teacher"].ToString().Trim();
this.urlLink.NavigateUrl = chen["url"].ToString().Trim();
this.urlLink.Text = chen["url"].ToString().Trim();
}
conn.Close();
}
private void bindbirthday()
{
string cmd;
cmd = " SELECT UserInfo.UserID, StudentInfo.Name, UserInfo.biryear, UserInfo.birmounth, UserInfo.birday FROM StudentInfo INNER JOIN UserInfo ON StudentInfo.StudentID = UserInfo.StudentID WHERE (UserInfo.UserID IN (SELECT UserID FROM UserToClass WHERE (ClassName = '"+ Session["classname"].ToString().Trim()+"')))";//设置SQL命令
this.SqlDataSource2.SelectCommand = cmd;
this.SqlDataSource1.DataBind(); //将SqlDataSource重新绑定
this.GridView1.DataBind(); //对GridView进行绑定
}
public string getday(object m, object d)
{
string day= tobirthday(System.DateTime.Today.Year, m, d);
if (day == "0")
day ="<img id=\"SelPic\" src=\"picture/cake.gif\" style=\"width: 30px; height: 20px;\" />";
return day;
}
public string sort(object m, object d)
{
string day = tobirthday(System.DateTime.Today.Year, m, d);
return day;
}
public string tobirthday(object y, object m, object d)
{
string birthday="";
int year = Convert.ToInt16(y.ToString()); //System.DateTime.Today.Year;
int mounth = Convert.ToInt16(m.ToString());
int day= Convert.ToInt16(d.ToString());
int mnow = System.DateTime.Today.Month;
if (mnow >mounth)
{
int extraday = System.DateTime.IsLeapYear(year) ? 366 : 365;
birthday = Convert.ToString(extraday - dayofyaer(year, mnow, System.DateTime.Today.Day) + dayofyaer(year + 1, mounth, day));
}
else{
if(mnow==mounth)
{ if(day<System.DateTime.Today.Day)
{
int extraday = System.DateTime.IsLeapYear(year) ? 366 : 365;
birthday = Convert.ToString(extraday - dayofyaer(year, mnow, System.DateTime.Today.Day) + dayofyaer(year + 1, mounth, day));
}
else{
birthday = Convert.ToString(dayofyaer(year,mounth,day ) - dayofyaer(year , mnow , System.DateTime.Today.Day));
}
}
else
{
birthday = Convert.ToString(dayofyaer(year, mounth, day) - dayofyaer(year, mnow, System.DateTime.Today.Day));
}
}
return birthday;
}
public int dayofyaer(int year, int mounth, int day)
{
int daycount=0; int run;
if ((year % 4 == 0 && year % 100 != 0) || (year % 400 == 0))
run = 29;
else
run = 28;
switch (mounth)
{
case 1:
{
daycount=day;
break;
}
case 2:
{
daycount = 31 + day;
break;
}
case 3:
{
daycount =run+ 31 + day;
break;
}
case 4:
{
daycount = run + day + 62;
break;
}
case 5:
{
daycount = run + day + 92;
break;
}
case 6:
{
daycount = run + day + 123;
break;
}
case 7:
{
daycount = run + day + 154;
break;
}
case 8:
{
daycount = run + day + 184;
break;
}
case 9:
{
daycount = run + day + 215;
break;
}
case 10:
{
daycount = run + day + 245;
break;
}
case 11:
{
daycount = run + day + 276;
break;
}
case 12:
{
daycount = run + day + 306;
break;
}
default:
break;
}
return daycount;
}
public string birhday(object y, object m, object d)
{
string year = y.ToString();
string mounth = m.ToString();
string day = d.ToString();
return year + "-" + mounth + "-" + day;
}
protected void GridView1_DataBound(object sender, EventArgs e)
{
}
protected void GetClass(string UserId)
{
SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);
conn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = "select distinct Num ,ClassName from UserToClass where UserID='" + UserId + "'";
SqlDataReader sdr = cmd.ExecuteReader();
if (sdr.HasRows == true)
{
this.ClassList.DataSource = sdr;
this.ClassList.DataTextField = "ClassName";
this.ClassList.DataValueField = "ClassName";
this.ClassList.DataBind();
}
//.Items.FindByText(Session["classname"].ToString().Trim());
conn.Close();
}
protected void ClassList_SelectedIndexChanged(object sender, EventArgs e)
{
Session["classname"] = this.ClassList.SelectedItem.Text;
bindGy();
}
protected void msgbtn_Click(object sender, EventArgs e)
{
Session["classname"] = this.ClassList.SelectedItem.Text;
Response.Redirect("classmsg.aspx");
}
protected void logout_Click(object sender, EventArgs e)
{
SqlConnection sqlcon;
sqlcon = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);
SqlCommand sqlcom;
string sqlstr = "delete from UserToClass where UserID='" + Session["UserID"].ToString().Trim() + "' and ClassName='" + this.ClassList.SelectedItem.Text + "'";
sqlcom = new SqlCommand(sqlstr, sqlcon);
sqlcon.Open();
sqlcom.ExecuteNonQuery();
sqlcon.Close();
Session["classname"] = null;
Response.Redirect("main.aspx");
}
protected void tclbtn_Click(object sender, EventArgs e)
{
Session["classname"] = this.ClassList.SelectedItem.Text;
Response.Redirect("AddrCard.aspx");
}
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
/////MsgBtn ImageButton2
ImageButton ibtn = ((ImageButton)e.Row.FindControl("wishbtn"));
if (ibtn == null)
{
return;
}
ibtn.Enabled = true;
//switch (Convert.ToInt32((e.Row.Cells[4].Text.Trim())))
//{
// case 1:
ibtn.CommandArgument = e.Row.DataItemIndex.ToString();
}
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
//LinkEmail
switch (e.CommandName)
{
case "wish":
{
int index = Convert.ToInt32(e.CommandArgument) - this.GridView1.PageIndex * 5;
//获取行的位置
GridViewRow row = GridView1.Rows[index];
//获取选定行的列的位置，比如第三列，付给你自己的变量表达式，这里是全局变量varImpID
// Session["MailTo"] = row.Cells[0].Text;
Label lb = (Label)row.FindControl("UserLab");
// this.testtext.Text = row.Cells[4].Text;
String StrTemp = lb.Text;
Session["MsgTo"] = StrTemp;
Response.Redirect("SendMsg.aspx");
} break;
default: break;
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -