C#连接、访问MySQL数据库(三)

public int EditName(long id, int userId, string name)
{
    StringBuilder sb = new StringBuilder();
    sb.Append("UPDATE T_Photo SET Name = ?Name WHERE ID = ?ID AND UserID = ?UserID");
    MySqlParameter[] parameters = {
                                     new MySqlParameter("?ID", MySqlDbType.Int64),
                                     new MySqlParameter("?UserID", MySqlDbType.Int32),
                                     new MySqlParameter("?Name", MySqlDbType.String)
                                 };
    parameters[0].Value = id;
    parameters[1].Value = userId;
    parameters[2].Value = name;
    return SQLHelper.ExecuteNonQuery(sb.ToString(), CommandType.Text, parameters);
}
　　

?

public MySqlDataReader GetListByOrderCode(string orderCode)
{
    StringBuilder sb = new StringBuilder();
    sb.Append("SELECT ID,OrderCount,Subtotal,ProductID, ");
    sb.Append("FROM t_orderdetail  ");


    //筛选条件
    sb.Append("WHERE OrderCode = ?OrderCode ");


    //排序
    sb.Append("ORDER BY ID DESC ");


    MySqlParameter[] parameters = {
                                     new MySqlParameter("?OrderCode", MySqlDbType.String)
                                 };


    parameters[0].Value = orderCode;
    return SQLHelper.ExecuteReader(sb.ToString(), CommandType.Text, parameters);

}
　　

?

public int BackOrder(long id)
{
    StringBuilder sb = new StringBuilder();


    sb.Append("BackOrder ");//存储过程名称


    MySqlParameter[] parameters = {
                                     new MySqlParameter("?OrderId", MySqlDbType.Int64)//OrderId必须与存储过程参数名、数据类型一致
                                 };
    parameters[0].Value = id;
    return MyCustomSQLHelper.ExecuteNonQuery(sb.ToString(), CommandType.StoredProcedure, parameters);
}

?