public TradeInfoLog AddCardlog() { var cryptoHelper = new CryptoHelper(Key, Vi); var jsonString = cryptoHelper.DecryptAesString(TradeInfo); TradeInfoLog log = JsonConvert.DeserializeObject <TradeInfoLog>(jsonString); try { string strsql = @"insert into TradeInfolog (MerchantID, Amt, TradeNo, MerchantOrderNo, RespondType, IP, EscrowBank,PaymentType, RespondCode, Auth, Card6No, Card4No,Exp ,TokenUseStatus, InstFirst, InstEach, Inst, ECI, PayTime,PaymentMethod, status,ord_code ) values ( @MerchantID, @Amt, @TradeNo, @MerchantOrderNo, @RespondType, @IP, @EscrowBank,@PaymentType, @RespondCode, @Auth, @Card6No, @Card4No,@Exp , @TokenUseStatus, @InstFirst, @InstEach, @Inst, @ECI, @PayTime,@PaymentMethod, @status,@ord_code)"; NameValueCollection nvc = new NameValueCollection { { "MerchantID", MerchantId }, { "Amt", log.Result.Amt }, { "TradeNo", log.Result.TradeNo }, { "MerchantOrderNo", log.Result.MerchantOrderNo }, { "RespondType", log.Result.RespondType ?? "" }, { "IP", log.Result.IP ?? "" }, { "EscrowBank", log.Result.EscrowBank ?? "" }, { "PaymentType", log.Result.PaymentType ?? "" }, { "RespondCode", log.Result.RespondCode ?? "" }, { "Auth", log.Result.Auth ?? "" }, { "Card6No", log.Result.Card6No ?? "" }, { "Card4No", log.Result.Card4No ?? "" }, { "Exp", log.Result.Exp ?? "" }, { "TokenUseStatus", log.Result.TokenUseStatus ?? "" }, { "InstFirst", log.Result.InstFirst ?? "" }, { "InstEach", log.Result.InstEach ?? "" }, { "Inst", log.Result.Inst ?? "" }, { "ECI", log.Result.ECI ?? "" }, { "PayTime", log.Result.PayTime }, { "PaymentMethod", log.Result.PaymentMethod ?? "" }, { "status", Status }, { "ord_code", log.Result.MerchantOrderNo } }; DbControl.Data_add(strsql, nvc); if (Status == "SUCCESS") { strsql = @"update tbl_OrderData set paid='Y' ,status='2' where ord_code=@ord_code"; nvc.Clear(); nvc.Add("ord_code", log.Result.MerchantOrderNo); DbControl.Data_add(strsql, nvc); } } catch (Exception e) { unity.classlib.SendsmtpMail("*****@*****.**", "error", e.Message); } return(log); }
public static TradeInfoLog Get_Tradelog(string ord_code) { TradeInfoLog log = new TradeInfoLog(); string strsql = @"select * FROM TradeInfolog where ord_code=@ord_code order by secno "; NameValueCollection nvc = new NameValueCollection { { "ord_code", ord_code } }; DataTable dt = DbControl.Data_Get(strsql, nvc); TradeInfoResult result = new TradeInfoResult { TradeNo = "", MerchantOrderNo = "", PaymentType = "", RespondCode = "", Auth = "", Card6No = "", Card4No = "", PayTime = "", PaymentMethod = "", ExpireDate = "", ExpireTime = "", BankCode = "", CodeNo = "", Amt = "", Exp = "" }; if (dt.Rows.Count > 0) { log.Status = dt.Rows[0]["status"].ToString(); result = new TradeInfoResult { TradeNo = dt.Rows[0]["TradeNo"].ToString(), MerchantOrderNo = dt.Rows[0]["MerchantOrderNo"].ToString(), PaymentType = dt.Rows[0]["PaymentType"].ToString(), RespondCode = dt.Rows[0]["RespondCode"].ToString(), Auth = dt.Rows[0]["Auth"].ToString(), Card6No = dt.Rows[0]["Card6No"].ToString(), Card4No = dt.Rows[0]["Card4No"].ToString(), PayTime = dt.Rows[0]["PayTime"].ToString(), PaymentMethod = dt.Rows[0]["PaymentMethod"].ToString(), ExpireDate = dt.Rows[0]["ExpireDate"].ToString(), ExpireTime = dt.Rows[0]["ExpireTime"].ToString(), BankCode = dt.Rows[0]["BankCode"].ToString(), CodeNo = dt.Rows[0]["CodeNo"].ToString(), Amt = dt.Rows[0]["Amt"].ToString(), Exp = dt.Rows[0]["Exp"].ToString() }; } log.Result = result; dt.Dispose(); return(log); }
public TradeInfoLog AddAtmlog() { var cryptoHelper = new CryptoHelper(Key, Vi); var jsonString = cryptoHelper.DecryptAesString(TradeInfo); TradeInfoLog log = JsonConvert.DeserializeObject <TradeInfoLog>(jsonString); string strsql = @"insert into TradeInfolog (MerchantID, Amt, TradeNo, MerchantOrderNo, RespondType, PaymentType, ExpireDate,ExpireTime, BankCode,CodeNo,status,ord_code ) values ( @MerchantID, @Amt, @TradeNo, @MerchantOrderNo, @RespondType, @PaymentType, @ExpireDate,@ExpireTime, @BankCode,@CodeNo,@status ,@ord_code)"; NameValueCollection nvc = new NameValueCollection { { "MerchantID", MerchantId }, { "Amt", log.Result.Amt }, { "TradeNo", log.Result.TradeNo }, { "MerchantOrderNo", log.Result.MerchantOrderNo }, { "PaymentType", log.Result.PaymentType }, { "RespondType", log.Result.RespondType }, { "ExpireDate", log.Result.ExpireDate ?? "" }, { "ExpireTime", log.Result.ExpireTime ?? "" }, { "BankCode", log.Result.BankCode ?? "" }, { "CodeNo", log.Result.CodeNo ?? "" }, { "status", Status }, { "ord_code", log.Result.MerchantOrderNo } }; try { DbControl.Data_add(strsql, nvc); } catch (Exception e) { unity.classlib.SendsmtpMail("*****@*****.**", "error", e.Message); } return(log); }
public static OrderData Get_ordData(string ord_code) { OrderData o = new OrderData(); DataTable dt = new DataTable(); string strsql = @"select * FROM tbl_OrderData where ord_code=@ord_code"; NameValueCollection nvc = new NameValueCollection { { "ord_code", ord_code } }; dt = DbControl.Data_Get(strsql, nvc); o.Ord_code = ord_code; o.Ord_id = 0; if (dt.Rows.Count > 0) { o.Ord_id = (int)dt.Rows[0]["ord_id"]; o.Ordphone = dt.Rows[0]["ordphone"].ToString(); o.Paymode = dt.Rows[0]["paymode"].ToString(); o.Status = dt.Rows[0]["status"].ToString(); o.Orddate = DateTime.Parse(dt.Rows[0]["ord_date"].ToString()); o.TotalPrice = (int)dt.Rows[0]["TotalPrice"]; o.Ordname = dt.Rows[0]["ordname"].ToString(); o.Memberid = dt.Rows[0]["Memberid"].ToString(); o.Delivery_kind = dt.Rows[0]["delivery_kind"].ToString(); o.Ordemail = dt.Rows[0]["email"].ToString(); o.Ordname = dt.Rows[0]["ordname"].ToString(); o.Shipphone = dt.Rows[0]["shipname"].ToString(); o.Shipname = dt.Rows[0]["shipphone"].ToString(); o.Shipaddress = dt.Rows[0]["shipaddress"].ToString(); o.Title = dt.Rows[0]["title"].ToString(); o.Companyno = dt.Rows[0]["companyno"].ToString(); o.Shipzip = dt.Rows[0]["zip"].ToString(); o.Ordaddress = dt.Rows[0]["ordaddress"].ToString(); string countyid = dt.Rows[0]["countryid"].ToString(); strsql = @"select * FROM tbl_city where cityid=@id"; nvc.Clear(); nvc.Add("id", dt.Rows[0]["cityid"].ToString()); dt = DbControl.Data_Get(strsql, nvc); //county縣 ItemData item = new ItemData(); if (dt.Rows.Count > 0) { item.Id = (int)dt.Rows[0]["cityid"]; item.Name = dt.Rows[0]["cityname"].ToString(); } o.Shipcity = item; dt.Dispose(); nvc.Clear(); if (countyid != "") { strsql = @"select * FROM tbl_county where countyid=@id"; nvc.Add("id", countyid); dt = DbControl.Data_Get(strsql, nvc); item = new ItemData(); if (dt.Rows.Count > 0) { item.Id = (int)dt.Rows[0]["countyid"]; item.Name = dt.Rows[0]["countyname"].ToString(); } o.Shipcounty = item; dt.Dispose(); } strsql = @"select * FROM tbl_OrderDetail INNER JOIN tbl_productData ON tbl_OrderDetail.p_id = tbl_productData.p_id where ord_id=@ord_id"; nvc.Clear(); nvc.Add("ord_id", o.Ord_id.ToString()); dt = DbControl.Data_Get(strsql, nvc); List <OrderDetail> detail = new List <OrderDetail>(); for (int i = 0; i <= dt.Rows.Count - 1; i++) { detail.Add(new OrderDetail { P_id = (int)dt.Rows[i]["p_id"], Num = (int)dt.Rows[i]["num"], Price = (int)dt.Rows[i]["Price"], Amount = (int)dt.Rows[i]["Amount"], Discount = (int)dt.Rows[i]["Discount"], P_name = dt.Rows[i]["productname"].ToString(), Pic = dt.Rows[i]["logo"].ToString() }); } TradeInfoLog log = Get_Tradelog(ord_code); o.TradeInfoLog = log; o.OrderDetail = detail; } return(o); }