//根据ID号查询顾客信息 public Customer select_customer(int ID) { String sql = "select * from customer_information where ID=@ID"; SqlParameter[] param = { new SqlParameter("@ID",SqlDbType.Int) }; param[0].Value = ID; Customer cus = new Customer(); DataTable dt = SqlHelper.ExecuteSelect(sql, param); foreach (DataRow dr in dt.Rows) { cus = DataRowToCustomer(dr); } return cus; }
//加入顾客函数 public int Add_customer(Customer cus) { String sql = "insert into customer_information(cus_nickname,cus_password,cus_telephone,cus_question,cus_answer,cus_score) values(@cus_nickname,@cus_password,@cus_telephone,@cus_question,@cus_answer,@cus_score)"; SqlParameter[] param = { new SqlParameter("@cus_nickname",SqlDbType.VarChar), new SqlParameter("@cus_password",SqlDbType.VarChar), new SqlParameter("@cus_telephone",SqlDbType.VarChar), new SqlParameter("@cus_question",SqlDbType.VarChar), new SqlParameter("@cus_answer",SqlDbType.VarChar), new SqlParameter("@cus_score",SqlDbType.Int), }; param[0].Value = cus.cus_nickname; param[1].Value = cus.cus_password; param[2].Value = cus.cus_telephone; param[3].Value = cus.cus_question; param[4].Value = cus.cus_answer; param[5].Value = cus.cus_score; return SqlHelper.ExecuteQuery(sql, param); }
//修改顾客信息函数 public int Update_customer(Customer cus, int ID) { String sql = "update customer_information set cus_nickname=@cus_nickname,cus_password=@cus_password,cus_telephone=@cus_telephone,cus_question=@cus_question,cus_answer=@cus_answer,cus_score=@cus_score where ID=@ID"; SqlParameter[] param = { new SqlParameter("@cus_nickname",SqlDbType.VarChar), new SqlParameter("@cus_password",SqlDbType.VarChar), new SqlParameter("@cus_telephone",SqlDbType.VarChar), new SqlParameter("@cus_question",SqlDbType.VarChar), new SqlParameter("@cus_answer",SqlDbType.VarChar), new SqlParameter("@cus_score",SqlDbType.Int), new SqlParameter("@ID",SqlDbType.Int) }; param[0].Value = cus.cus_nickname; param[1].Value = cus.cus_password; param[2].Value = cus.cus_telephone; param[3].Value = cus.cus_question; param[4].Value = cus.cus_answer; param[5].Value = cus.cus_score; param[6].Value = ID; return SqlHelper.ExecuteQuery(sql, param); }
public bool Update_customer(Customer cus, int ID) { return dal.Update_customer(cus, ID) > 0; }
public bool Add_customer(Customer cus) { return dal.Add_customer(cus) > 0; }
//顾客信息数据行转化为customer实例 public Customer DataRowToCustomer(DataRow dr) { Customer cus = new Customer(); cus.ID = (int)dr["ID"]; cus.cus_nickname = dr["cus_nickname"].ToString(); cus.cus_password = dr["cus_password"].ToString(); cus.cus_telephone = dr["cus_telephone"].ToString(); cus.cus_question = dr["cus_question"].ToString(); cus.cus_answer = dr["cus_answer"].ToString(); cus.cus_score = (int)dr["cus_score"]; return cus; }
//根据电话号码查询顾客 public Customer select_customer_by_teleohone(string tele) { String sql = "select * from customer_information where cus_telephone=@cus_telephone"; SqlParameter param = new SqlParameter("@cus_telephone",SqlDbType.VarChar); Customer cus = new Customer(); param.Value = tele; DataTable dt = SqlHelper.ExecuteSelect(sql,param); return cus = DataRowToCustomer(dt.Rows[0]); }