public void AddPrepaymentRequest(Prepayment prepayment) { using (var context = new scrumprojectEntities()) { context.Prepayments.Add(prepayment); } }
public void AddPrepaymentRequest(AdvancePayments advancePayment) { var prepay = new Prepayment { PID = advancePayment.PrepaidId, UID = advancePayment.UserId, Amount = advancePayment.Amount, Description = advancePayment.Description, Status = null }; advancePaymentsRepository.AddPrepaymentRequest(prepay); }
public static void Update(Prepayment prepayment) { var connection = DatabaseConnection.Connection; using (var command = connection.CreateCommand()) { const string sql = "update T_Prepayment set Prepayment_Warranty_Date = @date where Prepayment_Id = @id"; command.CommandText = sql; command.Parameters.AddWithValue("@id", prepayment.Id); command.Parameters.AddWithValue("@date", prepayment.WarrantyDate); Logger.LogQuery($"{sql}\r\n{prepayment}"); command.ExecuteNonQuery(); connection.Close(); } }
public static void Insert(Prepayment prepayment) { var connection = DatabaseConnection.Connection; using (var command = connection.CreateCommand()) { const string sql = "insert into T_Prepayment(Prepayment_Id,Prepayment_Warranty_Date) values(@id,@date)"; command.CommandText = sql; command.Parameters.AddWithValue("@id", prepayment.Id); command.Parameters.AddWithValue("@date", prepayment.WarrantyDate); Logger.LogQuery($"execute sql = {sql}\r\n{prepayment}"); command.ExecuteNonQuery(); connection.Close(); } }
public void OnEnable() { MsgRepo = new MsgRepo(); title = "支付测试"; _prepayment = new Prepayment(); _prepayment.name = "TestPrepayment"; _prepayment.display_name = "测试支付包"; _prepayment.description = "充值即可获得大礼哦"; _prepayment.currency_type = CurrencyType.GOLDEN_EGG; _prepayment.currency_count = 20000; _prepayment.price = 6; _prepayment.pay_channel.Add(PayChannelType.IOS_IAP); _prepayment.pay_channel.Add(PayChannelType.ALIPAY_IOS); _prepayment.pay_channel.Add(PayChannelType.ALIPAY_CLIENT); _trade = new Trade(); _trade.pay_channel = PayChannelType.ALIPAY_IOS; _trade.out_trade_no = "KSLDHGKL21934"; }
public static Prepayment SelectById(string prepaymentId) { var connection = DatabaseConnection.Connection; using (var command = connection.CreateCommand()) { const string sql = "select * from T_Prepayment where Prepayment_Id = @id"; command.CommandText = sql; command.Parameters.AddWithValue("@id", prepaymentId); Logger.LogQuery($"execute sql = {sql}\r\n id = {prepaymentId}"); Prepayment prepayment = null; using (var reader = command.ExecuteReader()) { if (reader.Read()) { prepayment = new Prepayment(prepaymentId); //date if (connection.State == ConnectionState.Closed) { connection.Open(); } var date = reader["Prepayment_Warranty_Date"].ToString(); try { prepayment.WarrantyDate = DateConverter.StringToPersianDate(date); } catch (Exception e) { Logger.LogException(e); } } else { throw new ItemNotFoundException("prepayment", "id", prepaymentId); } } connection.Close(); return(prepayment); } }
/// <summary> /// 计算支付包等值的金蛋数量。 /// </summary> /// <returns></returns> public static long CalculateGeValue(Prepayment prepayment) { if (prepayment == null) { return(0); } var geCount = 0L; var ypCount = 0L; if (prepayment.currency_type == CurrencyType.GOLDEN_EGG) { geCount += prepayment.currency_count; } else if (prepayment.currency_type == CurrencyType.YIN_PIAO) { ypCount += prepayment.currency_count; } var extraPack = prepayment.extra_pack; if (extraPack != null && extraPack.Count > 0) { for (int i = 0; i < extraPack.Count; i++) { var cur = extraPack[i]; if (cur.type == CurrencyType.GOLDEN_EGG) { geCount += cur.count; } else if (cur.type == CurrencyType.YIN_PIAO) { ypCount += cur.count; } } } return(geCount + ypCount * 100); }
public void ApplyData(string reason, Prepayment prepayment) { _reason = reason; _data = prepayment; if (prepayment == null) { return; } if (PayContent) { if (!PayContent.gameObject.activeSelf) { PayContent.gameObject.SetActive(true); } var content = !string.IsNullOrEmpty(prepayment.display_name) ? "购买:" + prepayment.display_name : ""; PayContent.text = content; } if (PayPrice) { if (!PayPrice.gameObject.activeSelf) { PayPrice.gameObject.SetActive(true); } PayPrice.text = "价格:¥ " + prepayment.price; } if (Description) { if (!string.IsNullOrEmpty(prepayment.description)) { if (!Description.gameObject.activeSelf) { Description.gameObject.SetActive(true); } Description.text = prepayment.description; } else { if (Description.gameObject.activeSelf) { Description.gameObject.SetActive(false); } } } AnalyticPanelShow(); // 不再在客户端对支付渠道进行过滤。 var channelList = prepayment.pay_channel; // 因为releaseConfig本身就是针对各个不同渠道特殊性而设计的。 // 所以也应该是根据特殊的情况来进行过滤。 var featureSwitch = _featureSwitch.Read(); var extraCharge = featureSwitch != null && featureSwitch.extra_charge; #if UNITY_IOS if (featureSwitch == null || !extraCharge) { if (channelList != null && channelList.Count > 0) { for (int i = 0; i < channelList.Count; i++) { if (channelList[i] != PayChannelType.IOS_IAP) { channelList.RemoveAt(i); i--; } } } } #endif #if UNITY_ANDROID var configHolder = GetConfigHolder(); if (configHolder.XiaoMiMode && !extraCharge) { if (channelList != null && channelList.Count > 0) { for (int i = 0; i < channelList.Count; i++) { if (channelList[i] != PayChannelType.XIAOMI) { channelList.RemoveAt(i); i--; } } } } #endif if (channelList == null || channelList.Count <= 0) { // 数据错误,关闭支付列表,显示一个错误的提示。 EnableComponent(false, false, true); SetStateTxt("数据发生错误,无法支付!\n请联系下方客服QQ解决"); } else if (channelList.Count <= 1) { // 如果只有一种支付方式则直接开始支付。 StartPay(channelList[0]); } else { // 多于一种支付方式,则显示支付列表。 EnableComponent(true, false, false); if (PayChannelList) { PayChannelList.ApplyData(channelList); } } }