public JsonResult ApplyWithDrawSubmit(string openid, string nickname, decimal amount, string pwd)
{
if (ServiceHelper.Create <IMemberCapitalService>().GetMemberInfoByPayPwd(base.CurrentUser.Id, pwd) == null)
{
throw new HimallException("支付密码不对，请重新输入！");
}
CapitalInfo capitalInfo = ServiceHelper.Create <IMemberCapitalService>().GetCapitalInfo(base.CurrentUser.Id);
decimal num = amount;
decimal? balance = capitalInfo.Balance;
if ((num <= balance.GetValueOrDefault() ? false : balance.HasValue))
{
throw new HimallException("提现金额不能超出可用金额！");
}
ApplyWithDrawInfo applyWithDrawInfo = new ApplyWithDrawInfo()
{
ApplyAmount = amount,
ApplyStatus = ApplyWithDrawInfo.ApplyWithDrawStatus.WaitConfirm,
ApplyTime = DateTime.Now,
MemId = base.CurrentUser.Id,
OpenId = openid,
NickName = nickname
};
ServiceHelper.Create <IMemberCapitalService>().AddWithDrawApply(applyWithDrawInfo);
return(Json(new { success = true }));
}
public void RefuseApplyWithDraw(long id, ApplyWithDrawInfo.ApplyWithDrawStatus status, string opuser, string remark)
{
decimal? nullable;
ApplyWithDrawInfo applyWithDrawInfo = context.ApplyWithDrawInfo.FirstOrDefault((ApplyWithDrawInfo e) => e.Id == id);
applyWithDrawInfo.ApplyStatus = status;
applyWithDrawInfo.OpUser = opuser;
applyWithDrawInfo.Remark = remark;
applyWithDrawInfo.ConfirmTime = new DateTime?(DateTime.Now);
CapitalInfo capitalInfo = context.CapitalInfo.FirstOrDefault((CapitalInfo e) => e.MemId == applyWithDrawInfo.MemId);
decimal? balance = capitalInfo.Balance;
capitalInfo.Balance = new decimal?(balance.Value + applyWithDrawInfo.ApplyAmount);
CapitalInfo capitalInfo1 = capitalInfo;
decimal? freezeAmount = capitalInfo.FreezeAmount;
decimal applyAmount = applyWithDrawInfo.ApplyAmount;
if (freezeAmount.HasValue)
{
nullable = new decimal?(freezeAmount.GetValueOrDefault() - applyAmount);
}
else
{
nullable = null;
}
capitalInfo1.FreezeAmount = nullable;
context.SaveChanges();
}
public object GetCapital()
{
CheckUserLogin();
var capital = MemberCapitalApplication.GetCapitalInfo(CurrentUser.Id);
var sitesetting = SiteSettingApplication.SiteSettings;
var redPacketAmount = 0M;
if (capital != null)
{
//redPacketAmount = capital.Mall_CapitalDetail.Where(e => e.SourceType == Mall.Model.CapitalDetailInfo.CapitalDetailType.RedPacket).Sum(e => e.Amount);
redPacketAmount = MemberCapitalApplication.GetSumRedPacket(capital.Id);
}
else
{
capital = new CapitalInfo();
}
bool canWithDraw = MemberApplication.CanWithdraw(CurrentUser.Id);
return(Json(new
{
success = true,
Balance = capital?.Balance ?? 0,
RedPacketAmount = redPacketAmount,
PresentAmount = capital?.PresentAmount ?? 0,
ChargeAmount = capital?.ChargeAmount ?? 0,
WithDrawMinimum = sitesetting.WithDrawMinimum,
WithDrawMaximum = sitesetting.WithDrawMaximum,
canWithDraw = canWithDraw,
isOpen = sitesetting.IsOpenRechargePresent,
rule = RechargePresentRuleApplication.GetRules()
}));
}
public ActionMessage editEmloyee(int id, CapitalInfo _capital)
{
ActionMessage ret = new ActionMessage();
if (_capital.CapitalName.Trim() == string.Empty)
{
ret.isSuccess = false;
ret.err.msgCode = "Internal Error";
ret.err.msgString = "Chưa nhập tên";
}
else
{
SqlConnectionFactory sqlConnection = new SqlConnectionFactory();
using (SqlConnection connection = sqlConnection.GetConnection())
{
{
try
{
CapitalDataLayer.GetInstance().UpdateCapital(connection, _capital);
ret.isSuccess = true;
}
catch (Exception ex)
{
ret.isSuccess = false;
ret.err.msgCode = "Internal Error";
ret.err.msgString = ex.ToString();
}
}
}
}
return(ret);
}
public ActionResult Index()
{
IMemberCapitalService memberCapitalService = ServiceHelper.Create <IMemberCapitalService>();
CapitalInfo capitalInfo = memberCapitalService.GetCapitalInfo(base.CurrentUser.Id);
return(View(capitalInfo));
}
public ActionMessage createCapital(CapitalInfo _capital)
{
ActionMessage ret = new ActionMessage();
if (_capital.CapitalName.Trim() == string.Empty)
{
ret.isSuccess = false;
ret.err.msgCode = "Internal Error";
ret.err.msgString = "Chưa nhập tên";
}
//else if (_department.SourceID == -1)
//{
//}
else
{
SqlConnectionFactory sqlConnection = new SqlConnectionFactory();
using (SqlConnection connection = sqlConnection.GetConnection())
{
try
{
CapitalDataLayer.GetInstance().InsertCapital(connection, _capital);
ret.isSuccess = true;
}
catch (Exception ex)
{
ret.isSuccess = false;
ret.err.msgCode = "Internal Error";
ret.err.msgString = ex.ToString();
}
}
}
return(ret);
}
public ActionResult ApplyWithDraw()
{
SiteSettingsInfo siteSettings = ServiceHelper.Create <ISiteSettingService>().GetSiteSettings();
//if (string.IsNullOrWhiteSpace(siteSettings.WeixinAppId) || string.IsNullOrWhiteSpace(siteSettings.WeixinAppSecret))
//{
// throw new HimallException("未配置公众号参数");
//}
////string str = "";//AccessTokenContainer.TryGetToken(siteSettings.WeixinAppId, siteSettings.WeixinAppSecret, false);
//SceneModel sceneModel = new SceneModel(QR_SCENE_Type.WithDraw)
//{
// Object = base.CurrentSellerManager.Id.ToString()
//};
int num = 0;//(new SceneHelper()).SetModel(sceneModel, 600);
//CreateQrCodeResult createQrCodeResult = QrCodeApi.Create(str, 300, num, 10000);
ViewBag.ticket = "";//createQrCodeResult.ticket;
ViewBag.Sceneid = num;
IMemberCapitalService memberCapitalService = ServiceHelper.Create <IMemberCapitalService>();
CapitalInfo capitalInfo = memberCapitalService.GetCapitalInfoByManagerId(base.CurrentSellerManager.Id);
if (capitalInfo == null)
{
ViewBag.ApplyWithMoney = 0;
}
else
{
dynamic viewBag = base.ViewBag;
decimal?balance = capitalInfo.Balance;
viewBag.ApplyWithMoney = balance.Value;
}
base.ViewBag.IsSetPwd = (string.IsNullOrWhiteSpace(base.CurrentSellerManager.Password) ? false : true);
return(View());
}
public JsonResult AddStatisticsMoneyLog(int TradingType, decimal TradingPrice, string OrderNum, int PayType, string TypeID)
{
IStatisticsMoneyService isms = ServiceHelper.Create <IStatisticsMoneyService>();
decimal moneybynow = isms.GetMoneyByUidType(base.CurrentSellerManager.Id, 2);
StatisticsMoney entity = new StatisticsMoney
{
UserId = base.CurrentSellerManager.Id,
UserName = base.CurrentSellerManager.UserName,
UserType = 2,
TradingTime = DateTime.Now,
TradingType = TradingType,
TradingPrice = TradingPrice,
OrderNum = OrderNum,
PayType = PayType,
Balance = moneybynow + TradingPrice,
BalanceAble = moneybynow + TradingPrice
};
isms.Add(entity);
CapitalInfo cinfo = ServiceHelper.Create <IMemberCapitalService>().GetCapitalInfoByManagerId(base.CurrentSellerManager.Id);
if (cinfo != null)
{
cinfo.Balance += TradingPrice;
ServiceHelper.Create <IMemberCapitalService>().UpdateCapitalAmount(cinfo.Id, 0, cinfo.Balance, 0, 0, base.CurrentSellerManager.Id);
}
return(Json(new { Successful = true }));
}
public ActionResult Index()
{
if (base.Request.Url.AbsolutePath.EndsWith("/Capital/Index", StringComparison.OrdinalIgnoreCase) || base.Request.Url.AbsolutePath.EndsWith("/Capital", StringComparison.OrdinalIgnoreCase))
{
return(this.Redirect(base.Url.RouteUrl("PayRoute") + "?area=mobile&platform=" + base.PlatformType.ToString() + "&controller=Capital&action=Index"));
}
CapitalInfo capitalInfo = this._iMemberCapitalService.GetCapitalInfo(base.CurrentUser.Id);
decimal num = 0M;
if (capitalInfo != null)
{
num = (from e in capitalInfo.Himall_CapitalDetail
where e.SourceType == CapitalDetailInfo.CapitalDetailType.RedPacket
select e).Sum <CapitalDetailInfo>((Func <CapitalDetailInfo, decimal>)(e => e.Amount));
((dynamic)base.ViewBag).CapitalDetails = (from e in capitalInfo.Himall_CapitalDetail
orderby e.CreateTime descending
select e).Take <CapitalDetailInfo>(15);
}
((dynamic)base.ViewBag).RedPacketAmount = num;
((dynamic)base.ViewBag).IsSetPwd = !string.IsNullOrWhiteSpace(base.CurrentUser.PayPwd);
SiteSettingsInfo siteSettings = this._iSiteSettingService.GetSiteSettings();
((dynamic)base.ViewBag).WithDrawMinimum = siteSettings.WithDrawMinimum;
((dynamic)base.ViewBag).WithDrawMaximum = siteSettings.WithDrawMaximum;
return(base.View(capitalInfo));
}
/* public JsonResult ApplyWithDrawSubmit(string openid, string nickname, decimal amount, string pwd) //仅仅支持微信支付
* {
* if (ServiceHelper.Create<IMemberCapitalService>().GetMemberInfoByPayPwd(base.CurrentUser.Id, pwd) == null)
* {
* throw new HimallException("支付密码不对，请重新输入！");
* }
* CapitalInfo capitalInfo = ServiceHelper.Create<IMemberCapitalService>().GetCapitalInfo(base.CurrentUser.Id);
* decimal num = amount;
* decimal? balance = capitalInfo.Balance;
* if ((num <= balance.GetValueOrDefault() ? false : balance.HasValue))
* {
* throw new HimallException("提现金额不能超出可用金额！");
* }
* ApplyWithDrawInfo applyWithDrawInfo = new ApplyWithDrawInfo()
* {
* ApplyAmount = amount,
* ApplyStatus = ApplyWithDrawInfo.ApplyWithDrawStatus.WaitConfirm,
* ApplyTime = DateTime.Now,
* MemId = base.CurrentUser.Id,
* OpenId = openid,
* NickName = nickname
* };
* ServiceHelper.Create<IMemberCapitalService>().AddWithDrawApply(applyWithDrawInfo);
* return Json(new { success = true });
* }*/
public JsonResult ApplyWithDrawSubmit(string withdrawtype, string myaccount, string nickname, decimal amount, string pwd) //扩展版本(提现方式、账号、人名)
{
//if (withdrawtype == null)
// return Json(new { success = true });
if (ServiceHelper.Create <IMemberCapitalService>().GetMemberInfoByPayPwd(base.CurrentUser.Id, pwd) == null)
{
// throw new HimallException("支付密码不对，请重新输入！");
return(Json(new { success = false, msg = "Payment pwd error,please try again!" }));
}
CapitalInfo capitalInfo = ServiceHelper.Create <IMemberCapitalService>().GetCapitalInfo(base.CurrentUser.Id);
decimal num = amount;
decimal? balance = capitalInfo.Balance;
if ((num <= balance.GetValueOrDefault() ? false : balance.HasValue))
{
throw new HimallException("withdraw amount exceed Balance！");
}
ApplyWithDrawInfo applyWithDrawInfo = new ApplyWithDrawInfo()
{
ApplyAmount = amount,
ApplyStatus = ApplyWithDrawInfo.ApplyWithDrawStatus.WaitConfirm,
ApplyTime = DateTime.Now,
MemId = base.CurrentUser.Id,
AccountId = 0,
WithdrawType = withdrawtype,
Myaccount = myaccount,
NickName = nickname,
};
ServiceHelper.Create <IMemberCapitalService>().AddWithDrawApply(applyWithDrawInfo);
return(base.Json(new { success = true }));
}
public JsonResult ApplyWithDrawSubmit(string openid, string nickname, decimal amount, string pwd, int applyType = 1)
{
if (!MemberApplication.VerificationPayPwd(base.CurrentUser.Id, pwd))
{
throw new HimallException("支付密码不对，请重新输入！");
}
if (!((applyType != UserWithdrawType.ALiPay.GetHashCode()) || base.CurrentSiteSetting.Withdraw_AlipayEnable))
{
throw new HimallException("不支持支付宝提现方式！");
}
CapitalInfo capitalInfo = this._iMemberCapitalService.GetCapitalInfo(base.CurrentUser.Id);
if (amount > capitalInfo.Balance)
{
throw new HimallException("提现金额不能超出可用金额！");
}
if (amount <= 0M)
{
throw new HimallException("提现金额不能小于等于0！");
}
if (string.IsNullOrWhiteSpace(openid) && (applyType == UserWithdrawType.WeiChat.GetHashCode()))
{
openid = WebHelper.GetCookie("Himall-User_OpenId");
}
if (string.IsNullOrWhiteSpace(nickname) && (applyType == UserWithdrawType.ALiPay.GetHashCode()))
{
throw new HimallException("数据异常,真实姓名不可为空！");
}
if (!string.IsNullOrWhiteSpace(openid) && (applyType == UserWithdrawType.WeiChat.GetHashCode()))
{
openid = SecureHelper.AESDecrypt(openid, "Mobile");
SiteSettingsInfo siteSettings = this._iSiteSettingService.GetSiteSettings();
if (!string.IsNullOrWhiteSpace(siteSettings.WeixinAppId) && !string.IsNullOrWhiteSpace(siteSettings.WeixinAppSecret))
{
WeixinUserInfoResult userInfo = CommonApi.GetUserInfo(AccessTokenContainer.TryGetToken(siteSettings.WeixinAppId, siteSettings.WeixinAppSecret, false), openid);
if (userInfo != null)
{
nickname = userInfo.nickname;
}
}
}
if (string.IsNullOrWhiteSpace(openid))
{
throw new HimallException("数据异常,OpenId或收款账号不可为空！");
}
ApplyWithDrawInfo model = new ApplyWithDrawInfo
{
ApplyAmount = amount,
ApplyStatus = ApplyWithDrawInfo.ApplyWithDrawStatus.WaitConfirm,
ApplyTime = DateTime.Now,
MemId = base.CurrentUser.Id,
OpenId = openid,
NickName = nickname,
ApplyType = new UserWithdrawType?((UserWithdrawType)applyType)
};
this._iMemberCapitalService.AddWithDrawApply(model);
return(base.Json(new { success = true }));
}
public void AddCapitalInfo(CapitalInfo cinfo)
{
if (cinfo == null)
{
return;
}
context.CapitalInfo.Add(cinfo);
context.SaveChanges();
}
/// <summary>
/// 充值成功
/// </summary>
/// <param name="chargeDetailId"></param>
public void ChargeSuccess(long chargeDetailId)
{
var chargeDetail = this.Context.ChargeDetailInfo.FirstOrDefault(p => p.Id == chargeDetailId);
if (chargeDetail == null)
{
return;
}
chargeDetail.ChargeStatus = ChargeDetailInfo.ChargeDetailStatus.ChargeSuccess;
var capital = this.Context.CapitalInfo.FirstOrDefault(p => p.MemId == chargeDetail.MemId);
if (capital == null)
{
CapitalInfo newCapital = new CapitalInfo()
{
Balance = 0,
ChargeAmount = 0,
MemId = chargeDetail.MemId,
Himall_CapitalDetail = new List <CapitalDetailInfo> {
new CapitalDetailInfo {
Id = CreateCode(CapitalDetailInfo.CapitalDetailType.ChargeAmount),
Amount = chargeDetail.ChargeAmount,
CreateTime = DateTime.Now,
SourceType = CapitalDetailInfo.CapitalDetailType.ChargeAmount,
SourceData = chargeDetailId.ToString()
}
}
};
this.Context.CapitalInfo.Add(newCapital);
}
else
{
var capitalDetail = this.Context.CapitalDetailInfo.FirstOrDefault(e => e.SourceData == chargeDetailId.ToString() && e.SourceType == CapitalDetailInfo.CapitalDetailType.ChargeAmount);
if (capitalDetail != null)//已经处理过直接返回
{
return;
}
this.Context.CapitalDetailInfo.Add(new CapitalDetailInfo()
{
Id = CreateCode(CapitalDetailInfo.CapitalDetailType.ChargeAmount),
Amount = chargeDetail.ChargeAmount,
CreateTime = DateTime.Now,
SourceType = CapitalDetailInfo.CapitalDetailType.ChargeAmount,
SourceData = chargeDetailId.ToString(),
CapitalID = capital.Id
});
}
this.Context.SaveChanges();
var sql = "UPDATE Himall_Capital SET Balance=Balance+@p1,ChargeAmount=ChargeAmount+@p1 WHERE MemId=@p0";
this.Context.Database.ExecuteSqlCommand(sql, capital.MemId, chargeDetail.ChargeAmount);
}
public CapitalInfo getCapitalbyId(int _ID)
{
SqlConnectionFactory sqlConnection = new SqlConnectionFactory();
using (SqlConnection connection = sqlConnection.GetConnection())
{
List <CapitalInfo> ListDepartment = CapitalDataLayer.GetInstance().GetAllCapitalbyID(connection, _ID);
CapitalInfo findCapital = ListDepartment.First();
return(findCapital);
}
}
private void InitCapital(long memberId)
{
CapitalInfo newCapital = new CapitalInfo()
{
Balance = 0,
ChargeAmount = 0,
MemId = memberId,
FreezeAmount = 0
};
DbFactory.Default.Add(newCapital);
}
public void UpdateCapital(SqlConnection connection, CapitalInfo _capital)
{
using (var command = new SqlCommand("UPDATE tbl_Capital \n" +
"SET CapitalName = @CapitalName \n" +
"WHERE (CapitalID = @CapitalID)", connection))
{
AddSqlParameter(command, "@CapitalID", _capital.CapitalID, System.Data.SqlDbType.Int);
AddSqlParameter(command, "@CapitalName", _capital.CapitalName, System.Data.SqlDbType.NVarChar);
WriteLogExecutingCommand(command);
command.ExecuteScalar();
}
}
public int InsertCapital(SqlConnection connection, CapitalInfo _capital)
{
int lastestInserted = 0;
using (var command = new SqlCommand("Insert into [dbo].[tbl_Capital] (CapitalName)" +
"VALUES(@CapitalName) ", connection))
{
AddSqlParameter(command, "@CapitalName", _capital.CapitalName, System.Data.SqlDbType.NVarChar);
WriteLogExecutingCommand(command);
command.ExecuteScalar();
}
return(lastestInserted);
}
public ActionResult ApplyWithDraw()
{
SiteSettingsInfo siteSettings = ServiceHelper.Create <ISiteSettingService>().GetSiteSettings();
if (string.IsNullOrWhiteSpace(siteSettings.WeixinAppId) || string.IsNullOrWhiteSpace(siteSettings.WeixinAppSecret))
{
throw new HimallException("Can not Set WeiXin AppId");
}
string str = AccessTokenContainer.TryGetToken(siteSettings.WeixinAppId, siteSettings.WeixinAppSecret, true);
SceneModel sceneModel = new SceneModel(QR_SCENE_Type.WithDraw)
{
Object = base.CurrentUser.Id.ToString()
};
int num = (new SceneHelper()).SetModel(sceneModel, 600);
CreateQrCodeResult createQrCodeResult = QrCodeApi.Create(str, 300, num, 10000);
ViewBag.ticket = createQrCodeResult.ticket;
ViewBag.Sceneid = num;
IMemberCapitalService memberCapitalService = ServiceHelper.Create <IMemberCapitalService>();
CapitalInfo capitalInfo = memberCapitalService.GetCapitalInfo(base.CurrentUser.Id);
if (capitalInfo == null)
{
ViewBag.ApplyWithMoney = 0;
}
else
{
dynamic viewBag = base.ViewBag;
decimal?balance = capitalInfo.Balance;
ViewBag.ApplyWithMoney = balance.Value;
}
string membersId = this.CurrentUser.UserName;
IEnumerable <WithDrawInfo> WithDraws = ServiceHelper.Create <IWithDrawService>().GetWithDrawByMembersId(membersId);//因为UserName值唯一，所以没有登录账号ID去获取信息
String[] Array = new String[WithDraws.Count()];
int i = 0;
foreach (var item in WithDraws)
{
Array[i] = item.WithdrawType + "【" + item.AccountNumber + "," + item.Name + "】";
i++;
}
ViewBag.List = Array;
ViewBag.Num = Array.Length;
base.ViewBag.IsSetPwd = (string.IsNullOrWhiteSpace(base.CurrentUser.PayPwd) ? false : true);
return(View());
}
public JsonResult ApplyWithDrawSubmit(string nickname, decimal amount, string pwd)
{
if (ServiceHelper.Create <IMemberCapitalService>().GetMemberInfoByPayPwd(base.CurrentUser.Id, pwd) == null)
{
throw new HimallException("支付密码不对，请重新输入！");
}
CapitalInfo capitalInfo = ServiceHelper.Create <IMemberCapitalService>().GetCapitalInfo(base.CurrentUser.Id);
decimal num = amount;
decimal? balance = capitalInfo.Balance;
if ((num <= balance.GetValueOrDefault() ? false : balance.HasValue))
{
throw new HimallException("提现金额不能超出可用金额！");
}
string cookie = WebHelper.GetCookie("Himall-User_OpenId");
string empty = string.Empty;
if (string.IsNullOrWhiteSpace(cookie))
{
throw new HimallException("数据异常,OpenId不能为空！");
}
cookie = SecureHelper.AESDecrypt(cookie, "Mobile");
SiteSettingsInfo siteSettings = ServiceHelper.Create <ISiteSettingService>().GetSiteSettings();
if (!string.IsNullOrWhiteSpace(siteSettings.WeixinAppId) && !string.IsNullOrWhiteSpace(siteSettings.WeixinAppSecret))
{
//string str = AccessTokenContainer.TryGetToken(siteSettings.WeixinAppId, siteSettings.WeixinAppSecret, false);
string str = CommonApi.GetToken(siteSettings.WeixinAppId, siteSettings.WeixinAppSecret).access_token;
//
WeixinUserInfoResult userInfo = CommonApi.GetUserInfo(str, cookie);
if (userInfo != null)
{
empty = userInfo.nickname;
}
}
ApplyWithDrawInfo applyWithDrawInfo = new ApplyWithDrawInfo()
{
ApplyAmount = amount,
ApplyStatus = ApplyWithDrawInfo.ApplyWithDrawStatus.WaitConfirm,
ApplyTime = DateTime.Now,
MemId = base.CurrentUser.Id,
OpenId = cookie,
NickName = empty
};
ServiceHelper.Create <IMemberCapitalService>().AddWithDrawApply(applyWithDrawInfo);
return(Json(new { success = true }));
}
public ActionMessage Post([FromBody] CapitalInfo _capital)
{
ActionMessage ret = new ActionMessage();
try
{
ret = CapitalServices.GetInstance().createCapital(_capital);
}
catch (Exception ex)
{
ret.isSuccess = false;
ret.err.msgCode = "001";
ret.err.msgString = ex.ToString();
}
return(ret);
}
public ActionMessage Put(int id, [FromBody] CapitalInfo _capital)
{
ActionMessage ret = new ActionMessage();
try
{
CapitalServices.GetInstance().editEmloyee(id, _capital);
ret.isSuccess = true;
}
catch (Exception ex)
{
ret.isSuccess = false;
ret.err.msgCode = "001";
ret.err.msgString = ex.ToString();
}
return(ret);
}
// GET: Mobile/Capital
public ActionResult Index()
{
CapitalIndexChargeModel result = new CapitalIndexChargeModel();
//判断是否需要跳转到支付地址
if (this.Request.Url.AbsolutePath.EndsWith("/Capital/Index", StringComparison.OrdinalIgnoreCase) || this.Request.Url.AbsolutePath.EndsWith("/Capital", StringComparison.OrdinalIgnoreCase))
{
return(Redirect(Url.RouteUrl("PayRoute") + "?area=mobile&platform=" + this.PlatformType.ToString() + "&controller=Capital&action=Index"));
}
var model = MemberCapitalApplication.GetCapitalInfo(CurrentUser.Id);
var redPacketAmount = 0M;
if (model != null)
{
//redPacketAmount = model.Himall_CapitalDetail.Where(e => e.SourceType == Model.CapitalDetailInfo.CapitalDetailType.RedPacket).Sum(e => e.Amount);
redPacketAmount = MemberCapitalApplication.GetSumRedPacket(model.Id);
result.CapitalDetails = MemberCapitalApplication.GetTopCapitalDetailList(model.Id, 15);
}
else
{
model = new CapitalInfo
{
Balance = 0,
ChargeAmount = 0,
FreezeAmount = 0,
MemId = CurrentUser.Id,
PresentAmount = 0
};
}
result.UserCaptialInfo = model;
result.IsEnableRechargePresent = SiteSettings.IsOpenRechargePresent;
if (result.IsEnableRechargePresent)
{
result.RechargePresentRules = RechargePresentRuleApplication.GetRules();
}
result.RedPacketAmount = redPacketAmount;
result.IsSetPwd = string.IsNullOrWhiteSpace(CurrentUser.PayPwd) ? false : true;
var siteSetting = SiteSettingApplication.SiteSettings;
result.WithDrawMinimum = siteSetting.WithDrawMinimum;
result.WithDrawMaximum = siteSetting.WithDrawMaximum;
result.CanWithDraw = MemberApplication.CanWithdraw(CurrentUser.Id);
return(View(result));
}
public ActionResult CapitalCharge()
{
IMemberCapitalService memberCapitalService = ServiceHelper.Create <IMemberCapitalService>();
CapitalInfo capitalInfo = memberCapitalService.GetCapitalInfoByManagerId(base.CurrentSellerManager.Id);
if (capitalInfo == null)
{
capitalInfo = new CapitalInfo()
{
MemId = 0,
Balance = 0,
FreezeAmount = 0,
ChargeAmount = 0,
ManageId = base.CurrentSellerManager.Id
};
memberCapitalService.AddCapitalInfo(capitalInfo);
}
return(View(capitalInfo));
}
public List <CapitalInfo> GetByName(SqlConnection connection, string name)
{
var result = new List <CapitalInfo>();
using (var command = new SqlCommand("Select * " +
" from tbl_Capital where CapitalName like '%" + name + "%' and isused = 1 order by CapitalID ", connection))
{
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
var info = new CapitalInfo();
info.CapitalID = GetDbReaderValue <int>(reader["CapitalID"]);
info.CapitalName = GetDbReaderValue <string>(reader["CapitalName"]);
result.Add(info);
}
}
return(result);
}
}
public decimal getMyMoney(long uid, int userType)
{
CapitalInfo SMInfo = (
from a in context.CapitalInfo
where a.ManageId == uid
select a).FirstOrDefault();
decimal aa;
if (SMInfo != null)
{
aa = decimal.Parse(SMInfo.Balance.ToString());
}
else
{
aa = 0;
}
return(aa);
}
public List <CapitalInfo> GetAllCapitalbyID(SqlConnection connection, int id)
{
var result = new List <CapitalInfo>();
using (var command = new SqlCommand("Select * " +
" from tbl_Capital where CapitalID = @CapitalID AND isused = 1 order by CapitalID ", connection))
{
AddSqlParameter(command, "@CapitalID", id, System.Data.SqlDbType.Int);
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
var info = new CapitalInfo();
info.CapitalID = GetDbReaderValue <int>(reader["CapitalID"]);
info.CapitalName = GetDbReaderValue <string>(reader["CapitalName"]);
result.Add(info);
}
}
return(result);
}
}
public ActionResult Center()
{
decimal num;
IQueryable <OrderInfo> topOrders = ServiceHelper.Create <IOrderService>().GetTopOrders(2147483647, base.CurrentUser.Id);
OrderQuery orderQuery = new OrderQuery()
{
Status = new OrderInfo.OrderOperateStatus?(OrderInfo.OrderOperateStatus.Finish),
UserId = new long?(base.CurrentUser.Id),
PageSize = 2147483647,
PageNo = 1,
Commented = new bool?(false)
};
OrderQuery orderQuery1 = orderQuery;
ViewBag.WaitingForComments = ServiceHelper.Create <IOrderService>().GetOrders <OrderInfo>(orderQuery1, null).Total;
UserMemberInfo member = ServiceHelper.Create <IMemberService>().GetMember(base.CurrentUser.Id);
ViewBag.AllOrders = topOrders.Count();
base.ViewBag.WaitingForRecieve = topOrders.Count((OrderInfo item) => (int)item.OrderStatus == 3);
base.ViewBag.WaitingForPay = topOrders.Count((OrderInfo item) => (int)item.OrderStatus == 1);
CapitalInfo capitalInfo = ServiceHelper.Create <IMemberCapitalService>().GetCapitalInfo(base.CurrentUser.Id);
if (capitalInfo == null)
{
ViewBag.Capital = 0;
}
else
{
dynamic viewBag = base.ViewBag;
num = (capitalInfo.Balance.HasValue ? capitalInfo.Balance.Value : new decimal(0));
viewBag.Capital = num;
}
int num1 = ServiceHelper.Create <ICouponService>().GetAllUserCoupon(base.CurrentUser.Id).Count();
num1 = num1 + ServiceHelper.Create <IShopBonusService>().GetCanUseDetailByUserId(base.CurrentUser.Id).Count();
ViewBag.GradeName = base.CurrentUser.MemberGradeName;
ViewBag.CouponsCount = num1;
ViewBag.CollectionShop = ServiceHelper.Create <IVShopService>().GetUserConcernVShops(base.CurrentUser.Id, 1, 2147483647).Count();
return(View(member));
}
public ActionResult ApplyWithDraw()
{
SiteSettingsInfo siteSettings = ServiceHelper.Create <ISiteSettingService>().GetSiteSettings();
if (string.IsNullOrWhiteSpace(siteSettings.WeixinAppId) || string.IsNullOrWhiteSpace(siteSettings.WeixinAppSecret))
{
throw new HimallException("未配置公众号参数");
}
//string str = AccessTokenContainer.TryGetToken(siteSettings.WeixinAppId, siteSettings.WeixinAppSecret, false);
string str = CommonApi.GetToken(siteSettings.WeixinAppId, siteSettings.WeixinAppSecret).access_token;
//
SceneModel sceneModel = new SceneModel(QR_SCENE_Type.WithDraw)
{
Object = base.CurrentUser.Id.ToString()
};
int num = (new SceneHelper()).SetModel(sceneModel, 600);
//CreateQrCodeResult createQrCodeResult = Senparc.Weixin.MP.AdvancedAPIs.QrCodeApi.Create(str, 300, num, 10000);
CreateQrCodeResult createQrCodeResult = Senparc.Weixin.MP.AdvancedAPIs.QrCodeApi.Create(str, 300, num, Senparc.Weixin.MP.QrCode_ActionName.QR_SCENE);
ViewBag.ticket = createQrCodeResult.ticket;
ViewBag.Sceneid = num;
IMemberCapitalService memberCapitalService = ServiceHelper.Create <IMemberCapitalService>();
CapitalInfo capitalInfo = memberCapitalService.GetCapitalInfo(base.CurrentUser.Id);
if (capitalInfo == null)
{
ViewBag.ApplyWithMoney = 0;
}
else
{
dynamic viewBag = base.ViewBag;
decimal?balance = capitalInfo.Balance;
viewBag.ApplyWithMoney = balance.Value;
}
base.ViewBag.IsSetPwd = (string.IsNullOrWhiteSpace(base.CurrentUser.PayPwd) ? false : true);
return(View());
}
public void AddWithDrawApply(ApplyWithDrawInfo model)
{
decimal?nullable;
context.ApplyWithDrawInfo.Add(model);
CapitalInfo capitalInfo = context.CapitalInfo.FirstOrDefault((CapitalInfo e) => e.MemId == model.MemId);
CapitalInfo capitalInfo1 = capitalInfo;
decimal? balance = capitalInfo1.Balance;
decimal applyAmount = model.ApplyAmount;
if (balance.HasValue)
{
nullable = new decimal?(balance.GetValueOrDefault() - applyAmount);
}
else
{
nullable = null;
}
capitalInfo1.Balance = nullable;
capitalInfo.FreezeAmount = new decimal?((capitalInfo.FreezeAmount.HasValue ? capitalInfo.FreezeAmount.Value + model.ApplyAmount : model.ApplyAmount));
context.SaveChanges();
}
public ActionResult Index()
{
IMemberCapitalService memberCapitalService = ServiceHelper.Create <IMemberCapitalService>();
CapitalInfo capitalInfo = memberCapitalService.GetCapitalInfo(base.CurrentUser.Id);
decimal num = new decimal(0);
if (capitalInfo != null)
{
num = (
from e in capitalInfo.Himall_CapitalDetail
where e.SourceType == CapitalDetailInfo.CapitalDetailType.RedPacket
select e).Sum <CapitalDetailInfo>((CapitalDetailInfo e) => e.Amount);
dynamic viewBag = base.ViewBag;
ICollection <CapitalDetailInfo> himallCapitalDetail = capitalInfo.Himall_CapitalDetail;
viewBag.CapitalDetails = (
from e in himallCapitalDetail
orderby e.CreateTime descending
select e).Take(15);
}
ViewBag.RedPacketAmount = num;
base.ViewBag.IsSetPwd = (string.IsNullOrWhiteSpace(base.CurrentUser.PayPwd) ? false : true);
return(View(capitalInfo));
}