//還回購物時扣除的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;
}
