protected void 保存Button_Click(object sender, EventArgs e)
{
if (Session["TNo"] == null)
{
X.Msg.Alert("Status", "保存出错1.").Show();
return;
}
if (题目TextField.Text == "")
{
X.Msg.Alert("Status", "请填写题目.").Show();
return;
}
if (期刊名TextField.Text == "")
{
X.Msg.Alert("Status", "请填写期刊名.").Show();
return;
}
if (第一作者TextField.Text == "")
{
X.Msg.Alert("Status", "请填写第一作者.").Show();
return;
}
if (接收日期DateField.Text == "")
{
X.Msg.Alert("Status", "请填写日期.").Show();
return;
}
if (基金TextField.Text == "")
{
X.Msg.Alert("Status", "请填写基金.").Show();
return;
}
if (单位ComboBox.Text == "")
{
X.Msg.Alert("Status", "请填写单位.").Show();
return;
}
if (级别ComboBox.Text == "")
{
X.Msg.Alert("Status", "请填写级别.").Show();
return;
}
if (卷号TextField.Text == "")
{
PJuanNo = 0;
}
else
{
int num = 0;
if (int.TryParse(卷号TextField.Text, System.Globalization.NumberStyles.Integer, null, out num))
{
PJuanNo = Convert.ToInt32(卷号TextField.Text);
}
else
{
X.Msg.Alert("Status", "卷号应为数字.").Show();
return;
}
}
if (期号TextField.Text == "")
{
PQiNo = 0;
}
else
{
int num = 0;
if (int.TryParse(期号TextField.Text, System.Globalization.NumberStyles.Integer, null, out num))
{
PQiNo = Convert.ToInt32(期号TextField.Text);
}
else
{
X.Msg.Alert("Status", "期号应为数字.").Show();
return;
}
}
DBHelp db = new DBHelp();
if (db.CheckPaper(题目TextField.Text)==2)
{
SqlConnection mycon = db.MyCon;
mycon.Open();
SqlCommand mycmd = mycon.CreateCommand();
string sel = "insert into PaperInfo(PName,TNo,PJName,PFirstName,PSecondName,PAcceptTime,PFundName,PJuanNo,PQiNo,PDeptName,PYeNo,PRank,PRemark,PType,PVType) Values('" + 题目TextField.Text + "','" + Session["TNo"].ToString() + "','" + 期刊名TextField.Text + "','" + 第一作者TextField.Text + "','" + 第二作者TextField.Text + "','" + 接收日期DateField.Text + "','" + 基金TextField.Text + "'," +PJuanNo + "," + PQiNo + ",'" + 单位ComboBox.SelectedItem.Text + "','" + 页码TextField.Text + "','" + 级别ComboBox.SelectedItem.Text + "','" + 备注TextArea.Text + "','" + 0 + "','"+0+"')";
mycmd.CommandText = sel;
mycmd.ExecuteNonQuery();
mycon.Close();
X.Msg.Alert("Status", "保存成功.").Show();
}
else
{
X.Msg.Alert("Status", "保存出错2.").Show();
}
}
