/// <summary> /// 从IDataReader创建OrderRefundInfo /// </summary> public static OrderRefundInfo BuildOrderRefundFromReader(IDataReader reader) { OrderRefundInfo orderRefundInfo = new OrderRefundInfo(); orderRefundInfo.Oid = TypeHelper.ObjectToInt(reader["oid"]); orderRefundInfo.OSN = reader["osn"].ToString(); orderRefundInfo.Uid = TypeHelper.ObjectToInt(reader["uid"]); orderRefundInfo.State = TypeHelper.ObjectToInt(reader["state"]); orderRefundInfo.ApplyTime = TypeHelper.ObjectToDateTime(reader["applytime"]); orderRefundInfo.PayMoney = TypeHelper.ObjectToDecimal(reader["paymoney"]); orderRefundInfo.RefundMoney = TypeHelper.ObjectToDecimal(reader["refundmoney"]); orderRefundInfo.RefundSN = reader["refundsn"].ToString(); orderRefundInfo.RefundSystemName = reader["refundsystemname"].ToString(); orderRefundInfo.RefundFriendName = reader["refundfriendname"].ToString(); orderRefundInfo.RefundTime = TypeHelper.ObjectToDateTime(reader["refundtime"]); orderRefundInfo.PaySN = reader["paysn"].ToString(); orderRefundInfo.PaySystemName = reader["paysystemname"].ToString(); orderRefundInfo.PayFriendName = reader["payfriendname"].ToString(); return orderRefundInfo; }
/// <summary> /// 申请退款 /// </summary> /// <param name="orderRefundInfo">订单退款信息</param> public void ApplyRefund(OrderRefundInfo orderRefundInfo) { DbParameter[] parms = { GenerateInParam("@oid", SqlDbType.Int, 4, orderRefundInfo.Oid), GenerateInParam("@osn", SqlDbType.VarChar,30,orderRefundInfo.OSN), GenerateInParam("@uid", SqlDbType.Int,4 ,orderRefundInfo.Uid), GenerateInParam("@state", SqlDbType.TinyInt,1 ,orderRefundInfo.State), GenerateInParam("@applytime", SqlDbType.DateTime,8,orderRefundInfo.ApplyTime), GenerateInParam("@paymoney", SqlDbType.Decimal,8,orderRefundInfo.PayMoney), GenerateInParam("@refundmoney", SqlDbType.Decimal,8,orderRefundInfo.RefundMoney), GenerateInParam("@refundsn", SqlDbType.VarChar,30 ,orderRefundInfo.RefundSN), GenerateInParam("@refundsystemname", SqlDbType.VarChar,20 ,orderRefundInfo.RefundSystemName), GenerateInParam("@refundfriendname", SqlDbType.NVarChar,30 ,orderRefundInfo.RefundFriendName), GenerateInParam("@refundtime", SqlDbType.DateTime,8 ,orderRefundInfo.RefundTime), GenerateInParam("@paysn", SqlDbType.VarChar,30 ,orderRefundInfo.PaySN), GenerateInParam("@paysystemname", SqlDbType.VarChar,20 ,orderRefundInfo.PaySystemName), GenerateInParam("@payfriendname", SqlDbType.NVarChar,30 ,orderRefundInfo.PayFriendName) }; RdbsHelper.ExecuteNonQuery(CommandType.StoredProcedure, string.Format("{0}applyrefund", RdbsHelper.RdbsTablePre), parms); }
/// <summary> /// 申请退款 /// </summary> /// <param name="orderRefundInfo">订单退款信息</param> public static void ApplyRefund(OrderRefundInfo orderRefundInfo) { BrnShop.Core.BSPData.RDBS.ApplyRefund(orderRefundInfo); }