标题这样写,估计也不合适。直接说事吧,看一段代码:
/// <summary>
/// 添加订单
/// </summary>
/// <param name="orderInfo">订单信息</param>
/// <param name="shipId">配送编号</param>
public static int Insert(OrderInfo orderInfo, int shipId)
{
IDataHelper dbo = DataHelperFactory.Create(FLoveDB);
SqlParameter[] parameters = {
new SqlParameter("@order_id",SqlDbType.VarChar),
new SqlParameter("@user_id",SqlDbType.Int),
new SqlParameter("@order_status",SqlDbType.Int),
new SqlParameter("@project_id",SqlDbType.Int),
new SqlParameter("@service_id",SqlDbType.Int),
new SqlParameter("@trade_amount",SqlDbType.Decimal),
new SqlParameter("@ship_fee",SqlDbType.Decimal),
new SqlParameter("@is_lock",SqlDbType.Bit),
new SqlParameter("@return_point",SqlDbType.Int),
new SqlParameter("@return_voucher",SqlDbType.Int),
new SqlParameter("@pay_way",SqlDbType.Int),
new SqlParameter("@note",SqlDbType.VarChar),
new SqlParameter("@ship_id",SqlDbType.Int),
new SqlParameter("@product_measures",SqlDbType.VarChar),
new SqlParameter("@goods_count",SqlDbType.Int),
new SqlParameter("@project_schedule",SqlDbType.Int),
new SqlParameter("@error_code",SqlDbType.Int)
};
parameters[0].Value = orderInfo.OrderId;
parameters[1].Value = orderInfo.UserId;
parameters[2].Value = (int)orderInfo.Status;
parameters[3].Value = orderInfo.ProjectId;
parameters[4].Value = orderInfo.ServiceId;
parameters[5].Value = orderInfo.TradeAmount;
parameters[6].Value = orderInfo.ShipFee;
parameters[7].Value = orderInfo.IsLock;
parameters[8].Value = orderInfo.ReturnPoint;
parameters[9].Value = orderInfo.ReturnVoucher;
parameters[10].Value = orderInfo.PayWay;
parameters[11].Value = orderInfo.Note;
parameters[12].Value = shipId;
parameters[13].Value = orderInfo.ProductMeasures;
parameters[14].Value = orderInfo.GoodsCount;
parameters[15].Value = orderInfo.ProjectSchedule;
parameters[16].Direction = ParameterDirection.Output;
dbo.ExecuteNonQuery(CommandType.StoredProcedure, SpInsert, parameters);
return Convert.ToInt32(parameters[15].Value);
}