/// <summary>
/// 导入用户
/// </summary>
protected void BeginImport_Click(object sender, EventArgs e)
{
string path = "";
if (FileUpload1.PostedFile != null)
{
path = FileUpload1.PostedFile.FileName;
}
if (path == "")
{
lblImportResult.Text = "请选择导入文件！";
return;
}
if (!path.Contains(':') || !path.Contains('\\'))
{
lblImportResult.Text = "请设置您当前浏览器：工具-internet选项-安全-自定\n义级别-将文件上传到服务器是包含本地路径！";
return;
}
string hzm = path.Substring(path.LastIndexOf('.') + 1);
if (hzm != "xls" && hzm != "xlsx")
{
lblImportResult.Text = "本系统只支持excel文件格式导入，可以参考下面摸板！";
return;
}
TbUser user = null;
TbStudent stu = null;
DataSet ds = ExcelToDataSet(path);
foreach (DataTable table in ds.Tables)
{
foreach (DataRow row in table.Rows)
{
user = new TbUser();
user.Xh = row[3].ToString();
user.YhName = row[4].ToString();
user.YhPwd = System.Web.Security.FormsAuthentication.HashPasswordForStoringInConfigFile(row[5].ToString(), "MD5");
user.Zt = 3;
int userIdentity = TbUserManager.AddUser(user);
if (userIdentity > 0)
{
stu = new TbStudent();
stu.XsName = row[0].ToString();
stu.XsSex = row[1].ToString();
stu.YhID = userIdentity;
stu.BjName = row[2].ToString();
stu.Remark = "";
int stuIdentity = TbStudentManager.AddStudent(stu);
}
}
}
lblImportResult.Text = "导入成功！";
}
protected void ButtonOK_Click(object sender, EventArgs e)
{
TbUser User = new TbUser();
TbStudent Student = new TbStudent();
User.YhName = this.TextYh.Text;
User.Xh = this.textStudentID.Text;
User.Zt = 3;
Student.XsName = this.TextName.Text;
Student.BjName = this.BjName.Text;
if (this.RadButNan.Checked)
{
Student.XsSex = this.RadButNan.Value;
}
else
{
Student.XsSex = this.RadButNv.Value;
}
Student.Remark = this.textBz.Text;
if (this.HiddenYhID.Value == "")
{
this.BjName.Text = "请选择...";
User.YhPwd = System.Web.Security.FormsAuthentication.HashPasswordForStoringInConfigFile(this.TextMm.Text, "MD5");
TbUserManager.SeeUser(User);
Student.YhID = TbUserManager.AddUser(User);
TbStudentManager.AddStudent(Student);
Load_Student();
}
else
{
User.YhPwd = this.TextMm.Text.Trim();
User.YhID = int.Parse(this.HiddenYhID.Value);
Student.YhID = int.Parse(this.HiddenYhID.Value);
TbUserManager.SetUser(User);
TbStudentManager.SetStudent(Student);
this.HiddenYhID.Value = "";
}
this.textStudentID.Text = "";
this.TextYh.Text = "";
this.TextName.Text = "";
this.textBz.Text = "";
this.BjName.Text = "请选择...";
this.RadButNan.Checked = true;
Load_Student();
}
