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