/// <summary>
/// 添加消费者用户
/// </summary>
/// <param name="cs">消费者实体</param>
/// <returns></returns>
public int AddConsumers(Entity.Consumers cs)
{
//将数据写入到Users表中
string sql = "insert into Users values('" + cs.cardno + "','" + cs.name + "','" + cs.age + "','" + cs.gender + "','" + cs.money + "','" + cs.status + "','" + cs.sno + "','" + cs.addtime + "')";
int reslut = sqlhelper.ExecuteNonQuery(sql);
//将数据插入到注册记录表中
DateTime dt = DateTime.Now;
string sno = Entity.GoAnyWhere.id;
string sql2 = "insert into Register values('" + sno + "','" + dt + "','" + cs.cardno + "','" + cs.money + "')";
sqlhelper.ExecuteNonQuery(sql2);
//返回影响的行数
return(reslut);
}
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("添加失败，请联系管理员", "温馨提示");
}
}
}
/// <summary>
/// 添加消费者用户
/// </summary>
/// <param name="cs">消费者实体</param>
/// <returns></returns>
public int AddConsumers(Entity.Consumers cs)
{
return(ic.AddConsumers(cs));
}
/// <summary>
/// 添加用户
/// </summary>
/// <param name="cs"></param>
/// <returns></returns>
public int addconsumers(Entity.Consumers cs)
{
return(CS.AddConsumers(cs));
}
