studentcreditin.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_StudentCreditIn : System.Web.UI.Page
{
    static int cr_ID = 0;
    static int sc_ID = 0;
    static int de_ID = 0;
    static int co_ID = 0;
    static int cr_Time = 0;
    decimal cr_Score = 0;
    string cr_StartTime;
    string cr_Description;
    int cr_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;
        if (!IsPostBack)
        {
            cr_ID = CommOp.ToInt(Request.QueryString["cr_ID"]);
            if (cr_ID != 0)
            {
                sql = "SELECT * FROM v_StCredit WHERE cr_ID=" + cr_ID;
                //读取数据库中的记录填充表单
                DataTable dt = DBExec.ExecDataTable(sql);
                if (dt.Rows.Count > 0)
                {
                    fillWithFullData(dt.Rows[0]);
                }
            }
            else
            {
                sc_ID = CommOp.ToInt(Request.QueryString["sc_ID"]);
               
                cr_ID = 0;
                sql = "SELECT * FROM v_StCredit 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["cr_StartTime"]);
        txtTime.Text = CommOp.ToStr(dr["cr_Time"]);
        txtDescription.Text = CommOp.ToStr(dr["cr_Description"]);
        ddlType.Text = CommOp.ToStr(dr["cr_Type"]);
        lblTitle.Text = "修改成绩记录";
        sc_ID = CommOp.ToInt(dr["cr_StCourse"]);
        de_ID = CommOp.ToInt(dr["ID"]);
        co_ID = CommOp.ToInt(dr["co_ID"]);
        txtScore.Text = CommOp.ToStr(dr["cr_Score"]);
    }

    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 = "90";
        txtDescription.Text = "";
        txtScore.Text = "";
        ddlType.Text = CommOp.ToStr(Request.QueryString["t"]);
        lblTitle.Text = "新增成绩记录";
        de_ID = CommOp.ToInt(dr["ID"]);
        co_ID = CommOp.ToInt(dr["co_ID"]);
    }

    protected void btnOK_Click(object sender, EventArgs e)
    {
     
        if (txtScore.Text.Trim() != "")
        {
            cr_StartTime = txtStartTime.Text;
            cr_Time = CommOp.ToInt(txtTime.Text);
            cr_Description = Server.HtmlEncode(txtDescription.Text.Trim());
            cr_Type = CommOp.ToInt(ddlType.Text);
            cr_Score = Convert.ToDecimal(txtScore.Text);
            if (cr_ID > 0)
            {
                String sql = "UPDATE J_Credit SET cr_StartTime='"+cr_StartTime+"',cr_Time="+cr_Time+", cr_type="+cr_Type+", cr_Description='"+cr_Description+"',cr_Score="+cr_Score+" WHERE cr_ID="+cr_ID + " AND cr_StCourse="+sc_ID;
                DBExec.ExecNonQuery(sql);
                lblMessageResult.Text = "修改成绩记录成功！";
            }
            else if (sc_ID > 0)
            {
                string sql = "INSERT INTO J_Credit (cr_StCourse,cr_StartTime,cr_Time,cr_Type,cr_Description,cr_Score) "
                + "VALUES (" + sc_ID + ",'" + cr_StartTime + "'," + cr_Time + "," + cr_Type + ",'" + cr_Description + "',"+cr_Score+")";
                DBExec.ExecNonQuery(sql);
                cr_ID = DBExec.ExecGetInt("SELECT IDENT_CURRENT('J_Credit')");
                lblMessageResult.Text = "新增成绩记录成功！";
                //Response.Redirect(Request.Path + "?cr_ID=" + id + "&sc_ID=" + sc_ID, false);
                
            }
            else
            {
                lblMessageResult.Text = "差参数!";
            }
        }
        else
        {
            string sql = "DELETE FROM J_Credit WHERE cr_ID=" + cr_ID;
            DBExec.ExecNonQuery(sql);
            lblMessageResult.Text = "删除了此成绩记录！";
            cr_ID = 0;
        }
        Label1.Text = "<script> window.opener.location = window.opener.location; </script>";
    }
}