protected override EmptyResponseData ProcessRequest(APIRequest <MultiCheckRP> pRequest) { var loggingSessionInfo = new SessionManager().CurrentUserLoginInfo; if (loggingSessionInfo == null) { throw new APIException("用户未登录") { ErrorCode = ERROR_CODES.INVALID_REQUEST } } ; VipWithdrawDepositApplyBLL bll = new VipWithdrawDepositApplyBLL(CurrentUserInfo); var result = bll.MultiCheck(pRequest.Parameters.Ids, pRequest.Parameters.Type, pRequest.Parameters.Remark); if (!result) { throw new APIException(ERROR_CODES.INVALID_BUSINESS, "审核失败"); } else { return(new EmptyResponseData()); } //throw new NotImplementedException(); } }
/// <summary> /// 提现确认/完成操作 /// </summary> /// <param name="pRequest"></param> /// <returns></returns> public string UpdateWDApply(string pRequest) { var rp = pRequest.DeserializeJSONTo <APIRequest <UpdateWDApplyRP> >(); //var loggingSessionInfo = Default.GetBSLoggingSession(rp.CustomerID, rp.UserID); var loggingSessionInfo = new SessionManager().CurrentUserLoginInfo; var vipWDApplyBll = new VipWithdrawDepositApplyBLL(loggingSessionInfo); //提现申请BLL实例化 string[] applyIdArray = rp.Parameters.ApplyID.Split(','); if (applyIdArray.Length > 0) { foreach (var applyId in applyIdArray) { var vipWDApplyEntity = vipWDApplyBll.GetByID(applyId); //获取提现申请对象 if (vipWDApplyEntity != null) { switch (rp.Parameters.Status) { case 1: //已确认 vipWDApplyEntity.Status = 1; vipWDApplyEntity.ConfirmDate = DateTime.Now; break; case 2: //已完成 vipWDApplyEntity.Status = 2; vipWDApplyEntity.CompleteDate = DateTime.Now; break; } vipWDApplyBll.Update(vipWDApplyEntity); //修改 } } } var rsp = new SuccessResponse <IAPIResponseData>(); return(rsp.ToJSON()); }
/// <summary> /// 提现记录列表 /// </summary> /// <returns></returns> public string GetWithdrawDeposit(string pRequest) { var rp = pRequest.DeserializeJSONTo <APIRequest <GetWDRP> >(); //var loggingSessionInfo = Default.GetBSLoggingSession(rp.CustomerID, rp.UserID); var loggingSessionInfo = new SessionManager().CurrentUserLoginInfo; var vipWDApplyBll = new VipWithdrawDepositApplyBLL(loggingSessionInfo); //提现申请BLL实例化 //查询参数 List <IWhereCondition> complexCondition = new List <IWhereCondition> { }; if (!string.IsNullOrEmpty(rp.Parameters.WithdrawNo)) //提现申请编号 { complexCondition.Add(new LikeCondition() { FieldName = "a.WithdrawNo", Value = "%" + rp.Parameters.WithdrawNo + "%" }); } //下面要加上对分销商的兼容性***** if (rp.Parameters.IsVip == 1)//会员 { if (!string.IsNullOrEmpty(rp.Parameters.VipName)) { complexCondition.Add(new LikeCondition() { FieldName = "v.VipName", Value = "%" + rp.Parameters.VipName + "%" }); } else if (rp.Parameters.IsVip == 2)//店员 { if (!string.IsNullOrEmpty(rp.Parameters.VipName)) { complexCondition.Add(new LikeCondition() { FieldName = "u.user_name", Value = "%" + rp.Parameters.VipName + "%" }); } } } //else if (rp.Parameters.IsVip == 3)//分销商 // complexCondition.Add(new LikeCondition() { FieldName = "u.RetailTraderName", Value = "%" + rp.Parameters.VipName + "%" }); if (!string.IsNullOrEmpty(rp.Parameters.Status))//判断状态 { complexCondition.Add(new EqualsCondition() { FieldName = "a.Status", Value = rp.Parameters.Status }); } complexCondition.Add(new EqualsCondition() { FieldName = "a.CustomerID", Value = loggingSessionInfo.ClientID }); //排序参数 List <OrderBy> lstOrder = new List <OrderBy> { }; lstOrder.Add(new OrderBy() { FieldName = "a.ApplyDate", Direction = OrderByDirections.Desc }); //根据rp.Parameters.IsVip查询不同的数据源 var wdApplyList = vipWDApplyBll.PagedQuery(complexCondition.ToArray(), lstOrder.ToArray(), rp.Parameters.PageSize, rp.Parameters.PageIndex + 1, rp.Parameters.IsVip); var rd = new WDManageInfoRD(); rd.TotalPageCount = wdApplyList.PageCount; rd.TotalCount = wdApplyList.RowCount; rd.WithdrawDepositList = wdApplyList.Entities.Select(t => new WDManageInfo() { AccountName = t.AccountName, ApplyID = t.ApplyID, WithdrawNo = t.WithdrawNo, ApplyDate = t.ApplyDate, VipName = t.VipName, VipId = t.VipID, Amount = t.Amount, Status = t.Status, CompleteDate = t.CompleteDate, BankName = t.BankName, CardNo = t.CardNo }).ToArray(); var rsp = new SuccessResponse <IAPIResponseData>(rd); return(rsp.ToJSON()); //return "{\"ResultCode\":0,\"Message\":\"OK\",\"IsSuccess\":true,\"Data\":{\"WithdrawDepositList\":[{\"ApplyID\":\"2E0AB4E2-53ED-4E19-90FE-8E1A56B324AB\",\"WithdrawNo\":\"2014123124030003\",\"ApplyDate\":\"2014-12-31\",\"Amount\":10,\"Status\":0,\"CompleteDate\":\"\",\"VipName\":\"demo1\",\"VipID\":\"0184281DFCAA41B5A5677FBC44BC12AA\"}],\"TotalPageCount\":1}}"; }
protected override GetWithdrawDepositApplyListRD ProcessRequest(DTO.Base.APIRequest <GetWithdrawDepositApplyListRP> pRequest) { var loggingSessionInfo = new SessionManager().CurrentUserLoginInfo; if (loggingSessionInfo == null) { throw new APIException("用户未登录") { ErrorCode = ERROR_CODES.INVALID_REQUEST } } ; var parameter = pRequest.Parameters; //排序参数 List <OrderBy> orderList = new List <OrderBy> { }; orderList.Add(new OrderBy() { FieldName = "ApplyDate", Direction = OrderByDirections.Desc }); //查询参数 List <IWhereCondition> complexCondition = new List <IWhereCondition> { }; if (!string.IsNullOrWhiteSpace(pRequest.Parameters.WithdrawNo)) { complexCondition.Add(new LikeCondition() { FieldName = "WithdrawNo", Value = "%" + parameter.WithdrawNo + "%" }); } if (pRequest.Parameters.VipType != null && pRequest.Parameters.VipType != -1) { complexCondition.Add(new EqualsCondition() { FieldName = "VipType", Value = parameter.VipType }); } if (!string.IsNullOrWhiteSpace(pRequest.Parameters.Name)) { complexCondition.Add(new LikeCondition() { FieldName = "Name", Value = "%" + parameter.Name + "%" }); } if (!string.IsNullOrWhiteSpace(pRequest.Parameters.Phone)) { complexCondition.Add(new LikeCondition() { FieldName = "Phone", Value = "%" + parameter.Phone + "%" }); } if (!string.IsNullOrWhiteSpace(pRequest.Parameters.ApplyStartDate)) { complexCondition.Add(new DirectCondition() { Expression = "ApplyDate>='" + parameter.ApplyStartDate + "'" }); } if (!string.IsNullOrWhiteSpace(pRequest.Parameters.ApplyEndDate)) { if (parameter.ApplyStartDate == parameter.ApplyEndDate) { parameter.ApplyEndDate = parameter.ApplyEndDate + " 23:59"; } complexCondition.Add(new DirectCondition { Expression = "ApplyDate<='" + parameter.ApplyEndDate + "'" }); } if (parameter.Status != null && parameter.Status != -1) { complexCondition.Add(new EqualsCondition() { FieldName = "Status", Value = parameter.Status }); } if (!string.IsNullOrWhiteSpace(parameter.CompleteStartDate)) { complexCondition.Add(new DirectCondition() { Expression = "CompleteDate>='" + parameter.CompleteStartDate + "'" }); } if (!string.IsNullOrWhiteSpace(parameter.CompleteEndDate)) { if (parameter.CompleteEndDate == parameter.CompleteStartDate) { parameter.CompleteEndDate = parameter.CompleteEndDate + ": 23:59"; } complexCondition.Add(new DirectCondition { Expression = "CompleteDate<='" + parameter.CompleteEndDate + "'" }); } VipWithdrawDepositApplyBLL bll = new VipWithdrawDepositApplyBLL(CurrentUserInfo); int rowCount = 0; int pageCount = 0; var dbSet = bll.PagedQueryDbSet(complexCondition.ToArray(), orderList.ToArray(), parameter.PageSize, parameter.PageIndex, out rowCount, out pageCount); var dbList = DataTableToObject.ConvertToList <WithdrawDepositApplyInfo>(dbSet.Tables[0]); foreach (var m in dbList) { m.ApplyDate = string.IsNullOrWhiteSpace(m.ApplyDate) ? string.Empty : Convert.ToDateTime(m.ApplyDate).ToString("yyyy-MM-dd"); m.CompleteDate = string.IsNullOrWhiteSpace(m.CompleteDate) ? string.Empty : Convert.ToDateTime(m.CompleteDate).ToString("yyyy-MM-dd"); } var result = new GetWithdrawDepositApplyListRD(); result.List = dbList; result.TotalCount = rowCount; result.TotalPage = pageCount; return(result); } }
private void DownLoadTXExcel(HttpContext pContext) { var req = pContext.Request["req"]; if (string.IsNullOrWhiteSpace(req)) { return; } var pRequest = JsonConvert.DeserializeObject <DTO.Base.APIRequest <GetWithdrawDepositApplyListRP> >(req); var loggingSessionInfo = new SessionManager().CurrentUserLoginInfo; if (loggingSessionInfo == null) { //throw new APIException("用户未登录") { ErrorCode = ERROR_CODES.INVALID_REQUEST }; return; } #region 获取数据 //排序参数 List <OrderBy> orderList = new List <OrderBy> { }; orderList.Add(new OrderBy() { FieldName = "ApplyDate", Direction = OrderByDirections.Desc }); //查询参数 List <IWhereCondition> complexCondition = new List <IWhereCondition> { }; if (!string.IsNullOrWhiteSpace(pRequest.Parameters.WithdrawNo)) { complexCondition.Add(new LikeCondition() { FieldName = "WithdrawNo", Value = "%" + pRequest.Parameters.WithdrawNo + "%" }); } if (pRequest.Parameters.VipType != null && pRequest.Parameters.VipType != -1) { complexCondition.Add(new EqualsCondition() { FieldName = "VipType", Value = pRequest.Parameters.VipType }); } if (!string.IsNullOrWhiteSpace(pRequest.Parameters.Name)) { complexCondition.Add(new JIT.Utility.DataAccess.Query.LikeCondition() { FieldName = "Name", Value = "%" + pRequest.Parameters.Name + "%" }); } if (!string.IsNullOrWhiteSpace(pRequest.Parameters.Phone)) { complexCondition.Add(new JIT.Utility.DataAccess.Query.LikeCondition() { FieldName = "Phone", Value = "%" + pRequest.Parameters.Phone + "%" }); } //if (!string.IsNullOrWhiteSpace(pRequest.Parameters.ApplyStartDate)) // complexCondition.Add(new JIT.Utility.DataAccess.Query.MoreThanCondition() { FieldName = "ApplyDate", Value = Convert.ToDateTime(pRequest.Parameters.ApplyStartDate) }); //if (!string.IsNullOrWhiteSpace(pRequest.Parameters.ApplyEndDate)) // complexCondition.Add(new JIT.Utility.DataAccess.Query.LessThanCondition() { FieldName = "ApplyDate", Value = Convert.ToDateTime(pRequest.Parameters.ApplyEndDate) }); if (!string.IsNullOrWhiteSpace(pRequest.Parameters.ApplyStartDate)) { complexCondition.Add(new DirectCondition() { Expression = "ApplyDate>='" + pRequest.Parameters.ApplyStartDate + "'" }); } if (!string.IsNullOrWhiteSpace(pRequest.Parameters.ApplyEndDate)) { if (pRequest.Parameters.ApplyStartDate == pRequest.Parameters.ApplyEndDate) { pRequest.Parameters.ApplyEndDate = pRequest.Parameters.ApplyEndDate + " 23:59"; } complexCondition.Add(new DirectCondition { Expression = "ApplyDate<='" + pRequest.Parameters.ApplyEndDate + "'" }); } if (pRequest.Parameters.Status != null && pRequest.Parameters.Status != -1) { complexCondition.Add(new JIT.Utility.DataAccess.Query.EqualsCondition() { FieldName = "Status", Value = pRequest.Parameters.Status }); } if (!string.IsNullOrWhiteSpace(pRequest.Parameters.CompleteStartDate)) { complexCondition.Add(new DirectCondition() { Expression = "CompleteDate >='" + pRequest.Parameters.CompleteStartDate + "'" }); } if (!string.IsNullOrWhiteSpace(pRequest.Parameters.CompleteEndDate)) { if (pRequest.Parameters.CompleteEndDate == pRequest.Parameters.CompleteEndDate) { pRequest.Parameters.CompleteEndDate = pRequest.Parameters.CompleteEndDate + " 23:59"; } complexCondition.Add(new DirectCondition { Expression = "CompleteDate<='" + pRequest.Parameters.CompleteEndDate + "'" }); } VipWithdrawDepositApplyBLL bll = new VipWithdrawDepositApplyBLL(loggingSessionInfo); int rowCount = 0; int pageCount = 0; var dbSet = bll.PagedQueryDbSet(complexCondition.ToArray(), orderList.ToArray(), 10000, pRequest.Parameters.PageIndex, out rowCount, out pageCount); var dbList = DataTableToObject.ConvertToList <WithdrawDepositApplyInfo>(dbSet.Tables[0]); foreach (var m in dbList) { m.ApplyDate = m.ApplyDate + "" == "" ? "" : Convert.ToDateTime(m.ApplyDate).ToString("yyyy-MM-dd"); m.CompleteDate = m.CompleteDate + "" == "" ? "" : Convert.ToDateTime(m.CompleteDate).ToString("yyyy-MM-dd"); } #endregion //var dt = ToDataTable<WithdrawDepositApplyInfo>(dbList); DataTable dt = new DataTable("dt"); dt.Columns.Add("提现单号"); dt.Columns.Add("姓名"); dt.Columns.Add("类别"); dt.Columns.Add("手机号"); dt.Columns.Add("提现金额(元)"); dt.Columns.Add("银行名称"); dt.Columns.Add("银行卡号"); dt.Columns.Add("开户人姓名"); dt.Columns.Add("状态"); dt.Columns.Add("申请时间"); dt.Columns.Add("完成时间"); foreach (var m in dbList) { DataRow row = dt.NewRow(); row["提现单号"] = m.WithdrawNo; row["姓名"] = m.Name; switch (m.VipType) { case 1: row["类别"] = "会员"; break; case 2: row["类别"] = "员工"; break; case 3: row["类别"] = "旧分销商"; break; case 4: row["类别"] = "分销商"; break; default: row["类别"] = ""; break; } row["手机号"] = m.Phone; row["提现金额(元)"] = m.Amount; row["银行名称"] = m.BankName; row["银行卡号"] = m.CardNo; row["开户人姓名"] = m.AccountName; switch (m.Status) { case 1: row["状态"] = "待审核"; break; case 2: row["状态"] = "已审核"; break; case 3: row["状态"] = "已完成"; break; case 4: row["状态"] = "审核不通过"; break; default: break; } row["申请时间"] = m.ApplyDate; row["完成时间"] = m.CompleteDate; dt.Rows.Add(row); } ExcelHelper excel = new ExcelHelper(); //上传目录 string directory = "~/Framework/Upload/"; //判断目录是否存在 if (!System.IO.Directory.Exists(pContext.Server.MapPath(directory))) { System.IO.Directory.CreateDirectory(pContext.Server.MapPath(directory)); } string fileName = DateTime.Now.Ticks + ".xls"; string MapUrl = pContext.Server.MapPath(directory + fileName); //string MapUrl = pContext.Server.MapPath(DateTime.Now.Ticks + ".xls"); excel.RenderToExcel(dt, MapUrl); Utils.OutputExcel(pContext, MapUrl);//输出Excel文件 }