918博天堂

?#pragma checksum "D:\wwwroot\bujuan\wwwroot\SystemSet\NewMoreSubject.aspx.cs" "{ff1816ec-aa5e-4d10-87f7-6f4963833460}" "977AE03C30AA209BA01F3AC0C1BF7AAE6938216A"

#line 1 "D:\wwwroot\bujuan\wwwroot\SystemSet\NewMoreSubject.aspx.cs"
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Configuration;

namespace EasyExam.SystemSet
{
	/// <summary>
	/// NewMoreSubject 的提要注明。
	/// </summary>
	public partial class NewMoreSubject : System.Web.UI.Page
	{

		string myLoginID="";
		PublicFunction ObjFun=new PublicFunction();

		protected void Page_Load(object sender, System.EventArgs e)
		{
			try
			{
				myLoginID=Session["LoginID"].ToString();
			}
			catch
			{
			}
			if (myLoginID=="")
			{
				Response.Redirect("../Login.aspx");
			}
			if (ObjFun.GetValues("select UserType from UserInfo where LoginID='"+myLoginID+"' and LoginID='Admin'","UserType")!="1")
			{
				Response.Write("<script>alert('对不起，您没有此操作权限！')</script>");
				Response.End();
			}
		}

		#region Web 窗体设计器天生的代码
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 该挪用是 ASP.NET Web 窗体设计器所必须的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的步骤 - 不要使用代码编纂器批改
		/// 此步骤的内容。
		/// </summary>
		private void InitializeComponent()
		{    

		}
		#endregion

		#region//*******批量增长科目*********
		protected void ButInput_Click(object sender, System.EventArgs e)
		{
			if(txtSubjectName.Text.Trim()=="")
			{
				this.RegisterStartupScript("newWindow","<script language='javascript'>alert('科目名称不能为空！')</script>");
				return;
			}
			string strTmpSubject=txtSubjectName.Text;

			string[] strArrSubject= strTmpSubject.Split(',');

			for(long i=0;i<strArrSubject.Length;i++)
			{
				if (strArrSubject[i].Trim()!="")
				{
					string strTmp=ObjFun.GetValues("select SubjectName from SubjectInfo where SubjectName='"+ObjFun.getStr(ObjFun.CheckString(strArrSubject[i].Trim()),20)+"'","SubjectName");
					if (strTmp.Trim()!="")
					{
						this.RegisterStartupScript("newWindow","<script language='javascript'>alert('"+strTmp+"科目已经存在！')</script>");
						return;
					}
				}
			}
			string strConn=ConfigurationSettings.AppSettings["strConn"];
			SqlConnection ObjConn = new SqlConnection(strConn);
			ObjConn.Open();
			SqlTransaction ObjTran=ObjConn.BeginTransaction();
			SqlCommand ObjCmd=new SqlCommand();
			ObjCmd.Transaction=ObjTran;
			ObjCmd.Connection=ObjConn;
			try
			{
				for(long i=0;i<strArrSubject.Length;i++)
				{
					if(strArrSubject[i].Trim()!="")
					{
						ObjCmd.CommandText="insert into SubjectInfo(SubjectName) values('"+ObjFun.getStr(ObjFun.CheckString(strArrSubject[i].Trim()),20)+"')";
						ObjCmd.ExecuteNonQuery();
					}
				}
				ObjTran.Commit();
				this.RegisterStartupScript("newWindow","<script language='javascript'>alert('批量新建科目成功！');try{ window.opener.RefreshForm() }catch(e){};</script>");
			}
			catch
			{
				ObjTran.Rollback();
				this.RegisterStartupScript("newWindow","<script language='javascript'>alert('批量新建科目失败！')</script>");
			}
			finally
			{
				ObjConn.Close();
				ObjConn.Dispose();
			}
			txtSubjectName.Text="";

			return;
		}
		#endregion

	}
}


#line default
#line hidden