protected void Page_Load(object sender, EventArgs e)
{
int id = 0;
if (int.TryParse(Request.QueryString["id"], out id))
{
recharge = RechargeOperation.GetRechargeById(id);
}
FormDataBind();
}
/// <summary>
/// 绑定银行卡
/// </summary>
/// <returns></returns>
public ActionResult SetDrawAccount()
{
try
{
NameValueCollection parmas = WorkContext.postparms;
//包含imei号
if (parmas.Keys.Count != 7)
{
return(APIResult("error", "缺少请求参数"));
}
MD_DrawAccount draw = new MD_DrawAccount
{
Account = parmas["account"],
Username = parmas["username"],
Card = parmas["cardname"],
Cardnum = parmas["cardnum"],
Cardaddress = parmas["cardaddress"],
Drawpwd = parmas["pwd"]
};
bool result = Recharge.ValidateDrawPwd(parmas["account"]);
if (!result)
{
return(APIResult("error", "未设置提现密码"));
}
PartUserInfo partUserInfo = Users.GetPartUserByMobile(parmas["account"]);
draw.Drawpwd = Users.CreateUserPassword(draw.Drawpwd, partUserInfo.Salt);
bool pwdres = Recharge.ValidateDrawPwd(draw.Account, draw.Drawpwd);
if (!pwdres)
{
return(APIResult("error", "提现密码错误"));
}
bool saveres = Recharge.UpdateDrawCardInfo(draw);
if (saveres)
{
return(APIResult("success", "保存成功"));
}
else
{
return(APIResult("error", "保存失败"));
}
}
catch (Exception ex)
{
return(APIResult("error", "保存失败"));
}
}
//初始化兑换条目集合
private void initList()
{
list = new List <Recharge> ();
int[] sids = RechargeSampleManager.Instance.getAllRecharge();
int max = sids.Length;
for (int i = 0; i < max; i++)
{
Recharge re = new Recharge(sids [i], 0);
list.Add(re);
}
}
static int TryGetValue(IntPtr L)
{
LuaScriptMgr.CheckArgsCount(L, 3);
Dictionary <uint, Recharge> obj = (Dictionary <uint, Recharge>)LuaScriptMgr.GetNetObjectSelf(L, 1, "Dictionary<uint,Recharge>");
uint arg0 = (uint)LuaScriptMgr.GetNumber(L, 2);
Recharge arg1 = null;
bool o = obj.TryGetValue(arg0, out arg1);
LuaScriptMgr.Push(L, o);
LuaScriptMgr.PushObject(L, arg1);
return(2);
}
public ActionResult Create(Recharge recharge)
{
if (ModelState.IsValid)
{
db.Recharges.Add(recharge);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.CustomerID = new SelectList(db.Customers, "CustomerID", "CustomerName", recharge.CustomerID);
return(View(recharge));
}
/// <summary>
/// 提现申请
/// </summary>
/// <returns></returns>
public ActionResult UserDraw()
{
NameValueCollection parmas = WorkContext.postparms;
if (parmas.Keys.Count != 4)
{
return(APIResult("error", "缺少请求参数"));
}
string account = parmas["account"];
decimal money = decimal.Parse(parmas["money"]);
if (money < 100)
{
return(APIResult("error", "最低请提现100元宝"));
}
PartUserInfo partUserInfo = Users.GetPartUserByMobile(account);
if (partUserInfo.TotalMoney < money)
{
return(APIResult("error", "余额不足"));
}
string mdpwd = Users.CreateUserPassword(parmas["password"], partUserInfo.Salt);
bool pwdres = Recharge.ValidateDrawPwd(account, mdpwd);
if (!pwdres)
{
return(APIResult("error", "提现密码错误"));
}
DrawInfoModel draw = new DrawInfoModel
{
Account = account,
Money = int.Parse(parmas["money"]),
};
string addres = Recharge.AddDraw(draw);
if (addres.EndsWith("成功"))
{
return(APIResult("success", "申请成功"));
}
else if (addres == "-1")
{
return(APIResult("error", "余额不足"));
}
else
{
return(APIResult("error", "申请失败"));
}
}
public ActionResult DelBank(int id = -1)
{
bool result = Recharge.DeleteDrawAccount(id.ToString());
if (result)
{
return(PromptView("删除成功"));
}
else
{
return(PromptView("删除失败"));
}
}
public ActionResult ExistsDrawAcc()
{
List <MD_DrawAccount> draw = Recharge.GetDrawAccountList(1, -1, " where b.Uid=" + WorkContext.Uid + "");
if (draw == null || draw.Count == 0)
{
return(Content("1"));
}
else
{
return(Content("2"));
}
}
public ActionResult RechargeAmount(Recharge model)
{
if (ModelState.IsValid)
{
try
{
//开启事务,保证数据的一致性
using (var scope = new TransactionScope())
{
if (!OperateHelper.IsLogin())
{
return(JsonMsgNoOk("对不起，你没权限操作"));
}
if (!OperateHelper.User.IsAdmin)
{
return(JsonMsgNoOk("对不起，你没权限操作"));
}
var userModel = BLLSession.IUserService.GetModel(m => m.UserID == model.UserID);
//插入充值表
model.Status = (int)RechargeStatusEnum.Succeed;
model.IsDel = false;
model.CreateDate = DateTime.Now;
model.OpeningBalance = userModel.Amount;
model.CurrentBalance = userModel.Amount + model.RechargeAmount;
model.RechargeUserName = "******";
BLLSession.IRechargeService.Add(model);
//更新用户剩余金额
userModel.Amount = model.CurrentBalance;
BLLSession.IUserService.ModifyModel(userModel);
//插入数据到消费流水表
BLLSession.IExpendLogService.Add(new ExpendLog()
{
UserID = model.UserID,
ConsumeAmount = 0,
RechargeAmount = model.RechargeAmount,
CreateDate = DateTime.Now,
ExpendLogTypeID = model.RechargeID,
ExpendLogType = (int)ExpendLogTypeEnum.Recharge,
Description = "充值完成增加金额"
});
scope.Complete();//提交事务
}
return(JsonMsgOk("充值成功"));
}
catch (Exception ex)
{
return(JsonMsgNoOk(ex.Message));
}
}
return(JsonMsgNoOk("充值失败，信息填写有误"));
}
/// <summary>
/// 提现导出excel
/// </summary>
/// <param name="dt"></param>
/// <returns></returns>
public FileResult ExportExcel(string username = "", string mobile = "", string alipayaccount = "", string status = "")
{
StringBuilder strb = new StringBuilder();
strb.Append(" where 1=1 ");
if (username != "")
{
strb.Append(" and a.username like '%" + username + "%' ");
}
if (mobile != "")
{
strb.Append(" and a.mobile like '" + mobile + "%' ");
}
if (alipayaccount != "")
{
strb.Append(" and a.alipay like '" + alipayaccount + "%' ");
}
if (status != "-1")
{
strb.Append(" and a.state =" + status);
}
strb.Append(" order by a.[addtime] desc");
//编号、手机号、姓名、支付宝账号、提现金额、提现时间、状态（审核中、已完成）、异常信息(支持文本输入）
DataTable dt = Recharge.GetDrawListForDT(1, -1, strb.ToString());
Dictionary <string, string> listcol = new Dictionary <string, string>()
{
};
listcol["编号"] = "drawid"; listcol["手机"] = "mobile"; listcol["姓名"] = "username"; listcol["支付宝账号"] = "alipay"; listcol["提现金额"] = "money";
listcol["提现时间"] = "addtime";
listcol["状态"] = "state"; listcol["异常信息"] = "exception";
string html = ExcelHelper.BuildHtml(dt, listcol);
//第一种:使用FileContentResult
byte[] fileContents = Encoding.Default.GetBytes(html);
return(File(fileContents, "application/ms-excel", "提现信息" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".xls"));
////第二种:使用FileStreamResult
//var fileStream = new MemoryStream(fileContents);
//return File(fileStream, "application/ms-excel", "fileStream.xls");
////第三种:使用FilePathResult
////服务器上首先必须要有这个Excel文件,然会通过Server.MapPath获取路径返回.
//var fileName = Server.MapPath("~/Files/fileName.xls");
//return File(fileName, "application/ms-excel", "fileName.xls");
}
public Recharge Addpay(Recharge charge)
{
if (charge != null)
{
using (DataContext db = new SqlserverContext())
{
Table <Recharge> T_order = db.GetTable <Recharge>();
T_order.InsertOnSubmit(charge);
db.SubmitChanges();
return(charge);
}
}
return(null);
}
/// <summary>
/// 新增
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public JsonResult Add(Recharge entity)
{
ModelState.Remove("ID");
ModelState.Remove("CreatedUserID");
if (ModelState.IsValid)
{
var result = WebService.Add_Recharge(entity);
return(JResult(result));
}
else
{
return(ParamsErrorJResult(ModelState));
}
}
/// <summary>
/// 绑定银行卡
/// </summary>
/// <returns></returns>
public ActionResult SetDrawAccount()
{
try
{
NameValueCollection parmas = WorkContext.postparms;
var id = parmas["id"];
MD_DrawAccount draw = new MD_DrawAccount
{
Uid = WorkContext.Uid,
Username = parmas["username"],
Drawaccid = Convert.ToInt32(parmas["id"]),
Card = parmas["cardname"],
Cardnum = parmas["cardnum"],
Cardaddress = "",// parmas["cardaddress"],
Drawpwd = parmas["pwd"]
};
bool result = Recharge.ValidateDrawPwdByUid(WorkContext.Uid);
if (!result)
{
return(APIResult("error", "未设置提现密码"));
}
PartUserInfo partUserInfo = Users.GetPartUserById(WorkContext.Uid);
//draw.Drawpwd = Users.CreateUserPassword(draw.Drawpwd, partUserInfo.Salt);
bool pwdres = Recharge.ValidateDrawPwdByUid(WorkContext.Uid, draw.Drawpwd);
if (!pwdres)
{
return(APIResult("error", "提现密码错误"));
}
bool saveres = Recharge.UpdateDrawCardInfo(draw);
if (saveres)
{
return(APIResult("success", "保存成功"));
}
else
{
return(APIResult("error", "保存失败"));
}
}
catch (Exception ex)
{
return(APIResult("error", "保存失败"));
}
}
public bool cupPayment(Cup cup)
{
if (!String.IsNullOrWhiteSpace(cup.txnType) && !String.IsNullOrWhiteSpace(cup.txnTime) &&
!String.IsNullOrWhiteSpace(cup.respCode) && !String.IsNullOrWhiteSpace(cup.merId) &&
!String.IsNullOrWhiteSpace(cup.orderId) && !String.IsNullOrWhiteSpace(cup.payType) &&
!String.IsNullOrWhiteSpace(cup.payCardNo) && cup.txnAmt != 0)
{
//1.发送到消息队列 2.存入缓存
//交易成功
if (cup.respCode.Equals(Commons.CUP_SUCCESS))
{
Order order = alipayDb.QueryOrder(cup.orderId) as Order;
//存在该订单
if (order != null)
{
Recharge charge = new Recharge()
{
ID = Guid.NewGuid().ToString(),
UserID = order.UserID,
OrderID = cup.orderId,
//单位：分
Amount = cup.txnAmt,
Creater = Commons.orderHandler.USER.ToString(),
CreateTime = DateTime.Now.ToString(),
PayOrderID = cup.queryId,
Remark = "银联消费类交易交易",
Type = (int)Commons.PayType.RECHARGE
};
OrderLog orderlog = new OrderLog()
{
CarID = order.CarID,
CreateTime = DateTime.Now.ToString(),
OrderID = cup.orderId,
Remark = "银联订单支付完成",
State = (int)Commons.Type.USING,
Time = DateTime.Now.ToString(),
UserID = order.UserID
};
cupQueue.SendCup(cup);
cupQueue.SendRecharge(charge);
LogerHelper.debug("银联操作成功");
//cupQueue.SendOrderLog(orderlog);
return(true);
}
}
}
return(false);
}
public Sprite visorClosed; //closed visor sprite
//init
void Start()
{
//objects
theVisorInsideView = GameObject.FindWithTag(TAG_VISOR_INSIDEVIEW); //visor inside view game object in scene
theVisorRechargeView = GameObject.FindWithTag(TAG_VISOR_RECHARGEVIEW); //visor recharge view game object in scene
theVisorRechargeView.transform.position = new Vector3(theVisorRechargeView.transform.position.x - VISOR_OFFSET_UNITS_INIT, theVisorRechargeView.transform.position.y, theVisorRechargeView.transform.position.z); //offset initial position for recharge view (to align left charging, rather than center)
//properties
//audio
sfxVisorFullEnabled = true;
//scripts
theRecharge = GetComponent <Recharge>(); //get recharge script attached to object
theGazeMove = GetComponent <GazeMove>(); //get gazemove script attached to object
} //end function
public ActionResult EditBank(int id = -1)
{
ViewData["referer"] = ShopUtils.GetAdminRefererCookie();
List <MD_DrawAccount> list = Recharge.GetDrawAccountList(1, 1, " where a.drawaccid=" + id);
if (list.Count > 0)
{
MD_DrawAccount draw = list[0];
return(View(draw));
}
else
{
return(PromptView("获取用户银行卡信息失败"));
}
}
public Sprite visorClosed; //closed visor sprite
//init
void Start () {
//objects
theVisorInsideView = GameObject.FindWithTag(TAG_VISOR_INSIDEVIEW); //visor inside view game object in scene
theVisorRechargeView = GameObject.FindWithTag(TAG_VISOR_RECHARGEVIEW); //visor recharge view game object in scene
theVisorRechargeView.transform.position = new Vector3(theVisorRechargeView.transform.position.x - VISOR_OFFSET_UNITS_INIT, theVisorRechargeView.transform.position.y, theVisorRechargeView.transform.position.z); //offset initial position for recharge view (to align left charging, rather than center)
//properties
//audio
sfxVisorFullEnabled = true;
//scripts
theRecharge = GetComponent<Recharge>(); //get recharge script attached to object
theGazeMove = GetComponent<GazeMove>(); //get gazemove script attached to object
} //end function
// GET: Recharge
public ActionResult Index()
{
Recharge taskItem = new Recharge();
int page = 1;
page = string.IsNullOrWhiteSpace(Request.Params["page"]) ? 1 : int.Parse(Request.Params["page"]);
Dictionary <string, string> dic = new Dictionary <string, string>();
List <Recharge> itemList = BaseModelDB.Recharge.ToList();
var pageItem = taskItem.PageList(page, 10, "/recharge/index", ref itemList);
ViewBag.PageData = pageItem;
ViewBag.ListItem = itemList;
// modelDB.Task
return(View());
}
/// <summary>
/// 充值导出excel
/// </summary>
/// <param name="dt"></param>
/// <returns></returns>
public FileResult ExportExcelForRech(string mobile = "", string suite = "-1", string platform = "全部", string starttime = "", string endtime = "")
{
StringBuilder strb = new StringBuilder();
strb.Append(" where 1=1 ");
if (mobile != "")
{
strb.Append(" and a.account like '" + mobile + "%' ");
}
if (suite != "-1")
{
strb.Append(" and a.vossuiteid = " + suite + " ");
}
if (platform != "全部")
{
strb.Append(" and a.platform = '" + platform + "' ");
}
if (starttime != "" && endtime != "")
{
strb.Append(" and (convert(varchar(10),a.paytime,120) between '" + starttime + "' and '" + endtime + "')");
}
strb.Append(" order by a.addtime desc ");
DataTable dt = Recharge.GetRechargeListForDt(1, -1, strb.ToString());
Dictionary <string, string> listcol = new Dictionary <string, string>()
{
};
listcol["编号"] = "rechargeid"; listcol["手机号"] = "account"; listcol["姓名"] = "nickname"; listcol["职位"] = "userrank"; listcol["充值金额"] = "total_fee";
listcol["充值套餐"] = "suitename";
listcol["支付方式"] = "platform"; listcol["充值时间"] = "paytime";
string html = ExcelHelper.BuildHtml(dt, listcol);
//第一种:使用FileContentResult
byte[] fileContents = Encoding.Default.GetBytes(html);
return(File(fileContents, "application/ms-excel", "充值信息" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".xls"));
////第二种:使用FileStreamResult
//var fileStream = new MemoryStream(fileContents);
//return File(fileStream, "application/ms-excel", "fileStream.xls");
////第三种:使用FilePathResult
////服务器上首先必须要有这个Excel文件,然会通过Server.MapPath获取路径返回.
//var fileName = Server.MapPath("~/Files/fileName.xls");
//return File(fileName, "application/ms-excel", "fileName.xls");
}
protected override bool CreateRecharge(out Recharge thrid)
{
thrid = null;
HttpContextAccessor.HttpContext.Request.EnableRewind();
HttpContextAccessor.HttpContext.Request.Body.Position = 0;
var buffer = new MemoryStream();
HttpContextAccessor.HttpContext.Request.Body.CopyTo(buffer);
buffer.Position = 0;
StreamReader reader = new StreamReader(buffer);
var s = reader.ReadToEnd();
Dictionary <string, string> dic = JsonHelper.Json <Dictionary <string, string> >(s);
if (dic["status"] != "1")
{
LogHelper.Error($"一点付status状态码不为1，是{dic["status"]}");
return(false);
}
thrid = (from r in Context.Recharges where r.OrderNo == dic["out_trade_no"] select r).FirstOrDefault();
if (thrid == null)
{
LogHelper.Error($"一点付找不到订单[{dic["out_trade_no"]}]");
return(false);
}
StringBuilder sb = new StringBuilder();
string[] no = new[] { "sign", "bankcode", "client_ip" };
foreach (string k in dic.Keys.OrderBy(t => t))
{
if (!no.Contains(k))
{
sb.Append($"{k}={dic[k]}&");
}
}
//sb.Append("key=" + thrid.MerchantsBank.MerchantsKey);
//if (dic["sign"] != SecurityHelper.MD5Encrypt(sb.ToString().Trim()).ToUpper())
//{
// LogHelper.Error($"{sb.ToString().Trim()}");
// LogHelper.Error($"签名失败，我方签名[{SecurityHelper.MD5Encrypt(sb.ToString().Trim()).ToUpper()}]，对方签名[{ dic["sign"]}]");
// return false;
//}
return(true);
}
public bool alipayPayment(Com.ChinaPalmPay.Platform.RentCar.Model.Alipay alipay)
{
//验证是否是支付宝发出的通知
//如果alipay通知正确，存入消息队列
if (!String.IsNullOrWhiteSpace(alipay.out_trade_no) && alipay.total_fee != 0 && !String.IsNullOrWhiteSpace(alipay.trade_status) &&
!String.IsNullOrWhiteSpace(alipay.trade_no))
{
//1.发送到消息队列 2.存入缓存
//交易成功
if (alipay.trade_status.Equals(Commons.success) || alipay.trade_status.Equals(Commons.finished))
{
Order order = alipayDb.QueryOrder(alipay.out_trade_no);
if (order != null)
{
Recharge charge = new Recharge()
{
ID = Guid.NewGuid().ToString(),
UserID = order.UserID,
OrderID = alipay.out_trade_no,
//单位：分
Amount = alipay.total_fee * 100,
Creater = Commons.orderHandler.USER.ToString(),
CreateTime = DateTime.Now.ToString(),
PayOrderID = alipay.trade_no,
Remark = "支付宝交易",
Type = (int)Commons.PayType.RECHARGE
};
OrderLog orderlog = new OrderLog()
{
CarID = order.CarID,
CreateTime = DateTime.Now.ToString(),
OrderID = alipay.out_trade_no,
Remark = "支付宝订单支付完成",
State = (int)Commons.Type.USING,
Time = DateTime.Now.ToString(),
UserID = order.UserID
};
alipayQueue.Send(alipay);
alipayQueue.Send(charge);
//alipayQueue.Send(orderlog);
LogerHelper.debug("支付宝操作成功");
return(true);
}
}
}
return(false);
}
/// <summary>
/// 获取提现或充值提示
/// </summary>
/// <returns></returns>
public ActionResult GetTS()
{
List <OWZX.Model.DrawInfoModel> drawlist = Recharge.GetDrawList(1, -1, " where a.state in (0,1)");
List <OWZX.Model.MD_Remit> remitlist = NewUser.GetUserRemitList(1, -1, " where a.status in (0,1)");
int draw = 0; int remit = 0;
if (drawlist != null && drawlist.Count > 0)
{
draw = drawlist.Count;
}
if (remitlist != null && remitlist.Count > 0)
{
remit = remitlist.Count;
}
return(Content(draw.ToString() + "_" + remit.ToString()));
}
/// <summary>
/// 向充值表插入信息
/// </summary>
/// <param name="recharge">充值实体</param>
/// <returns>返回受影响行数</returns>
public int InsertRecharge(Recharge recharge)
{
//定义参数
SqlParameter[] sqlams = { new SqlParameter("@StudentCardno", recharge.StudentCardno),
new SqlParameter("@RechargeCash", recharge.RechargeCash),
new SqlParameter("@RechargeDate", recharge.RechargeDate),
new SqlParameter("@RechargeTime", recharge.RechargeTime),
new SqlParameter("@OpertionID", recharge.OpertionID),
new SqlParameter("@State", recharge.State) };
//定义SQL语句
string sql = @"insert into Recharge values(@StudentCardno,@RechargeCash,@RechargeDate,@RechargeTime,@OpertionID,@State)";
//执行SQL语句
int Relust = sqlHelper.ExecuteNonQuery(sql, sqlams, CommandType.Text);
return(Relust);//返回受影响行数
}
public ActionResult DelRecharge(int id)
{
Recharge rec = new Recharge()
{
Id = id
};
if (RechargeBll.Delete(rec))
{
return(Content("ok"));
}
else
{
return(Content("no"));
}
}
//init
void Start()
{
//debug
debugOn = false; //default to off
//properties
currentLevel = 0; //initial level
isGameOver = false; //initial flag
//objects
theCam = Camera.main; //main camera in scene
theGame = GameObject.FindWithTag(TAG_GAME); //game manager object in scene
theDimView = GameObject.FindWithTag(TAG_DIMVIEW); //dim view game object in scene
theVisor = GameObject.FindWithTag(TAG_VISOR); //visor object in scene
theVisorFrameView = GameObject.FindWithTag(TAG_VISOR_FRAMEVIEW); //visor frame view object in scene
theTargets = GameObject.FindWithTag(TAG_TARGETS); //targets game object container in scene
theTutorial = GameObject.FindWithTag(TAG_TUTORIAL); //tutorial game object container in scene
//scripts
theBounds = theGame.AddComponent <Bounds>(); //add new bounds script
theData = theGame.AddComponent <GazeDataManager>(); //add new data manager script
theWave = theGame.AddComponent <Wave>(); //add new wave script
theVisorRechargeScript = theVisor.GetComponent <Recharge>(); //visor recharge script
theVisorGazeMoveScript = theVisor.GetComponent <GazeMove>(); //visor gazemove script
//init tutorial wave
//a single target that must be destroyed to advance
theWave = theWave.waveWithPrefabParentLimits(target_00, theTargets, 1, 1, 0);
//update score
ScoreManager.Instance.resetScore();
UnityEngine.Debug.Log("[GameManager] Starting the game!");
//transition into scene via state manager
if (StateManager.Instance != null)
{
TransitionFade theTransition = StateManager.Instance.gameObject.GetComponent <TransitionFade>();
theTransition.toggleFade();
}
//audio
if (AudioManager.Instance != null)
{
AudioManager.Instance.toggleFade();
}
} //end function
/// <summary>
/// 查询充值记录
/// </summary>
/// <param name="Cardno">卡号</param>
/// <param name="form">充值窗体</param>
/// <returns>查询到的记录</returns>
DataTable SelectRechargeIBLL.Selectrechar(string Cardno, Form form, ref string StrMsg)
{
//用于返回信息
StrMsg = "";
//接受判空返回值，判断文本框是否为空。
string isNull = IsNull.isNull(form);
//接受是不是数字的判断返回值
bool isNumber = IsNull.IsNumber(Cardno);
//接受返回的充值记录
DataTable Selectrechar = new DataTable();
//判断卡号是否为空
if (isNull == "")//没有返回值，说明不为空
{
//判断卡号是不是数字
if (isNumber == true)//是数字
{
//调用查询记录的数据层接口和创建DAL层工厂，创建DAL层具体的类。
SelectRechargeIDAL selectRecharIDAL = (SelectRechargeIDAL)fact.CreateUser("SelectRechargeDAL");
//实例化充值实体与赋值
Recharge recharge = new Recharge();
recharge.StudentCardno = int.Parse(Cardno); //卡号赋值
Selectrechar = selectRecharIDAL.SelectRecharge(recharge); //查询充值记录里
#region 查询充值记录
//判断卡号是否存在
if (Selectrechar.Rows.Count == 0)//等于零说明账号不存在！
{
StrMsg = "账号不存在，或者没有充值记录！";
}
else
{
StrMsg = "查询完毕！";
}
#endregion
}
else
{
StrMsg = "卡号请输入数字!";
}
}
else
{
StrMsg = isNull;
}
return(Selectrechar);//返回查询信息
}
private void btnRecharge_Click(object sender, EventArgs e)
{
try
{
Recharge r = new Recharge {
Id = Convert.ToInt32(txtReId.Text), PhoneNumber = txtRePnumber.Text, Value = Convert.ToDecimal(txtReValue.Text), Date = Convert.ToDateTime(txtReDate.Text), State = 1
};
var json = SerializationHelpers.SerializeJson(r);
var resp = ResponseCallService(json, "POST", "Recharge");
var userinfo = SerializationHelpers.DeserializeJson <Response>(resp);
txtReResponse.Text = "Id Response: " + userinfo.idResponse + "\n Response: " + userinfo.response + "\n Exception: " + userinfo.exception;
}
catch (Exception ex)
{
txtReResponse.Text = "Oops... Something went wrong: \nException: " + ex.Message;
}
}
static int _CreateRecharge(IntPtr L)
{
int count = LuaDLL.lua_gettop(L);
if (count == 0)
{
Recharge obj = new Recharge();
LuaScriptMgr.PushObject(L, obj);
return(1);
}
else
{
LuaDLL.luaL_error(L, "invalid arguments to method: Recharge.New");
}
return(0);
}
/// <summary>
/// 完成提现转账
/// </summary>
public ActionResult EditDraw(int drawId, string exception, string type)
{
List <DrawInfoModel> listdraw = Recharge.GetDrawList(1, 15, " where drawid=" + drawId);
DrawInfoModel draw = new DrawInfoModel();
if (listdraw.Count > 0)
{
draw = listdraw[0];
}
else
{
return(AjaxResult("error", "提现信息不存在"));
}
if (type == "2")
{
//完成
draw.Updateuser = WorkContext.UserName;
if (exception == "")
{
draw.State = "2";
}
else
{
draw.State = "3";
}
draw.Exception = exception;
}
else if (type == "1")
{
//审核中
draw.Exception = "";
draw.Updateuser = WorkContext.UserName;
draw.State = "1";
}
bool result = Recharge.UpdateDraw(draw);
if (result)
{
return(AjaxResult("success", "处理成功"));
}
else
{
return(AjaxResult("error", "处理失败"));
}
}
/// <summary>
/// 设置提现密码
/// </summary>
/// <returns></returns>
public ActionResult DrawPwd()
{
try
{
NameValueCollection parmas = WorkContext.postparms;
MD_DrawAccount draw = new MD_DrawAccount
{
Uid = WorkContext.Uid,
Drawpwd = parmas["password"]
};
PartUserInfo partUserInfo = Users.GetPartUserById(WorkContext.Uid);
//draw.Drawpwd = Users.CreateUserPassword(draw.Drawpwd, partUserInfo.Salt);
if (parmas.AllKeys.Contains("oldpwd") && parmas["oldpwd"] != "")
{
//string oldpwd = Users.CreateUserPassword(parmas["oldpwd"], partUserInfo.Salt);
string oldpwd = parmas["oldpwd"];
bool pwdres = Recharge.ValidateDrawPwdByUid(WorkContext.Uid, oldpwd);
if (!pwdres)
{
return(APIResult("error", "原有密码错误"));
}
}
if (partUserInfo.Password == draw.Drawpwd)
{
return(APIResult("error", "提现密码和登录密码不能一致"));
}
bool saveres = Recharge.UpdateDrawPWD(draw);
if (saveres)
{
return(APIResult("success", "保存成功"));
}
else
{
return(APIResult("error", "保存失败"));
}
}
catch (Exception ex)
{
return(APIResult("error", "保存失败"));
}
}
/// <summary>
/// Execute an incoming Recharge request, calculating:
/// 1. Saving Recharge into DB
/// 2. Validating the Promotions for the Customer
/// </summary>
/// <param name="data">Stream with Json Data; Object: Recharge Entity</param>
/// <returns>Stream with Json Data; Object: Response Data</returns>
public Stream rechargePhoneNumber(Stream data)
{
try
{
string promAdv = string.Empty;
decimal valueProm = 0;
recharge = SerializationHelpers.DeserializeJson <Recharge>(data);
cus = dataAccess.getCustomerPerPhone(recharge.Id, recharge.PhoneNumber);
transValidations.validateCustomerSubscription(cus);
var res = dataAccess.phoneRecharge(recharge);
if (res != 0)
{
listCus = dataAccess.getLastCustomerBonus(cus.Id, cus.PhoneNumber);
if (listCus.Count() == 0)
{
customerPromotions(ref promAdv, ref valueProm);
}
else if (transValidations.validateGrantedBonus(listCus.OrderByDescending(c => c.ActivationDay).First().ActivationDay))
{
customerPromotions(ref promAdv, ref valueProm);
}
getCustomerBalance(valueProm);
resp.idResponse = res;
resp.response = "Recharged successfull, value: " + recharge.Value + ", " + (!string.IsNullOrEmpty(promAdv) ? promAdv : "");
resp.exception = null;
}
else
{
resp.idResponse = 1;
resp.response = "Recharged not complete";
resp.exception = null;
}
return(SerializationHelpers.GenerateStreamFromString(SerializationHelpers.SerializeJson <Response>(resp)));
}
catch (Exception ex)
{
resp.idResponse = 400;
resp.response = "Transaction: rechargePhoneNumber; Customer does not Exist. ";
resp.exception = ex.Message;
return(SerializationHelpers.GenerateStreamFromString(SerializationHelpers.SerializeJson <Response>(resp)));
}
}
/// <summary>
/// 删除提现
/// </summary>
public ActionResult DelDraw(int[] drawId)
{
List <DrawInfoModel> list = Recharge.GetDrawList(1, 15, " where drawid in (" + CommonHelper.IntArrayToString(drawId) + ")");
if (list.Count > 0)
{
bool result = Recharge.DeleteDraw(CommonHelper.IntArrayToString(drawId));
if (result)
{
return(PromptView("删除成功"));
}
else
{
return(PromptView("删除失败"));
}
}
return(PromptView("提现信息不存在"));
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
string clientName = Request.Form[txtClientName.ID].Trim();
string invoice = Request.Form[txtInvoice.ID].Trim();
string remark = Request.Form[txtRemark.ID].Trim();
string strReceivedTime = Request.Form[txtReceivedTime.ID].Trim();
DateTime receivedTime = new DateTime(1999, 1, 1);
if (string.IsNullOrEmpty(strReceivedTime) || !DateTime.TryParse(strReceivedTime, out receivedTime))
{
lblMsg.Text = "收款时间不能为空，且只能为时间格式！";
return;
}
if (string.IsNullOrEmpty(invoice) || Validator.IsMatchLessThanChineseCharacter(invoice, INVOICE_NUMBER_LENGTH))
{
lblMsg.Text = "发票号码不能为空，且长度不能超过" + INVOICE_NUMBER_LENGTH + "个字符！";
return;
}
if (string.IsNullOrEmpty(clientName) || clientName == "请输入客户姓名拼音的首字母" || Validator.IsMatchLessThanChineseCharacter(clientName, CLIENT_NAME_LENGTH))
{
lblMsg.Text = "客户姓名不能为空，且长度不能超过" + CLIENT_NAME_LENGTH + "个字符！";
return;
}
Client client = ClientOperation.GetClientByRealName(clientName);
if (client == null)
{
lblMsg.Text = "客户不存在！";
return;
}
if (!string.IsNullOrEmpty(remark) && Validator.IsMatchLessThanChineseCharacter(remark, REMARK_LENGTH))
{
lblMsg.Text = "备注长度不能超过" + REMARK_LENGTH + "个字符！";
return;
}
decimal paid = 0;
decimal exchangeRate = 1;
decimal money = 0;
if (ddlCurrencyType.SelectedItem.Value == "2")
{
if (!decimal.TryParse(Request.Form[txtClientPaid.ID].Trim(), out paid))
{
lblMsg.Text = "客户付款金额只能为数字！";
return;
}
if (!decimal.TryParse(Request.Form[txtExchangeRate.ID].Trim(), out exchangeRate))
{
lblMsg.Text = "当前汇率只能为数字！";
return;
}
string strActualReceived = Request.Form["txtActualReceived"];
if (!decimal.TryParse(strActualReceived, out money))
{
return;
}
}
else
{
if (!decimal.TryParse(Request.Form[txtReceivedMoney.ID], out money))
{
lblMsg.Text = "收款金额只能为数字！";
return;
}
}
if (money <= 0)
{
lblMsg.Text = "付款金额必须大于0！";
return;
}
Recharge recharge = new Recharge();
recharge.Account = ddlReceiveAccount.SelectedItem.Text;
recharge.ClientId = client.Id;
recharge.CreateTime = DateTime.Now;
recharge.UserId = user.Id;
recharge.CurrencyType = EnumConvertor.ConvertToCurrencyType(byte.Parse(ddlCurrencyType.SelectedItem.Value));
recharge.Encode = StringHelper.GetEncodeNumber("SK");
recharge.Invoice = invoice;
recharge.ExchangeRate = exchangeRate;
recharge.Money = money;
recharge.Paid = paid;
recharge.ReceiveTime = receivedTime;
recharge.Remark = remark;
RechargeOperation.CreateRecharge(recharge);
decimal balance = client.Balance + money;
client.Balance = balance;
ClientOperation.UpdateClientBalance(client);
List<ShouldReceive> result = ShouldReceiveOperation.GetShouldReceiveByClientId(client.Id);
if (result.Count > 0)
{
foreach (ShouldReceive sr in result)
{
if (sr.Money <= money)
{
sr.Status = true;
sr.Type = "订单已收";
sr.ReceiveTime = DateTime.Now;
ShouldReceiveOperation.UpdateShouldReceive(sr);
ReceivedDeducted rd = new ReceivedDeducted();
rd.Money = sr.Money;
rd.Client = client;
rd.ArEncode = recharge.Encode;
rd.ArAccount = recharge.Account;
rd.ArUserId = recharge.UserId;
rd.SrEncode = sr.Encode;
rd.CreateTime = DateTime.Now;
rd.CompanyId = client.CompanyId;
ShouldReceiveOperation.CreateReceivedDeducted(rd);
money = money - sr.Money;
}
else if (money > 0)
{
sr.Money = sr.Money - money;
ShouldReceiveOperation.UpdateShouldReceive(sr);
ReceivedDeducted rd = new ReceivedDeducted();
rd.Money = money;
rd.Client = client;
rd.ArEncode = recharge.Encode;
rd.ArAccount = recharge.Account;
rd.ArUserId = recharge.UserId;
rd.SrEncode = sr.Encode;
rd.CreateTime = DateTime.Now;
rd.CompanyId = client.CompanyId;
ShouldReceiveOperation.CreateReceivedDeducted(rd);
sr.Money = money;
sr.Status = true;
sr.Type = "订单已收";
sr.ReceiveTime = DateTime.Now;
ShouldReceiveOperation.CreateOrderShouldReceive(sr);
money = 0;
MailSend(client, recharge.Money);
}
}
}
MailSend(client, recharge.Money);
}
//init
void Start () {
//debug
debugOn = false; //default to off
//properties
currentLevel = 0; //initial level
isGameOver = false; //initial flag
//objects
theCam = Camera.main; //main camera in scene
theGame = GameObject.FindWithTag(TAG_GAME); //game manager object in scene
theDimView = GameObject.FindWithTag(TAG_DIMVIEW); //dim view game object in scene
theVisor = GameObject.FindWithTag(TAG_VISOR); //visor object in scene
theVisorFrameView = GameObject.FindWithTag(TAG_VISOR_FRAMEVIEW); //visor frame view object in scene
theTargets = GameObject.FindWithTag(TAG_TARGETS); //targets game object container in scene
theTutorial = GameObject.FindWithTag(TAG_TUTORIAL); //tutorial game object container in scene
//scripts
theBounds = theGame.AddComponent<Bounds>(); //add new bounds script
theData = theGame.AddComponent<GazeDataManager>(); //add new data manager script
theWave = theGame.AddComponent<Wave>(); //add new wave script
theVisorRechargeScript = theVisor.GetComponent<Recharge>(); //visor recharge script
theVisorGazeMoveScript = theVisor.GetComponent<GazeMove>(); //visor gazemove script
//init tutorial wave
//a single target that must be destroyed to advance
theWave = theWave.waveWithPrefabParentLimits(target_00, theTargets, 1, 1, 0);
//update score
ScoreManager.Instance.resetScore();
UnityEngine.Debug.Log("[GameManager] Starting the game!");
//transition into scene via state manager
if (StateManager.Instance != null) {
TransitionFade theTransition = StateManager.Instance.gameObject.GetComponent<TransitionFade>();
theTransition.toggleFade();
}
//audio
if (AudioManager.Instance != null) {
AudioManager.Instance.toggleFade();
}
} //end function
