public int GetInsert(M_Exroom exroom) { string sqlStr = "INSERT INTO [dbo].[ZL_Exroom] ([RoomName],[Starttime],[Endtime],[ExaID],[AddTime],[Stuidlist]) VALUES (@RoomName,@Starttime,@Endtime,@ExaID,@AddTime,@Stuidlist);select @@IDENTITY"; SqlParameter[] cmdParams = exroom.GetParameters(exroom); return(SqlHelper.ObjectToInt32(SqlHelper.ExecuteScalar(CommandType.Text, sqlStr, cmdParams))); }
protected void EBtnSubmit_Click(object sender, EventArgs e) { M_Exroom roominfo = new M_Exroom(); if (Request.Form["hiden"] != null) { int roomid = DataConverter.CLng(Request.Form["hiden"]); roominfo = rll.GetSelect(roomid); } roominfo.AddTime = DateTime.Now; roominfo.Endtime = DataConverter.CDate(this.txt_Endtime.Text); roominfo.ExaID = DataConverter.CLng(Request.Form["pageid"]); roominfo.RoomName = this.txt_RoomName.Text; roominfo.Starttime = DataConverter.CDate(this.txt_Starttime.Text); roominfo.Stuidlist = this.Request.Form["txt_Stuidlist"]; if (Request.Form["hiden"] != null) { rll.GetUpdate(roominfo); function.WriteSuccessMsg("修改成功!", "ExamExroom.aspx"); } else { rll.GetInsert(roominfo); function.WriteSuccessMsg("添加成功!", "ExamExroom.aspx"); } }
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>"); } }
public int insert(M_Exroom model) { return(Sql.insert(strTableName, model.GetParameters(model), BLLCommon.GetParas(model), BLLCommon.GetFields(model))); }
public bool GetUpdate(M_Exroom model) { return(Sql.UpdateByIDs(strTableName, PK, model.ExrID.ToString(), BLLCommon.GetFieldAndPara(model), model.GetParameters(model))); }