public static void UpdatePayRecord(Pay_Record pay_record)
{
string sql = @"update `pay_record` set
pay_method=@pay_method
response=@response,
transaction_date=@transaction_date
where orderuuid = @orderuuid";
ExecuteNonQueryByEntity(sql, pay_record);
}
[WebMethod]//20.添加充值订单
public bool AddPayRecord(string Guid, Pay_Record pay)
{
var accId = GetLoginId(Guid);
if (accId == 0)
{
return(false);
}
pay.userId = accId;
return(PayDAL.AddPayRecord(pay));
}
private void button1_Click(object sender, EventArgs e)
{
var dic = client.GetLotteryList(guid);
var a = client.GetBetInfo(guid, 489);
//button1.Text = ++i+"";
//WebService1SoapClient client1 = new WebService1SoapClient();
//var list = client1.GetLotteryList(guid);
WS_BetInfo[] list = new WS_BetInfo[1];
list[0] = new WS_BetInfo();
list[0].BetNum = "0||||";
list[0].BetPlayTypeCode = 93;
list[0].BetUnit = 1;
list[0].BetMoneyMode = "元";
list[0].BetMoney = 2;
list[0].ChoicePosition = "";
list[0].IsGetBackPercent = false;
list[0].BetTimes = 1;
var asb = client.SendBetInfo(guid, 1, "20170809117", list);
Pay_Record record = new Pay_Record
{
mchtOrderId = "",
orderNO = "NO20170810162401",
orderAmount = 12,
orderDatetime = "20170810042401",
payerName = "",
payerEmail = "",
payerTelephone = "",
paydatetime = "",
payType = 0,
merchantId = "100020091219001",
productName = "12123",
productId = null,
productDesc = null,
productNum = 1,
productPrice = 12,
ext1 = null,
ext2 = null
};
//var flag = client.AddPayRecord(guid, record);
// var list1=client.GetBetInfoList1(guid, 1, DateTime.Now, DateTime.Now, null, null, false);
// var flag= client.DonePayRecord("ewd2asr87ghht9rt4wqw78e2qw778wds21x777gjd","NO20170810162401", 1, "20170810200254", 0);
//var a= client.GetBetInfo(guid, 1664430);
//var a = client.Withdraw(guid,new decimal(0.1), "6227007102080017916", "中国建设银行");
}
public static void CreatePayRecord(Pay_Record pay_record)
{
string sql = @"insert into `pay_record` (
orderuuid,
pay_method,
response,
transaction_date
)
values
(
@orderuuid,
@pay_method,
@response,
@transaction_date
)";
ExecuteNonQueryByEntity(sql, pay_record);
}
public static void DeletePayRecord(Pay_Record pay_record)
{
string sql = @"update from `pay_record` set Deleted=1 where orderuuid = @orderuuid";
ExecuteNonQueryByEntity(sql, pay_record);
}