/// <summary>
/// 保存
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSave_Click(object sender, EventArgs e)
{
#region 验证
if (string.IsNullOrEmpty(tbCode.Text.Trim()))
{
Common.JShelper.JSAlert(this.Page, "", "教师编号不能为空！");
tbCode.Focus();
}
else if (string.IsNullOrEmpty(tbName.Text.Trim()))
{
Common.JShelper.JSAlert(this.Page, "", "老师名称不能为空！");
tbName.Focus();
}
else if (string.IsNullOrEmpty(tbPassword.Text.Trim()))
{
Common.JShelper.JSAlert(this.Page,"","密码不能为空！");
tbPassword.Focus();
}
#endregion
else
{
LabMS.Model.Teacher MT = new LabMS.Model.Teacher();
MT.CardCode = tbkpCode.Text.Trim();
MT.ComeFrom = tbcs.Text.Trim();
MT.Dirthday = DateTime.Parse(tbcsrq.Text.Trim());
MT.Education = tbwhcd.Text.Trim();
MT.Email = tbEmail.Text.Trim();
MT.Fax = tbFax.Text.Trim();
MT.GDate = DateTime.Parse(tbbysj.Text.Trim());
MT.GSchool = tbbyxx.Text.Trim();
MT.Health = tbjkzk.Text.Trim();
MT.HomeAddress = tbhomeAdd.Text.Trim();
MT.Homephone = tbhomeTel.Text.Trim();
MT.Jobs = tbzw.Text.Trim();
MT.Marriage = tbhyzk.Text.Trim();
MT.Mobile = tbPhone.Text.Trim();
MT.Nation = tbmz.Text.Trim();
MT.OfficeAddress = tbOfficeAdd.Text.Trim();
MT.Political = tbzzmm.Text.Trim();
MT.Professional = tbjszc.Text.Trim();
MT.Province = tbPro.Text.Trim();
MT.SexCode = ddlSex.SelectedValue.ToString();
MT.Specially = tbzyjstc.Text.Trim();
MT.Teacher_Code = tbCode.Text.Trim();
MT.Teacher_Name = tbName.Text.Trim();
MT.Tel = tbOfficeTel.Text.Trim();
MT.WorkDate = DateTime.Parse(tbgzrq.Text.Trim());
MT.Password = tbPassword.Text.Trim();
LabMS.BLL.Teacher BT = new LabMS.BLL.Teacher();
int a = BT.Add(MT);
if (a > 0)
{
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "", "<script type='text/javascript'>alert('新增成功！');window.opener.location.href=window.opener.location.href;self.close();</script>");
}
}
}
/*
/// <summary>
/// ��ҳ��ȡ�����б�
/// </summary>
public DataSet GetList(int PageSize,int PageIndex,string strWhere)
{
SqlParameter[] parameters = {
new SqlParameter("@tblName", SqlDbType.VarChar, 255),
new SqlParameter("@fldName", SqlDbType.VarChar, 255),
new SqlParameter("@PageSize", SqlDbType.Int),
new SqlParameter("@PageIndex", SqlDbType.Int),
new SqlParameter("@IsReCount", SqlDbType.Bit),
new SqlParameter("@OrderType", SqlDbType.Bit),
new SqlParameter("@strWhere", SqlDbType.VarChar,1000),
};
parameters[0].Value = "Teacher";
parameters[1].Value = "ID";
parameters[2].Value = PageSize;
parameters[3].Value = PageIndex;
parameters[4].Value = 0;
parameters[5].Value = 0;
parameters[6].Value = strWhere;
return DbHelperSQL.RunProcedure("UP_GetRecordByPage",parameters,"ds");
}*/
/// <summary>
/// ��¼��֤
/// </summary>
/// <param name="strPeople"></param>
/// <param name="strPass"></param>
/// <returns></returns>
public override object ValidatePeople(string strPeople, string strPass)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select * from Teacher");
strSql.Append(" where Teacher_Name=@Teacher_Name and Password=@Password ");
SqlParameter[] parameters = {
new SqlParameter("@Teacher_Name", SqlDbType.VarChar,50),
new SqlParameter("@Password", SqlDbType.VarChar,50)};
parameters[0].Value = strPeople;
parameters[1].Value = strPass;
DataSet ds = new DataSet();
try
{
ds = DbHelperSQL.Query(strSql.ToString(), parameters);
}
catch
{
throw (new Exception("���ݿ���ʴ���!"));
}
LabMS.Model.Teacher model = new LabMS.Model.Teacher();
try
{
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["ID"].ToString() != "")
{
model.ID = int.Parse(ds.Tables[0].Rows[0]["ID"].ToString());
}
model.Teacher_Code = ds.Tables[0].Rows[0]["Teacher_Code"].ToString();
model.Teacher_Name = ds.Tables[0].Rows[0]["Teacher_Name"].ToString();
model.SexCode = ds.Tables[0].Rows[0]["SexCode"].ToString();
if (ds.Tables[0].Rows[0]["Dirthday"].ToString() != "")
{
model.Dirthday = DateTime.Parse(ds.Tables[0].Rows[0]["Dirthday"].ToString());
}
if (ds.Tables[0].Rows[0]["WorkDate"].ToString() != "")
{
model.WorkDate = DateTime.Parse(ds.Tables[0].Rows[0]["WorkDate"].ToString());
}
model.Professional = ds.Tables[0].Rows[0]["Professional"].ToString();
if (ds.Tables[0].Rows[0]["GDate"].ToString() != "")
{
model.GDate = DateTime.Parse(ds.Tables[0].Rows[0]["GDate"].ToString());
}
model.GSchool = ds.Tables[0].Rows[0]["GSchool"].ToString();
model.Specially = ds.Tables[0].Rows[0]["Specially"].ToString();
model.Education = ds.Tables[0].Rows[0]["Education"].ToString();
model.Jobs = ds.Tables[0].Rows[0]["Jobs"].ToString();
model.Nation = ds.Tables[0].Rows[0]["Nation"].ToString();
model.Province = ds.Tables[0].Rows[0]["Province"].ToString();
model.CardCode = ds.Tables[0].Rows[0]["CardCode"].ToString();
model.ComeFrom = ds.Tables[0].Rows[0]["ComeFrom"].ToString();
model.Political = ds.Tables[0].Rows[0]["Political"].ToString();
model.Health = ds.Tables[0].Rows[0]["Health"].ToString();
model.Marriage = ds.Tables[0].Rows[0]["Marriage"].ToString();
model.Tel = ds.Tables[0].Rows[0]["Tel"].ToString();
model.OfficeAddress = ds.Tables[0].Rows[0]["OfficeAddress"].ToString();
model.Homephone = ds.Tables[0].Rows[0]["Homephone"].ToString();
model.HomeAddress = ds.Tables[0].Rows[0]["HomeAddress"].ToString();
model.Mobile = ds.Tables[0].Rows[0]["Mobile"].ToString();
model.Email = ds.Tables[0].Rows[0]["Email"].ToString();
model.Fax = ds.Tables[0].Rows[0]["Fax"].ToString();
model.Password = ds.Tables[0].Rows[0]["Password"].ToString();
return model;
}
else
{
return null;
}
}
catch
{
throw (new Exception("datasetTOobjectת������!"));
}
}
/// <summary>
/// �õ�һ������ʵ��
/// </summary>
public LabMS.Model.Teacher GetModel(int ID)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select top 1 ID,Teacher_Code,Teacher_Name,SexCode,Dirthday,WorkDate,Professional,GDate,GSchool,Specially,Education,Jobs,Nation,Province,CardCode,ComeFrom,Political,Health,Marriage,Tel,OfficeAddress,Homephone,HomeAddress,Mobile,Email,Fax,Password from Teacher ");
strSql.Append(" where ID=@ID ");
SqlParameter[] parameters = {
new SqlParameter("@ID", SqlDbType.Int,4)};
parameters[0].Value = ID;
LabMS.Model.Teacher model=new LabMS.Model.Teacher();
DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters);
if(ds.Tables[0].Rows.Count>0)
{
if(ds.Tables[0].Rows[0]["ID"].ToString()!="")
{
model.ID=int.Parse(ds.Tables[0].Rows[0]["ID"].ToString());
}
model.Teacher_Code=ds.Tables[0].Rows[0]["Teacher_Code"].ToString();
model.Teacher_Name=ds.Tables[0].Rows[0]["Teacher_Name"].ToString();
model.SexCode=ds.Tables[0].Rows[0]["SexCode"].ToString();
if(ds.Tables[0].Rows[0]["Dirthday"].ToString()!="")
{
model.Dirthday=DateTime.Parse(ds.Tables[0].Rows[0]["Dirthday"].ToString());
}
if(ds.Tables[0].Rows[0]["WorkDate"].ToString()!="")
{
model.WorkDate=DateTime.Parse(ds.Tables[0].Rows[0]["WorkDate"].ToString());
}
model.Professional=ds.Tables[0].Rows[0]["Professional"].ToString();
if(ds.Tables[0].Rows[0]["GDate"].ToString()!="")
{
model.GDate=DateTime.Parse(ds.Tables[0].Rows[0]["GDate"].ToString());
}
model.GSchool=ds.Tables[0].Rows[0]["GSchool"].ToString();
model.Specially=ds.Tables[0].Rows[0]["Specially"].ToString();
model.Education=ds.Tables[0].Rows[0]["Education"].ToString();
model.Jobs=ds.Tables[0].Rows[0]["Jobs"].ToString();
model.Nation=ds.Tables[0].Rows[0]["Nation"].ToString();
model.Province=ds.Tables[0].Rows[0]["Province"].ToString();
model.CardCode=ds.Tables[0].Rows[0]["CardCode"].ToString();
model.ComeFrom=ds.Tables[0].Rows[0]["ComeFrom"].ToString();
model.Political=ds.Tables[0].Rows[0]["Political"].ToString();
model.Health=ds.Tables[0].Rows[0]["Health"].ToString();
model.Marriage=ds.Tables[0].Rows[0]["Marriage"].ToString();
model.Tel=ds.Tables[0].Rows[0]["Tel"].ToString();
model.OfficeAddress=ds.Tables[0].Rows[0]["OfficeAddress"].ToString();
model.Homephone=ds.Tables[0].Rows[0]["Homephone"].ToString();
model.HomeAddress=ds.Tables[0].Rows[0]["HomeAddress"].ToString();
model.Mobile=ds.Tables[0].Rows[0]["Mobile"].ToString();
model.Email=ds.Tables[0].Rows[0]["Email"].ToString();
model.Fax=ds.Tables[0].Rows[0]["Fax"].ToString();
model.Password = ds.Tables[0].Rows[0]["Password"].ToString();
return model;
}
else
{
return null;
}
}
/// <summary>
/// 保存
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSave_Click(object sender, EventArgs e)
{
#region 验证
if (string.IsNullOrEmpty(tbCode.Text.Trim()))
{
Common.JShelper.JSAlert(this.Page, "", "教师编号不能为空！");
tbCode.Focus();
}
else if (string.IsNullOrEmpty(tbName.Text.Trim()))
{
Common.JShelper.JSAlert(this.Page, "", "老师名称不能为空！");
tbName.Focus();
}
else if (string.IsNullOrEmpty(tbPassword.Text.Trim()))
{
Common.JShelper.JSAlert(this.Page, "", "密码不能为空！");
tbPassword.Focus();
}
#endregion
else
{
LabMS.Model.Teacher MT = new LabMS.Model.Teacher();
MT.CardCode = tbkpCode.Text.Trim();
MT.ComeFrom = tbcs.Text.Trim();
if (tbcsrq.Text.Trim() != "")
{
MT.Dirthday = DateTime.Parse(tbcsrq.Text.Trim());
}
MT.Education = tbwhcd.Text.Trim();
MT.Email = tbEmail.Text.Trim();
MT.Fax = tbFax.Text.Trim();
if (tbbysj.Text.Trim() != "")
{
MT.GDate = DateTime.Parse(tbbysj.Text.Trim());
}
MT.GSchool = tbbyxx.Text.Trim();
MT.Health = tbjkzk.Text.Trim();
MT.HomeAddress = tbhomeAdd.Text.Trim();
MT.Homephone = tbhomeTel.Text.Trim();
MT.Jobs = tbzw.Text.Trim();
MT.Marriage = tbhyzk.Text.Trim();
MT.Mobile = tbPhone.Text.Trim();
MT.Nation = tbmz.Text.Trim();
MT.OfficeAddress = tbOfficeAdd.Text.Trim();
MT.Political = tbzzmm.Text.Trim();
MT.Professional = tbjszc.Text.Trim();
MT.Province = tbPro.Text.Trim();
MT.SexCode = ddlSex.SelectedValue.ToString();
MT.Specially = tbzyjstc.Text.Trim();
MT.Teacher_Code = tbCode.Text.Trim();
MT.Teacher_Name = tbName.Text.Trim();
MT.Tel = tbOfficeTel.Text.Trim();
MT.Password = tbPassword.Text.Trim();
if (tbgzrq.Text.Trim() != "")
{
MT.WorkDate = DateTime.Parse(tbgzrq.Text.Trim());
}
MT.ID = int.Parse(Request.QueryString["ID"].ToString());
LabMS.BLL.Teacher BT = new LabMS.BLL.Teacher();
try
{
BT.Update(MT);
if (FlagHF.Value == "look")
{
Common.JShelper.JsAlertAndClose(Page, "", "修改成功！");
}
else
{
Common.JShelper.JSAlertAndRedirect(this.Page, "", "修改成功！", "BaseDataTeacherList.aspx");
}
}
catch
{
Common.JShelper.JSAlert(this.Page, "", "修改失败！");
}
}
}
protected void Save_OnClick(object sender, EventArgs e)
{
#region
if (String.IsNullOrEmpty(UserPasswordTBX.Text.Trim()))
{
Common.JShelper.JSAlert(Page, "script", "请输入旧密码!");
return;
}
if (UserPasswordTBX.Text.Length > 50)
{
Common.JShelper.JSAlert(Page, "script", "旧密码长度输入过长!");
return;
}
if (String.IsNullOrEmpty(NewPasswordTBX.Text.Trim()))
{
Common.JShelper.JSAlert(Page, "script", "请输入新密码密码!");
return;
}
if (NewPasswordTBX.Text.Length > 50)
{
Common.JShelper.JSAlert(Page, "script", "新密码长度输入过长!");
return;
}
if (!Regex.IsMatch(NewPasswordTBX.Text.Trim(), @"^\w+$"))
{
Common.JShelper.JSAlert(Page, "script", "新密码输入不合法(只能为数字、英文或下划线的组合)!");
return;
}
//if (String.IsNullOrEmpty(RePasswordTBX.Text.Trim()))
//{
// Common.JShelper.JSAlert(Page, "script", "请重复输入新密码!");
//}
//if (RePasswordTBX.Text.Length > 50)
//{
// Common.JShelper.JSAlert(Page, "script", "重复新密码长度输入过长!");
//}
//if (!Regex.IsMatch(RePasswordTBX.Text.Trim(), @"^\w+$"))
//{
// Common.JShelper.JSAlert(Page, "script", "重复新密码输入不合法(只能为数字、英文或下划线的组合)!");
//}
if (String.Compare(RePasswordTBX.Text, NewPasswordTBX.Text) != 0)
{
Common.JShelper.JSAlert(Page, "script", "两次新密码输入不一致!");
return;
}
//验证用户名和密码输入是否正确
if (!IsUserNameAndPassword())
{
Common.JShelper.JSAlert(Page, "script", "用户名和密码输入不匹配!");
return;
}
#endregion
if (!String.IsNullOrEmpty(UserID))
{
int ID;
if (int.TryParse(UserID, out ID))
{
if (UserType == "mana")
{
LabMS.BLL.UserTable userTable = new LabMS.BLL.UserTable();
LabMS.Model.UserTable userTableModel = new LabMS.Model.UserTable();
userTableModel = userTable.GetModel(ID);
userTableModel.Password = NewPasswordTBX.Text.Trim();
try
{
userTable.Update(userTableModel);
Common.JShelper.JsAlertAndClose(Page, "script", "密码修改成功！");
}
catch
{
Common.JShelper.JsAlertAndClose(Page, "script", "密码修改失败!");
}
}
else if (UserType == "teacher")
{
LabMS.BLL.Teacher userTable = new LabMS.BLL.Teacher();
LabMS.Model.Teacher userTableModel = new LabMS.Model.Teacher();
userTableModel = userTable.GetModel(ID);
userTableModel.Password = NewPasswordTBX.Text.Trim();
try
{
userTable.Update(userTableModel);
Common.JShelper.JsAlertAndClose(Page, "script", "密码修改成功！");
}
catch
{
Common.JShelper.JsAlertAndClose(Page, "script", "密码修改失败!");
}
}
else
{
LabMS.BLL.Student userTable = new LabMS.BLL.Student();
LabMS.Model.Student userTableModel = new LabMS.Model.Student();
userTableModel = userTable.GetModel(ID);
userTableModel.Student_Pass = NewPasswordTBX.Text.Trim();
try
{
userTable.Update(userTableModel);
Common.JShelper.JsAlertAndClose(Page, "script", "密码修改成功！");
}
catch
{
Common.JShelper.JsAlertAndClose(Page, "script", "密码修改失败!");
}
}
}
else
{
Common.JShelper.JsAlertAndClose(Page, "script", "用户ID存储不合法，请退出系统，重新登录后进行修改密码！");
}
}
else
{
Common.JShelper.JsAlertAndClose(Page, "script", "用户Session丢失，请退出系统，重新登录后进行修改密码！");
}
}
