add_m7.aspx.cs

一个研究生管理系统 具体的情况自己看了

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

public partial class manger_add_m7 : System.Web.UI.Page
{
    public int allpage = 0;
    protected void Page_Load(object sender, EventArgs e)
    {
        try
        {
            if (Session["admin"].ToString() != "true")
            {
                //Response.Write("<script>parent.window.location.href='login.aspx';</script>");
                Response.Write("<script>parent.window.location.href='../login.aspx';</script>");
                Response.End();
            }
        }
        catch
        {
            Response.Write("<script>parent.window.location.href='../login.aspx';</script>");
            Response.End();
        }
        if (!IsPostBack)
        {
            int id = -1;

            try
            {//检查是否删除信息
                id = Convert.ToInt32(Request["deleteid"].ToString());
            }
            catch
            {
                id = -1;
            }
            if (id > 0)
            {//删除一个信息
                if (grd_MIS.manager.DelData_OneLoanInfo(id))
                {
                    Response.Write("<script>alert('删除成功');</script>");
                }
                else
                {
                    Response.Write("<script>alert('删除失败，请与系统维护人员联系');</script>");
                }
            }
        }

    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        if (titletext.Text == "")
        {
            Response.Write("<script>alert('学号未填写');</script>");
            return;
 
        }
        int nom = -1;
        try
        {
            nom = Convert.ToInt32(nomey.Text);
        }
        catch
        {
            Response.Write("<script>alert('金额填写有误');</script>");
            return;
        }
        DateTime dt = DateTime.Now.Date;
        try
        {
            dt = Convert.ToDateTime(time.Text).Date;
        }
        catch
        { 
        }
        String[] number = titletext.Text.Split(',');
        int i = 0;
        while (i < number.Length)
        {
           if(!grd_MIS.manager.Add_OneLoanInfo(number[i], dt, remark.Text, nom))
            {
                Response.Write(number[i]);
                Response.Write("<script>alert('信息填写有误');</script>");
                return;
            }
            i++;
 
        }
        Response.Write("<script>alert('添加成功');</script>");
        titletext.Text = "";
        nomey.Text = "";
        remark.Text = "";


    }
    public void print()
    {
        time.Text = DateTime.Now.Date.ToShortDateString();
        //打印历史活动信息
        int pageid = 1;
        try
        {
            pageid = Convert.ToInt32(Request["pageid"].ToString());

        }
        catch
        {
            pageid = 1;

        }
        DataTable reader = grd_MIS.manager.GetData_LoanInfo();//接口调用
        //Response.Write(reader.DefaultView.Count.ToString()+","+reader.Rows.Count.ToString());
        
        int i = (pageid - 1) * 10;
        int j = i + 9;
        if (reader != null)
        {
            
         
            while (reader.Rows.Count > i && i <= j)
            {
                DataRow read = reader.Rows[i];
                Response.Write("<tr><td align=\"center\" class=\"mode5\" >");
                Response.Write(read["StuName"].ToString());
                Response.Write("</td><td align=\"center\" class=\"mode5\" >");
                Response.Write(Convert.ToDateTime(read["LoanData"]).ToShortDateString());
                Response.Write("</td><td align=\"center\" class=\"mode5\" >");
                Response.Write(read["LoanMoney"].ToString());
                Response.Write("</td><td align=\"center\" class=\"mode5\">");
                Response.Write("<a target=\"_blank\" href=\"add_m7.aspx?id=" + read["StuID"].ToString() + "\">		<font color=\"#000000\" style=\"font-size: 9pt\">查看学生信息</font></a>" + "</font>&nbsp&nbsp");
                Response.Write("<a target=\"_self\" onclick='{if(confirm(\"您确定删除吗?此操作将不能恢复!\")){return true;}return false;}' href=\"add_m7.aspx?deleteid=" + read["LoanID"].ToString() +"&pageid="+pageid.ToString()+ "\">		<font color=\"#000000\" style=\"font-size: 9pt\">删除</font></a>" + "</font>&nbsp&nbsp");
                Response.Write("</td></tr>\n");
                i++;

            }
            
            page_1.Text = "当前是第" + pageid.ToString() + "页";
            allpage = (reader.Rows.Count+9) / 10;
            page_all.Text = "共" + Convert.ToString(allpage) + "页";



        }
    }
    public void print1()
    {
        for (int i = 1; i <= allpage; i++)
        {
            Response.Write("<a href=add_m7.aspx?pageid=" + i.ToString() + ">" + i.ToString() + "</a>&nbsp\n");
        }
    }
       
    protected void Button1_Click1(object sender, EventArgs e)
    {
        int begin = Convert.ToInt32(DropDownList2.SelectedValue);
        int end = Convert.ToInt32(DropDownList1.SelectedValue);
        if (begin > end)
        {
            Response.Write("<script>alert('年份选择有误，请重新选择');</script>");
            return;
 
        }
        String tm = begin.ToString() +"-1-1";
        String td = end.ToString() + "-12-31";
        
        try
        {
            dg.DataSource = grd_MIS.manager.GetData_LoanInfo(Convert.ToDateTime(tm), Convert.ToDateTime(td));
            dg.DataBind();
            //dg.Columns.Add("tgh", typeof(int));
            comm.ToExcel(dg, "StundetLoanInfo");
        }
        catch
        {
            Response.Write("<script>alert('导出失败，请与管理员联系');</script>");
 
        }


    }
   
}