private void tsbSave_Click(object sender, EventArgs e)
{
if (op == operation.insert)
{
DataClasses1DataContext db = new DataClasses1DataContext(connStr);
reserveManage re = new reserveManage();
re.cus2_name = txtName.Text;
re.cus2_id = txtId.Text;
re.cus2_phone = txtPhone.Text;
re.cus2_type = cbroomType.Text;
re.cus2_roomid = Convert.ToInt32(cbRoomID.Text);
re.cus2_time = dtTime.Value;
re.cus2_days = Convert.ToInt32(txtDays.Text);
re.cus2_pay = Convert.ToSingle(txtPay.Text);
re.cus2_extra = Convert.ToInt32(txtExtra.Text);
db.reserveManage.InsertOnSubmit(re);
db.SubmitChanges();
MessageBox.Show("数据添加成功", "添加记录", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
BindInfo();
}
else if (op == operation.update)
{
DataClasses1DataContext db = new DataClasses1DataContext(connStr);
reserveManage cre = new reserveManage();
var result = from c in db.reserveManage
where c.cus2_id == txtId.Text
select c;
foreach (reserveManage c in result)
{
c.cus2_name = txtName.Text;
c.cus2_id = txtId.Text;
c.cus2_phone = txtPhone.Text;
c.cus2_type = cbroomType.Text;
c.cus2_roomid = Convert.ToInt32(cbRoomID.Text);
c.cus2_time = dtTime.Value;
c.cus2_days = Convert.ToInt32(txtDays.Text);
c.cus2_pay = Convert.ToSingle(txtPay.Text);
c.cus2_extra = Convert.ToInt32(txtExtra.Text);
db.SubmitChanges();
MessageBox.Show("数据修改成功", "修改记录", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
BindInfo();
}
}
}
partial void UpdatereserveManage(reserveManage instance);
partial void DeletereserveManage(reserveManage instance);
partial void InsertreserveManage(reserveManage instance);