protected void Button3_Click(object sender, EventArgs e) { string reutrntxt = ""; if (Request.Form["item"] != null && Request.Form["item"] != "") { string item = Request.Form["item"]; if (item.IndexOf(',') > -1) { string[] itemarr = item.Split(','); for (int i = 0; i < itemarr.Length; i++) { //csll.DeleteByGroupID(DataConverter.CLng(i)); M_ExStudent sinfos = csll.GetSelect(DataConverter.CLng(i)); string stuname = sinfos.Stuname; string stuid = sinfos.Stuid.ToString(); reutrntxt = reutrntxt + stuid + "|" + stuname; if (i < itemarr.Length - 1) { reutrntxt = reutrntxt + "||"; } } } else { M_ExStudent sinfos = csll.GetSelect(DataConverter.CLng(item)); string stuname = sinfos.Stuname; string stuid = sinfos.Stuid.ToString(); reutrntxt = stuid + "|" + stuname; } } Page.ClientScript.RegisterStartupScript(this.GetType(), "script", "<script>clickext('" + reutrntxt + "');</script>"); //Response.Write("<script>clickext();</script>");//parent.addstudio('" + reutrntxt + "'); }
public int GetInsert(M_ExStudent exStudent) { string sqlStr = "INSERT INTO [dbo].[ZL_ExStudent] ([Stuname],[Stupassword],[Stucardno],[Userid],[Exptime],[Lognum],[Examnum],[Logtimeout],[Stugroup],[Regulation],[strCompetence],[Course],[Qualified],[Addtime]) VALUES (@Stuname,@Stupassword,@Stucardno,@Userid,@Exptime,@Lognum,@Examnum,@Logtimeout,@Stugroup,@Regulation,@strCompetence,@Course,@Qualified,@Addtime);select @@IDENTITY"; SqlParameter[] cmdParams = initmod.GetParameters(exStudent); return(SqlHelper.ObjectToInt32(SqlHelper.ExecuteScalar(CommandType.Text, sqlStr, cmdParams))); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Request.QueryString["cid"] != null) { string cid = Request.QueryString["cid"]; M_Exroom rinfo = rll.GetSelect(DataConverter.CLng(cid)); this.Label1.Text = "修改考场"; this.Literal1.Text = "修改考场"; this.EBtnSubmit.Text = "修改考场"; hiden_Hid.Value = cid; this.txt_RoomName.Text = rinfo.RoomName; this.txt_Starttime.Text = rinfo.Starttime.ToString(); this.txt_AddTime.Text = rinfo.AddTime.ToString(); this.txt_Endtime.Text = rinfo.Endtime.ToString(); if (rinfo.Stuidlist != null && rinfo.Stuidlist != "") { if (rinfo.Stuidlist.IndexOf(',') > -1) { string[] studarr = rinfo.Stuidlist.Split(','); for (int i = 0; i < studarr.Length; i++) { int sid = DataConverter.CLng(studarr[i]); if (sid > 0) { M_ExStudent sinfo = sll.GetSelect(sid); ListItem itemlis = new ListItem(); itemlis.Text = sinfo.Stuname.ToString(); itemlis.Value = sinfo.Stuid.ToString(); itemlis.Selected = true; this.txt_Stuidlist.Items.Add(itemlis); } } } else { int sid = DataConverter.CLng(rinfo.Stuidlist); if (sid > 0) { M_ExStudent sinfo = sll.GetSelect(sid); ListItem itemlis = new ListItem(); itemlis.Text = sinfo.Stuname.ToString(); itemlis.Value = sinfo.Stuid.ToString(); itemlis.Selected = true; this.txt_Stuidlist.Items.Add(itemlis); } } } } else { this.txt_AddTime.Text = DateTime.Now.ToString(); } Call.SetBreadCrumb(Master, "<li>教育模块</li><li><a href='QuestionManage.aspx'>在线考试系统</a></li><li>" + Literal1.Text + "</li>"); } }
protected void Page_Load(object sender, EventArgs e) { if (Request.QueryString["id"] != null) { int sid = DataConverter.CLng(Request.QueryString["id"]); M_ExStudent stinfo = sll.GetSelect(sid); this.txt_Stuname.Text = stinfo.Stuname; this.txt_Stupassword.Text = stinfo.Stupassword; this.txt_Addtime.Text = stinfo.Addtime.ToString(); //this.txt_Qualified.Text = stinfo.Qualified.ToString(); this.txt_Regulation.Text = stinfo.Regulation.ToString(); this.txt_Stucardno.Text = stinfo.Stucardno.ToString(); this.txt_Stugroup.Text = stinfo.Stugroup.ToString(); this.txt_Exptime.Text = stinfo.Exptime.ToString(); this.txt_Course.Text = stinfo.Course; } else { this.txt_Addtime.Text = DateTime.Now.ToString(); } Call.SetBreadCrumb(Master, "<li>教育模块</li><li><a href='QuestionManage.aspx'>在线考试系统</a></li><li>学员管理</li><li>" + Label2.Text + "</li>"); }
public int insert(M_ExStudent model) { return(Sql.insert(strTableName, model.GetParameters(model), model.GetParas(), model.GetFields())); }
public bool GetUpdate(M_ExStudent model) { return(Sql.UpdateByIDs(strTableName, PK, model.Stuid.ToString(), model.GetFieldAndPara(), model.GetParameters(model))); }