protected void 保存Button_Click(object sender, EventArgs e)
{
if (名称TextField.Text == "")
{
X.Msg.Alert("Status", "请填写项目名称.").Show();
return;
}
if (编号TextField.Text == "")
{
X.Msg.Alert("Status", "请填写项目编号.").Show();
return;
}
if (项目类别ComboBox.SelectedItem.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 (结题时间DateField.Text == "")
{
X.Msg.Alert("Status", "请选择结题时间.").Show();
return;
}
if (项目金额TextField.Text == "")
{
XMMoney = 0;
}
else
{
int num = 0;
if (int.TryParse(项目金额TextField.Text, System.Globalization.NumberStyles.Integer, null, out num))
{
XMMoney = Convert.ToInt32(项目金额TextField.Text);
}
else
{
X.Msg.Alert("Status", "金额应为数字.").Show();
return;
}
}
DBHelp db = new DBHelp();
if (db.CheckXM(编号TextField.Text) == 2)
{
SqlConnection mycon = db.MyCon;
mycon.Open();
SqlCommand mycmd = mycon.CreateCommand();
string insel = "insert into XMInfo(XMName,XMNo,TNo,XMType,XMJtType,XMBegin,XMFzr,XMEnd,XMDeptName,XMMoney,XMFundDept,XMRemark,XType,XVType) values('"+名称TextField.Text+"','"+编号TextField.Text+"','"+Session["TNo"].ToString()+"','"+项目类别ComboBox.SelectedItem.Text+"','"+具体类型ComboBox.SelectedItem.Text+"','"+立项日期DateField.Text+"','"+负责人TextField.Text+"','"+结题时间DateField.Text+"','"+单位ComboBox.SelectedItem.Text+"','"+项目金额TextField.Text+"','"+资助单位TextField.Text+"','"+项目简介TextArea.Text+"','0','0')";
mycmd.CommandText = insel;
mycmd.ExecuteNonQuery();
mycon.Close();
X.Msg.Alert("Status", "保存成功.").Show();
}
else
{
X.Msg.Alert("Status", "该项目已保存.").Show();
}
}
