protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Request.QueryString["stuid"] != null)
{
liCoures.Text = "修改学员信息";
Label1.Text = "修改学员信息";
int stuid = DataConverter.CLng(Request.QueryString["stuid"]);
M_Recruitment rinfo = rll.GetSelect(stuid);
this.txt_Studioname.Text = rinfo.Studioname.ToString();
this.txt_CradNo.Text = rinfo.CradNo;
this.txt_LogPassWord.Text = rinfo.LogPassWord;
this.txt_PriorUserName.Text = rinfo.PriorUserName;
this.txt_Remark.Text = rinfo.Remark;
this.txt_Addinfo.Text = rinfo.Addinfo;
this.txt_Tel.Text = rinfo.Tel;
this.EBtnSubmit.Text = "修改信息";
}
else
{
liCoures.Text = "添加学员信息";
int id = DataConverter.CLng(Request.QueryString["id"]);
HiddenField hiden = new HiddenField();
sid_Hid.Value = id.ToString();
this.txt_WriteTime.Text = DateTime.Now.ToString();
}
Call.SetBreadCrumb(Master, "<li>教育模块</li><li><a href='QuestionManage.aspx'>在线考试系统</a></li><li>培训资料库</li><li>" + liCoures.Text + "</li>");
}
}
protected void Button1_Click(object sender, EventArgs e)
{
if (ViewState["tableinfo"] != null)
{
StringBuilder sb = new StringBuilder();
StringWriter sw = new StringWriter(sb);
HtmlTextWriter htw = new HtmlTextWriter(sw);
Page page = new Page();
HtmlForm form = new HtmlForm();
string titles = "学员姓名,预设用户名,预设登录密码,联系电话,联系地址,身份证号码,登记时间,备注";
string[] usertit = titles.Split(',');
DataTable viewtable = (DataTable)ViewState["tableinfo"];
sb.Append(titles.Replace(",", "\t"));
sb.Append("\n");
for (int ii = 0; ii < viewtable.Rows.Count; ii++)
{
if (viewtable != null && viewtable.Rows.Count > 0)
{
int sssid = DataConverter.CLng(viewtable.Rows[0]["ssid"]);
M_Recruitment rinfo = rll.GetSelect(sssid);
sb.Append(rinfo.Studioname + "\t");
sb.Append(rinfo.PriorUserName + "\t");
sb.Append(rinfo.LogPassWord + "\t");
sb.Append(rinfo.Tel + "\t");
sb.Append(rinfo.Addinfo + "\t");
sb.Append(rinfo.CradNo + "\t");
sb.Append(rinfo.WriteTime + "\t");
sb.Append(rinfo.Remark + "\t");
}
sb.Append("\n");
}
Response.Clear();
Response.Buffer = true;
Response.ContentType = "application/vnd.ms-excel";
Response.AddHeader("Content-Disposition", "attachment;filename=Recruitment(" + DateTime.Now.ToString() + ").xls");
Response.Charset = "UTF-8";
Response.ContentEncoding = Encoding.Default;
Response.Write(sb.ToString());
Response.End();
}
}
private static M_Recruitment GetInfoFromReader(SqlDataReader rdr)
{
M_Recruitment info = new M_Recruitment();
info.id = DataConverter.CLng(rdr["id"].ToString());
info.Studioname = rdr["Studioname"].ToString();
info.PriorUserName = rdr["PriorUserName"].ToString();
info.LogPassWord = rdr["LogPassWord"].ToString();
info.TechID = DataConverter.CLng(rdr["TechID"].ToString());
info.CourseID = DataConverter.CLng(rdr["CourseID"].ToString());
info.ClassID = DataConverter.CLng(rdr["ClassID"].ToString());
info.Remark = rdr["Remark"].ToString();
info.Tel = rdr["Tel"].ToString();
info.Addinfo = rdr["Addinfo"].ToString();
info.CradNo = rdr["CradNo"].ToString();
info.WriteTime = DataConverter.CDate(rdr["WriteTime"].ToString());
info.AddTime = DataConverter.CDate(rdr["AddTime"].ToString());
info.EnrolllistID = DataConverter.CLng(rdr["EnrolllistID"].ToString());
rdr.Close();
rdr.Dispose();
return(info);
}
protected void EBtnSubmit_Click(object sender, EventArgs e)
{
if (Request.Form["stuid"] != null)
{
int stuid = DataConverter.CLng(Request.Form["stuid"]);
M_Recruitment rinfo = rll.GetSelect(stuid);
rinfo.Studioname = this.txt_Studioname.Text;
rinfo.CradNo = this.txt_CradNo.Text;
rinfo.LogPassWord = this.txt_LogPassWord.Text;
rinfo.PriorUserName = this.txt_PriorUserName.Text;
rinfo.Remark = this.txt_Remark.Text;
rinfo.Addinfo = this.txt_Addinfo.Text;
rinfo.Tel = this.txt_Tel.Text;
string sid = rinfo.EnrolllistID.ToString();
rll.GetUpdate(rinfo);
Page.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('修改成功!');location.href='StudioInfoListByTech.aspx?id=" + sid.ToString() + "';", true);
}
else
{
int sid = DataConverter.CLng(Request.Form["sid"]);
M_EnrollList llinfo = ell.GetSelect(sid);
M_Recruitment rinfo = new M_Recruitment();
rinfo.Studioname = this.txt_Studioname.Text;
rinfo.CradNo = this.txt_CradNo.Text;
rinfo.EnrolllistID = DataConverter.CLng(Request.Form["sid"]);
rinfo.LogPassWord = this.txt_LogPassWord.Text;
rinfo.PriorUserName = this.txt_PriorUserName.Text;
rinfo.Remark = this.txt_Remark.Text;
rinfo.Addinfo = this.txt_Addinfo.Text;
rinfo.TechID = llinfo.UesrID;
rinfo.Tel = this.txt_Tel.Text;
rinfo.WriteTime = this.txt_WriteTime.Text == "" ? DateTime.Now : DataConverter.CDate(this.txt_WriteTime.Text);
rinfo.AddTime = DateTime.Now;
rll.GetInsert(rinfo);
Page.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('添加成功!');location.href='StudioInfoListByTech.aspx?id=" + DataConverter.CLng(Request.Form["sid"]).ToString() + "';", true);
}
}
/// <summary>
///更新记录
/// </summary>
/// <param name="Recruitment"></param>
/// <returns></returns>
public bool GetUpdate(M_Recruitment model)
{
return(DBCenter.UpdateByID(model, model.ClassID));
}
/// <summary>
///添加记录
/// </summary>
/// <param name="Recruitment"></param>
/// <returns></returns>
public int GetInsert(M_Recruitment model)
{
return(DBCenter.Insert(model));
}
