|
Server : Microsoft-IIS/10.0 System : Windows NT EBS-6136 10.0 build 17763 (Windows Server 2016) i586 User : jxgj ( 0) PHP Version : 7.0.33 Disable Function : passthru,exec,system,shell_exec,proc_open,popen,pcntl_exec,socket_bind,stream_socket_server Directory : D:/tmp_aspnet/root/8346f1f3/9c1cfaad/ |
?#pragma checksum "D:\wwwroot\bujuan\wwwroot\UserManag\NewOneUser.aspx.cs" "{ff1816ec-aa5e-4d10-87f7-6f4963833460}" "6C75AAA3574B0FB244F72D40E2A30FB3EEBC754E"
#line 1 "D:\wwwroot\bujuan\wwwroot\UserManag\NewOneUser.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.IO;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Configuration;
namespace EasyExam.UserManag
{
/// <summary>
/// NewOneUser 的提要注明 。
/// </summary>
public partial class NewOneUser : System.Web.UI.Page
{
string myUserID="";
string myLoginID="";
PublicFunction ObjFun=new PublicFunction();
#region//************初始化信息*********
protected void Page_Load(object sender, System.EventArgs e)
{
try
{
myUserID=Session["UserID"].ToString();
myLoginID=Session["LoginID"].ToString();
}
catch
{
}
if (myLoginID=="")
{
Response.Redirect("../Login.aspx");
}
txtBirthday.Attributes["readonly"]="true";
if (!IsPostBack)
{
if (ObjFun.GetValues("select UserType from UserInfo where LoginID='"+myLoginID+"' and UserType=1 and (RoleMenu=1 or (RoleMenu=2 and Exists(select OptionID from UserPower where UserID=UserInfo.UserID and PowerID=3 and OptionID=2)))","UserType")!="1")
{
Response.Write("<script>alert('对不起，您没有此操作权限！')</script>");
Response.End();
}
else
{
ShowDeptInfo();//显示部门信息
ShowJobInfo();//显示职务信息
DDLDept.Items.FindByText("--请选择--").Selected=true;
DDLJob.Items.FindByText("--请选择--").Selected=true;
}
}
}
#endregion
#region//*********显示部门信息**********
private void ShowDeptInfo()
{
string strConn=ConfigurationSettings.AppSettings["strConn"];
SqlConnection SqlConn=new SqlConnection(strConn);
SqlDataAdapter SqlCmd=new SqlDataAdapter("select * from DeptInfo",SqlConn);
DataSet SqlDS=new DataSet();
SqlCmd.Fill(SqlDS,"DeptInfo");
DDLDept.DataSource=SqlDS.Tables["DeptInfo"].DefaultView;
DDLDept.DataTextField="DeptName";
DDLDept.DataValueField="DeptID";
DDLDept.DataBind();
SqlConn.Dispose();
ListItem strTmp=new ListItem("--请选择--","0");
DDLDept.Items.Add(strTmp);
}
#endregion
#region//*********显示职务信息**********
private void ShowJobInfo()
{
string strConn=ConfigurationSettings.AppSettings["strConn"];
SqlConnection SqlConn=new SqlConnection(strConn);
SqlDataAdapter SqlCmd=new SqlDataAdapter("select * from JobInfo",SqlConn);
DataSet SqlDS=new DataSet();
SqlCmd.Fill(SqlDS,"JobInfo");
DDLJob.DataSource=SqlDS.Tables["JobInfo"].DefaultView;
DDLJob.DataTextField="JobName";
DDLJob.DataValueField="JobID";
DDLJob.DataBind();
SqlConn.Dispose();
ListItem strTmp=new ListItem("--请选择--","0");
DDLJob.Items.Add(strTmp);
}
#endregion
#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 (txtLoginID.Text.Trim()=="")
{
this.RegisterStartupScript("newWindow","<script language='javascript'>alert('帐号不能为空！')</script>");
return;
}
if (txtNewUserPwd.Text.Trim()!=txtSureUserPwd.Text.Trim())
{
this.RegisterStartupScript("newWindow","<script language='javascript'>alert('两次密码不一致！')</script>");
return;
}
if (RBLUserSex.SelectedIndex<0)
{
this.RegisterStartupScript("newWindow","<script language='javascript'>alert('请选择帐户性别！')</script>");
return;
}
if (DDLUserType.SelectedItem.Text.Trim()=="")
{
this.RegisterStartupScript("newWindow","<script language='javascript'>alert('请选择帐户类型！')</script>");
return;
}
if ((myLoginID.Trim().ToUpper()!="ADMIN")&&(DDLUserType.SelectedItem.Value=="1"))
{
this.RegisterStartupScript("newWindow","<script language='javascript'>alert('治理帐户只能创建通常帐户！')</script>");
return;
}
if (DDLUserState.SelectedItem.Text.Trim()=="")
{
this.RegisterStartupScript("newWindow","<script language='javascript'>alert('请选择帐户状态！')</script>");
return;
}
string strTmp=ObjFun.GetValues("select LoginID from UserInfo where LoginID='"+ObjFun.getStr(ObjFun.CheckString(txtLoginID.Text.Trim()),20)+"'","LoginID");
if (strTmp.Trim()!="")
{
this.RegisterStartupScript("newWindow","<script language='javascript'>alert('此"+txtLoginID.Text.Trim()+"帐号已经存在，无法注册！')</script>");
return;
}
string strLoginID=ObjFun.getStr(ObjFun.CheckString(txtLoginID.Text.Trim()),20);
string strUserName=ObjFun.getStr(ObjFun.CheckString(txtUserName.Text.Trim()),20);
string strUserPwd=ObjFun.getStr(ObjFun.CheckString(txtNewUserPwd.Text.Trim()),20);
string strUserSex=RBLUserSex.SelectedItem.Text.Trim();
string strBirthday=txtBirthday.Text.Trim();
string strUserImg=UpUserPhoto.PostedFile.FileName;
string strDeptID=DDLDept.SelectedItem.Value;
string strJobID=DDLJob.SelectedItem.Value;
string strTelephone=ObjFun.getStr(ObjFun.CheckString(txtTelephone.Text.Trim()),20);
string strCertType=ObjFun.getStr(ObjFun.CheckString(txtCertType.Text.Trim()),20);
string strCertNum=ObjFun.getStr(ObjFun.CheckString(txtCertNum.Text.Trim()),20);
string strLoginIP=ObjFun.getStr(txtLoginIP.Text.Trim(),20);
int intUserType=Convert.ToInt32(DDLUserType.SelectedItem.Value);
int intUserState=Convert.ToInt32(DDLUserState.SelectedItem.Value);
int intJudgeUser=0;
int intJudgeTestType=0;
int intRoleMenu=0;
if (intUserType==1)
{
intJudgeUser=1;
intJudgeTestType=1;
intRoleMenu=1;
}
int intCreateUserID=Convert.ToInt32(myUserID);
DateTime dtmCreateDate=Convert.ToDateTime(System.DateTime.Now.ToString("d"));
byte[] imgBinaryData;
if (strUserImg.Trim()!="")
{
string strName=strUserImg.Substring(strUserImg.Length-4);
strTmp=".JPG.GIF";
if (strTmp.IndexOf(strName.ToUpper())<0)
{
this.RegisterStartupScript("newWindow","<script language='javascript'>alert('照片体式不正确！')</script>");
return;
}
Stream imgStream;
int imgLen;
imgStream=UpUserPhoto.PostedFile.InputStream;
imgLen=UpUserPhoto.PostedFile.ContentLength;
imgBinaryData=new byte[imgLen];
int n=imgStream.Read(imgBinaryData,0,imgLen);
}
else
{
imgBinaryData=new byte[0];
}
int NumRowsAffected=MyDatabaseMethod(strLoginID,strUserName,strUserPwd,strUserSex,strBirthday,strDeptID,strJobID,strTelephone,strCertType,strCertNum,strLoginIP,intUserType,intUserState,intJudgeUser,intJudgeTestType,intRoleMenu,intCreateUserID,dtmCreateDate,imgBinaryData);
if (NumRowsAffected>0)
{
this.RegisterStartupScript("newWindow","<script language='javascript'>alert('新建帐户成功！');try{ window.opener.RefreshForm() }catch(e){};</script>");
}
else
{
this.RegisterStartupScript("newWindow","<script language='javascript'>alert('新建帐户失败！')</script>");
}
txtLoginID.Text="";
txtUserName.Text="";
RBLUserSex.Items.FindByValue("女").Selected=false;
RBLUserSex.Items.FindByValue("男").Selected=true;
txtBirthday.Text="";
DDLDept.SelectedIndex=-1;
DDLJob.SelectedIndex=-1;
DDLDept.Items.FindByText("--请选择--").Selected=true;
DDLJob.Items.FindByText("--请选择--").Selected=true;
txtTelephone.Text="";
txtCertType.Text="";
txtCertNum.Text="";
txtLoginIP.Text="";
DDLUserType.SelectedIndex=-1;
DDLUserState.SelectedIndex=-1;
DDLUserType.Items.FindByValue("0").Selected=true;
DDLUserState.Items.FindByValue("1").Selected=true;
}
#endregion
#region//*********将数据更到数据库中*********
public int MyDatabaseMethod(string strLoginID,string strUserName,string strUserPwd,string strUserSex,string strBirthday,string strDeptID,string strJobID,string strTelephone,string strCertType,string strCertNum,string strLoginIP,int intUserType,int intUserState,int intJudgeUser,int intJudgeTestType,int intRoleMenu,int intCreateUserID,DateTime dtmCreateDate,byte[] imgbin)
{
string strConn="";
string strSql="";
PublicFunction ObjFun=new PublicFunction();
strConn=ConfigurationSettings.AppSettings["strConn"];
SqlConnection ObjConn = new SqlConnection(strConn);
strSql="Insert into UserInfo(LoginID,UserName,UserPwd,UserSex,Birthday,DeptID,JobID,Telephone,CertType,CertNum,LoginIP,UserType,UserState,JudgeUser,JudgeTestType,RoleMenu,CreateUserID,CreateDate,UserPhoto) Values (@TmpLoginID,@TmpUserName,@TmpUserPwd,@TmpUserSex,@TmpBirthday,@TmpDeptID,@TmpJobID,@TmpTelephone,@TmpCertType,@TmpCertNum,@TmpLoginIP,@TmpUserType,@TmpUserState,@TmpJudgeUser,@TmpJudgeTestType,@TmpRoleMenu,@TmpCreateUserID,@TmpCreateDate,@TmpUserPhoto)";
SqlCommand ObjCmd=new SqlCommand(strSql,ObjConn);
//帐号
SqlParameter ParamLoginID=new SqlParameter("@TmpLoginID",SqlDbType.VarChar,20);
ParamLoginID.Value = strLoginID;
ObjCmd.Parameters.Add(ParamLoginID);
//姓名
SqlParameter ParamUserName=new SqlParameter("@TmpUserName",SqlDbType.VarChar,20);
ParamUserName.Value = strUserName;
ObjCmd.Parameters.Add(ParamUserName);
//密码
SqlParameter ParamUserPwd=new SqlParameter("@TmpUserPwd",SqlDbType.VarChar,20);
ParamUserPwd.Value = strUserPwd;
ObjCmd.Parameters.Add(ParamUserPwd);
//性别
SqlParameter ParamUserSex=new SqlParameter("@TmpUserSex",SqlDbType.VarChar,2);
ParamUserSex.Value = strUserSex;
ObjCmd.Parameters.Add(ParamUserSex);
//诞生年月
if (strBirthday!="")
{
SqlParameter ParamBirthday=new SqlParameter("@TmpBirthday",SqlDbType.DateTime);
ParamBirthday.Value = Convert.ToDateTime(strBirthday);
ObjCmd.Parameters.Add(ParamBirthday);
}
else
{
SqlParameter ParamBirthday=new SqlParameter("@TmpBirthday",SqlDbType.DateTime);
ParamBirthday.Value = System.DBNull.Value;
ObjCmd.Parameters.Add(ParamBirthday);
}
//所属部门
SqlParameter ParamDeptID=new SqlParameter("@TmpDeptID",SqlDbType.Int);
ParamDeptID.Value = Convert.ToInt32(strDeptID);
ObjCmd.Parameters.Add(ParamDeptID);
//职务
SqlParameter ParamJobID=new SqlParameter("@TmpJobID",SqlDbType.Int);
ParamJobID.Value = Convert.ToInt32(strJobID);
ObjCmd.Parameters.Add(ParamJobID);
//电话
SqlParameter ParamTelephone=new SqlParameter("@TmpTelephone",SqlDbType.VarChar,20);
ParamTelephone.Value = strTelephone;
ObjCmd.Parameters.Add(ParamTelephone);
//证件类型
SqlParameter ParamCertType=new SqlParameter("@TmpCertType",SqlDbType.VarChar,20);
ParamCertType.Value = ObjFun.CheckString(strCertType);
ObjCmd.Parameters.Add(ParamCertType);
//证件号码
SqlParameter ParamCertNum=new SqlParameter("@TmpCertNum",SqlDbType.VarChar,20);
ParamCertNum.Value = strCertNum;
ObjCmd.Parameters.Add(ParamCertNum);
//登录IP
SqlParameter ParamLoginIP=new SqlParameter("@TmpLoginIP",SqlDbType.VarChar,20);
ParamLoginIP.Value = strLoginIP;
ObjCmd.Parameters.Add(ParamLoginIP);
//类型
SqlParameter ParamUserType=new SqlParameter("@TmpUserType",SqlDbType.Int);
ParamUserType.Value = Convert.ToInt32(intUserType);
ObjCmd.Parameters.Add(ParamUserType);
//状态
SqlParameter ParamUserState=new SqlParameter("@TmpUserState",SqlDbType.Int);
ParamUserState.Value = Convert.ToInt32(intUserState);
ObjCmd.Parameters.Add(ParamUserState);
//评卷帐号
SqlParameter ParamJudgeUser=new SqlParameter("@TmpJudgeUser",SqlDbType.Int);
ParamJudgeUser.Value = Convert.ToInt32(intJudgeUser);
ObjCmd.Parameters.Add(ParamJudgeUser);
//评卷题型
SqlParameter ParamJudgeTestType=new SqlParameter("@TmpJudgeTestType",SqlDbType.Int);
ParamJudgeTestType.Value = Convert.ToInt32(intJudgeTestType);
ObjCmd.Parameters.Add(ParamJudgeTestType);
//角色菜单
SqlParameter ParamRoleMenu=new SqlParameter("@TmpRoleMenu",SqlDbType.Int);
ParamRoleMenu.Value = Convert.ToInt32(intRoleMenu);
ObjCmd.Parameters.Add(ParamRoleMenu);
//创建帐号
SqlParameter ParamCreateUserID=new SqlParameter("@TmpCreateUserID",SqlDbType.Int);
ParamCreateUserID.Value = Convert.ToInt32(intCreateUserID);
ObjCmd.Parameters.Add(ParamCreateUserID);
//创建功夫
SqlParameter ParamCreateDate=new SqlParameter("@TmpCreateDate",SqlDbType.DateTime);
ParamCreateDate.Value = dtmCreateDate;
ObjCmd.Parameters.Add(ParamCreateDate);
if (imgbin.Length>0)
{
SqlParameter ParamUserPhoto=new SqlParameter("@TmpUserPhoto",SqlDbType.Image);
ParamUserPhoto.Value = imgbin;
ObjCmd.Parameters.Add(ParamUserPhoto);
}
else
{
SqlParameter ParamUserPhoto=new SqlParameter("@TmpUserPhoto",SqlDbType.Image);
ParamUserPhoto.Value = System.DBNull.Value;
ObjCmd.Parameters.Add(ParamUserPhoto);
}
ObjConn.Open();
int numRowsAffected=ObjCmd.ExecuteNonQuery();
ObjConn.Close();
ObjConn.Dispose();
return numRowsAffected;
}
#endregion
#region//*********检测帐号是否存在*********
protected void ButCheck_Click(object sender, System.EventArgs e)
{
string strTmp=ObjFun.GetValues("select LoginID from UserInfo where LoginID='"+ObjFun.getStr(ObjFun.CheckString(txtLoginID.Text.Trim()),20)+"'","LoginID");
if (strTmp.Trim()=="")
{
this.RegisterStartupScript("newWindow","<script language='javascript'>alert('此"+txtLoginID.Text.Trim()+"帐号不存在，能够注册！')</script>");
}
else
{
this.RegisterStartupScript("newWindow","<script language='javascript'>alert('此"+txtLoginID.Text.Trim()+"帐号已经存在，不能注册！')</script>");
}
}
#endregion
}
}
#line default
#line hidden