protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DataBaseAccess db = new DataBaseAccess();
dt = db.read("findmatchnode", CommandType.StoredProcedure).Tables[0];
DataRow[] rows = dt.Select("topid='0'");
for (int i = 0; i < rows.Length; i++)
{
TreeNode node = new TreeNode(rows[i]["permissionname"].ToString(), rows[i]["permissionid"].ToString(), "", rows[i]["url"].ToString(), "MainFrame");
TreeView1.Nodes.Add(node);
AddChildNode(node, dt.Select("topid='" + rows[i]["permissionid"].ToString() + "'"));
}
DataTable da = db.read("select distinct Teamname from TeamSum", CommandType.Text).Tables[0];
DropDownList1.Items.Add("--->请选择球队<---".ToString());
DropDownList2.Items.Add("--->请选择球队<---".ToString());
DropDownList3.Items.Add("--->请选择裁判员<---".ToString());
DropDownList4.Items.Add("--->请选择计时员<---".ToString());
foreach (DataRow dr in da.Rows)
{
DropDownList1.Items.Add(new ListItem(dr["Teamname"].ToString()));
DropDownList2.Items.Add(new ListItem(dr["Teamname"].ToString()));
}
da = db.read("select Judgername from JudgeInformation", CommandType.Text).Tables[0];
foreach (DataRow dr in da.Rows)
{
DropDownList3.Items.Add(new ListItem(dr["Judgername"].ToString()));
}
da = db.read("select Timekeepername from TimeKeeperInformation", CommandType.Text).Tables[0];
foreach (DataRow dr in da.Rows)
{
DropDownList4.Items.Add(new ListItem(dr["Timekeepername"].ToString()));
}
}
}
protected void Button1_Click(object sender, EventArgs e)
{
string teamname = DropDownList1.SelectedValue;
string playername = DropDownList2.SelectedValue;
string playerscore = TextBox1.Text;
DataBaseAccess db = new DataBaseAccess();
DataTable ds = db.read("select top 1 turn from LeagueStanding order by turn desc", CommandType.Text).Tables[0];
tur = ds.Rows[0]["turn"].ToString();
SqlParameter teamn = new SqlParameter("@teamname", teamname);
SqlParameter player = new SqlParameter("@playername", playername);
SqlParameter turn = new SqlParameter("@turn", tur);
SqlParameter score = new SqlParameter("@score", playerscore);
SqlParameter sprv = new SqlParameter("@result", SqlDbType.Int);
sprv.Direction = ParameterDirection.Output;
if (Button1.CommandName == "yes")
{
db.command("insertplayerscore", CommandType.StoredProcedure, teamn, player, turn, score, sprv);
if (sprv.Value.ToString() == "0")
{
Response.Write("<script>alert('添加成功！');</script>");
DropDownList1.Items.Clear();
DropDownList2.Items.Clear();
TextBox1.Text = "";
}
else
{
Response.Write("<script>alert('添加失败，请检查！');</script>");
}
}
}
public void ds(string str)
{
DataBaseAccess dtm = new DataBaseAccess();
DataTable dt = dtm.read(str, CommandType.Text).Tables[0];
DataView dv = dt.DefaultView;
GridView1.DataSource = dv;
GridView1.DataBind();
}
//球员射手榜前五甲
void PlayerBind()
{
DataBaseAccess db = new DataBaseAccess();
DataTable dt = db.read("select place,playername,teamname,playergoals from playerranking", CommandType.Text).Tables[0];
DataView dv = dt.DefaultView;
GridView2.DataSource = dv;
GridView2.DataBind();
}
//球队积分榜五甲
void TeamBind()
{
DataBaseAccess db = new DataBaseAccess();
DataTable dt = db.read("select * from teamranking", CommandType.Text).Tables[0];
DataView dv = dt.DefaultView;
GridView3.DataSource = dv;
GridView3.DataBind();
}
void databind(string turn)
{
DataBaseAccess db = new DataBaseAccess();
DataTable dt = db.read("select turn,teamname,playername,playernumber,playerredcard,playeryellowcard,stopperiod from TeamPlayer,RedYellowCards where TeamPlayer.playerorder=RedYellowCards.playerorder and RedYellowCards.turn='" + turn + "'", CommandType.Text).Tables[0];
DataView dv = dt.DefaultView;
GridView3.DataSource = dv;
GridView3.DataBind();
}
private void BindGrid()
{
DataBaseAccess db = new DataBaseAccess();
DataTable dt = db.read("select top 100 * from TeamPlayer,RedYellowCards where teamplayer.playerorder=RedYellowCards.playerorder order by turn", CommandType.Text).Tables[0];
DataView dv = dt.DefaultView;
GridView1.DataKeyNames = new string[] { "playername", "turn" };
GridView1.DataSource = dv;
GridView1.DataBind();
}
private void BindGrid()
{
DataBaseAccess db = new DataBaseAccess();
DataTable da = db.read("select * from PlayCourt", CommandType.Text).Tables[0];
DataView dv = da.DefaultView;
GridView1.DataKeyNames = new string[] { "Courtname" };
GridView1.DataSource = dv;
GridView1.DataBind();
}
private void BindGrid()
{
DataBaseAccess db = new DataBaseAccess();
DataTable dt = db.read("select * from TimeKeeperInformation order by Timekeepernumber", CommandType.Text).Tables[0];
DataView dv = dt.DefaultView;
GridView1.DataKeyNames = new string[] { "Timekeepernumber" };
GridView1.DataSource = dv;
GridView1.DataBind();
}
private void BindGrid()
{
DataBaseAccess db = new DataBaseAccess();
DataTable dt = db.read("select * from LeagueStanding order by turn desc", CommandType.Text).Tables[0];
DataView dv = dt.DefaultView;
GridView1.DataKeyNames = new string[] { "teamname", "turn" };
GridView1.DataSource = dv;
GridView1.DataBind();
}
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
DropDownList2.Items.Clear();
DataBaseAccess db = new DataBaseAccess();
string turn = DropDownList1.SelectedValue;
DataTable dateam = db.read("select teama from ScheduleArrange where turn='" + turn + "'", CommandType.Text).Tables[0];
DropDownList2.Items.Add("--->请选择球队<---".ToString());
foreach (DataRow dr in dateam.Rows)
{
DropDownList2.Items.Add(new ListItem(dr["teama"].ToString()));
}
DataTable dateamb = db.read("select teamb from ScheduleArrange where turn='" + turn + "'", CommandType.Text).Tables[0];
foreach (DataRow dr in dateamb.Rows)
{
DropDownList2.Items.Add(new ListItem(dr["teamb"].ToString()));
}
}
private void BindGrid()
{
DataBaseAccess db = new DataBaseAccess();
DataTable dt = db.read("select * from ScheduleArrange order by turn,FieldOrder", CommandType.Text).Tables[0];
DataView dv = dt.DefaultView;
GridView1.DataKeyNames = new string[] { "turn", "FieldOrder" };
GridView1.DataSource = dv;
GridView1.DataBind();
}
//datalist绑定
private void dt()
{
DataBaseAccess da = new DataBaseAccess();
DataTable dt = da.read("select distinct teamname from LeagueStanding", CommandType.Text).Tables[0];
DataView dv = dt.DefaultView;
DataList1.DataSource = dv;
DataList1.DataKeyField = "teamname";
DataList1.DataBind();
}
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
string ddl = DropDownList1.SelectedValue;
DataBaseAccess db = new DataBaseAccess();
DataTable dt = db.read("select Turn,FieldOrder,CONVERT(varchar(100),fixture,20)fixture,Courtname,Judgername,Timekeepername,TeamA,TeamB from ScheduleArrange where turn='" + ddl + "' order by FieldOrder asc", CommandType.Text).Tables[0];
DataView dv = dt.DefaultView;
GridView3.DataSource = dv;
GridView3.DataBind();
}
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
string ddl = DropDownList1.SelectedValue;
DataBaseAccess db = new DataBaseAccess();
DataTable dt = db.read("select Teamname,fieldorder,Turn,Teamscore,Teamlose,GoalDifference,Score from LeagueStanding where turn='" + ddl + "'", CommandType.Text).Tables[0];
DataView dv = dt.DefaultView;
GridView1.DataSource = dv;
GridView1.DataBind();
}
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
string ddl = DropDownList1.SelectedValue;
DataBaseAccess db = new DataBaseAccess();
DataTable dt = db.read("select top 100 * from playerrangkingall where turn='" + ddl + "' order by Playergoals desc", CommandType.Text).Tables[0];
DataView dv = dt.DefaultView;
GridView1.DataSource = dv;
GridView1.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
DataBaseAccess db = new DataBaseAccess();
DataTable dt = db.read("select distinct userType from UserInformation", CommandType.Text).Tables[0];
DropDownList1.Items.Add("--->请选择管理类型<---".ToString());
foreach (DataRow dr in dt.Rows)
{
DropDownList1.Items.Add(new ListItem(dr["userType"].ToString()));
}
}
void databind()
{
DataBaseAccess db = new DataBaseAccess();
string teamname = DropDownList1.SelectedValue;
DataTable da = db.read("select playernumber,playerorder,playername,idnumber,gender,CONVERT(varchar(100),datebirth,5) datebirth from teamplayer where teamname='" + teamname + "'", CommandType.Text).Tables[0];
DataView dv = da.DefaultView;
GridView1.DataKeyNames = new string[] { "playerorder" };
GridView1.DataSource = dv;
GridView1.DataBind();
GridView1.Columns[0].Visible = false;
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DataBaseAccess db = new DataBaseAccess();
dt = db.read("select * from teamnode where username='******'", CommandType.Text).Tables[0];
DataRow[] rows = dt.Select("topid='0'");
for (int i = 0; i < rows.Length; i++)
{
TreeNode node = new TreeNode(rows[i]["permissionname"].ToString(), rows[i]["permissionid"].ToString(), "", rows[i]["url"].ToString(), "MainFrame");
TreeView1.Nodes.Add(node);
AddChildNode(node, dt.Select("topid='" + rows[i]["permissionid"].ToString() + "'"));
}
DataTable da = db.read("select distinct turn from ScheduleArrange", CommandType.Text).Tables[0];
DropDownList1.Items.Add("--->请选择轮次<---".ToString());
foreach (DataRow dr in da.Rows)
{
DropDownList1.Items.Add(new ListItem(dr["turn"].ToString()));
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DataBaseAccess da = new DataBaseAccess();
DataTable dt = da.read("select distinct turn from LeagueStanding", CommandType.Text).Tables[0];
DropDownList1.Items.Add("--->轮次<---".ToString());
foreach (DataRow dr in dt.Rows)
{
DropDownList1.Items.Add(new ListItem(dr["turn"].ToString()));
}
}
}
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
DropDownList2.Items.Clear();
string teamname = DropDownList1.SelectedValue;
DataBaseAccess db = new DataBaseAccess();
DataTable dt = db.read("select playername from teamplayer where teamname='" + teamname + "'", CommandType.Text).Tables[0];
DropDownList2.Items.Add("--->选择球员<---".ToString());
foreach (DataRow dr in dt.Rows)
{
DropDownList2.Items.Add(new ListItem(dr["playername"].ToString(), dr["playername"].ToString()));
}
}
protected void DropDownList3_SelectedIndexChanged(object sender, EventArgs e)
{
DropDownList1.Items.Clear();
string turn = DropDownList3.SelectedValue;
DataBaseAccess db = new DataBaseAccess();
DataTable da = db.read("select distinct teamname from LeagueStanding where turn='" + turn + "'", CommandType.Text).Tables[0];
DropDownList1.Items.Add("--->选择球队<---".ToString());
foreach (DataRow dr in da.Rows)
{
DropDownList1.Items.Add(new ListItem(dr["teamname"].ToString(), dr["teamname"].ToString()));
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DataBaseAccess db = new DataBaseAccess();
dt = db.read("findnode", CommandType.StoredProcedure).Tables[0];
DataRow[] rows = dt.Select("topid='0'");
for (int i = 0; i < rows.Length; i++)
{
TreeNode node = new TreeNode(rows[i]["permissionname"].ToString(), rows[i]["permissionid"].ToString(), "", rows[i]["url"].ToString(), "MainFrame");
TreeView1.Nodes.Add(node);
AddChildNode(node, dt.Select("topid='" + rows[i]["permissionid"].ToString() + "'"));
}
DataTable da = db.read("select distinct teamname from TeamPlayer", CommandType.Text).Tables[0];
DropDownList1.Items.Add("--->请选择球队名称<---".ToString());
foreach (DataRow dr in da.Rows)
{
DropDownList1.Items.Add(new ListItem(dr["teamname"].ToString()));
}
// databind();
}
GridView1.Attributes.Add("style", "table-layout:fixed");
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
DataBaseAccess db = new DataBaseAccess();
string playername = GridView1.DataKeys[e.RowIndex]["playername"].ToString();
string turn = GridView1.DataKeys[e.RowIndex]["turn"].ToString();
DataTable dt = db.read("select playerorder from TeamPlayer where playername='" + playername + "'", CommandType.Text).Tables[0];
string playerorder = dt.Rows[0]["playerorder"].ToString();
string playergoals = ((TextBox)GridView1.Rows[e.RowIndex].Cells[3].Controls[0]).Text;
db.command("update topscorer set playergoals='" + playergoals + "' where turn=" + turn + " and playerorder='" + playerorder + "'", CommandType.Text);
GridView1.EditIndex = -1;
BindGrid();
Response.Write("<script>alert('更新成功！');</script>");
}
void databind()
{
DataBaseAccess db = new DataBaseAccess();
DataTable da = db.read("select * from TeamSum", CommandType.Text).Tables[0];
DataView dv = da.DefaultView;
GridView1.DataKeyNames = new string[] { "teamname" };
if (Session["sort"] != null)
{
dv.Sort = Session["sort"].ToString();
}
GridView1.DataSource = dv;
GridView1.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DataBaseAccess db = new DataBaseAccess();
DataTable da = db.read("select distinct turn from ScheduleArrange", CommandType.Text).Tables[0];
DropDownList1.Items.Add("--->轮次<----".ToString());
foreach (DataRow dr in da.Rows)
{
DropDownList1.Items.Add(new ListItem(dr["turn"].ToString()));
}
PlayerBind();
TeamBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DataBaseAccess db = new DataBaseAccess();
dt = db.read("findmatchnode", CommandType.StoredProcedure).Tables[0];
DataRow[] rows = dt.Select("topid='0'");
for (int i = 0; i < rows.Length; i++)
{
TreeNode node = new TreeNode(rows[i]["permissionname"].ToString(), rows[i]["permissionid"].ToString(), "", rows[i]["url"].ToString(), "MainFrame");
TreeView1.Nodes.Add(node);
AddChildNode(node, dt.Select("topid='" + rows[i]["permissionid"].ToString() + "'"));
}
}
}
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "Delete")
{
DataBaseAccess db = new DataBaseAccess();
GridViewRow drv = ((GridViewRow)(((ImageButton)(e.CommandSource)).Parent.Parent)); //此得出的值是表示那行被选中的索引值
int turn = Int32.Parse(GridView1.DataKeys[drv.RowIndex]["turn"].ToString());
string playername = (GridView1.DataKeys[drv.RowIndex]["playername"].ToString());
DataTable dt = db.read("select playerorder from TeamPlayer where playername='" + playername + "'", CommandType.Text).Tables[0];
string playerorder = dt.Rows[0]["playerorder"].ToString();
db.command("delete from RedYellowCards where playerorder='" + playerorder + "' and turn='" + turn + "'", CommandType.Text);
BindGrid();
Response.Write("<script>alert('删除成功！');</script>");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DataBaseAccess db = new DataBaseAccess();
dt = db.read("select * from teamnode where username='******'", CommandType.Text).Tables[0];
DataRow[] rows = dt.Select("topid='0'");
for (int i = 0; i < rows.Length; i++)
{
TreeNode node = new TreeNode(rows[i]["permissionname"].ToString(), rows[i]["permissionid"].ToString(), "", rows[i]["url"].ToString(), "MainFrame");
TreeView1.Nodes.Add(node);
AddChildNode(node, dt.Select("topid='" + rows[i]["permissionid"].ToString() + "'"));
}
BindGrid();
}
}
protected void Button1_Click(object sender, EventArgs e)
{
DataBaseAccess db = new DataBaseAccess();
try
{
DataTable dt = db.read("select Username from userinformation where Username='******'", CommandType.Text).Tables[0];
int i = dt.Rows.Count;
if (i.ToString() == "0")
{
if (TextBox2.Text == TextBox3.Text)
{
SqlParameter sname = new SqlParameter("@Username", TextBox1.Text);
SqlParameter spwd = new SqlParameter("@UserPassword", TextBox2.Text);
SqlParameter stype = new SqlParameter("@userType", DropDownList1.SelectedValue.ToString());
SqlParameter semail = new SqlParameter("@UserEmail", TextBox4.Text);
SqlParameter stel = new SqlParameter("@Usertelephone", TextBox5.Text);
SqlParameter sresult = new SqlParameter("@result", SqlDbType.Int);
sresult.Direction = ParameterDirection.Output;
db.command("insertuser", CommandType.StoredProcedure, sname, spwd, stype, semail, stel, sresult);
if (sresult.Value.ToString() == "1")
{
Response.Redirect("Login.aspx");
//Response.Write("<script>alert('继续');</script>");
}
else
{
Response.Write("<script>alert('注册失败，请重新注册');</script>");
}
}
else
{
TextBox2.Text = "";
TextBox3.Text = "";
Response.Write("<script>alert('两次密码不一致！');</script>");
}
}
else
{
TextBox2.Text = "";
TextBox3.Text = "";
Response.Write("<script>alert('该用户已存在！');</script>");
}
}
catch (Exception ex)
{ throw ex; }
}
