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);
}
