result.aspx.cs

勤工俭学的管理系统 记录学生资料

using System;
using System.Data;
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;
using sues_data;

public partial class result_aspx : System.Web.UI.Page
{
    // Page events are wired up automatically to methods 
    // with the following names:
    // Page_Load, Page_AbortTransaction, Page_CommitTransaction,
    // Page_DataBinding, Page_Disposed, Page_Error, Page_Init, 
    // Page_Init Complete, Page_Load, Page_LoadComplete, Page_PreInit
    // Page_PreLoad, Page_PreRender, Page_PreRenderComplete, 
    // Page_SaveStateComplete, Page_Unload
     
    protected void Page_Load(object sender, EventArgs e)
    {
		if (!Page.IsPostBack)
			if (Session["admin"].ToString() != "admin")
				Response.Redirect("../Default.aspx");

    }
	protected void score_Click(object sender, EventArgs e)
	{
		string sql = "select * from rule where ID like '" + college.SelectedValue+"%'";
		DataUse show = new DataUse();
		DataTable dt = new DataTable("skimmer");
		dt.Columns.Add("ID", typeof(System.String));
		dt.Columns.Add("Name", typeof(System.String));
		dt.Columns.Add("score", typeof(System.String));
		dt.Columns.Add("reward", typeof(System.String));
		DataTable rule = show.getDataTable(sql, "rule");
		DataRow dtr;
		foreach (DataRow dr in rule.Rows)
		{
			int some = 0;
			int total = int.Parse(dr[1].ToString()) + int.Parse(dr[2].ToString()) + int.Parse(dr[3].ToString());
			sql = "select ID,Class,Name,score from st_score" +
				" where Class like '"+dr[0].ToString() +"%' order by score DESC";
			DataTable temp = show.getDataTable(sql,dr[1].ToString());
			for (int i = 0; i < int.Parse(dr[1].ToString()); i++)
			{
				if (float.Parse(temp.Rows[i][3].ToString()) > 3.7)
				{
					dtr = dt.NewRow();
					dtr[0] = temp.Rows[i][0];
					dtr[1] = temp.Rows[i][2];
					dtr[2] = temp.Rows[i][3];
					dtr[3] = "一等奖";
					dt.Rows.Add(dtr);
				}
				else
					some++;
			}
			for (int i = (int)int.Parse(dr[1].ToString()); i < int.Parse(dr[1].ToString()) + int.Parse(dr[2].ToString()); i++)
			{
				if (float.Parse(temp.Rows[i-some][3].ToString()) > 3)
				{
					dtr = dt.NewRow();
					dtr[0] = temp.Rows[i - some][0];
					dtr[1] = temp.Rows[i - some][2];
					dtr[2] = temp.Rows[i - some][3];
					dtr[3] = "二等奖";
					dt.Rows.Add(dtr);
				}
				else
					some++;
			}
			for (int i = int.Parse(dr[1].ToString()) + int.Parse(dr[2].ToString()); i < total; i++)
			{
				if (float.Parse(temp.Rows[i-some][3].ToString()) >2.3)
				{
					dtr = dt.NewRow();
					dtr[0] = temp.Rows[i - some][0];
					dtr[1] = temp.Rows[i - some][2];
					dtr[2] = temp.Rows[i - some][3];
					dtr[3] = "三等奖";
					dt.Rows.Add(dtr);
				}
			}
			DataGrid1.DataSource = dt;
			DataGrid1.DataBind();
		}
	}
}