/// <summary>
/// 提现申请
/// </summary>
private void submitDrawmoney()
{
int userid = GetFormValue("userid", 0);
decimal money = Convert.ToDecimal(GetFormValue("money", "0"));
string name = GetFormValue("name", "");
string mobile = GetFormValue("mobile", "");
string payaccount = GetFormValue("payaccount", "");
DrawMoneyModel model = new DrawMoneyModel()
{
UserId = userid,
ApplyMoney = money,
PayAccount = payaccount,
UserName = name,
UserMobile = mobile
};
string msg = "";
bool flag = UserLogic.Instance.AddDrawMoney(model, out msg);
if (flag)
{
json = JsonConvert.SerializeObject(new ResultModel(ApiStatusCode.OK));
}
else
{
json = JsonConvert.SerializeObject(new ResultModel(ApiStatusCode.保存失败, msg));
}
}
/// <summary>
/// 添加提现申请
/// </summary>
/// <param name="CouponId">The coupon identifier.</param>
/// <param name="userId">The user identifier.</param>
/// <returns>true if XXXX, false otherwise.</returns>
public bool AddDrawMoney(DrawMoneyModel model, out string msg)
{
lock (drawObj)
{
msg = "";
UserBaseInfoModel userInfo = dal.GetUserInfo(model.UserId);
if (userInfo == null)
{
msg = "无效用户";
return(false);
}
if (userInfo.IsActive == 0)
{
msg = "账号已冻结，请联系管理员!";
return(false);
}
if (userInfo.UserMoney < model.ApplyMoney)
{
msg = "提现金额不能大于可用金额";
return(false);
}
using (TransactionScope scope = new TransactionScope())
{
if (dal.AddDrawMoney(model))
{
//添加锁定金额
dal.addUserMoneyLocked(model.UserId, model.ApplyMoney);
//添加提现记录
dal.AddRebateLog(new RebateLogModel()
{
UserId = model.UserId,
Income = 0,
RebateMoney = -model.ApplyMoney,
Remark = "申请提现"
});
}
scope.Complete();
}
return(true);
}
}
public HttpResponseMessage GetUserWithdrawal(string Statetime, string Endtime, int pageNum, int pagesize, int?State, int UserId)
{
List <DrawMoneyModel> list = new List <DrawMoneyModel>();
if (string.IsNullOrWhiteSpace(Statetime) == false && string.IsNullOrWhiteSpace(Endtime) == false)
{
stime = DateTime.Parse(Statetime);
etime = DateTime.Parse(Endtime);
}
var json = string.Empty;
int count = 0;
if (State != 0 && string.IsNullOrWhiteSpace(Statetime) == false && string.IsNullOrWhiteSpace(Endtime) == false)
{
count = entities.DrawMoney.Where(e => e.UserId == UserId && e.State == State && DbFunctions.TruncateTime(e.RemoveMoenyTime) >= stime && DbFunctions.TruncateTime(e.RemoveMoenyTime) <= etime).Count();
var query = entities.DrawMoney.Where(e => e.UserId == UserId && e.State == State && DbFunctions.TruncateTime(e.RemoveMoenyTime) >= stime && DbFunctions.TruncateTime(e.RemoveMoenyTime) <= etime).OrderByDescending(i => i.Id).Skip(pagesize * (pageNum - 1)).Take(pagesize).ToList();
foreach (var item in query)
{
DrawMoneyModel model = new DrawMoneyModel();
model.Id = item.Id;
model.UserId = (int)item.UserId;
model.RemoveMoenyNumber = item.RemoveMoenyNumber;
model.RemoveMoenyStae = item.State;
model.RemoveMoeny = item.RemoveMoeny;
model.RemoveMoenyTime = item.RemoveMoenyTime.Value.ToString("yyyy-MM-dd HH:mm:ss");
model.Bank = item.Bank;
model.BankName = item.BankName;
model.BankAccount = item.BankAccount;
model.Remarks = item.Remarks;
list.Add(model);
}
json = JsonConvert.SerializeObject(list);
}
else if (State != 0)
{
count = entities.DrawMoney.Where(e => e.UserId == UserId && e.State == State).Count();
var query = entities.DrawMoney.Where(e => e.UserId == UserId && e.State == State).OrderByDescending(i => i.Id).Skip(pagesize * (pageNum - 1)).Take(pagesize).ToList();
foreach (var item in query)
{
DrawMoneyModel model = new DrawMoneyModel();
model.Id = item.Id;
model.UserId = (int)item.UserId;
model.RemoveMoenyNumber = item.RemoveMoenyNumber;
model.RemoveMoenyStae = item.State;
model.RemoveMoeny = item.RemoveMoeny;
model.RemoveMoenyTime = item.RemoveMoenyTime.Value.ToString("yyyy-MM-dd HH:mm:ss");
model.Bank = item.Bank;
model.BankName = item.BankName;
model.BankAccount = item.BankAccount;
model.Remarks = item.Remarks;
list.Add(model);
}
json = JsonConvert.SerializeObject(list);
}
else if (string.IsNullOrWhiteSpace(Statetime) == false && string.IsNullOrWhiteSpace(Endtime) == false)
{
count = entities.DrawMoney.Where(e => e.UserId == UserId && DbFunctions.TruncateTime(e.RemoveMoenyTime) >= stime && DbFunctions.TruncateTime(e.RemoveMoenyTime) <= etime).Count();
var query = entities.DrawMoney.Where(e => e.UserId == UserId && DbFunctions.TruncateTime(e.RemoveMoenyTime) >= stime && DbFunctions.TruncateTime(e.RemoveMoenyTime) <= etime).OrderByDescending(i => i.Id).Skip(pagesize * (pageNum - 1)).Take(pagesize).ToList();
foreach (var item in query)
{
DrawMoneyModel model = new DrawMoneyModel();
model.Id = item.Id;
model.UserId = (int)item.UserId;
model.RemoveMoenyNumber = item.RemoveMoenyNumber;
model.RemoveMoenyStae = item.State;
model.RemoveMoeny = item.RemoveMoeny;
model.RemoveMoenyTime = item.RemoveMoenyTime.Value.ToString("yyyy-MM-dd HH:mm:ss");
model.Bank = item.Bank;
model.BankName = item.BankName;
model.BankAccount = item.BankAccount;
model.Remarks = item.Remarks;
list.Add(model);
}
json = JsonConvert.SerializeObject(list);
}
else
{
count = entities.DrawMoney.Where(e => e.UserId == UserId).Count();
var query = entities.DrawMoney.Where(e => e.UserId == UserId).OrderByDescending(i => i.Id).Skip(pagesize * (pageNum - 1)).Take(pagesize).ToList();
foreach (var item in query)
{
DrawMoneyModel model = new DrawMoneyModel();
model.Id = item.Id;
model.UserId = (int)item.UserId;
model.RemoveMoenyNumber = item.RemoveMoenyNumber;
model.RemoveMoenyStae = item.State;
model.RemoveMoeny = item.RemoveMoeny;
model.RemoveMoenyTime = item.RemoveMoenyTime.Value.ToString("yyyy-MM-dd HH:mm:ss");
model.Bank = item.Bank;
model.BankName = item.BankName;
model.BankAccount = item.BankAccount;
model.Remarks = item.Remarks;
list.Add(model);
}
json = JsonConvert.SerializeObject(list);
}
json = JsonConvert.SerializeObject(list);
StringBuilder sb = new StringBuilder();
sb.Append("{");
sb.Append("\"total\"");
sb.Append(":");
sb.Append("\"" + count + "\"");
sb.Append(",");
sb.Append("\"list\"");
sb.Append(":");
sb.Append(json);
sb.Append("}");
json = sb.ToString();
return(new HttpResponseMessage {
Content = new StringContent(json, System.Text.Encoding.UTF8, "application/json")
});
}
