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