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)));
}
