showall.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 showAll_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 Button1_Click(object sender, EventArgs e)
	{
		string [] y=new string [13];
		DataUse show = new DataUse();
		int month;
		float  money = 0;
		DataTable dt = new DataTable("skimmer");
		dt.Columns.Add("姓名", typeof(System.String));
		dt.Columns.Add("班级", typeof(System.String));
		dt.Columns.Add("部门", typeof(System.String));
		dt.Columns.Add("联系方式", typeof(System.String));
		dt.Columns.Add("负责老师", typeof(System.String));
		dt.Columns.Add("老师联系", typeof(System.String));
		dt.Columns.Add("贫困情况", typeof(System.String));
		dt.Columns.Add("备注", typeof(System.String));
		if (Year1.SelectedValue == Year2.SelectedValue)
		{
			for (int i = 0; i <= int.Parse(Month2.SelectedValue) - int.Parse(Month1.SelectedValue); i++)
			{
				month = i + int.Parse(Month1.SelectedValue);
				y[i] = Year1.SelectedValue + "-" + month.ToString();
				dt.Columns.Add(y[i], typeof(System.String));
			}
			month = int.Parse(Month2.SelectedValue) - int.Parse(Month1.SelectedValue);
		}
		else
		{
			for (int i = 0; i <= int.Parse(Month2.SelectedValue) - int.Parse(Month1.SelectedValue )+ 12; i++)
			{
				month = i + int.Parse(Month1.SelectedValue);
				if (month > 12)
				{
					int year = int.Parse(Year1.SelectedValue) + 1;
					month -= 12;
					y[i] = year.ToString() + "-" + month.ToString();
					dt.Columns.Add(y[i], typeof(System.String));
				}
				else
				{
					y[i] = Year1.SelectedValue + "-" + month.ToString();
					dt.Columns.Add(y[i], typeof(System.String));
				}
			}
			month = int.Parse(Month2.SelectedValue) - int.Parse(Month1.SelectedValue)+12;
		}
        dt.Columns.Add("总计", typeof(System.String));
		string sql = "select student.Name as 姓名,student.Class as 班级,student.Part as 部门,student.Phone as 联系方式,"
			+ "teacher.teacher as 负责老师,teacher.phone as 老师联系,student.Poor as 贫困情况,student.Bak as 备注 from student,"
			+"teacher where student.Name like '" + Name.Text + "%' and student.Class"
			+" like '" + Class.Text + "%' and student.Part like '" + Part.Text + "%'"
			+" and teacher.Part=student.Part";
		if (Name.Text == "" && Class.Text == "" && Part.Text == "")
			sql = "select student.Name as 姓名,student.Class as 班级,student.Part as 部门,student.Phone as 联系方式,"
			+ "teacher.teacher as 负责老师,teacher.phone as 老师联系,student.Poor as 贫困情况,student.Bak as 备注 from student,"
			+ "teacher where student.Part<>'家教' and student.Part<>'未分配' and teacher.Part=student.Part order by student.Part";
		dt = show.getDataTable(sql,dt);
        
		foreach (DataRow dr in dt.Rows)
		{
			sql = "select * from work_rst where Name='" + dr[0].ToString() + "' and Class='"+dr[1].ToString()+"'";
			DataTable temp3 = show.getDataTable(sql, "work");
            float total = 0;
			for (int i = 0; i <= month; i++)
				foreach (DataRow dk in temp3.Rows)
					if (dk[2].ToString() == y[i])
					{
						money =float.Parse(dk[3].ToString())*8;
                        total += money;
						dr[i + 8] = money.ToString();
					}
            dr[month + 9] = total.ToString();
		}
		DataGrid1.DataSource = dt;
		DataGrid1.DataBind();

	}
	protected void DataGrid1_SelectedIndexChanged(object sender, EventArgs e)
	{
		Session["name"] = DataGrid1.SelectedItem.Cells[1].Text;
		Session["class"] = DataGrid1.SelectedItem.Cells[2].Text;
		Session["bak"] = DataGrid1.SelectedItem.Cells[8].Text;
		Response.Redirect("addRst.aspx");
	}
    protected void Button2_Click(object sender, EventArgs e)
    {
        DataUse ud= new DataUse();
        DataTable dt =ud.getDataTable("select * from Sheet1","data");
        foreach (DataRow dr in dt.Rows)
            ud.commit("update student set Poor='是' where Name='"+dr[0].ToString()+"'");
    }
}