/// <summary>
/// 获取参数列表
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
private static List <SQLiteParameter> GetParameters(Order model)
{
List <SQLiteParameter> parameters = new List <SQLiteParameter>()
{
new SQLiteParameter("@order_no", DbType.String),
new SQLiteParameter("@order_name", DbType.String),
new SQLiteParameter("@order_body", DbType.String),
new SQLiteParameter("@order_url", DbType.String),
new SQLiteParameter("@payment_type", DbType.String),
new SQLiteParameter("@original_money", DbType.Decimal, 4),
new SQLiteParameter("@money", DbType.Decimal, 4),
new SQLiteParameter("@invoice_title", DbType.String),
new SQLiteParameter("@user_id", DbType.Int32, 8),
new SQLiteParameter("@from_id", DbType.Int32, 8),
new SQLiteParameter("@emp_id", DbType.Int32, 8),
new SQLiteParameter("@order_type", DbType.String),
new SQLiteParameter("@order_status", DbType.String),
new SQLiteParameter("@feedback_status", DbType.String),
new SQLiteParameter("@transport_fee", DbType.Decimal, 4),
new SQLiteParameter("@remark", DbType.String),
new SQLiteParameter("@arrived_at", DbType.Int64, 8),
new SQLiteParameter("@express_at", DbType.Int64, 8),
new SQLiteParameter("@sign_at", DbType.Int64, 8),
new SQLiteParameter("@close_at", DbType.Int64, 8),
new SQLiteParameter("@refund_at", DbType.Int64, 8),
new SQLiteParameter("@is_delete", DbType.Int32, 8),
new SQLiteParameter("@created_at", DbType.Int64, 8),
new SQLiteParameter("@updated_at", DbType.Int64, 8),
new SQLiteParameter("@pay_at", DbType.Int64, 8),
new SQLiteParameter("@feedback_at", DbType.Int64, 8),
new SQLiteParameter("@buyer_id", DbType.Int32, 8)
};
parameters[0].Value = model.No;
parameters[1].Value = model.Name;
parameters[2].Value = model.Body;
parameters[3].Value = model.Url;
parameters[4].Value = model.Payment.ToString();
parameters[5].Value = model.OriginalMoney;
parameters[6].Value = model.Money;
parameters[7].Value = model.InvoiceTitle;
parameters[8].Value = model.UserId;
parameters[9].Value = model.FromId;
parameters[10].Value = model.EmpId;
parameters[11].Value = model.OrderType.ToString();
parameters[12].Value = model.Status.ToString();
parameters[13].Value = model.FeedbackStatus.ToString();
parameters[14].Value = model.TransportFee;
parameters[15].Value = model.Remark;
parameters[16].Value = model.ConvertDateTimeInt(model.ArrivedAt);
parameters[17].Value = model.ConvertDateTimeInt(model.ExpressAt);
parameters[18].Value = model.ConvertDateTimeInt(model.SignAt);
parameters[19].Value = model.ConvertDateTimeInt(model.CloseAt);
parameters[20].Value = model.ConvertDateTimeInt(model.RefundAt);
parameters[21].Value = model.IsDelete ? 1 : 0;
parameters[22].Value = model.ConvertDateTimeInt(model.CreatedAt);
parameters[23].Value = model.ConvertDateTimeInt(model.UpdatedAt);
parameters[24].Value = model.ConvertDateTimeInt(model.PayAt);
parameters[25].Value = model.ConvertDateTimeInt(model.FeedbackAt);
parameters[26].Value = model.BuyerId;
return(parameters);
}
