protected void OnSaveInfoClick(object sender, EventArgs e)
{
string _content = tbcontent.Text;
if (string.IsNullOrEmpty(_content))
{
return;
}
string _sql = "insert into 题目内容(类型,题目,答案) values('{0}','{1}','{2}')";
_sql = string.Format(_sql, lbtype.SelectedValue, _content, tbsave.Text);
int _index = SchoolData.ExecNonQuery(_sql);
if (_index > 0)
{
tbsave.Text = "";
tbcontent.Text = "";
}
else
{
return;
}
_sql = "select * from 题目内容 order by id desc";
DataTable _dt = SchoolData.Query(_sql);
GridView1.DataSource = _dt;
GridView1.DataBind();
}
protected void OnSaveBactInfoClick(object sender, EventArgs e)
{
string _val = tbcontent.Text;
string[] _vals = _val.Split(new string[] { ";" }, StringSplitOptions.None);
foreach (string _v in _vals)
{
string _sql = _v.Replace("\n", "");
if (string.IsNullOrEmpty(_sql))
{
continue;
}
int _index = SchoolData.ExecNonQuery(_sql);
if (_index != 1)
{
tbsave.Text = "错误" + _v;
return;
}
}
tbsave.Text = "成功";
}
