Admin/RoomOnDutyAdd.aspx.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

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 LaboratoryOrder.DataBase;
using System.Data.SqlClient;

namespace LaboratoryOrder.Admin
{
    public partial class RoomOnDutyAdd : System.Web.UI.Page
    {
        protected DataTable termTable,adminTable;
        protected void Page_Load(object sender, EventArgs e)
        {
            if (Request.Form["s1"] != null)
            {
                string term = Request.Form["term"].ToString();
                string weekDes = Request.Form["weekDes"].ToString();
                string monday = Request.Form["monday"].ToString();
                string tuesday = Request.Form["tuesday"].ToString();
                string wednesday = Request.Form["wednesday"].ToString();
                string thursday = Request.Form["thursday"].ToString();
                string friday = Request.Form["friday"].ToString();
                string saturday = Request.Form["saturday"].ToString();
                string sunday = Request.Form["sunday"].ToString();

                SqlParameter[] para = new SqlParameter[10];
                para[0] = SqlBase.CreateParam("@term", SqlDbType.VarChar, 12, ParameterDirection.Input, term);
                para[1] = SqlBase.CreateParam("@weekDes", SqlDbType.VarChar, 10, ParameterDirection.Input, weekDes);
                para[2] = SqlBase.CreateParam("@scheduler", SqlDbType.VarChar, 16, ParameterDirection.Input, Common.CurrentUser.CurUserInfo.AdminName);
                para[3] = SqlBase.CreateParam("@monday", SqlDbType.VarChar, 16, ParameterDirection.Input, monday);
                para[4] = SqlBase.CreateParam("@tuesday", SqlDbType.VarChar, 16, ParameterDirection.Input, tuesday);
                para[5] = SqlBase.CreateParam("@wednesday", SqlDbType.VarChar, 16, ParameterDirection.Input, wednesday);
                para[6] = SqlBase.CreateParam("@thursday", SqlDbType.VarChar, 16, ParameterDirection.Input, thursday);
                para[7] = SqlBase.CreateParam("@friday", SqlDbType.VarChar, 16, ParameterDirection.Input, friday);
                para[8] = SqlBase.CreateParam("@saturday", SqlDbType.VarChar, 16, ParameterDirection.Input, saturday);
                para[9] = SqlBase.CreateParam("@sunday", SqlDbType.VarChar, 16, ParameterDirection.Input, sunday);
                
                try
                {
                    SqlBase.ExecuteQuery("insert into RoomOnDuty(term,weekDes,scheduler,infodate,Monday,Tuesday,Wednesday,Thursday,Friday,Saturday,Sunday) select @term,@weekDes,@scheduler,convert(varchar(10),getdate(),120),@Monday,@Tuesday,@Wednesday,@Thursday,@Friday,@Saturday,@Sunday", para, CommandType.Text);
                    Response.Redirect("RoomOnDutyManage.aspx");
                }
                catch(Exception err)
                {
                    Response.Write(err.Message);
                    Response.End();
                }
            }

            termTable = SqlBase.ExecuteDataTable("select * from param where paramname = 'term'", CommandType.Text);
            adminTable = SqlBase.ExecuteDataTable("select * from LabUsers order by adminName", CommandType.Text);
        }
    }