internal static int Add(RechargeCheck model)
{
using (var cn = new MySqlConnection(sqlconnectionString))
{
cn.Open();
int i = cn.Execute(@"insert into RechargeCheck(SerialNo,UserID,ProductID,Money,CreateTime) values (@SerialNo,@UserID,@ProductID,@Money,@CreateTime);", model);
cn.Close();
return(i);
}
}
internal static int Delete(RechargeCheck model)
{
using (var cn = new MySqlConnection(sqlconnectionString))
{
cn.Open();
int i = cn.Execute(@"delete from RechargeCheck where SerialNo = @SerialNo", model);
cn.Close();
return(i);
}
}
internal static int Update(RechargeCheck model)
{
using (var cn = new MySqlConnection(sqlconnectionString))
{
cn.Open();
int i = cn.Execute(@"update RechargeCheck set SerialNo = @SerialNo, UserID = @UserID, ProductID = @ProductID, Money = @Money where ID = @ID", model);
cn.Close();
return(i);
}
}
internal static RechargeCheck GetModelBySerialNo(RechargeCheck model)
{
using (var cn = new MySqlConnection(sqlconnectionString))
{
cn.Open();
IEnumerable <RechargeCheck> i = cn.Query <RechargeCheck>(@"select * from RechargeCheck where SerialNo = @SerialNo", model);
cn.Close();
return(i.FirstOrDefault());
}
}
internal static IEnumerable <RechargeCheck> GetModelByUserID(RechargeCheck model)
{
using (var cn = new MySqlConnection(sqlconnectionString))
{
cn.Open();
IEnumerable <RechargeCheck> i = cn.Query <RechargeCheck>(@"
select r.* from " + database2 + @".RechargeCheck as r left JOIN " + database1 + @".QQZoneRecharge as q on r.SerialNo = q.BillNo
where r.UserID = @UserID and r.SerialNo like 'AppTreasure%' and q.BillNo is NULL", model);
cn.Close();
return(i);
}
}
public static RechargeCheck GetModelBySerialNo(RechargeCheck model)
{
return(RechargeCheckDAL.GetModelBySerialNo(model));
}
public static int Update(RechargeCheck model)
{
return(RechargeCheckDAL.Update(model));
}
public static IEnumerable <RechargeCheck> GetModelByUserID(RechargeCheck mi)
{
return(RechargeCheckDAL.GetModelByUserID(mi));
}
public static RechargeCheck GetModelByID(RechargeCheck mi)
{
return(RechargeCheckDAL.GetModelByID(mi));
}
public static int Add(RechargeCheck model)
{
return(RechargeCheckDAL.Add(model));
}
public static int Delete(RechargeCheck model)
{
return(RechargeCheckDAL.Delete(model));
}
public ActionResult YeePay(Dictionary <string, string> queryvalues)
{
string _data = queryvalues.ContainsKey("data") ? queryvalues["data"] : string.Empty;
string _encryptkey = queryvalues.ContainsKey("encryptkey") ? queryvalues["encryptkey"] : string.Empty;
if (_data == string.Empty || _encryptkey == string.Empty)
{
Response.Redirect("mobilecall://fail");
return(Content("参数不正确!"));
}
try
{
//商户注意：接收到易宝的回调信息后一定要回写success用以保证握手成功！
//Response.Write("success");
YeepayCallback model = new YeepayCallback();
model.Data = _data;
model.EncryptKey = _encryptkey;
model.CallBackResult = YJPayUtil.checkYbCallbackResult(_data, _encryptkey);//解密易宝支付回调结果
JsonToInstance util = new JsonToInstance();
YeepayCallbackReslut m = util.ToInstance <YeepayCallbackReslut>(model.CallBackResult);
RechargeCheck rc = RechargeCheckBLL.GetModelBySerialNo(new RechargeCheck {
SerialNo = m.orderid
});
#if Debug
Role user = RoleBLL.GetModelByID(new Role {
ID = rc.UserID
});
#endif
#if P17
Role user = RoleBLL.GetModelByID(new Role {
ID = rc.UserID
});
#endif
#if Release
Role user = RoleBLL.GetModelByID(new Role {
ID = rc.UserID
});
#endif
IAPProduct iap = IAPProductBLL.GetModelByID(rc.ProductID);
isFirst iF = iap.product_id.Split('_')[0].Equals("firstCharge")?isFirst.是:isFirst.否;
chipType ct = iF == isFirst.是 ? chipType.首冲礼包 : (chipType)iap.goodsType;
bool firstGif = iF == isFirst.是;
uint gold = iap.goodsType == 1 ? (uint)iap.goods : 0;
uint dia = iap.goodsType == 2 ? (uint)iap.goods : 0;
if (firstGif)
{
gold = (uint)(iap.goods + iap.attach_chip);
dia = (uint)iap.attach_5b;
}
uint rmb = (uint)(rc.Money / 100);
normal ServiceNormalS = normal.CreateBuilder()
.SetUserID((uint)rc.UserID)
.SetGold(gold)
.SetDia(dia)
.SetRmb(rmb)
.SetFirstGif(firstGif)
.Build();
Bind tbind = Cmd.runClient(new Bind(BR_Cmd.BR_NORMAL, ServiceNormalS.ToByteArray()));
switch ((CenterCmd)tbind.header.CommandID)
{
case CenterCmd.CS_NORMAL:
normalRep ServiceNormalC = normalRep.ParseFrom(tbind.body.ToBytes());
if (ServiceNormalC.Suc)
{
RechargeBLL.Add(new Recharge {
BillNo = m.yborderid, OpenID = rc.SerialNo, UserID = rc.UserID, Money = rc.Money, CreateTime = DateTime.Now, Chip = gold, ChipType = ct, IsFirst = iF, NickName = iap.productname, PayItem = iap.product_id, PF = raType.易宝, UserAccount = user.NickName
});
RechargeCheckBLL.Delete(new RechargeCheck {
SerialNo = m.orderid
});
//Response.Redirect("mobilecall://success");
return(RedirectToAction("success", "Home"));
}
//Response.Redirect("mobilecall://fail?suc=" + ServiceNormalC.Suc);
break;
case CenterCmd.CS_CONNECT_ERROR:
break;
}
//Response.Redirect("mobilecall://fail");
return(RedirectToAction("fail", "Home"));
}
catch (Exception err)
{
//Response.Redirect("mobilecall://fail?err=" + err);
return(RedirectToAction("fail", "Home"));
//return Content("支付失败!" + err);
}
}
