private void btnsubmit_Click(object sender, EventArgs e) { //提交日程 string datetime = this.skinDateTimePicker1.Text + " " + this.dateTimePicker1.Text; int important = this.comboxImportant.SelectedIndex + 1; string detail = this.skinTextBox1.Text; richeng r = new richeng(); r.Uid = Local.getCurrentUid(); r.Detail = detail; r.Time = datetime; r.IsFinished = 0; r.ZyLevel = important; if (BLL.richengBLL.add(r) == 1) { MessageBox.Show("提交成功"); bind(); } }
/// <summary> /// 添加日程 /// </summary> /// <param name="r"></param> /// <returns></returns> public static object add(richeng r) { sqltext = " insert into [dbo].[richeng](uid,detail,zyLevel,time,isFinished)values('" + r.Uid + "','" + r.Detail + "','" + r.ZyLevel + "','" + r.Time + "','0')"; return(SQLHELPER.ExecuteNonQuery(sqltext)); }
//添加 public static int add(richeng r) { return(Convert.ToInt32(DAL.richengServer.add(r))); }