//還回購物時扣除的hg點數 public string AccumulatedUserHG(int deductHg, HgDeduct hd) { StringBuilder sql = new StringBuilder(); try { if (deductHg != 0 && (!string.IsNullOrEmpty(hd.order_id))) { sql.Append(" INSERT INTO hg_accumulate_refund "); sql.Append(" (enc_idno,chk_sum,transaction_date,merchant,terminal,refund_point,category,wallet,note,order_id) "); sql.AppendFormat(" values ('{0}','{1}','{2}','{3}','{4}'", hd.enc_idno, hd.chk_sum, DateTime.Now, 6601000081, 13999501); sql.AppendFormat(" ,'{0}','{1}','{2}','{3}','{4}')", deductHg, "N0699999", 991991, "吉甲地台灣好市集訂單編號" + hd.order_id + "扣除點數:" + deductHg + "點", hd.order_id); } return sql.ToString(); } catch (Exception ex) { throw new Exception("OrderReturnMasterDao.AccumulatedUserHG-->" + ex.Message + sql.ToString(), ex); } }
public string InsertHGAccRefund(HgDeduct hg_deduct, int accumulated_happygo, uint order_id) { //要改**********************// StringBuilder sql = new StringBuilder(); try { sql.AppendFormat(@"insert into hg_accumulate_refund (enc_idno,chk_sum,transaction_date,"); sql.AppendFormat(@"merchant,terminal,refund_point,category,wallet,note,order_id)"); sql.AppendFormat(@" values('{0}','{1}','{2}','{3}',", hg_deduct.enc_idno, hg_deduct.chk_sum, DateTime.Now.ToString("yyyyMMddHHmmss"), "6601000081"); sql.AppendFormat(@"'{0}','{1}','{2}','{3}',", "13999501", accumulated_happygo, "N0699999", "991991"); sql.AppendFormat(@"'{0}','{1}')", "吉甲地台灣好市集訂單編號" + order_id + "扣除點數:" + accumulated_happygo + "點", order_id); return sql.ToString(); } catch (Exception ex) { throw new Exception("OrderReturnStatusDao.InsertHGAccRefund-->" + ex.Message + sql.ToString(), ex); } }
public StreamReader GetUrl(OrderReturnMasterQuery query, HgDeduct hd) { WebClient wc = new WebClient(); string url = query.HgReturnUrl + "?MERCHANT_POS=" + query.HgMerchandID + "&TERMINAL_POS=" + query.HgTeminalID + "&ENC_IDNO=" + hd.enc_idno + "&CHK_SUM=" + hd.chk_sum + "&TOKEN=" + hd.token + "&ORDER_ID=" + hd.order_id; Stream stream = wc.OpenRead(url); StreamReader sr = new StreamReader(stream); return sr; }