/// <summary>
/// 删除用户信息
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public int DeleteDelivery(string id)
{
try
{
string sql = $"{ CreateSqlString.DeleteSqlString(new Delivery { }) } WHERE DeliveryId = @DeliveryId";
MySqlParameter[] pars =
{
new MySqlParameter("@DeliveryId", MySqlDbType.VarChar, 36)
};
pars[0].Value = id;
return(SqlHelper.ExecuteNonquery(sql, CommandType.Text, pars));
}
catch
{
throw;
}
}
/// <summary>
/// 删除用户信息
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public int DeleteAppraise(string id)
{
try
{
string sql = CreateSqlString.DeleteSqlString(new Appraise {
}) + " WHERE AppraiseId = @AppraiseId";
SqlParameter[] pars =
{
new SqlParameter("@AppraiseId", SqlDbType.VarChar, 36)
};
pars[0].Value = id;
return(SqlHelper.ExecuteNonquery(sql, CommandType.Text, pars));
}
catch
{
throw;
}
}