public int clientUpdate(string name, string phone)//用户修改信息
{
string sql = "update Reply set Name=" + "'" + name + "'" + "where Phone=" + "'" + phone + "'";
SqlHelper sqlHelper = new SqlHelper();
return(sqlHelper.ExcuteNoneQuery(sql));
}
public int AddFeedBack(Reply reply)//发布反馈
{
int result = 0;
//SqlHelper sqlHelper = new SqlHelper();
string sql = "insert into Reply values(@Phone,@Name,@Evaluate,@Message,@Time,@AdReply)";
SqlParameter[] spms =
{
new SqlParameter("@Phone", reply.Phone),
new SqlParameter("@Name", reply.Name),
new SqlParameter("@Evaluate", reply.Evaluate),
new SqlParameter("@Message", reply.Message),
new SqlParameter("@Time", reply.Time),
new SqlParameter("@AdReply", reply.AdReply)
};
result = sqlHelper.ExcuteNoneQuery(sql, spms);
return(result);
}
public int AdminDelete(int id)//管理员根据id删除对应行
{
string sql = "delete from Client where ID=" + id;
//sql参数数组
SqlHelper sqlHelper = new SqlHelper();
return(sqlHelper.ExcuteNoneQuery(sql));
}
public int Delete2(string phone)//根据手机号删除对应行
{
string sql = "delete from FeedBack where Phone=" + "'" + phone + "'";
//sql参数数组
SqlHelper sqlHelper = new SqlHelper();
return(sqlHelper.ExcuteNoneQuery(sql));
}
public int Delete(int id)//根据id删除对应行
{
string sql = "delete from FeedBack where ID=" + id;
//sql参数数组
SqlHelper sqlHelper = new SqlHelper();
return(sqlHelper.ExcuteNoneQuery(sql));
}
public int UpdatePwd(string newPwd, String phone)//用户修改密码
{
string sql = "update Client set Pwd=@Pwd where Phone=" + phone;
//sql参数数组
SqlParameter[] paras = new SqlParameter[] {
new SqlParameter("@Pwd", newPwd)
};
SqlHelper sqlHelper = new SqlHelper();
return(sqlHelper.ExcuteNoneQuery(sql, paras));
}
public int adminUpdate(Client client, string phone2)//用户修改信息
{
string sql = "update Reply set Phone=@Phone,Name=@Name where Phone=" + "'" + phone2 + "'";
SqlParameter[] paras = new SqlParameter[] {
new SqlParameter("@Phone", client.Phone),
new SqlParameter("@Name", client.Name),
};
SqlHelper sqlHelper = new SqlHelper();
return(sqlHelper.ExcuteNoneQuery(sql, paras));
}
public int Update(Client client, String phone)//用户修改信息
{
string sql = "update Client set Phone=@Phone,Name=@Name,Sex=@Sex,Age=@Age where Phone=" + phone;
//sql参数数组
SqlParameter[] paras = new SqlParameter[] {
//new SqlParameter("@ID",client.ID),
new SqlParameter("@Phone", client.Phone),
new SqlParameter("@Name", client.Name),
new SqlParameter("@Sex", client.Sex),
new SqlParameter("@Age", client.Age == null?DBNull.Value:(object)client.Age),
};
SqlHelper sqlHelper = new SqlHelper();
return(sqlHelper.ExcuteNoneQuery(sql, paras));
}
public int AddClient(Client client)//用户注册
{
int result = 0;
SqlHelper sqlHelper = new SqlHelper();
string sql = "insert into Client values(@Phone,@Pwd,@Name,@Sex,@Age)";
SqlParameter[] spms =
{
new SqlParameter("@Phone", client.Phone),
new SqlParameter("@Pwd", client.Pwd),
new SqlParameter("@Name", client.Name),
new SqlParameter("@Sex", client.Sex),
new SqlParameter("@Age", client.Age),
};
result = sqlHelper.ExcuteNoneQuery(sql, spms);
return(result);
}
public int AddFeedBack(FeedBack feedBack)//发布反馈
{
int result = 0;
SqlHelper sqlHelper = new SqlHelper();
string sql = "insert into FeedBack values(@Phone,@Name,@Message,@Evaluate,@Time)";
SqlParameter[] spms =
{
new SqlParameter("@Phone", feedBack.Phone),
new SqlParameter("@Name", feedBack.Name),
new SqlParameter("@Message", feedBack.Message),
new SqlParameter("@Evaluate", feedBack.Evaluate),
new SqlParameter("@Time", feedBack.Time)
};
result = sqlHelper.ExcuteNoneQuery(sql, spms);
return(result);
}
public int adminUpdate(Client client, int id)//管理员修改用户信息
{
string sql = "update Client set Phone=@Phone,Pwd=@Pwd,Name=@Name,Sex=@Sex,Age=@Age where ID=" + id;
//sql参数数组
SqlParameter[] paras = new SqlParameter[] {
//new SqlParameter("@ID",client.ID),
new SqlParameter("@Phone", client.Phone),
new SqlParameter("@Pwd", client.Pwd),
new SqlParameter("@Name", client.Name),
new SqlParameter("@Sex", client.Sex),
new SqlParameter("@Age", client.Age == null?DBNull.Value:(object)client.Age),
};
SqlHelper sqlHelper = new SqlHelper();
return(sqlHelper.ExcuteNoneQuery(sql, paras));
}
