private void btnAdd_Click(object sender, EventArgs e) { Htgl ht = new Htgl(); ht.Detail = txtDetail.Text; //详细 ht.Htbh = txthtBH.Text; //合同编号 ht.Time = datetimeEnd.text; //结束时间 ht.WriteTime = datetimeWrite.text; //签署时间 ht.StartTime = dateTimeStart.text; //生效时间 ht.Uid = _uids[this.comboxUser.SelectedIndex]; if (HTBLL.addHt(ht) == 1) { MessageBox.Show("添加成功"); _f.bind(); this.Close(); } }
//增加合同 public static int addHt(Htgl h) { return(DAL.HTServer.addHt(h)); }
//增加合同 public static int addHt(Htgl h) { sqltext = " insert into Htgl(htbh,uid,startTime,endTime,Detail,writeTime)values('" + h.Htbh + "','" + h.Uid + "','" + h.StartTime + "','" + h.Time + "','" + h.Detail + "','" + h.WriteTime + "')"; return((int)DAL.SQLHELPER.ExecuteNonQuery(sqltext)); }