studentcredit.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_StudentCredit : System.Web.UI.Page
{
    LoginInfo My;
    protected void Page_Load(object sender, EventArgs e)
    {
        My = new LoginInfo(Session["LoginID"]);
        if (My.LoginID == 0) Response.Redirect("~/Signin.aspx");

        ClassCourse.ClassCourseChanged += new uctl_ClassCourse.ClassCourseChangedEventHander(ClassCourseChange);
        
        if (!IsPostBack)
        {
            string datenow = CommOp.ToStr(Session["CreditDate"]);
            if (datenow == "")
                Calendar1.SelectedDate = DateTime.Now;
            else
            {
                Calendar1.SelectedDate = Convert.ToDateTime(datenow);
           }
            txtStartTime.Text = Calendar1.SelectedDate.ToShortDateString();
            ddlType.SelectedIndex = 0;
            btnSave.Attributes.Add("onclick", "return saveChanged();");
            txtStartTime.Attributes.Add("onclick", "turnDatePicker();");
        }
    }

    private void savePreviousChange(string prevChg)
    {
        string [] attStatus = prevChg.Split(',');
        foreach (string att in attStatus)
        {
            string[] ats = att.Split('|');
            string sql = "";
            if (ats[2] == "") //如果分数为空
            {
                sql = "DELETE FROM J_Credit WHERE cr_ID = " + ats[0];
                DBExec.ExecNonQuery(sql);
            }
            else if (ats[0] == "0") //如果以前没有该分数,则新增记录
            {
                sql = "INSERT INTO J_Credit (cr_StCourse,cr_StartTime,cr_Type,cr_Score) "
                + "VALUES (" + ats[1] + ",'" + txtStartTime.Text + "'," + ats[3] + "," + ats[2] + ")";
                DBExec.ExecNonQuery(sql);
            }
            else //修改以前的分数
            {
                sql = "UPDATE J_Credit SET cr_StartTime='" + txtStartTime.Text + "',cr_Type=" + ats[3] + ", cr_Score=" + ats[2] + " WHERE cr_ID=" + ats[0] + " AND cr_StCourse=" + ats[1];
                DBExec.ExecNonQuery(sql);
            }
        }
    }

    private void ClassCourseChange()
    {
        string classname = "(无班级)";
        string coursename = "(所有课程)";
        if (ClassCourse.ClassName != "") classname = ClassCourse.ClassName;
        if (ClassCourse.CourseName != "") coursename = ClassCourse.CourseName;

        Path.Text = classname + " - " +  coursename;

        SqlDataSource3.SelectParameters.Clear();
        SqlDataSource3.SelectParameters.Add("de_ID", ClassCourse.ClassID.ToString());
        SqlDataSource3.SelectParameters.Add("co_ID", ClassCourse.CourseID.ToString());
        SqlDataSource3.SelectParameters.Add("ThisDate", txtStartTime.Text);
        SqlDataSource3.SelectParameters.Add("EmployeeID", My.LoginID.ToString());
        GridView1.DataBind();
    }

    protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
    {

        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            String[] TypeNameArr = new String[] {"平时", "期中", "期末", "结业", "补考" };
            int typecol = 7;
            int scorecol = 8;
            int lastcol = 9;
            int cr_ID = 0;
            int sc_ID = 0;
            int type = 0;
            string score = "";
            string typeStr = "";
            int index = e.Row.RowIndex;

            DataKey keys = GridView1.DataKeys[index];
            // keys[0] - 测验编号 [1]-班级-课程号  [2]=分数 [3]=测试分类

            if (keys[0] != DBNull.Value)
            {
                cr_ID = Convert.ToInt32(keys[0]);
            }

            if (keys[1] != DBNull.Value)
            {
                sc_ID = Convert.ToInt32(keys[1]);
            }

            if (keys[2] != DBNull.Value)
            {
                score = keys[2].ToString();
            }

            if (keys[3] !=DBNull.Value)
            {
                type = Convert.ToInt32(keys[3]);
                typeStr = TypeNameArr[type];
            }


            e.Row.Cells[typecol].Attributes.Add("onclick",
               "if (!scoreArr[" + index + "]) " +
                   "scoreArr[" + index + "] = new ScoreBox(" + cr_ID + "," + sc_ID + ",'" + score + "'," + type + "," + index + ",'" + ddlType.ClientID + "'); " +
                   "scoreArr[" + index + "].typeclick();");

            e.Row.Cells[typecol].Text = "<div id='type" + index + "' style='padding:3px;' class='att"+type+"'>"+typeStr+"</div>";

            e.Row.Cells[scorecol].Attributes.Add("onclick", 
                "if (!scoreArr[" + index + "]) " +
                    "scoreArr[" + index + "] = new ScoreBox(" + cr_ID + "," + sc_ID + ",'" + score + "',"+type+"," + index + ",'"+ ddlType.ClientID + "'); "+
                    "scoreArr[" + index + "].click();");

            e.Row.Cells[scorecol].Text = "<div id='showscore" + index + "' style='display:block'>"+score+"</div>" +
                "<input type=text size=6 style='width:40px;height:14px;display:none' " + 
                "name='inputscore" + index + "' id='inputscore" + index +
                "' onblur= 'scoreArr[" + index + "].blur()' value='" + score + "' />";

            e.Row.Cells[lastcol].Text = "<a href=\"javascript:opendialog(" + cr_ID + "," + sc_ID + ",'"+txtStartTime.ClientID+"','"+ddlType.ClientID+"')\">修改</a>";
        }
    }

    protected void btnSave_Click(object sender, EventArgs e)
    {
        savePreviousChange(Request.Form["ChangedInfo"]);
        GridView1.DataBind();
    }

    private void dayPicked()
    {
        txtStartTime.Text = Calendar1.SelectedDate.ToShortDateString();
        Session["CreditDate"] = Calendar1.SelectedDate;
        ClassCourse.ShowAndSave();
        ClassCourseChange();
    }

    protected void Calendar1_SelectionChanged(object sender, EventArgs e)
    {
        dayPicked();
    }

    protected void btnNextDay_Click(object sender, EventArgs e)
    {
        Calendar1.SelectedDate = Calendar1.SelectedDate.AddDays(1);
        dayPicked();
    }

    protected void btnPrevtDay_Click(object sender, EventArgs e)
    {
        Calendar1.SelectedDate = Calendar1.SelectedDate.AddDays(-1);
        dayPicked();
    }

    protected void SqlDataSource1_Selected(object sender, SqlDataSourceStatusEventArgs e)
    {
        lblCounter.Text = "(" + e.AffectedRows + "人)";
    }
}