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);
}
protected void ButInput_Click(object sender, System.EventArgs e)
{
if (txtLoginID.Text.Trim() == "")
{
this.RegisterStartupScript("newWindow", "<script language='javascript'>alert('帐号不能为空！')</script>");
txtLoginID.Focus();
return;
}
if (string.IsNullOrEmpty(txtUserName.Text.Trim()))
{
this.RegisterStartupScript("newWindow", "<script language='javascript'>alert('请填写用户名！')</script>");
txtUserName.Focus();
return;
}
if (string.IsNullOrEmpty(txtNewUserPwd.Text.Trim()))
{
this.RegisterStartupScript("newWindow", "<script language='javascript'>alert('请填写密码！')</script>");
txtNewUserPwd.Focus();
return;
}
if (txtNewUserPwd.Text.Trim() != txtSureUserPwd.Text.Trim())
{
this.RegisterStartupScript("newWindow", "<script language='javascript'>alert('两次密码不一致！')</script>");
txtNewUserPwd.Focus();
return;
}
if (RBLUserSex.SelectedIndex < 0)
{
this.RegisterStartupScript("newWindow", "<script language='javascript'>alert('请选择帐户性别！')</script>");
RBLUserSex.Focus();
return;
}
if (DDLDept.SelectedItem.Text == "--请选择--")
{
this.RegisterStartupScript("newWindow", "<script language='javascript'>alert('请选择部门！')</script>");
DDLDept.Focus();
return;
}
if (string.IsNullOrEmpty(txtCertNum.Text.Trim()))
{
this.RegisterStartupScript("newWindow", "<script language='javascript'>alert('请填写身份证号码！')</script>");
txtCertNum.Focus();
return;
}
if (DDLUserType.SelectedItem.Text.Trim() == "")
{
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(ObjFun.GetValues("select UserID from UserInfo where LoginID='Admin'", "UserID"));
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)
{
if (intUserState == 0)
{
this.RegisterStartupScript("newWindow", "<script language='javascript'>alert('帐户注册成功，帐号审核后生效！');window.close();</script>");
}
else
{
this.RegisterStartupScript("newWindow", "<script language='javascript'>alert('帐户注册成功，帐号已经生效！');window.close();</script>");
}
}
else
{
this.RegisterStartupScript("newWindow", "<script language='javascript'>alert('帐户注册失败！')</script>");
}
}
