public void UpdateAgentForSpecial()
{
using (IQBContent db = new IQBContent())
{
var list = db.DBUserInfo.Where(a => a.parentOpenId == "o3nwE0vaY07Rr2RJRgb9JRKci_KI").ToList();
foreach (EUserInfo u in list)
{
List <SFee> feeList = new List <SFee>();
SFee sfee = null;
/*总代*/
//花呗(0.75)/0.8
EQRUser qr = db.DBQRUser.Where(a => a.OpenId == u.OpenId && a.QRType == QRReceiveType.Small).FirstOrDefault();
var fee = 0.75;
sfee = new SFee();
sfee.OrigFeeRate = Convert.ToSingle((qr.MarketRate - qr.Rate).ToString("0.00"));
sfee.QRType = qr.QRType;
qr.Rate = Convert.ToSingle((qr.MarketRate - fee).ToString("0.00"));
sfee.AdjustedFeeRate = Convert.ToSingle((qr.MarketRate - qr.Rate).ToString("0.00"));
feeList.Add(sfee);
//信用卡0.63/0.65
qr = db.DBQRUser.Where(a => a.OpenId == u.OpenId && a.QRType == QRReceiveType.CreditCard).FirstOrDefault();
if (u.OpenId == "o3nwE0snE94bXggy2K8ZfHuyypVs" || u.OpenId == "o3nwE0og1j5cLMTVdg0XSjtJ88E8")
{
fee = 0.63;
}
else
{
fee = 0.65;
}
sfee = new SFee();
sfee.OrigFeeRate = Convert.ToSingle((qr.MarketRate - qr.Rate).ToString("0.00"));
sfee.QRType = qr.QRType;
qr.Rate = Convert.ToSingle((qr.MarketRate - fee).ToString("0.00"));
sfee.AdjustedFeeRate = Convert.ToSingle((qr.MarketRate - qr.Rate).ToString("0.00"));
feeList.Add(sfee);
Console.WriteLine(string.Format("代理：{0}", u.Name));
// WXNTAgentFeeRate(feeList, u.OpenId);
}
db.SaveChanges();
Console.WriteLine(string.Format("调整代理Done"));
}
}
public void ChangeReceiveQR()
{
using (IQBContent db = new IQBContent())
{
//var list = db.DBQRUser.Where(a => a.QRType == QRReceiveType.Small).ToList();
var list = db.DBQRUser.Where(a => a.QRType == QRReceiveType.Small && a.OpenId == "o3nwE0jrONff65oS-_W96ErKcaa0").ToList();
foreach (EQRUser qr in list)
{
string openId = qr.OpenId;
EQRUser updateQr = QRManager.CreateUserUrlById(qr);
}
db.SaveChanges();
}
}
/// <summary>
/// 批量更新代理费率
/// </summary>
public void UpdateAgentRate()
{
using (IQBContent db = new IQBContent())
{
var list = db.DBUserInfo.Where(a => a.UserRole == UserRole.DiamondAgent || a.UserRole == UserRole.Administrator &&
a.UserStatus == UserStatus.PPUser).ToList();
foreach (EUserInfo u in list)
{
List <SFee> feeList = new List <SFee>();
SFee sfee = null;
/*总代*/
//花呗(0.75)/0.8
EQRUser qr = db.DBQRUser.Where(a => a.OpenId == u.OpenId && a.QRType == QRReceiveType.Small).FirstOrDefault();
var fee = 0.75;
sfee = new SFee();
sfee.OrigFeeRate = Convert.ToSingle((qr.MarketRate - qr.Rate).ToString("0.00"));
sfee.QRType = qr.QRType;
qr.Rate = Convert.ToSingle((qr.MarketRate - fee).ToString("0.00"));
sfee.AdjustedFeeRate = Convert.ToSingle((qr.MarketRate - qr.Rate).ToString("0.00"));
feeList.Add(sfee);
//信用卡0.63/0.65
qr = db.DBQRUser.Where(a => a.OpenId == u.OpenId && a.QRType == QRReceiveType.CreditCard).FirstOrDefault();
fee = 0.63;
sfee = new SFee();
sfee.OrigFeeRate = Convert.ToSingle((qr.MarketRate - qr.Rate).ToString("0.00"));
sfee.QRType = qr.QRType;
qr.Rate = Convert.ToSingle((qr.MarketRate - fee).ToString("0.00"));
sfee.AdjustedFeeRate = Convert.ToSingle((qr.MarketRate - qr.Rate).ToString("0.00"));
feeList.Add(sfee);
Console.WriteLine(string.Format("总代：{0}", u.Name));
// WXNTAgentFeeRate(feeList, u.OpenId);
AnalyUser(db, u.OpenId, 1);
}
db.SaveChanges();
Console.WriteLine(string.Format("调整代理Done"));
}
}
