/// <summary> /// 新增后台客户订单 /// </summary> public static string AddClientOrder(ClientOrder model) { string orderID = Guid.NewGuid().ToString(); SqlConnection conn = new SqlConnection(ClientOrderDAL.ConnectionString); conn.Open(); SqlTransaction tran = conn.BeginTransaction(); try { bool bl = ClientOrderDAL.BaseProvider.AddClientOrder(orderID, model.UserQuantity, model.Years, model.Amount, model.RealAmount,model.Type, model.AgentID, model.ClientID, model.CreateUserID,model.PayType,model.SystemType, model.SourceType,tran); if (bl) { //单据明细 foreach (var detail in model.Details) { if (!ClientOrderDAL.BaseProvider.AddClientOrderDetail(orderID, detail.ProductID, detail.Price, detail.Qunatity, detail.CreateUserID, tran)) { orderID = string.Empty; tran.Rollback(); conn.Dispose(); } } tran.Commit(); conn.Dispose(); } else { orderID = string.Empty; tran.Rollback(); conn.Dispose(); } } catch { orderID = string.Empty; tran.Rollback(); conn.Dispose(); } return orderID; }
/// <summary> /// 升级客户服务 /// </summary> /// <param name="client"></param> public JsonResult SaveClientAuthorize(string clientID, int serviceType, int giveType, int userQuantity, string endTime, int buyType, int buyUserQuantity, int buyUserYears) { bool flag = false; var client = ClientBusiness.GetClientDetail(clientID); var agent = AgentsBusiness.GetAgentDetail(client.AgentID); ClientAuthorizeLog log = new ClientAuthorizeLog(); log.CreateUserID = CurrentUser.UserID; log.ClientID = clientID; log.AgentID = client.AgentID; log.OrderID = string.Empty; if (serviceType == 1)//赠送 { if (giveType == 1)//赠送人数 { flag = AgentsBusiness.AddClientAgentUserQuantity(client.AgentID, userQuantity); log.BeginTime = agent.EndTime; log.EndTime = agent.EndTime; log.UserQuantity = userQuantity; log.Type = 2; } else//赠送时间 { log.BeginTime = agent.EndTime; flag = AgentsBusiness.SetClientAgentEndTime(client.AgentID, DateTime.Parse(endTime)); log.EndTime = DateTime.Parse(endTime); log.UserQuantity = agent.UserQuantity; log.Type = 3; } ClientBusiness.UpdatetClientCache(client.ClientID); AgentsBusiness.UpdatetAgentCache(client.AgentID); ClientBusiness.InsertClientAuthorizeLog(log); ClearClientCache(client.AgentID); } else//购买生成订单 { log.Type = buyType; int remainderMonths = 0;//剩余月份 int years = 1; if (buyType == 2)//购买人数 { remainderMonths = (agent.EndTime.Year - DateTime.Now.Year) * 12 + (agent.EndTime.Month - DateTime.Now.Month) - 1; if (agent.EndTime.Day >= DateTime.Now.Day) remainderMonths += 1; years = remainderMonths / 12 == 0 ? 1 : remainderMonths / 12; log.BeginTime = agent.EndTime; log.EndTime = agent.EndTime; log.UserQuantity = userQuantity; } else { years = buyUserYears; log.BeginTime = agent.EndTime; log.EndTime = agent.EndTime.AddYears(years); log.UserQuantity = agent.UserQuantity; } int pageCount = 0; int totalCount = 0; List<ModulesProduct> list = ModulesProductBusiness.GetModulesProducts(string.Empty, int.MaxValue, 1, ref totalCount, ref pageCount); //获取订单产品的最佳组合 var way = ModulesProductBusiness.GetBestWay(buyUserQuantity, list.OrderByDescending(m => m.UserQuantity).Where(m => m.PeriodQuantity == years).ToList()); //获取订单参数 ClientOrder model = new ClientOrder(); model.UserQuantity = way.TotalQuantity; model.Type = buyType; model.Years = years; model.Amount = way.TotalMoney; model.RealAmount = way.TotalMoney; model.SourceType = 1; //购买人数 float remainderYears = 1; if (buyType == 2) { remainderYears = (float)remainderMonths / (12 * years); model.Amount = decimal.Parse((float.Parse(model.Amount.ToString()) * remainderYears).ToString("f2")); model.RealAmount = model.Amount; } model.AgentID = client.AgentID; model.ClientID = client.ClientID; model.CreateUserID = CurrentUser.UserID; model.Details = new List<ClientOrderDetail>(); foreach (var p in way.Products) { ClientOrderDetail detail = new ClientOrderDetail(); detail.ProductID = p.Key; detail.Qunatity = p.Value; detail.CreateUserID = CurrentUser.CreateUserID; detail.Price = list.Find(m => m.ProductID == p.Key).Price; //购买人数 if (buyType == 2) { detail.Price = decimal.Parse((float.Parse(detail.Price.ToString()) * remainderYears).ToString("f2")); } model.Details.Add(detail); } string orderID = ClientOrderBusiness.AddClientOrder(model); log.OrderID = orderID; flag = string.IsNullOrEmpty(orderID) ? false : true; } JsonDictionary.Add("Result", flag ? 1 : 0); return new JsonResult() { Data = JsonDictionary, JsonRequestBehavior = JsonRequestBehavior.AllowGet }; }
/// <summary> /// 获取订单基本信息 /// </summary> public static ClientOrder GetClientOrderInfo(string orderID) { DataTable dt = ClientOrderDAL.BaseProvider.GetClientOrderInfo(orderID); ClientOrder model = new ClientOrder(); if (dt.Rows.Count == 1) { DataRow row = dt.Rows[0]; model.FillData(row); model.CreateUser = OrganizationBusiness.GetUserByUserID(model.CreateUserID, model.AgentID); if (string.IsNullOrEmpty(model.CreateUser.Name)) { M_Users mUser = M_UsersBusiness.GetUserDetail(model.CreateUserID); if (mUser != null && !string.IsNullOrEmpty(mUser.Name)) { model.CreateUser.Name = mUser.Name; } } if (!string.IsNullOrEmpty(model.CheckUserID)) { model.CheckUser = OrganizationBusiness.GetUserByUserID(model.CheckUserID, model.AgentID); if (string.IsNullOrEmpty(model.CheckUser.Name)) { M_Users mUser = M_UsersBusiness.GetUserDetail(model.CheckUserID); if (mUser != null && !string.IsNullOrEmpty(mUser.Name)) { model.CheckUser.Name = mUser.Name; } } } } return model; }
public static List<ClientOrder> GetBase(string keyWords, int status, int type, string beginDate, string endDate, string agentID, string clientID, int userType, int pageSize, int pageIndex, ref int totalCount, ref int pageCount) { DataTable dt = ClientOrderDAL.BaseProvider.GetClientOrders(keyWords,status, type, beginDate, endDate, agentID, clientID, pageSize, pageIndex, ref totalCount, ref pageCount); List<ClientOrder> list = new List<ClientOrder>(); if (dt.Rows.Count > 0) { foreach (DataRow row in dt.Rows) { ClientOrder model = new ClientOrder(); model.FillData(row); if (!string.IsNullOrEmpty(model.CheckUserID)) { model.CheckUser = OrganizationBusiness.GetUserByUserID(model.CheckUserID, model.AgentID); if (string.IsNullOrEmpty(model.CheckUser.Name)) { M_Users mUser = M_UsersBusiness.GetUserDetail(model.CheckUserID); if(mUser!=null && !string.IsNullOrEmpty(mUser.Name)){ model.CheckUser.Name = mUser.Name; } } } model.CreateUser = OrganizationBusiness.GetUserByUserID(model.CreateUserID, model.AgentID); if (string.IsNullOrEmpty(model.CreateUser.Name)) { M_Users mUser = M_UsersBusiness.GetUserDetail(model.CreateUserID); if (mUser != null && !string.IsNullOrEmpty(mUser.Name)) { model.CreateUser.Name = mUser.Name; } } list.Add(model); } } return list; }
/// <summary> /// 根据人数、年数生成客户订单 /// </summary> public JsonResult AddClientOrder(int quantity, int years, int type) { int remainderMonths = 12;//剩余月份 //购买人数 if (type == 2) { remainderMonths = (CurrentAgent.EndTime.Year - DateTime.Now.Year) * 12 + (CurrentAgent.EndTime.Month - DateTime.Now.Month) - 1; if (CurrentAgent.EndTime.Day >= DateTime.Now.Day) remainderMonths += 1; years = remainderMonths / 12 == 0 ? 1 : remainderMonths / 12; } int pageCount = 0; int totalCount = 0; List<ModulesProduct> list = ModulesProductBusiness.GetModulesProducts(string.Empty, int.MaxValue, 1, ref totalCount, ref pageCount); //获取订单产品的最佳组合 var way = ModulesProductBusiness.GetBestWay(quantity, list.OrderByDescending(m => m.UserQuantity).Where(m => m.PeriodQuantity == years).ToList()); //获取订单参数 ClientOrder model = new ClientOrder(); model.UserQuantity = way.TotalQuantity; model.Type = type; model.Years = years; model.Amount = way.TotalMoney; decimal discount = 1M; if (!string.IsNullOrEmpty(CurrentUser.AliMemberID)) { if (type == 1 || type == 2) { discount = 0.50M; } else { discount = 0.88M; } } else { if (type == 1 || type == 2) { discount = 0.5M; } } model.RealAmount = way.TotalMoney * discount; //购买人数 float remainderYears = 1; if (type == 2) { remainderYears = (float)remainderMonths / (12 * years); model.Amount = decimal.Parse((float.Parse(model.Amount.ToString()) * remainderYears).ToString("f2")); model.RealAmount = decimal.Parse((float.Parse(model.RealAmount.ToString()) * remainderYears).ToString("f2")); } model.AgentID = CurrentUser.AgentID; model.ClientID = CurrentUser.ClientID; model.CreateUserID = CurrentUser.UserID; model.SourceType = 0; model.Details = new List<ClientOrderDetail>(); foreach (var p in way.Products) { ClientOrderDetail detail = new ClientOrderDetail(); detail.ProductID = p.Key; detail.Qunatity = p.Value; detail.CreateUserID = CurrentUser.CreateUserID; detail.Price = list.Find(m => m.ProductID == p.Key).Price; //购买人数 if (type == 2) { detail.Price = decimal.Parse((float.Parse(detail.Price.ToString()) * remainderYears).ToString("f2")); } model.Details.Add(detail); } string orderID = ClientOrderBusiness.AddClientOrder(model); JsonDictionary.Add("ID", orderID); JsonDictionary.Add("RealAmount", model.RealAmount); return new JsonResult { Data = JsonDictionary, JsonRequestBehavior = JsonRequestBehavior.AllowGet }; }