public LoginController(AccountApplication accountApplication, TokenConfigurations tokenConfigurations ) { this.accountApplication = accountApplication; this.tokenConfigurations = tokenConfigurations; }
public JsonResult DetailList(long accountId, int enumOrderTypeId, DateTime?startDate, DateTime?endDate, int page, int rows) { var queryModel = new AccountQuery() { StartDate = startDate, EndDate = endDate.HasValue ? endDate.Value.AddDays(1) : endDate, AccountId = accountId, PageSize = rows, EnumOrderType = (Entities.AccountDetailInfo.EnumOrderType)enumOrderTypeId, PageNo = page }; var accountDetails = AccountApplication.GetAccountDetails(queryModel); var result = (from p in accountDetails.Models select new { p.Id, p.OrderType, OrderTypeDescription = p.OrderType.ToDescription(), p.OrderId, p.ProductActualPaidAmount, p.FreightAmount, p.CommissionAmount, p.RefundCommisAmount, p.BrokerageAmount, p.ReturnBrokerageAmount, p.RefundTotalAmount, Date = p.Date.ToString(), OrderDate = p.OrderDate.ToString(), p.OrderRefundsDates }).ToList(); return(Json(new { rows = result, total = accountDetails.Total })); }
public FileResult AgreementDetailListExportExcel(long accountId, int enumOrderTypeId, DateTime?startDate, DateTime?endDate) { var queryModel = new AccountQuery() { StartDate = startDate, EndDate = endDate.HasValue ? endDate.Value.AddDays(1) : endDate, AccountId = accountId, PageSize = int.MaxValue, PageNo = 1 }; QueryPageModel <DTO.AccountMetaModel> pageModelMetaInfo = AccountApplication.GetAccountMeta(queryModel); var mode = pageModelMetaInfo.Models.ToList().Select(e => new DTO.AccountMetaModel { AccountId = e.Id, Id = e.Id, EndDate = e.EndDate, StartDate = e.StartDate, MetaKey = e.MetaKey, MetaValue = e.MetaValue, DateRange = e.StartDate.ToString("yyyy-MM-dd") + " 至 " + e.EndDate.ToString("yyyy-MM-dd") }).ToList(); //创建Excel文件的对象 NPOI.HSSF.UserModel.HSSFWorkbook book = new NPOI.HSSF.UserModel.HSSFWorkbook(); //添加一个sheet ISheet sheet1 = book.CreateSheet("Sheet1"); //获取list数据 //给sheet1添加第一行的头部标题 IRow row1 = sheet1.CreateRow(0); row1.CreateCell(0).SetCellValue("类型"); row1.CreateCell(1).SetCellValue("营销类型"); row1.CreateCell(2).SetCellValue("费用"); row1.CreateCell(3).SetCellValue("服务周期"); sheet1.SetColumnWidth(0, 550 * 5); sheet1.SetColumnWidth(1, 550 * 20); sheet1.SetColumnWidth(2, 550 * 8); sheet1.SetColumnWidth(3, 550 * 15); //将数据逐步写入sheet1各个行 for (int i = 0; i < mode.Count(); i++) { IRow rowtemp = sheet1.CreateRow(i + 1); rowtemp.CreateCell(0).SetCellValue("营销服务费"); rowtemp.CreateCell(1).SetCellValue(mode[i].MetaKey); rowtemp.CreateCell(2).SetCellValue(mode[i].MetaValue); rowtemp.CreateCell(3).SetCellValue(mode[i].DateRange); } // 写入到客户端 System.IO.MemoryStream ms = new System.IO.MemoryStream(); book.Write(ms); ms.Seek(0, SeekOrigin.Begin); return(File(ms, "application/vnd.ms-excel", "结算详情-营销服务费列表.xls")); }
public ActionResult AccountDetail(long id) { Entities.AccountInfo account = AccountApplication.GetAccount(id); if (account.ShopId != CurrentSellerManager.ShopId) { throw new MallException("不存在该结算信息" + id); } return(View(account)); }
public IActionResult Post(AccountMasterDTO account, [FromServices] AccountApplication accountApplication) { try { return(Ok(accountApplication.Created(account))); } catch (Exception ex) { return(BadRequest(ex)); } }
public IActionResult GetById(int id, [FromServices] AccountApplication accountApplication) { try { return(Ok(accountApplication.GetById(id))); } catch (Exception ex) { return(BadRequest(ex)); } }
public IActionResult GetAllAccountsMaster([FromServices] AccountApplication accountApplication) { try { return(Ok(accountApplication.GetAllAccountsMaster())); } catch (Exception ex) { return(BadRequest(ex)); } }
public IActionResult GetChildrenAccounts(int childrenAccountsId, [FromServices] AccountApplication accountApplication) { try { return(Ok(accountApplication.GetChildrenAccounts(childrenAccountsId))); } catch (Exception ex) { return(BadRequest(ex)); } }
public IActionResult PostFull(AccountFullDTO account, [FromServices] AccountApplication accountApplication) { try { return(Ok(accountApplication.PostFull(account))); } catch (Exception ex) { return(BadRequest(ex)); } }
public IActionResult Put(int id, AccountUpdated account, [FromServices] AccountApplication accountApplication) { try { return(Ok(accountApplication.Updated(id, account))); } catch (Exception ex) { return(BadRequest(ex)); } }
public JsonResult ConfirmAccount(long id, string remark) { Result result = new Result(); try { AccountApplication.ConfirmAccount(id, remark); result.success = true; } catch (Exception ex) { result.msg = ex.Message; } return(Json(result)); }
public JsonResult List(int status, string shopName, int page, int rows) { var queryModel = new AccountQuery() { Status = (Entities.AccountInfo.AccountStatus?)status, ShopName = shopName, PageSize = rows, PageNo = page }; var accounts = AccountApplication.GetAccounts(queryModel); var models = new List <AccountModel>(); foreach (var item in accounts.Models) { AccountModel model = new AccountModel(); model.Id = item.Id; model.ShopId = item.ShopId; model.ShopName = item.ShopName; model.AccountDate = item.AccountDate.ToString(); model.StartDate = item.StartDate; model.EndDate = item.EndDate; model.Status = (int)item.Status; model.ProductActualPaidAmount = item.ProductActualPaidAmount; model.FreightAmount = item.FreightAmount; model.CommissionAmount = item.CommissionAmount; model.RefundAmount = item.RefundAmount; model.RefundCommissionAmount = item.RefundCommissionAmount; model.AdvancePaymentAmount = item.AdvancePaymentAmount; model.PeriodSettlement = item.PeriodSettlement; model.Remark = item.Remark; model.BrokerageAmount = item.Brokerage; model.ReturnBrokerageAmount = item.ReturnBrokerage; model.TimeSlot = string.Format("{0} 至 {1}", model.StartDate.Date.ToString("yyyy-MM-dd"), model.EndDate.Date.ToString("yyyy-MM-dd")); models.Add(model); } return(Json(new { rows = models, total = accounts.Total })); }
public JsonResult MetaDetailList(long accountId, int enumOrderTypeId, DateTime? startDate, DateTime? endDate, int page, int rows) { var queryModel = new AccountQuery() { StartDate = startDate, EndDate = endDate.HasValue ? endDate.Value.AddDays(1) : endDate, AccountId = accountId, PageSize = rows, PageNo = page }; QueryPageModel<DTO.AccountMetaModel> pageModelMetaInfo = AccountApplication.GetAccountMeta(queryModel); var mode = pageModelMetaInfo.Models.ToList().Select(e => new DTO.AccountMetaModel { AccountId = e.Id, Id = e.Id, EndDate = e.EndDate, StartDate = e.StartDate, MetaKey = e.MetaKey, MetaValue = e.MetaValue, DateRange = e.StartDate.ToString("yyyy-MM-dd") + " 至 " + e.EndDate.ToString("yyyy-MM-dd") }); return Json(new { rows = mode, total = pageModelMetaInfo.Total }); }
public AccountController(AccountApplication accountApplication) { this._accountApplication = accountApplication; }
public AccountController(AccountApplication application) { _accountApplication = application; }
public FileResult ExportExcel(int status, string shopName) { var queryModel = new AccountQuery() { Status = (Entities.AccountInfo.AccountStatus?)status, ShopName = shopName, PageSize = int.MaxValue, PageNo = 1 }; var accounts = AccountApplication.GetAccounts(queryModel); var models = new List <AccountModel>(); foreach (var item in accounts.Models.ToArray()) { AccountModel model = new AccountModel(); model.Id = item.Id; model.ShopId = item.ShopId; model.ShopName = item.ShopName; model.AccountDate = item.AccountDate.ToString(); model.StartDate = item.StartDate; model.EndDate = item.EndDate; model.Status = (int)item.Status; model.ProductActualPaidAmount = item.ProductActualPaidAmount; model.FreightAmount = item.FreightAmount; model.CommissionAmount = item.CommissionAmount; model.RefundAmount = item.RefundAmount; model.RefundCommissionAmount = item.RefundCommissionAmount; model.BrokerageAmount = item.Brokerage; model.ReturnBrokerageAmount = item.ReturnBrokerage; model.AdvancePaymentAmount = item.AdvancePaymentAmount; model.PeriodSettlement = item.PeriodSettlement; model.Remark = item.Remark; model.TimeSlot = string.Format("{0} 至 {1}", model.StartDate.Date.ToString("yyyy-MM-dd"), model.EndDate.Date.ToString("yyyy-MM-dd")); models.Add(model); } //创建Excel文件的对象 NPOI.HSSF.UserModel.HSSFWorkbook book = new NPOI.HSSF.UserModel.HSSFWorkbook(); //添加一个sheet ISheet sheet1 = book.CreateSheet("Sheet1"); //获取list数据 //给sheet1添加第一行的头部标题 var thead = sheet1.CreateRow(0); thead.CreateCell(0).SetCellValue("店铺名称"); thead.CreateCell(1).SetCellValue("时间段"); thead.CreateCell(2).SetCellValue("商品实付总额"); thead.CreateCell(3).SetCellValue("运费"); thead.CreateCell(4).SetCellValue("佣金"); thead.CreateCell(5).SetCellValue("退款金额"); thead.CreateCell(6).SetCellValue("退还佣金"); thead.CreateCell(7).SetCellValue("分销佣金"); thead.CreateCell(8).SetCellValue("退还分销佣金"); thead.CreateCell(9).SetCellValue("营销费用总额"); thead.CreateCell(10).SetCellValue("本期应结"); thead.CreateCell(11).SetCellValue("出账日期"); //将数据逐步写入sheet1各个行 for (int i = 0; i < models.Count; i++) { var row = sheet1.CreateRow(i + 1); row.CreateCell(0).SetCellValue(models[i].ShopName); row.CreateCell(1).SetCellValue(models[i].TimeSlot); row.CreateCell(2).SetCellValue(models[i].ProductActualPaidAmount.ToString()); row.CreateCell(3).SetCellValue(models[i].FreightAmount.ToString()); row.CreateCell(4).SetCellValue(models[i].CommissionAmount.ToString()); row.CreateCell(5).SetCellValue(models[i].RefundAmount.ToString()); row.CreateCell(6).SetCellValue(models[i].RefundCommissionAmount.ToString()); row.CreateCell(7).SetCellValue(models[i].BrokerageAmount.ToString()); row.CreateCell(8).SetCellValue(models[i].ReturnBrokerageAmount.ToString()); row.CreateCell(9).SetCellValue(models[i].AdvancePaymentAmount.ToString()); row.CreateCell(10).SetCellValue(models[i].PeriodSettlement.ToString()); row.CreateCell(11).SetCellValue(models[i].AccountDate.ToString()); } // 写入到客户端 var ms = new System.IO.MemoryStream(); book.Write(ms); ms.Seek(0, SeekOrigin.Begin); return(File(ms, "application/vnd.ms-excel", "结算管理.xls")); }
public AccountController(AccountApplication accountApplication) => this.accountApplication = accountApplication;
public ActionResult Detail(long id) { Entities.AccountInfo account = AccountApplication.GetAccount(id); return(View(account)); }
public FileResult DetailListExportExcel(long accountId, int enumOrderTypeId, DateTime?startDate, DateTime?endDate) { var queryModel = new AccountQuery() { StartDate = startDate, EndDate = endDate.HasValue ? endDate.Value.AddDays(1) : endDate, AccountId = accountId, PageSize = int.MaxValue, EnumOrderType = (Entities.AccountDetailInfo.EnumOrderType)enumOrderTypeId, PageNo = 1 }; var accountDetails = AccountApplication.GetAccountDetails(queryModel); var accountDetailsModel = (from p in accountDetails.Models.ToList() select new { p.Id, p.OrderType, OrderTypeDescription = p.OrderType.ToDescription(), p.OrderId, p.ProductActualPaidAmount, p.FreightAmount, p.CommissionAmount, p.RefundCommisAmount, p.RefundTotalAmount, Date = p.Date.ToString(), OrderDate = p.OrderDate.ToString(), p.OrderRefundsDates }).ToList(); //创建Excel文件的对象 NPOI.HSSF.UserModel.HSSFWorkbook book = new NPOI.HSSF.UserModel.HSSFWorkbook(); //添加一个sheet ISheet sheet1 = book.CreateSheet("Sheet1"); //获取list数据 //给sheet1添加第一行的头部标题 string titleFlag = string.Empty; IRow row1 = sheet1.CreateRow(0); if (enumOrderTypeId == 1) { titleFlag = "订单列表"; row1.CreateCell(0).SetCellValue("类型"); row1.CreateCell(1).SetCellValue("订单编号"); row1.CreateCell(2).SetCellValue("商品实付金额"); row1.CreateCell(3).SetCellValue("运费"); row1.CreateCell(4).SetCellValue("佣金"); row1.CreateCell(5).SetCellValue("下单日期"); row1.CreateCell(6).SetCellValue("成交日期"); sheet1.SetColumnWidth(0, 550 * 5); sheet1.SetColumnWidth(1, 550 * 20); sheet1.SetColumnWidth(2, 550 * 8); sheet1.SetColumnWidth(3, 550 * 5); sheet1.SetColumnWidth(4, 550 * 5); sheet1.SetColumnWidth(5, 550 * 15); sheet1.SetColumnWidth(6, 550 * 15); } else if (enumOrderTypeId == 0) { titleFlag = "退单列表"; row1.CreateCell(0).SetCellValue("类型"); row1.CreateCell(1).SetCellValue("订单编号"); row1.CreateCell(2).SetCellValue("商品实付金额"); row1.CreateCell(3).SetCellValue("运费"); row1.CreateCell(4).SetCellValue("退款金额"); row1.CreateCell(5).SetCellValue("退还佣金"); row1.CreateCell(6).SetCellValue("退单日期"); sheet1.SetColumnWidth(0, 550 * 5); sheet1.SetColumnWidth(1, 550 * 20); sheet1.SetColumnWidth(2, 550 * 8); sheet1.SetColumnWidth(3, 550 * 5); sheet1.SetColumnWidth(4, 550 * 8); sheet1.SetColumnWidth(5, 550 * 5); sheet1.SetColumnWidth(6, 550 * 15); } //将数据逐步写入sheet1各个行 for (int i = 0; i < accountDetailsModel.Count(); i++) { IRow rowtemp = sheet1.CreateRow(i + 1); if (enumOrderTypeId == 1) { rowtemp.CreateCell(0).SetCellValue(titleFlag); rowtemp.CreateCell(1).SetCellValue(accountDetailsModel[i].OrderId.ToString()); rowtemp.CreateCell(2).SetCellValue(accountDetailsModel[i].ProductActualPaidAmount.ToString()); rowtemp.CreateCell(3).SetCellValue(accountDetailsModel[i].FreightAmount.ToString()); rowtemp.CreateCell(4).SetCellValue(accountDetailsModel[i].CommissionAmount.ToString()); rowtemp.CreateCell(5).SetCellValue(accountDetailsModel[i].OrderDate.ToString()); rowtemp.CreateCell(6).SetCellValue(accountDetailsModel[i].Date.ToString()); } else if (enumOrderTypeId == 0) { rowtemp.CreateCell(0).SetCellValue(titleFlag); rowtemp.CreateCell(1).SetCellValue(accountDetailsModel[i].OrderId.ToString()); rowtemp.CreateCell(2).SetCellValue(accountDetailsModel[i].ProductActualPaidAmount.ToString()); rowtemp.CreateCell(3).SetCellValue(accountDetailsModel[i].FreightAmount.ToString()); rowtemp.CreateCell(4).SetCellValue(accountDetailsModel[i].RefundTotalAmount.ToString()); rowtemp.CreateCell(5).SetCellValue(accountDetailsModel[i].RefundCommisAmount.ToString()); rowtemp.CreateCell(6).SetCellValue(accountDetailsModel[i].OrderRefundsDates.ToString()); } } // 写入到客户端 System.IO.MemoryStream ms = new System.IO.MemoryStream(); book.Write(ms); ms.Seek(0, SeekOrigin.Begin); return(File(ms, "application/vnd.ms-excel", string.Format("结算详情-{0}.xls", titleFlag))); }
public RegisterController(AccountApplication application) { _accountApplication = application; }
public void Delete(AccountApplication accountApplication) { context.AccountApplications.Remove(context.AccountApplications.Find(accountApplication.Id)); }