/// <summary>
/// 新增提现记录
/// 窦海超
/// 2015年3月23日 11:40:56
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool AddWtihdrawRecords(WithdrawRecordsModel model)
{
string sql = @"
INSERT INTO dbo.WtihdrawRecords
( [Platform] ,
UserId ,
Amount ,
Balance ,
CreateTime ,
Status ,
AdminId
)
VALUES ( @Platform , -- Platform - int
@UserId , -- UserId - int
@Amount , -- Amount - decimal
@Balance , -- Balance - decimal
GETDATE() , -- CreateTime - datetime
1 , -- Status - int
@AdminId -- AdminId - int
)
";
IDbParameters parm = DbHelper.CreateDbParameters();
parm.AddWithValue("@Platform", model.Platform);
parm.AddWithValue("@UserId", model.UserId);
parm.AddWithValue("@Amount", model.Amount);
parm.AddWithValue("@Balance", model.Balance);
parm.AddWithValue("@AdminId", model.AdminId);
return(DbHelper.ExecuteNonQuery(SuperMan_Write, sql, parm) > 0 ? true : false);
}
/// <summary>
/// 新增提现流水记录
/// 窦海超
/// 2015年3月23日 11:40:56
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool AddRecords(WithdrawRecordsModel model)
{
string sql = @"
INSERT INTO dbo.Records
( [Platform] ,
UserId ,
Amount ,
Balance ,
CreateTime ,
AdminId,
IsDel,
Remark,
OrderId,
RecordType
)
VALUES ( @Platform , -- Platform - int
@UserId , -- UserId - int
@Amount , -- Amount - decimal
@Balance , -- Balance - decimal
getdate() , -- CreateTime - datetime
@AdminId, -- AdminId - int
@IsDel,
@Remark,
@OrderId,
@RecordType
)
";
IDbParameters parm = DbHelper.CreateDbParameters();
parm.AddWithValue("@Platform", model.Platform);
parm.AddWithValue("@UserId", model.UserId);
parm.AddWithValue("@Amount", model.Amount);
parm.AddWithValue("@Balance", model.Balance);
parm.AddWithValue("@AdminId", model.AdminId);
parm.AddWithValue("@IsDel", model.IsDel);
parm.AddWithValue("@Remark", model.Remark == null ? "" : model.Remark);
parm.AddWithValue("@OrderId", model.OrderId);
parm.AddWithValue("@RecordType", model.RecordType);
return(DbHelper.ExecuteNonQuery(SuperMan_Write, sql, parm) > 0 ? true : false);
}
/// <summary>
/// 跨店补贴
/// 徐鹏程
/// 20150414
/// </summary>
public bool CrossShop(List <GlobalConfigSubsidies> SubsidiesList)
{
IList <GrabOrderModel> list = subsidyDao.GetBusinessCount();
WtihdrawRecordsDao withdrawRecordsDao = new WtihdrawRecordsDao();
ClienterDao clienterDao = new ClienterDao();
int MaxSubsidiesShop = SubsidiesList.Max(t => ParseHelper.ToInt(t.Value1)); //最大数量
double MaxSubsidiesPrice = ParseHelper.ToDouble(SubsidiesList.Where(t => ParseHelper.ToInt(t.Value1) == MaxSubsidiesShop).ToList()[0].Value2); //最大金额
foreach (GrabOrderModel item in list)
{
//Ets.Model.DomainModel.Clienter.ClienterModel cliterModel = new ClienterDao().GetUserInfoByUserId(item.ClienterId);//获取当前用户余额
WithdrawRecordsModel withdraw = new WithdrawRecordsModel();
#region 写流水
withdraw.Platform = 1;
withdraw.AdminId = 0;
withdraw.UserId = item.ClienterId;
int businessCount = item.BusinessCount;
//var findSubsidie = SubsidiesList.OrderByDescending(t => ParseHelper.ToInt(t.Value1)).ToList().Where(t => ParseHelper.ToInt(t.Value1) >= businessCount).First();
//double businessPrice = findSubsidie == null ? 0 : ParseHelper.ToDouble(findSubsidie.Value2);
//ParseHelper.ToDouble(SubsidiesList.Select(t => ParseHelper.ToInt(t.Value1) == businessCount));
double businessPrice = 0;
if (businessCount > MaxSubsidiesShop)
{
businessPrice = MaxSubsidiesPrice;
}
else
{
var tmpPrice = SubsidiesList.Where(t => ParseHelper.ToInt(t.Value1) == businessCount).ToList();
if (tmpPrice == null || tmpPrice.Count <= 0)
{
continue;
}
businessPrice = ParseHelper.ToDouble(tmpPrice[0].Value2);//当前金额
}
withdraw.Amount = ParseHelper.ToDecimal(businessPrice, 0);
withdraw.Balance = ParseHelper.ToDecimal(item.AccountBalance, 0) + withdraw.Amount;
withdraw.Remark = string.Format("跨店抢单奖励{0}元", withdraw.Amount);
//记录跨店日志
CrossShopModel crossShopModel = new CrossShopModel()
{
Amount = withdraw.Amount,
BusinessCount = businessCount,
ClienterId = withdraw.UserId,
Platform = 2,
Remark = withdraw.Remark,
InsertTime = DateTime.Now
};
#endregion
ClienterBalanceRecord cbrm = new ClienterBalanceRecord()
{
ClienterId = withdraw.UserId,
Amount = withdraw.Amount, //奖励的金额
Status = ClienterBalanceRecordStatus.Success.GetHashCode(),
Balance = withdraw.Balance + withdraw.Amount, //奖励后的金额
RecordType = ClienterBalanceRecordRecordType.SystemReward.GetHashCode(),
Operator = "系统服务",
RelationNo = "",
Remark = "跨店骑士奖励"
};
using (IUnitOfWork tran = EdsUtilOfWorkFactory.GetUnitOfWorkOfEDS())
{
//修改records表增加记录作废，改为 新表ClienterBalanceRecord
// withdrawRecordsDao.AddRecords(withdraw);
clienterBalanceRecordDao.Insert(cbrm);
clienterDao.UpdateAccountBalanceAndWithdraw(withdraw);//更改用户金额
subsidyDao.InsertCrossShopLog(crossShopModel);
tran.Complete();
}
}
return(true);
}