/// <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)); }