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 (单位ComboBox.Text == "")
{
X.Msg.Alert("Status", "请填写参与人单位.").Show();
return;
}
if (起始日期DateField.Text == "")
{
X.Msg.Alert("Status", "请填写会议起始日期.").Show();
return;
}
if (结束日期DateField.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 (卷号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.CheckConf(发表论文TextField.Text) == 2)
{
SqlConnection mycon = db.MyCon;
mycon.Open();
SqlCommand mycmd = mycon.CreateCommand();
string sel = "insert into CInfo(CName,TNo,CPaperName,CDeptName,CBeginTime,CEndTime,CAcceptTime,CFundName,CPFirstName,CPSecondName,CPJuanNo,CCanJia,CPQiNo,CPYeNo,CPRank,CRemark,CType,CVType) Values('" + 会议名称TextField.Text + "','" + Session["TNo"].ToString() + "','" + 发表论文TextField.Text + "','" + 单位ComboBox.SelectedItem.Text + "','" + 起始日期DateField.Text + "','" + 结束日期DateField.Text + "','" + 接收日期DateField.Text + "','" + 基金TextField.Text + "','" + 第一作者TextField.Text + "','" + 第二作者TextField.Text + "'," + PJuanNo + ",'" + 参加人员TextField.Text + "'," + PQiNo + ",'" + 页码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();
}
}
