//加载所有会员
private void LoadMemmberInfoByDelFlag(int p)
{
MemmberInfoBLL bll = new MemmberInfoBLL();
dgvMemmber.AutoGenerateColumns = false;
dgvMemmber.DataSource = bll.GetAllMemmberInfoByDelFlag(p);
dgvMemmber.SelectedRows[0].Selected = false;
}
//加载会员级别
public void LoadMember(int p)
{
MemmberInfoBLL bll = new MemmberInfoBLL();
List <MemmberInfo> list = bll.GetAllMemmberInfoByDelFlag(p);
list.Insert(0, new MemmberInfo {
MemmberId = -1, MemName = "请选择"
});
cmbMemmber.DataSource = list;
cmbMemmber.DisplayMember = "MemName";
cmbMemmber.ValueMember = "MemmberId";
}
//确定按钮，新增和修改
private void btnOk_Click(object sender, EventArgs e)
{
MemmberInfo mem = new MemmberInfo();
if (IsCheck())
{
mem.MemAddress = txtAddress.Text;
mem.MemBirthdaty = Convert.ToDateTime(txtBirs.Text);
mem.MemDiscount = Convert.ToDecimal(txtMemDiscount.Text);
mem.MemEndServerTime = dtEndServerTime.Value;
mem.MemGender = CheckGender();
mem.MemIntegral = Convert.ToInt32(txtMemIntegral.Text);
mem.MemMobilePhone = txtMemPhone.Text;
mem.MemMoney = Convert.ToDecimal(txtmemMoney.Text);
mem.MemName = txtMemName.Text;
mem.MemNum = txtMemNum.Text;
mem.MemType = Convert.ToInt32(cmbMemType.SelectedIndex);
}
MemmberInfoBLL bll = new MemmberInfoBLL();
//新增还是修改
if (this.Tp == 1)//新增
{
mem.DelFlag = 0;
mem.SubTime = System.DateTime.Now;
//if (bll.SaveMemmber(mem,this.Tp))
//{
// MessageBox.Show("新增成功");
// this.Close();
//}
//else
//{
// MessageBox.Show("新增失败");
//}
}
else if (this.Tp == 2) //修改
{
mem.MemmberId = Convert.ToInt32(labId.Text);
//if (bll.SaveMemmber(mem, this.Tp))
//{
// MessageBox.Show("修改成功");
// this.Close();
//}
//else
//{
// MessageBox.Show("修改失败");
//}
}
string st = bll.SaveMemmber(mem, this.Tp) ? "操作成功" : "操作失败";
MessageBox.Show(st);
this.Close();
}
//修改
private void btnUpdateMember_Click(object sender, EventArgs e)
{
if (dgvMemmber.SelectedRows.Count > 0)
{
int id = Convert.ToInt32(dgvMemmber.SelectedRows[0].Cells[0].Value);
MemmberInfoBLL bll = new MemmberInfoBLL();
MemmberInfo mem = bll.GetMemmberByMemmberid(id);
mem.MemmberId = id;
fea.Obj = mem;
ShowChangeMemmber(2);//2表示修改
//根据选中行的id去数据库查询是否有这条数据,并以对象的方式返回来
//传对象
}
}
private void btnAccounts_Click(object sender, EventArgs e)
{
OrderInfo order = new OrderInfo();
order.OrderId = Convert.ToInt32(labOrderId.Text); //订单的id
order.EndTime = DateTime.Now; //订单中的结束时间
//如果选择会员
if (cmbMemmber.SelectedIndex == 0)
{
//不是会员
// order.DisCount = 10;
}
else
{
//是会员
//会员的余额更新
//如果是会员,那么要获取该会员的余额-当前消费的金额,更新到会员的表中
decimal memYuMoney = Convert.ToDecimal(labyeMoney.Text) - Convert.ToDecimal(lblMoney.Text);
int memId = Convert.ToInt32(cmbMemmber.SelectedValue);
MemmberInfoBLL bll = new MemmberInfoBLL();
bool memresult = bll.UpdateMoney(memId, memYuMoney); //更新会员的余额
order.OrderMemId = memId; //订单中的会员id
order.DisCount = Convert.ToDecimal(lblDis.Text); //这个是订单中的会员折扣
}
//更新餐桌的状态=0
//获取餐桌的id,更改餐桌的状态
DeskInfoBLL dkBll = new DeskInfoBLL();
bool result = dkBll.UpdateDeskStateByDeskId(this.Id, 0);
//订单的状态=2
//获取订单的id更改订单的状态.更新这个订单最后花费多少钱,结束时间
order.OrderMoney = Convert.ToDecimal(lblMoney.Text);//这个订单花了多少钱
//窗体关闭
OrderInfoBLL obll = new OrderInfoBLL();
bool oresult = obll.UpdateOrderInfoMoney(order);
if (result && oresult)
{
MessageBox.Show("结账成功");
this.Close();
}
else
{
MessageBox.Show("结账失败");
}
}
//修改会员 2表示是修改
private void btnUpdateMember_Click(object sender, EventArgs e)
{
//FrmChangeMemmber fcm = new FrmChangeMemmber();
//fcm.ShowDialog();
if (dgvMemmber.SelectedRows.Count > 0)
{
int id = Convert.ToInt32(dgvMemmber.SelectedRows[0].Cells[0].Value);
//根据id去数据库查询这条数据是否存在
MemmberInfoBLL bll = new MemmberInfoBLL();
MemmberInfo mem = bll.GetMemmberInfoByMemmberId(id);
fea.obj = mem;
ShowFrmChangeMemmber(2);
}
else
{
MessageBox.Show("请选择要修改的数据");
}
}
//删除会员
private void btnDelete_Click(object sender, EventArgs e)
{
if (dgvMemmber.SelectedRows.Count > 0)
{
if (DialogResult.OK == MessageBox.Show("是否删除", "删除", MessageBoxButtons.OKCancel))
{
string strId = dgvMemmber.SelectedRows[0].Cells[0].Value.ToString();
int memId = Convert.ToInt32(strId);
MemmberInfoBLL bll = new MemmberInfoBLL();
string msg = bll.DeleteMemmber(memId) ? "操作成功" : "操作失败";
MessageBox.Show(msg);
LoadMemmberInfoByDelFlag(0);
}
}
else
{
MessageBox.Show("请选中删除的会员");
}
}
private void btnOk_Click(object sender, EventArgs e)
{
//获取会员信息
//不为空
MemmberInfo mem = new MemmberInfo();
if (IsCheck())
{
mem.MemAddress = txtAddress.Text;
mem.MemBirthdaty = Convert.ToDateTime(txtBirs.Text); //生日最好用控件
mem.MemDiscount = Convert.ToDecimal(txtMemDiscount.Text); //折扣
mem.MemEndServerTime = dtEndServerTime.Value;
mem.MemGender = IsGender();
mem.MemIntegral = Convert.ToInt32(txtMemIntegral.Text);
mem.MemMobilePhone = txtMemPhone.Text;
mem.MemMoney = Convert.ToDecimal(txtmemMoney.Text);
mem.MemName = txtMemName.Text;
mem.MemNum = txtMemNum.Text;
mem.MemType = Convert.ToInt32(cmbMemType.SelectedValue);
}
else
{
//MessageBox.Show("不能为空");
return; //没的话，直接确定会生成空值，报错
}
MemmberInfoBLL bll = new MemmberInfoBLL();
//新增还是修改
if (this.Tp == 1)
{
mem.DelFlag = 0;
mem.SubTime = System.DateTime.Now;
}
else if (this.Tp == 2)
{
mem.MemmberId = Convert.ToInt32(labId.Text);
}
string st = bll.SaveMemmber(mem, this.Tp) ? "操作成功" : "操作失败";
MessageBox.Show(st);
this.Close();
}
//会员是否选中计算花费多少钱
private void cmbMemmber_SelectedIndexChanged(object sender, EventArgs e)
{
if (cmbMemmber.SelectedIndex != 0)
{
int memId = Convert.ToInt32(cmbMemmber.SelectedValue);
MemmberInfoBLL bll = new MemmberInfoBLL();
MemmberInfo mem = bll.GetMemMoneyAndDisCountAndTypeNameByMemId(memId);
labyeMoney.Text = mem.MemMoney.ToString(); //会员的余额
lblDis.Text = mem.MemDiscount.ToString(); //折扣
labTp.Text = mem.MemTpName;
lblMoney.Text = (Convert.ToDecimal(labMoney.Text) * mem.MemDiscount / 10).ToString();
}
else
{
labyeMoney.Text = "";
lblDis.Text = "";
labTp.Text = "";
lblMoney.Text = labMoney.Text;
}
}
//删除
private void btnDelete_Click(object sender, EventArgs e)
{
//判断是否有选中的行
if (dgvMemmber.SelectedRows.Count > 0)
{
int id = Convert.ToInt32(dgvMemmber.SelectedRows[0].Cells[0].Value);
MemmberInfoBLL bll = new MemmberInfoBLL();
if (bll.DeleteMemmberByMemmberId(id))
{
MessageBox.Show("操作成功");
LoadMemmberInfoByDelFlag(0);
}
else
{
MessageBox.Show("操作失败");
}
}
else
{
MessageBox.Show("请选中要删除的行");
}
}
//增加或者是修改
private void btnOk_Click(object sender, EventArgs e)
{
//判断文本框不能为空
if (IsCheck())
{
//判断是新增还是修改
MemmberInfo mem = new MemmberInfo();
//地址没写
mem.MemBirthdaty = Convert.ToDateTime(txtBirs.Text); //生日最好用控件
mem.MemDiscount = Convert.ToDecimal(txtMemDiscount.Text); //折扣
mem.MemEndServerTime = dtEndServerTime.Value;
mem.MemGender = IsGender();
mem.MemIntegral = Convert.ToInt32(txtMemIntegral.Text);
mem.MemMobilePhone = txtMemPhone.Text;
mem.MemMoney = Convert.ToDecimal(txtmemMoney.Text);
mem.MemName = txtMemName.Text;
mem.MemNum = txtMemNum.Text;
mem.MemType = Convert.ToInt32(cmbMemType.SelectedValue);
if (this.Tp == 1)//新增
{
mem.DelFlag = 0;
mem.SubTime = DateTime.Now;
}
else if (this.Tp == 2)//修改id
{
mem.MemmberId = Convert.ToInt32(labId.Text);
}
//调用方法 是新增还是修改
MemmberInfoBLL bll = new MemmberInfoBLL();
string msg = bll.SaveMemmberInfo(mem, this.Tp)?"操作成功":"操作失败";
MessageBox.Show(msg);
this.Close();
}
}
