private void frmModifyCsInfo_Load(object sender, EventArgs e) //窗体加载事件
{
string cardno = Entity.GoAnyWhere.cardno;
Facade.Consumers cs = new Facade.Consumers();
DataTable dt = cs.ReturnConsumeinfo(cardno);
//将查询到的数据显示到界面上
txtCardno.Text = Convert.ToString(dt.Rows[0][0]);
txtName.Text = Convert.ToString(dt.Rows[0][1]);
txtAge.Text = Convert.ToString(dt.Rows[0][2]);
cboGender.Text = Convert.ToString(dt.Rows[0][3]);
txtAddMoney.Text = Convert.ToString(dt.Rows[0][4]);
cboStatus.Text = Convert.ToString(dt.Rows[0][5]);
}
private void button1_Click(object sender, EventArgs e) //点击确定添加按钮
{
Facade.Consumers consumer = new Facade.Consumers();
//判断卡号是否存在
string cardno = txtCardno.Text.Trim();
DataTable dt = consumer.ReturnConsumeinfo(cardno);
if (dt.Rows.Count > 0)
{
MessageBox.Show("此用户已存在，请确认后重新输入！", "温馨提示");
txtCardno.SelectAll();
}
else
{
Entity.Consumers cs = new Entity.Consumers();
cs.cardno = txtCardno.Text.Trim();
cs.name = txtName.Text.Trim();
cs.age = txtAge.Text.Trim();
cs.gender = cboGender.Text.Trim();
cs.money = txtAddMoney.Text.Trim();
cs.status = cboStatus.Text.Trim();
cs.sno = Entity.GoAnyWhere.id;
cs.addtime = DateTime.Now;
//将界面获取的数据插入到数据库中
int result = consumer.addconsumers(cs); //插入到消费者信息表
if (result > 0)
{
MessageBox.Show("添加成功！", "温馨提示");
//将消费者信息插入到登录表中
Entity.Login user = new Entity.Login();
user.username = txtCardno.Text.Trim();
user.password = "******";
user.level = "用户";
user.status = cboStatus.Text.Trim();
Facade.LoginUsers fuser = new Facade.LoginUsers();
int result2 = fuser.addusers(user);
}
else
{
MessageBox.Show("添加失败，请联系管理员", "温馨提示");
}
}
}