private void tsbSave_Click(object sender, EventArgs e)
{
//如果点击的是“新建”按钮，则进行数据添加操作
if (op == operation.insert)
{
DataClasses1DataContext db = new DataClasses1DataContext(connStr);
customerManage cre = new customerManage();
cre.cus_name = txtName.Text;
cre.cus_id = txtId.Text;
cre.cus_phone = txtPhone.Text;
cre.cus_type = cbroomType.Text;
cre.cus_roomid = Convert.ToInt32(cbRoomID.Text);
cre.cus_time = dtTime.Value;
cre.cus_days = Convert.ToInt32(txtDays.Text);
cre.cus_pay = Convert.ToSingle(txtPay.Text);
cre.cus_extra = Convert.ToInt32(txtExtra.Text);
db.customerManage.InsertOnSubmit(cre);
db.SubmitChanges();
MessageBox.Show("信息添加成功", "添加记录", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
BindInfo();
}
//如果点击的是“编辑”按钮，则进行数据更新操作
else if (op == operation.update)
{
DataClasses1DataContext db = new DataClasses1DataContext(connStr);
var result = from c in db.customerManage
where c.cus_id == txtId.Text
select c;
foreach (customerManage c in result)
{
c.cus_name = txtName.Text;
c.cus_id = txtId.Text;
c.cus_phone = txtPhone.Text;
c.cus_type = cbroomType.Text;
c.cus_roomid = Convert.ToInt32(cbRoomID.Text);
c.cus_time = dtTime.Value;
c.cus_days = Convert.ToInt32(txtDays.Text);
c.cus_pay = Convert.ToSingle(txtPay.Text);
c.cus_extra = Convert.ToInt32(txtExtra.Text);
db.SubmitChanges();
MessageBox.Show("信息修改成功", "修改记录", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
BindInfo();
}
}
}
partial void UpdatecustomerManage(customerManage instance);
partial void DeletecustomerManage(customerManage instance);
partial void InsertcustomerManage(customerManage instance);
