qlParameter("?UserID", MySqlDbType.Int32)
};
parameters[0].Value = id;
parameters[1].Value = userId;
return SQLHelper.ExecuteNonQuery(sb.ToString(), CommandType.Text, parameters);
}
?
3、修改操作（update）
?
示例代码：
?
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);
}
?
4、查询操作（select）
?
示例代码：
?
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);
}
?
5、调用存储过程
?
示例代码：
?
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);
}
?