studentattendin.aspx.cs

asp.net 2.0的教务管理软件源码

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;

public partial class Personal_StudentAttendIn : System.Web.UI.Page
{
    static int at_ID = 0;
    static int sc_ID = 0;
    static int de_ID = 0;
    static int co_ID = 0;
    string at_StartTime;
    int at_Time=0;
    string at_Description;
    int at_Type = 0;
    LoginInfo My;
    protected void Page_Load(object sender, EventArgs e)
    {
        My = new LoginInfo(Session["LoginID"]);
        if (My.LoginID == 0) Response.End();
        String sql;
        at_ID = CommOp.ToInt(Request.QueryString["at_ID"]);
        sc_ID = CommOp.ToInt(Request.QueryString["sc_ID"]);
        if (!IsPostBack)
        {
            if (at_ID != 0)
            {
                sql = "SELECT * FROM v_StAttend WHERE at_ID=" + at_ID;
                //读取数据库中的记录填充表单
                DataTable dt = DBExec.ExecDataTable(sql);
                if (dt.Rows.Count > 0)
                {
                    fillWithFullData(dt.Rows[0]);
                }
            }
            else
            {
                sql = "SELECT * FROM v_StAttend WHERE sc_ID=" + sc_ID;
                DataTable dt = DBExec.ExecDataTable(sql);
                if (dt.Rows.Count > 0)
                {
                    fillWithPartData(dt.Rows[0]);
                }
            }
        }
    }

    private void fillWithFullData(DataRow dr)
    {
        lblName.Text = CommOp.ToStr(dr["pe_Name"]);
        lblClass.Text = CommOp.ToStr(dr["部门名称"]);
        txtStartTime.Text = CommOp.ToDateStr(dr["at_StartTime"]);
        txtTime.Text = CommOp.ToStr(dr["at_Time"]);
        txtDescription.Text =CommOp.ToStr(dr["at_Description"]);
        ddlType.Text = CommOp.ToStr(dr["at_Type"]);
        lblTitle.Text = "修改考勤记录";
        sc_ID = CommOp.ToInt(dr["at_StCourse"]);
        de_ID = CommOp.ToInt(dr["ID"]);
        co_ID = CommOp.ToInt(dr["co_ID"]);
    }

    private void fillWithPartData(DataRow dr)
    {
        lblName.Text = CommOp.ToStr(dr["pe_Name"]);
        lblClass.Text = CommOp.ToStr(dr["部门名称"]);
        txtStartTime.Text = CommOp.ToStr(Request.QueryString["d"]);
        txtTime.Text = CommOp.ToStr(Request.QueryString["t"]);
        txtDescription.Text = "";
        ddlType.Text = "0";
        lblTitle.Text = "新增考勤记录";
        de_ID = CommOp.ToInt(dr["ID"]);
        co_ID = CommOp.ToInt(dr["co_ID"]);
    }

    protected void btnOK_Click(object sender, EventArgs e)
    {
        at_StartTime = CommOp.ToDateStr(txtStartTime.Text);
        at_Time = CommOp.ToInt(txtTime.Text);
     
        at_Description = Server.HtmlEncode(txtDescription.Text.Trim());
        at_Type = CommOp.ToInt(ddlType.Text);

        if (at_Type != 0)
        {
            if (at_ID > 0)
            {
                String sql = "UPDATE J_Attend SET at_StartTime='"+at_StartTime+"',at_Time="+at_Time+", at_type="+at_Type+", at_Description='"+at_Description+"' WHERE at_ID="+at_ID + " AND at_StCourse="+sc_ID;
                DBExec.ExecNonQuery(sql);
                lblMessageResult.Text = "修改考勤记录成功！";
            }
            else if (sc_ID > 0)
            {
                string sql = "INSERT INTO J_Attend (at_StCourse,at_StartTime,at_Time,at_Type,at_Description) "
                + "VALUES (" + sc_ID + ",'" + at_StartTime + "'," + at_Time + "," + at_Type + ",'" + at_Description + "')";
                DBExec.ExecNonQuery(sql);
                at_ID = DBExec.ExecGetInt("SELECT IDENT_CURRENT('J_Attend')");
                lblMessageResult.Text = "新增考勤记录成功！";
                //Response.Redirect(Request.Path + "?at_ID=" + id + "&sc_ID=" + sc_ID, false);
                
            }
            else
            {
                lblMessageResult.Text = "差参数!";
            }
        }
        else
        {
            string sql = "DELETE FROM J_Attend WHERE at_ID=" + at_ID;
            DBExec.ExecNonQuery(sql);
            lblMessageResult.Text = "删除了此考勤记录！";
            at_ID = 0;
        }
        Label1.Text = "<script> window.opener.location = window.opener.location; </script>";
    }
}