/// <summary> /// Create a new RequstMoney /// </summary> /// <param name="newRequstMoney">new RequstMoney</param> /// <returns>new RequstMoney id</returns> public Guid Create(RequstMoney newRequstMoney) { string sql = string.Format("EXEC sp_requestmoney_c {0},{1},{2},{3},{4},{5},{6},{7},{8}" , ToQuote(newRequstMoney.ID) , ToQuote(newRequstMoney.Username) , ToQuote(newRequstMoney.Money) , ToQuote(newRequstMoney.Msg) , ToQuote(DateTime.Now) , ToQuote(CurrentUserName) , ToQuote(DateTime.Now) , ToQuote(CurrentUserName) , ToQuote(newRequstMoney.Statues) ); try { int rowcount = SqlHelper.ExecuteNonQuery(ConnectStr, CommandType.Text, sql); if (rowcount == 1) { return(newRequstMoney.ID); } else { throw new Exception("SQL execution failed"); } } catch (Exception ex) { throw new Exception("SQL execution failed", ex); } }
/// <summary> /// Delete an existing RequstMoney /// </summary> /// <param name="thisRequstMoney">RequstMoney</param> /// <returns>bool</returns> public bool Delete(RequstMoney thisRequstMoney) { string sql = string.Format("exec dbo.sp_RequstMoney_d {0} " , ToQuote(thisRequstMoney.ID) ); try { int rowcount = SqlHelper.ExecuteNonQuery(ConnectStr, CommandType.Text, sql); if (rowcount >= 1) { return(true); } else { throw new Exception("SQL execution failed"); } } catch (Exception ex) { throw new Exception("SQL execution failed", ex); } }
/// <summary> /// Don't repeat yourself! This private function is for shared by all query public functions /// </summary> /// <param name="sql"></param> /// <param name="page"></param> /// <param name="pg"></param> /// <returns></returns> IList <RequstMoney> GetRequstMoneys(string sql, int page, string sortKey, out PaginationInfo paging) { using (DataSet ds = SqlHelper.ExecuteDataset(ConnectStr, CommandType.Text, sql)) { if (ds == null || ds.Tables.Count != 2) { throw new Exception("SQL execution failed"); } else { List <RequstMoney> Comments = new List <RequstMoney>(); foreach (DataRow dr in ds.Tables[0].Rows) { RequstMoney Comment = new RequstMoney() { ID = new Guid(dr["id"].ToString()), Msg = ParseStr(dr["Msg"]), Money = ParseDecimal(dr["Money"]), Statues = ParseInt(dr["Statues"]), Username = ParseStr(dr["Username"]), Createby = ParseStr(dr["Createby"]), Createtime = ParseStr(dr["Createtime"]), Updateby = ParseStr(dr["Updateby"]), Updatetime = ParseStr(dr["Updatetime"]) }; Comments.Add(Comment); } paging = new PaginationInfo() { Current = page, Size = ParseInt(ds.Tables[1].Rows[0]["pagesize"]), TotalRecords = ParseInt(ds.Tables[1].Rows[0]["totalrecords"]), TotalPages = (int)Math.Ceiling(ParseInt(ds.Tables[1].Rows[0]["totalrecords"]) / ParseFloat(ds.Tables[1].Rows[0]["pagesize"])) }; return(Comments); } } }
public JsonResult RequestMoneyNodeal(string id, string msg) { PaginationInfo paging = new PaginationInfo(); RequstMoney money = irequestmoney.Get(new Guid(id)); money.Msg = msg; ResultMsg result = new ResultMsg { Msg = "操作失败", Result = false }; bool isupdate = irequestmoney.Update(money); if (isupdate) { if (msg.Contains("提现失败")) { ReduceUserPoint4(money.Username, money.Money, "提现失败,返回余额:" + money.Money.ToString()); } result.Msg = "操作成功"; result.Result = true; } return(Json(result, JsonRequestBehavior.AllowGet)); }
public JsonResult RequestMoneyToServer(string money) { PaginationInfo paging2 = new PaginationInfo(); IList <User> users = iuser.Get(null, UserName, null, null, null, null, null, null, null, null, 1, 0, null, out paging2); User user = users[0]; //IList<SettingGroup> settings = isetting.GetSystemSetting(); //string ratestr = GetSettingVal(settings, "3396287A-DCF3-4701-8D44-9B3C515D5DEF"); //string moneyratestr = GetSettingVal(settings, "2AADE1C6-59BE-4B0E-927C-7B28BFC8C397"); //decimal rate = decimal.Parse(ratestr); //decimal moneyrate = decimal.Parse(moneyratestr); //decimal availmoney = (1 - rate) * (user.Point - user.FreezePoint) / moneyrate; decimal balance = user.Balance; decimal requestmoney = decimal.Parse(money); ResultMsg msg = new ResultMsg(); try { if (requestmoney < 100) { msg.Msg = "提现金额必须大于等于100元"; msg.Result = false; return(Json(msg, JsonRequestBehavior.AllowGet)); } if (requestmoney > balance) { //ModelState.AddModelError("", "可用积分不够,您最多只能兑换" + ((int)availmoney).ToString() + "元"); msg.Msg = "可用余额不够"; msg.Result = false; return(Json(msg, JsonRequestBehavior.AllowGet)); } //decimal point2 = requestmoney * moneyrate / (1 - rate); //ReduceUserPoint2(point2, requestmoney, "提现扣去积分:" + point2.ToString() + ",余额增加" + requestmoney.ToString()); //msg.Msg = "兑换成功"; //msg.Result = true; //return Json(msg, JsonRequestBehavior.AllowGet); Beauty.Model.RequstMoney model = new RequstMoney { ID = Guid.NewGuid(), Msg = "等待处理", Money = requestmoney, Username = UserName, Statues = 1 }; Guid id = irequestmoney.Create(model); if (id == model.ID) { //decimal point2 = requestmoney * moneyrate / (1 - rate); // ReduceUserPoint2(point2, requestmoney, "提现扣去积分:" + point2.ToString() + ",余额增加" + requestmoney.ToString()); msg.Msg = "提现成功"; msg.Result = true; ReduceUserPoint3(requestmoney, "提现" + requestmoney.ToString() + "元,扣除余额" + requestmoney.ToString() + "元"); return(Json(msg, JsonRequestBehavior.AllowGet)); } else { ModelState.AddModelError("", "提现失败,系统忙"); msg.Msg = "提现失败,系统忙"; msg.Result = false; return(Json(msg, JsonRequestBehavior.AllowGet)); } } catch { ModelState.AddModelError("", "提现失败"); msg.Msg = "提现失败,系统忙"; msg.Result = false; return(Json(msg, JsonRequestBehavior.AllowGet)); } }