/// <summary>
/// Deletes salesman based on SalesManID.
/// </summary>
/// <param name="deleteSalesManID">Represents SalesManID to delete.</param>
/// <returns>Determines whether the existing salesman is updated.</returns>
public override bool DeleteSalesManDAL(Guid deleteSalesManID)
{
bool salesmanDeleted = false;
try
{
//Find SalesMan based on searchSalesManID
SalesMan matchingSalesMan = salesmanList.Find(
(item) => { return(item.SalesManID == deleteSalesManID); }
);
if (matchingSalesMan != null)
{
//Delete SalesMan from the collection
salesmanList.Remove(matchingSalesMan);
salesmanDeleted = true;
}
}
catch (Exception)
{
throw;
}
return(salesmanDeleted);
}
public OperationResult Create(SalesManViewModel input)
{
var result = new OperationResult();
try
{
BizModel context = new BizModel();
BizRepository <SalesMan> repository = new BizRepository <SalesMan>(context);
SalesMan sales = new SalesMan()
{
Name = input.Name
};
repository.Create(sales);
context.SaveChanges();
result.IsSuccessful = true;
}
catch (Exception ex)
{
result.IsSuccessful = false;
result.exception = ex;
}
return(result);
}
public async Task <ActionResult> Edit([Bind(Include = "SalesManID,Updated,Updator,SalesManName,SalesManPhone,UserName")] SalesMan salesman)
{
//if (HttpContext.User.IsInRole("sales"))
// {
// salesman.UserName = HttpContext.User.Identity.Name;
// }
using (FFSecurityDBEntities db2 = new FFSecurityDBEntities())
{
ViewBag.UserName = new SelectList(db2.AspNetUsers, "UserName", "UserName", salesman.UserName).ToList();
}
if (ModelState.IsValid)
{
db.Entry(salesman).State = EntityState.Modified;
await db.SaveChangesAsync();
if (HttpContext.User.IsInRole("sales"))
{
return(RedirectToAction("Details", "SalesMan"));
}
return(RedirectToAction("Index"));
}
return(View(salesman));
}
public IActionResult AddSalesMan(string userName, string code, DepartmentType department)
{
if (!_permissionService.Authorize("UpdateSalesMan"))
{
return(Error("权限不足"));
}
var salesMan = _salesManService.GetSalesManByNameAndCode(userName, code);
if (salesMan != null)
{
return(Error("已存在名称和编码相同的数据"));
}
var model = new SalesMan
{
UserName = userName,
Code = code,
Department = department
};
_salesManService.AddSalesMan(model);
return(Success());
}
public JsonResult <EResponseBase <SalesMan> > UpdateSalesMan(SalesMan SalesMan)
{
return(Json(Service.Update(SalesMan)));
}
public JsonResult <EResponseBase <SalesMan> > InsertSalesMan(SalesMan SalesMan)
{
return(Json(Service.Add(SalesMan)));
}
public void AddSalesMan(SalesMan newsalesMan)
{
SalesMen[salesmenCount] = newsalesMan;
salesmenCount++;
}
public bool find(SalesMan objSalesMan)
{
return(objSalesManDao.Find(objSalesMan));
}
public void create(SalesMan objSalesMan)
{
SalesMan objSalesManAux = new SalesMan();
bool verification = true;
string code = objSalesMan.IdSalesMan;
if (code == null || code.Trim().Equals(""))
{
objSalesMan.State = 10;
return;
}
else
{
code = objSalesMan.IdSalesMan.Trim();
verification = code.Length > 0 && code.Length <= 5;
if (!verification)
{
objSalesMan.State = 1;
return;
}
}
string name = objSalesMan.Name;
if (name == null || name.Trim().Equals(""))
{
objSalesMan.State = 20;
return;
}
else
{
name = objSalesMan.Name.Trim();
verification = name.Length > 0 && name.Length <= 30;
if (!verification)
{
objSalesMan.State = 2;
return;
}
}
string cpf = objSalesMan.Cpf;
if (cpf == null || cpf.Trim().Equals(""))
{
objSalesMan.State = 30;
return;
}
else
{
cpf = objSalesMan.Cpf.Trim();
verification = cpf.Length > 10 && cpf.Length <= 11;
if (!verification)
{
objSalesMan.State = 3;
return;
}
}
string telephone = objSalesMan.Telephone;
if (telephone == null || telephone.Trim().Equals(""))
{
objSalesMan.State = 40;
return;
}
else
{
telephone = objSalesMan.Telephone.Trim();
verification = telephone.Length > 9 && telephone.Length <= 15;
if (!verification)
{
objSalesMan.State = 4;
return;
}
}
string address = objSalesMan.Address;
if (address == null || address.Trim().Equals(""))
{
objSalesMan.State = 50;
return;
}
else
{
address = objSalesMan.Address.Trim();
verification = address.Length > 5 && address.Length <= 50;
if (!verification)
{
objSalesMan.State = 5;
return;
}
}
objSalesManAux.IdSalesMan = objSalesMan.IdSalesMan;
verification = !objSalesManDao.Find(objSalesManAux);
if (!verification)
{
objSalesMan.State = 8;
return;
}
objSalesManDao.Create(objSalesMan);
objSalesMan.State = 99;
return;
}
public void update(SalesMan objSalesMan)
{
bool verification = true;
SalesMan objSalesManAux = new SalesMan();
string name = objSalesMan.Name;
if (name == null || name.Trim().Equals(""))
{
objSalesMan.State = 20;
return;
}
else
{
name = objSalesMan.Name.Trim();
verification = name.Length > 0 && name.Length <= 50;
if (!verification)
{
objSalesMan.State = 2;
return;
}
}
string cpf = objSalesMan.Cpf;
if (cpf == null || cpf.Trim().Equals(""))
{
objSalesMan.State = 30;
return;
}
else
{
cpf = objSalesMan.Cpf.Trim();
verification = cpf.Length > 10 && cpf.Length <= 11;
if (!verification)
{
objSalesMan.State = 3;
return;
}
}
string telephone = objSalesMan.Telephone;
if (telephone == null || telephone.Trim().Equals(""))
{
objSalesMan.State = 40;
return;
}
else
{
telephone = objSalesMan.Telephone.Trim();
verification = telephone.Length > 8 && telephone.Length <= 15;
if (!verification)
{
objSalesMan.State = 4;
return;
}
}
string address = objSalesMan.Address;
if (address == null || address.Trim().Equals(""))
{
objSalesMan.State = 50;
return;
}
else
{
address = objSalesMan.Address.Trim();
verification = address.Length > 0 && address.Length <= 50;
if (!verification)
{
objSalesMan.State = 5;
return;
}
}
/*
* objSalesManAux.IdSalesMan = objSalesMan.IdSalesMan;
* verification = !objSalesManDao.Find(objSalesManAux);
* if (!verification)
* {
* objSalesMan.State = 8;
* return;
* }
*/
objSalesManDao.Update(objSalesMan);
objSalesMan.State = 99;
return;
}
/// <summary>
/// 返回购物车里对应的产品佣金比例
/// </summary>
/// <param name="userId"></param>
/// <param name="goodsId"></param>
/// <returns></returns>
public CpsRateCar GetCps_rate(int userId, int goodsId, int appId, int salesManRecordId)
{
CpsRateCar cpsRateCar = new CpsRateCar();
EntGoods entGoods = EntGoodsBLL.SingleModel.GetModel(goodsId);
SalesManConfig salesManConfig = SalesManConfigBLL.SingleModel.GetModel($"appId={appId}");
if (entGoods != null && entGoods.isDistribution != 0 && salesManConfig != null && !string.IsNullOrEmpty(salesManConfig.configStr))
{
#region 表示开启分销员购买权限,分销员购买自己分享的产品不受保护期限制,佣金算自己的
SalesMan salesMan = SalesManBLL.SingleModel.GetModel($"UserId={userId} and state=2");
ConfigModel configModel = JsonConvert.DeserializeObject <ConfigModel>(salesManConfig.configStr);
if (configModel.payMentManager.allow_seller_buy == 1 && salesMan != null)
{
salesManRecordId = Convert.ToInt32(base.Add(new SalesManRecord()
{
appId = entGoods.aid,
salesManId = salesMan.Id,
configStr = salesManConfig.configStr,
salesmanGoodsId = goodsId,
state = 1,
addTime = DateTime.Now,
cps_rate = (entGoods.isDefaultCps_Rate == 0 ? configModel.payMentManager.cps_rate : entGoods.cps_rate)
}));
if (salesManRecordId <= 0)
{
return(cpsRateCar);
}
cpsRateCar.salesManRecordUserId = -1;
cpsRateCar.recordId = salesManRecordId;
cpsRateCar.cps_rate = entGoods.cps_rate;
return(cpsRateCar);
}
#endregion
// SalesManRecordUser salesManRecordUser = salesManRecordUserBLL.GetModel($" userId={userId} and goodsId={goodsId} and DATE_ADD(UpdateTime,INTERVAL protected_time Day)>now()");
SalesManRecordUser salesManRecordUser = SalesManRecordUserBLL.SingleModel.GetModel($" userId={userId} and DATE_ADD(UpdateTime,INTERVAL protected_time Day)>now()"); //MINUTE
if (salesManRecordUser != null) //用户-分销员存在绑定关系 计算佣金才返回对应每条购物车产品佣金比例
{
SalesManRecord salesManRecord = base.GetModel($"Id={salesManRecordId} and state=1");
if (salesManRecord != null)//表示从分享推广页面进入购买的
{
salesManRecord.configModel = JsonConvert.DeserializeObject <ConfigModel>(salesManRecord.configStr);
salesMan = SalesManBLL.SingleModel.GetModel(salesManRecord.salesManId);
if (salesManRecord.configModel.payMentManager.allow_seller_buy == 1 && salesMan != null && salesMan.UserId == userId)
{
//表示开启分销员购买权限,分销员购买自己分享的产品不受保护期限制,佣金算自己的
cpsRateCar.salesManRecordUserId = -1;
cpsRateCar.recordId = salesManRecord.Id;
cpsRateCar.cps_rate = entGoods.cps_rate;
return(cpsRateCar);
}
}
//表示从普通页面进入购买的
salesManRecord = base.GetModel($"Id={salesManRecordUser.recordId} and state=1");
if (salesManRecord != null && entGoods != null)
{
if (entGoods.isDefaultCps_Rate == 0)
{
salesManRecord.configModel = JsonConvert.DeserializeObject <ConfigModel>(salesManConfig.configStr);
if (salesManRecord.configModel != null && salesManRecord.configModel.payMentManager != null)
{
cpsRateCar.cps_rate = salesManRecord.configModel.payMentManager.cps_rate;
}
}
else
{
cpsRateCar.cps_rate = entGoods.cps_rate;
}
cpsRateCar.salesManRecordUserId = salesManRecordUser.Id;
cpsRateCar.recordId = salesManRecordUser.recordId;
return(cpsRateCar);
}
}
else
{
//这里表示没有保护期或者保护期失效 再根据是不是直接通过分销分享链接买的如果是则算给该分销员
SalesManRecord salesManRecord = base.GetModel($"Id={salesManRecordId} and state=1");
if (salesManRecord != null)
{
//表示关闭了保护期设置 直接通过分享链接购买
salesManRecordUser = SalesManRecordUserBLL.SingleModel.GetModel($" userId={userId} and protected_time=0 and salesmanId={salesManRecord.salesManId}");
if (salesManRecordUser != null)
{
cpsRateCar.salesManRecordUserId = salesManRecordUser.Id;
cpsRateCar.recordId = salesManRecord.Id;
cpsRateCar.cps_rate = entGoods.cps_rate;
}
}
}
}
return(cpsRateCar);
}
// GET: /SalesMan/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
SalesMan salesman = db.SalesMan.Find(id);
var cus = (from s in db.ServiceAssign
from c in db.Customer
from p in db.Service
where s.SalesManId == id && s.CustomerId == c.Id && s.NewspaperId == p.Id
select new
{
customer = c,
ServiceAssign = s,
service = p,
}).ToList(); // as IEnumerable<CounterVM>;
ViewBag.Newspaper = new SelectList(db.Service.ToList(), "NewsPaperName", "NewspaperName");
if (!(cus.Count == 0))
{
List <SalesmanVM> objConter = new List <SalesmanVM>();
foreach (var item in cus)
{
SalesmanVM counter = new SalesmanVM();
counter.salesman = salesman;
counter.Customertype = item.customer.CustomerType;
counter.CustomerId = item.customer.CustomerId;
counter.CustomerName = item.customer.FirstName;
counter.Address = item.customer.Address;
counter.Phone = item.customer.MPhone;
counter.Newspaper = item.service.NewsPaperName;
counter.Quantity = Convert.ToInt32(item.ServiceAssign.Quantity).ToString();
counter.Ended = item.ServiceAssign.EndedDate;
counter.EndedDate = ADTOBS.EngToNep(item.ServiceAssign.EndedDate).ToString();
counter.Paperdispatchdate = ADTOBS.EngToNep(item.ServiceAssign.PaperDispatchDate).ToString();
objConter.Add(counter);
}
ViewBag.errmsg = "customer";
if (objConter.AsEnumerable() == null)
{
return(HttpNotFound());
}
return(View(objConter.AsEnumerable()));
}
else
{
SalesmanVM objsale = new SalesmanVM();
List <SalesmanVM> objConter = new List <SalesmanVM>();
objsale.salesman = salesman;
objConter.Add(objsale);
ViewBag.errmsg = "no cus";
return(View(objConter.AsEnumerable()));
}
}
/// <summary>
/// 专业版小程序端接口调用申请提现
/// </summary>
/// <param name="appId"></param>
/// <param name="userId"></param>
/// <param name="drawCashMoney"></param>
/// <param name="partner_trade_no"></param>
/// <returns></returns>
public int AddDistributionDrawCashApply(int appId, int userId, int drawCashMoney, string partner_trade_no)
{
SalesMan salesMan = SalesManBLL.SingleModel.GetModel($"appId={appId} and userId={userId}");
if (salesMan == null)
{
return(-1);//表示申请提现的分销员不存在
}
if (salesMan.useCash < drawCashMoney)
{
return(-2);//表示本次申请的提现金额小于账号可提现金额
}
//后续加入提现黑名单
//int countNowDay = 0;//当天提现申请记录
// string sql = $"SELECT COUNT(*) FROM DrawCashApply WHERE TO_DAYS(AddTime)=TO_DAYS(NOW()) and userId={salesMan.UserId}";
//object obj = SqlMySql.ExecuteScalar(Utility.dbEnum.MINIAPP.ToString(), CommandType.Text, sql);
//if (obj != null)
//{
// countNowDay = Convert.ToInt32(obj);
//}
//if (countNowDay > 3)
// return -3;//当天提现次数超标
DrawCashApply drawCashApply = new DrawCashApply();
TransactionModel tranModel = new TransactionModel();
drawCashApply.partner_trade_no = partner_trade_no;
drawCashApply.userId = userId;
drawCashApply.AddTime = DateTime.Now;
drawCashApply.Aid = appId;
drawCashApply.applyType = 0;
drawCashApply.cashMoney = drawCashMoney;
drawCashApply.hostIP = Utility.WebHelper.GetIP();
drawCashApply.UpdateTime = DateTime.Now;
//提现金额需要进行审核
drawCashApply.state = 0;
drawCashApply.drawState = 0;
string salesManRecordIds = string.Join(",", SalesManRecordOrderBLL.SingleModel.GetSalesManRecordIds(salesMan.Id, appId));
OrderSum orderSumPeople = SalesManRecordOrderBLL.SingleModel.GetOrderSum(appId, salesManRecordIds, 0);
OrderSum orderSumAuto = SalesManRecordOrderBLL.SingleModel.GetOrderSum(appId, salesManRecordIds, 1);
drawCashApply.orderCount = orderSumPeople.payOrderCount + orderSumAuto.payOrderCount;
drawCashApply.orderTotalCpsMoney = (Convert.ToDouble(orderSumPeople.payOrderTotalCpsMoney) + Convert.ToDouble(orderSumAuto.payOrderTotalCpsMoney)).ToString();
drawCashApply.orderTotalMoney = (Convert.ToDouble(orderSumPeople.payOrderTotalPrice) + Convert.ToDouble(orderSumAuto.payOrderTotalPrice)).ToString();
int afterUseCash = salesMan.useCash - drawCashMoney;
drawCashApply.useCash = (afterUseCash * 0.01).ToString("0.00");
salesMan.useCash = afterUseCash;
salesMan.UpdateTime = DateTime.Now;
tranModel.Add(base.BuildAddSql(drawCashApply));
tranModel.Add(SalesManBLL.SingleModel.BuildUpdateSql(salesMan));
if (tranModel.sqlArray.Length > 0 && SalesManBLL.SingleModel.ExecuteTransactionDataCorect(tranModel.sqlArray))
{
return(1);//表示加入申请提现记录成功并且更新了分销员的提现金额
}
else
{
return(0);//表示执行事务失败
}
}
public abstract bool UpdateSalesManPasswordDAL(SalesMan updateSalesMan);
public abstract bool UpdateSalesManDAL(SalesMan updateSalesMan);
//Methods for CRUD operations public abstract bool AddSalesManDAL(SalesMan newSalesMan);
