///// <summary> /////发送短信 ///// </summary> //private string SendSMS(HttpContext context) //{ // string PhoneList = context.Request["PhoneList"]; // //var SMSContent = context.Request["SMSContent"]; // //if (string.IsNullOrWhiteSpace(SMSContent)) // //{ // // return "请输入短信内容"; // //} // //var userInfo= DataLoadTool.GetCurrUserModel(); // //int count = 0; // //foreach (var item in PhoneList.Split(',')) // //{ // // string Parm = string.Format("userName={0}&userPwd={1}&mobile={2}&content={3}&pipeID=membertrigger", userInfo.UserID, userInfo.Password, item, SMSContent); // // Common.HttpInterFace obj = new Common.HttpInterFace(); // // string result = obj.PostWebRequest(Parm, "http://www.jubit.org/Serv/SubmitSMSAPI.aspx", System.Text.Encoding.GetEncoding("gb2312")); // // if (result=="0") // // { // // count++; // // } // // else // // { // // } // //} // //if (PhoneList.Split(',').Length==count) // //{ // // return "true"; // //} // //else // //{ // // return "短信未全部发送成功,请检查余额或联系管理员"; // //} // //BLLMember bllMember = new BLLMember(""); // //context.Session[SessionKey.PageRedirect] = "/Activity/ActivityData.aspx"; // //context.Session[SessionKey.PageCacheName] = "cache" + bllMember.GetGUID(TransacType.CacheGet); // //Comm.DataCache.SetCache(context.Session[SessionKey.PageCacheName].ToString(), PhoneList); // return "true"; //} /// <summary> /// 下载报名数据 /// </summary> /// <param name="context"></param> /// <returns></returns> private void DownLoadActivityData(HttpContext context) { BLLPermission.BLLMenuPermission bllMenupermission = new BLLPermission.BLLMenuPermission(""); bool isData = bllMenupermission.CheckPerRelationByaccount(bllUser.GetCurrUserID(), -1); if (isData) { return; } string activityId = context.Request["ActivityID"]; string exportType = context.Request["type"]; if (!bllActivity.IsExistActivity(activityId)) { return; } ////判断普通用户是否有相应权限 //if (!bll.CheckActivityIDAndUser(ActivityID, cu.UserID) && userInfo.UserType != 1) // return; #region 日志模块 if (exportType == "DistributionOffLine") { bllLog.Add(BLLJIMP.Enums.EnumLogType.DistributionOffLine, BLLJIMP.Enums.EnumLogTypeAction.Export, bllUser.GetCurrUserID(), "导出分销员审核数据"); } else { bllLog.Add(BLLJIMP.Enums.EnumLogType.DistributionOffLine, BLLJIMP.Enums.EnumLogTypeAction.Export, bllUser.GetCurrUserID(), "导出活动报名数据"); } #endregion DataTable dataTable = bllActivity.QueryActivityData(activityId); string fileName = bllActivity.GetActivityInfoByActivityID(activityId).ActivityName; DataLoadTool.ExportDataTable(dataTable, string.Format("{0}_{1}_data.xls", fileName, DateTime.Now.ToString())); }
public void ProcessRequest(HttpContext context) { int lotteryId = int.Parse(context.Request["LotteryId"]); bllLog.Add(BLLJIMP.Enums.EnumLogType.Marketing, BLLJIMP.Enums.EnumLogTypeAction.Export, bllLog.GetCurrUserID(), "导出中奖名单"); DataTable dt = bllLottery.QueryLotteryData(lotteryId); foreach (DataRow dr in dt.Rows) { UserInfo userInfo = bllUser.GetUserInfo(dr["UserID"].ToString()); if (userInfo != null) { if (string.IsNullOrEmpty(dr["姓名"].ToString())) { dr["姓名"] = userInfo.TrueName; } if (string.IsNullOrEmpty(dr["手机"].ToString())) { dr["手机"] = userInfo.Phone; } } } dt.Columns.Remove("UserID"); DataLoadTool.ExportDataTable(dt, string.Format("{0}_{1}data.xls", "中奖名单", DateTime.Now.ToString())); }
/// <summary> /// 导出数据 /// </summary> private void DownLoadForwardData(HttpContext context) { string mid = context.Request["Mid"]; //string activityId = context.Request["activityID"]; //string uId = context.Request["uid"]; // activityId = bllActivity.Get<BLLJIMP.Model.JuActivityInfo>(" JuActivityID=" + activityId).SignUpActivityID; // DataTable dt = new DataTable(); StringBuilder strSql = new StringBuilder(); strSql.Append("SELECT "); strSql.AppendFormat(" userInfo.TrueName as 转发人姓名,"); strSql.AppendFormat(" userInfo.Phone as 转发人手机号码,"); strSql.AppendFormat(" ActivityName as 活动名称,"); strSql.AppendFormat(" ActivitySignUpCount as 报名人数,"); strSql.AppendFormat(" DistinctOpenCount as IP,"); strSql.AppendFormat(" OpenCount as PV,"); strSql.AppendFormat(" UV as 微信阅读人数,"); strSql.AppendFormat(" RealLink as 链接地址,"); strSql.AppendFormat(" InsertDate as 创建时间"); strSql.Append(" FROM ZCJ_MonitorLinkInfo left join ZCJ_UserInfo userInfo on LinkName=userInfo.UserId "); strSql.AppendFormat(" WHERE MonitorPlanID={0} ", mid); dt = ZentCloud.ZCBLLEngine.BLLBase.Query(strSql.ToString()).Tables[0]; // DataLoadTool.ExportDataTable(dt, string.Format("{0}data.xls", "", DateTime.Now.ToString())); }
public void ProcessRequest(HttpContext context) { string sDate = context.Request["start_date"]; string eDate = context.Request["end_date"]; DataTable dataTable = bllMall.QueryStatisticsData(sDate, eDate); DataLoadTool.ExportDataTable(dataTable, string.Format("{0}_{1}_data.xls", bllLog.GetWebsiteInfoModel().WebsiteName, DateTime.Now.ToString())); bllLog.Add(BLLJIMP.Enums.EnumLogType.DistributionOffLine, BLLJIMP.Enums.EnumLogTypeAction.Export, bllLog.GetCurrUserID(), "导出商城统计数据"); }
public void ProcessRequest(HttpContext context) { string fromDate = context.Request["from_date"]; string toDate = context.Request["to_date"]; string keyWord = context.Request["keyword"]; string type = context.Request["type"]; string userId = context.Request["user_id"]; System.Text.StringBuilder sbSql = new System.Text.StringBuilder(); sbSql.AppendFormat("Select"); sbSql.AppendFormat(" ProjectId as[订单号],"); sbSql.AppendFormat(" ProjectAmount as[订单金额],"); sbSql.AppendFormat(" Rate as[佣金比例],"); sbSql.AppendFormat(" Amount as[佣金金额],"); sbSql.AppendFormat(" Remark as[备注],"); sbSql.AppendFormat(" InsertDate as[时间]"); sbSql.AppendFormat(" From ZCJ_ProjectCommission"); sbSql.AppendFormat(" Where ZCJ_ProjectCommission.WebsiteOwner='{0}'", bllUser.WebsiteOwner); if (!string.IsNullOrEmpty(type)) { sbSql.AppendFormat(" And ProjectType='{0}'", type); } if (!string.IsNullOrEmpty(fromDate)) { sbSql.AppendFormat(" And InsertDate>='{0}'", fromDate); } if (!string.IsNullOrEmpty(toDate)) { toDate = (DateTime.Parse(toDate).AddHours(23).AddMinutes(59).AddSeconds(59)).ToString(); sbSql.AppendFormat(" And InsertDate<='{0}'", toDate); } if (!string.IsNullOrEmpty(keyWord)) { sbSql.AppendFormat(" And ProjectName like '%{0}%'", keyWord); } if (!string.IsNullOrEmpty(userId)) { sbSql.AppendFormat(" And UserID ='{0}'", userId); } sbSql.AppendFormat(" Order By ProjectId ASC,InsertDate ASC"); var dataTable = ZentCloud.ZCBLLEngine.BLLBase.Query(sbSql.ToString()).Tables[0]; DataLoadTool.ExportDataTable(dataTable, string.Format("{0}_{1}_data.xls", "分佣记录", DateTime.Now.ToString())); }
public void ProcessRequest(HttpContext context) { System.Text.StringBuilder sbSql = new System.Text.StringBuilder(); sbSql.AppendFormat("Select "); //sbSql.AppendFormat(" FromDate as [开始日期],"); //sbSql.AppendFormat(" ToDate as [结束日期],"); sbSql.AppendFormat(" (CONVERT(varchar(100), FromDate, 121) +'至'+CONVERT(varchar(100), ToDate, 121)) as 起止日期,"); sbSql.AppendFormat(" SettlementId as [结算单号],"); sbSql.AppendFormat(" SupplierName as [商户名称],"); sbSql.AppendFormat(" SettlementTotalAmount as [产品结算金额],"); sbSql.AppendFormat(" SaleTotalAmount as [销售额],"); sbSql.AppendFormat(" ServerTotalAmount as [服务费=销售额-产品结算额],"); sbSql.AppendFormat(" TotalTransportFee as [代收运费],"); sbSql.AppendFormat(" SettlementTotalAmount as [结算金额=产品结算金额+代收运费],"); sbSql.AppendFormat(" Status as [结算状态],"); sbSql.AppendFormat(" [开票]=(case when IsInvoice=0 then '未开票' when IsInvoice=1 then '已开票' end) "); sbSql.AppendFormat(" from ZCJ_SupplierSettlement "); sbSql.AppendFormat(" Where Websiteowner='{0}'", bllMall.WebsiteOwner); string settlementId = context.Request["settlement_id"]; string status = context.Request["status"]; string supplierUserId = context.Request["supplier_user_id"]; string date = context.Request["date"]; if (!string.IsNullOrEmpty(supplierUserId)) { sbSql.AppendFormat(" And SupplierUserId='{0}'", supplierUserId); } if (!string.IsNullOrEmpty(status)) { sbSql.AppendFormat(" And Status='{0}'", status); } if (!string.IsNullOrEmpty(date)) { sbSql.AppendFormat(" And FromDate='{0}'", date); } if (!string.IsNullOrEmpty(settlementId)) { sbSql.AppendFormat(" And SettlementId='{0}'", settlementId); } // System.Data.DataTable dt = dt = ZentCloud.ZCBLLEngine.BLLBase.Query(sbSql.ToString()).Tables[0]; DataLoadTool.ExportDataTable(dt, string.Format("{0}_{1}_data.xls", "结算单", DateTime.Now.ToString())); }
public void ProcessRequest(HttpContext context) { if (bllUser.IsLogin) { var currentUserInfo = bllUser.GetCurrentUserInfo(); if (currentUserInfo.UserType.Equals(1) || currentUserInfo.UserID.Equals(bllUser.WebsiteOwner)) { bllLog.Add(BLLJIMP.Enums.EnumLogType.DistributionOffLine, BLLJIMP.Enums.EnumLogTypeAction.Export, bllLog.GetCurrUserID(), "导出分销申请提现数据"); string tranIds = context.Request["tranids"]; System.Data.DataTable dt = new System.Data.DataTable(); StringBuilder sbSql = new StringBuilder(); sbSql.AppendFormat("SELECT AutoID as 商户流水号,AccountName as 收款银行户名,BankAccount as 收款银行账号,BankName as 收款开户银行, AccountBranchName as 收款开户网点名称,AccountBranchProvince as 开户行省份,AccountBranchCity as 开户行所在市,RealAmount as 金额,IsPublic as 对公私标识,Remark as 备注 from ZCJ_WithdrawCash where AutoID in({0}) ", tranIds); dt = ZentCloud.ZCBLLEngine.BLLBase.Query(sbSql.ToString(), "WithdrawCash").Tables[0]; DataLoadTool.ExportDataTable(dt, string.Format("提现申请IE浏览器请把后缀名改为xls{0}.xls", DateTime.Now.ToString("yyyyMMddHHmm"))); } } }
public void ProcessRequest(HttpContext context) { string settlementId = context.Request["settlement_id"]; System.Text.StringBuilder sbSql = new System.Text.StringBuilder(); sbSql.AppendFormat("Select "); sbSql.AppendFormat(" OrderId as [订单号],"); sbSql.AppendFormat(" BaseAmount as [产品结算金额],"); sbSql.AppendFormat(" TransportFee as [代收运费],"); sbSql.AppendFormat(" SettlementAmount as [结算金额=产品结算金额+代收运费]"); sbSql.AppendFormat(" from ZCJ_SupplierSettlementDetail "); sbSql.AppendFormat(" Where SettlementId='{0}'", settlementId); var settlement = bllMall.Get <BLLJIMP.Model.SupplierSettlement>(string.Format(" SettlementId='{0}'", settlementId)); System.Data.DataTable dt = dt = ZentCloud.ZCBLLEngine.BLLBase.Query(sbSql.ToString()).Tables[0]; DataLoadTool.ExportDataTable(dt, string.Format("{0}_{1}至{2}_结算单号{3}.xls", settlement.SupplierName, settlement.FromDate.ToString("yyyyMMdd"), settlement.ToDate.ToString("yyyyMMdd"), settlementId)); }
public virtual void ProcessRequest(HttpContext context) { context.Response.ContentType = "application/json"; context.Response.Expires = 0; string keyWord = context.Request["KeyWord"]; string fromDate = context.Request["FromDate"]; string toDate = context.Request["ToDate"]; string type = context.Request["type"]; string status = context.Request["status"]; string orderType = context.Request["orderType"]; StringBuilder sbSql = new StringBuilder(); sbSql.AppendFormat("Select (Case When OrderType =5 Then '预约' When OrderType=6 Then '推荐' When OrderType=7 Then '预约' When OrderType=8 Then '推荐' Else '' End) as 类型,"); sbSql.AppendFormat(" Status as 确认状态,"); sbSql.AppendFormat(" Consignee as 姓名,"); sbSql.AppendFormat(" Phone as 手机号,"); sbSql.AppendFormat(" Ex1 as 年龄,"); sbSql.AppendFormat(" Ex2 as 性别,"); sbSql.AppendFormat(" Ex3 as 症状描述,"); sbSql.AppendFormat(" Ex5 as 专家,"); sbSql.AppendFormat(" '' as 身份,"); sbSql.AppendFormat(" Ex6 as 科室,"); sbSql.AppendFormat(" InsertDate as 提交时间 "); var fieldList = bllMall.GetList <TableFieldMapping>(string.Format("WebsiteOwner='{0}' And TableName ='ZCJ_WXMallOrderInfo' Order by Sort DESC", bllMall.WebsiteOwner)); if (fieldList.Count > 0) { for (int i = 0; i < fieldList.Count; i++) { sbSql.AppendFormat(" ,{0} as {1}", fieldList[i].Field, fieldList[i].MappingName); } } sbSql.AppendFormat(" from ZCJ_WXMallOrderInfo Where WebsiteOwner='{0}' ", bllMall.WebsiteOwner); if (string.IsNullOrEmpty(orderType)) { sbSql.AppendFormat(" And OrderType in(5,6)", type); } else { sbSql.AppendFormat(" And OrderType in(7,8)", type); } if (!string.IsNullOrEmpty(type)) { sbSql.AppendFormat("And OrderType={0}", type); } if (!string.IsNullOrEmpty(status)) { sbSql.AppendFormat("And Status='{0}'", status); } if (!string.IsNullOrEmpty(keyWord)) { sbSql.AppendFormat("And ( Consignee like'%{0}%' Or Ex5 like'%{0}%' Or Ex6 like'%{0}%')", keyWord); } if ((!string.IsNullOrEmpty(fromDate)))//大于开始时间 { sbSql.AppendFormat("And InsertDate>='{0}'", Convert.ToDateTime(fromDate)); } if ((!string.IsNullOrEmpty(toDate)))//小于结束时间 { sbSql.AppendFormat("And InsertDate<'{0}'", Convert.ToDateTime(toDate).AddDays(1)); } sbSql.AppendFormat(" Order By InsertDate DESC"); var dataTable = ZentCloud.ZCBLLEngine.BLLBase.Query(sbSql.ToString()).Tables[0]; foreach (System.Data.DataRow item in dataTable.Rows) { try { if (!string.IsNullOrEmpty(item["专家"].ToString())) { string result = ""; var doctorNameList = item["专家"].ToString(); foreach (var doctorName in doctorNameList.Split(',')) { WXMallProductInfo doctorInfo = bllMall.Get <WXMallProductInfo>(string.Format(" WebsiteOwner='{0}' And PName='{1}'", bllMall.WebsiteOwner, doctorName)); if (doctorInfo != null) { result += doctorInfo.ExArticleTitle_2 + ","; } } result = result.TrimEnd(','); item["身份"] = result; } } catch (Exception) { continue; } } DataLoadTool.ExportDataTable(dataTable, string.Format("{0}_{1}_data.xls", "预约", DateTime.Now.ToString())); }
public void ProcessRequest(HttpContext context) { string keyWord = context.Request["keyword"]; //关键字 string categoryId = context.Request["category_id"]; //分类id string sort = context.Request["sort"]; //排序号 string isAppointment = context.Request["is_appointment"]; //是否是预购商品 string isGroupBuyProduct = context.Request["is_group_buy"]; //是否参与团购 string iSthreshold = context.Request["is_threshold"]; //库存紧急商品 string isOnSale = context.Request["is_onsale"]; //上下架 string isPromotionProduct = context.Request["is_promotion_product"]; //是否特卖商品 StringBuilder sbWhere = new StringBuilder(); sbWhere.AppendFormat(" WebsiteOwner='{0}' AND IsDelete=0 ", bllMall.WebsiteOwner); if (!string.IsNullOrEmpty(keyWord)) { sbWhere.AppendFormat(" And (PName like '%{0}%' Or ProductCode like '%{0}%' or Tags like '%{0}%' Or PID='{0}')", keyWord); } if (!string.IsNullOrEmpty(categoryId)) { sbWhere.AppendFormat(" And CategoryId='{0}'", categoryId); } if (!string.IsNullOrEmpty(isOnSale)) { sbWhere.AppendFormat(" And IsOnSale={0} ", isOnSale); } else { sbWhere.AppendFormat(" And IsOnSale=1 "); } if (!string.IsNullOrEmpty(isAppointment)) { sbWhere.AppendFormat(" And IsAppointment={0}", isAppointment); } if (!string.IsNullOrEmpty(isPromotionProduct)) { sbWhere.AppendFormat(" And IsPromotionProduct={0} ", isPromotionProduct); } if (!string.IsNullOrEmpty(isGroupBuyProduct) && isGroupBuyProduct == "1") { sbWhere.AppendFormat(" And GroupBuyRuleIds <>'' "); //是团购商品的时候,过滤掉可以用积分购买的商品 sbWhere.AppendFormat(" And ( Score = 0 or Score is null ) "); } string orderBy = string.Empty; if (!string.IsNullOrEmpty(sort)) { sbWhere.AppendFormat(GetSortList(sort)); } List <WXMallProductInfo> productList = bllMall.GetList <WXMallProductInfo>(sbWhere.ToString()); List <ProductModel> pList = new List <ProductModel>(); WebsiteInfo website = bllMall.GetWebsiteInfoModelFromDataBase(); var list = from p in productList select new { product_id = p.PID, product_code = p.ProductCode, category_name = bllMall.GetWXMallCategoryName(p.CategoryId), product_title = p.PName, base_price = p.BasePrice, quote_price = p.PreviousPrice, sale_count = p.SaleCount, totalcount = bllMall.GetProductTotalStock(int.Parse(p.PID)), supplier_name = bllMall.GetSuppLierByUserId(p.SupplierUserId, p.WebsiteOwner) != null?bllMall.GetSuppLierByUserId(p.SupplierUserId, p.WebsiteOwner).Company : "", freight_template = p.FreightTemplateId <= 0 ? "包邮" : bllMall.GetFreightTemplate(p.FreightTemplateId).TemplateName }; if (!string.IsNullOrEmpty(iSthreshold)) { list = list.Where(p => p.totalcount <= 0).ToList(); } foreach (var p in list) { foreach (var item in bllMall.GetProductSkuList(int.Parse(p.product_id))) { ProductModel prodduct = new ProductModel(); prodduct.PID = item.ProductId; prodduct.PName = p.product_title; prodduct.TotalCount = p.totalcount; prodduct.ProductCode = p.product_code; prodduct.CategoryName = p.category_name; prodduct.SupplierName = p.supplier_name; prodduct.ProductStock = item.Stock; prodduct.Price = item.Price; prodduct.FreightTemplateName = p.freight_template; prodduct.ShowProps = item.ShowProps; prodduct.BasePrice = item.BasePrice; prodduct.pBasePrice = p.base_price; prodduct.QuotePrice = p.quote_price; pList.Add(prodduct); } } DataTable dt = new DataTable(); dt.Columns.Add("商品ID"); 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("商户"); for (int i = 0; i < pList.Count; i++) { DataRow newRow = dt.NewRow(); newRow["商品ID"] = pList[i].PID; newRow["商品名称"] = pList[i].PName; newRow["商品编码"] = pList[i].ProductCode; newRow["商品规格"] = pList[i].ShowProps; newRow["总库存"] = pList[i].TotalCount; newRow["基础价"] = pList[i].BasePrice; if (pList[i].BasePrice == 0) { newRow["基础价"] = pList[i].pBasePrice; } newRow["售价"] = pList[i].Price; newRow["原价"] = pList[i].QuotePrice; newRow["库存"] = pList[i].ProductStock; newRow["物流"] = pList[i].FreightTemplateName; newRow["商户"] = pList[i].SupplierName; dt.Rows.Add(newRow); } dt.TableName = "商品列表"; DataTable[] dt2 = { dt }; DataLoadTool.ExportDataTable(dt2, string.Format("{0}_data.xls", DateTime.Now.ToString())); }
public void ProcessRequest(HttpContext context) { string orderStatus = context.Request["order_status"]; string orderFromDate = context.Request["order_from_date"]; string orderToDate = context.Request["order_to_date"]; string orderId = context.Request["order_id"]; string supplierUserId = context.Request["supplier_user_id"]; System.Text.StringBuilder sbSql = new System.Text.StringBuilder(); sbSql.AppendFormat("Select "); sbSql.AppendFormat(" SupplierName as [商户名称],"); sbSql.AppendFormat(" OrderId as [订单编号],"); sbSql.AppendFormat(" OrderDate as [下单时间],"); sbSql.AppendFormat(" BaseAmount as [产品结算金额],"); sbSql.AppendFormat(" SaleAmount as [销售额],"); sbSql.AppendFormat(" ServerAmount as [服务费=销售额-产品结算额],"); sbSql.AppendFormat(" TransportFee as [代收运费],"); sbSql.AppendFormat(" SettlementAmount as [结算金额=产品结算金额+代收运费],"); sbSql.AppendFormat(" OrderStatus as [订单状态],"); sbSql.AppendFormat(" [退款]=(case when IsRefund=0 then '无' when IsRefund=1 then '有' end) "); sbSql.AppendFormat(" from ZCJ_SupplierUnSettlement "); sbSql.AppendFormat(" Where Websiteowner='{0}'", bllMall.WebsiteOwner); if (!string.IsNullOrEmpty(supplierUserId)) { sbSql.AppendFormat(" And SupplierUserId='{0}'", supplierUserId); } if (!string.IsNullOrEmpty(orderId)) { sbSql.AppendFormat(" And OrderId='{0}'", orderId); } if (!string.IsNullOrEmpty(orderStatus)) { if (orderStatus != "退款退货") { sbSql.AppendFormat(" And OrderStatus='{0}'", orderStatus); } else { sbSql.AppendFormat(" And IsRefund=1 "); } } if (!string.IsNullOrEmpty(orderFromDate)) { sbSql.AppendFormat(" And OrderDate>='{0}'", orderFromDate); } if (!string.IsNullOrEmpty(orderToDate)) { sbSql.AppendFormat(" And OrderDate<='{0}'", orderToDate); } // System.Data.DataTable dt = dt = ZentCloud.ZCBLLEngine.BLLBase.Query(sbSql.ToString()).Tables[0]; DataLoadTool.ExportDataTable(dt, string.Format("{0}_{1}_data.xls", "未结算单", DateTime.Now.ToString())); }
public void ProcessRequest(HttpContext context) { string startTime = context.Request["start_time"]; string stopTime = context.Request["stop_time"]; string userId = context.Request["user_id"]; string type = context.Request["type"]; StringBuilder sbSQL = new StringBuilder(); sbSQL.AppendFormat(" WebSiteOwner='{0}' ", bllUserScoreDetail.WebsiteOwner); if (!string.IsNullOrWhiteSpace(userId)) { sbSQL.AppendFormat(" And UserID='{0}' ", userId); } if (!string.IsNullOrWhiteSpace(type)) { sbSQL.AppendFormat(" And ScoreType='{0}' ", type); } else { sbSQL.AppendFormat(" And ScoreType!='AccountAmount' And ScoreType!='TotalAmount' "); } if (!string.IsNullOrEmpty(startTime)) { sbSQL.AppendFormat(" AND AddTime>='{0}' ", DateTime.Parse(startTime)); } if (!string.IsNullOrEmpty(stopTime)) { sbSQL.AppendFormat(" AND AddTime<='{0}' ", DateTime.Parse(stopTime)); } List <UserScoreDetailsInfo> userScores = bllUserScoreDetail.GetList <UserScoreDetailsInfo>(sbSQL.ToString()); DataTable dt = new DataTable(); dt.Columns.Add("日期"); dt.Columns.Add("用户"); dt.Columns.Add("手机"); dt.Columns.Add("积分"); dt.Columns.Add("说明"); for (int i = 0; i < userScores.Count; i++) { UserInfo user = bllUser.GetUserInfo(userScores[i].UserID); if (user == null) { continue; } DataRow newRow = dt.NewRow(); newRow["日期"] = userScores[i].AddTime; newRow["用户"] = user.TrueName; newRow["手机"] = user.Phone; newRow["积分"] = userScores[i].Score; newRow["说明"] = userScores[i].AddNote; dt.Rows.Add(newRow); } dt.TableName = "积分详情"; DataTable[] dt2 = { dt }; DataLoadTool.ExportDataTable(dt2, string.Format("{0}_data.xls", DateTime.Now.ToString())); }
public void ProcessRequest(HttpContext context) { StringBuilder sbWhere = new StringBuilder(); sbWhere.AppendFormat(" WebsiteOwner= '{0}' And IsNull(IsMain,0)=0", bllMall.WebsiteOwner); string fromDate = context.Request["from_date"]; //开始日期 string toDate = context.Request["to_date"]; //结束日期 string status = context.Request["status"]; //订单状态 string orderIds = context.Request["oids"]; //订单号 string userAutoIds = context.Request["user_aids"]; //用户自动编号 string userTags = context.Request["user_tags"]; //用户标签 string isYuYueOrder = context.Request["is_yuyue"]; //是否是会议室预约和资源预约订单 string supplierUserId = context.Request["supplier_userid"]; //供应商账号 //订单类型 //0 商城订单 //1 礼品订单 //2 团购订单 //3 无 //4 活动订单 //5 会议室预订 //6 导师预约 string orderType = context.Request["order_type"]; if (!string.IsNullOrEmpty(orderType)) { if (orderType == "5") { sbWhere.AppendFormat(" And ArticleCategoryType='MeetingRoom'"); } else if (orderType == "6") { sbWhere.AppendFormat(" And ArticleCategoryType='BookingTutor'"); } else { sbWhere.AppendFormat(" And OrderType={0}", orderType); } } if (!string.IsNullOrEmpty(fromDate)) { sbWhere.AppendFormat(" And InsertDate>='{0}'", fromDate); } if (!string.IsNullOrEmpty(toDate)) { sbWhere.AppendFormat(" And InsertDate<='{0}'", toDate); } if (orderType == "2" && !string.IsNullOrEmpty(status)) { status = ConvertGroupbuyStatus(status); sbWhere.AppendFormat(" And GroupBuyStatus in({0})", status); } if (orderType == "2") { sbWhere.AppendFormat(" And PaymentStatus=1 ", status); } if ((!string.IsNullOrEmpty(status)) && (status != "退款退货") && orderType != "2") { status = "'" + status.Replace(",", "','") + "'"; sbWhere.AppendFormat(" And Status in({0})", status); } if (status == "退款退货") { sbWhere.AppendFormat(" And IsRefund=1 "); } if (!string.IsNullOrEmpty(orderIds)) { orderIds = "'" + orderIds.Replace(",", "','") + "'"; sbWhere.AppendFormat(" And OrderID in({0}) ", orderIds); } if (bllUser.IsSupplier(currentUserInfo)) { sbWhere.AppendFormat(" And SupplierUserId ='{0}' ", currentUserInfo.UserID); } if ((!string.IsNullOrEmpty(userAutoIds)) || (!string.IsNullOrEmpty(userTags))) { string userIds = ""; if (!string.IsNullOrEmpty(userAutoIds)) { foreach (var userAutoId in userAutoIds.Split(',')) { var userInfo = bllUser.GetUserInfoByAutoID(int.Parse(userAutoId)); if (userInfo != null) { userIds += string.Format("'{0}',", userInfo.UserID); } } } if (!string.IsNullOrEmpty(userTags)) { foreach (string tag in userTags.Split(',')) { List <UserInfo> userList = bllUser.GetList <UserInfo>(string.Format(" Websiteowner='{0}' And TagName like '%{1}%'", bllUser.WebsiteOwner, tag)); foreach (var userInfo in userList) { userIds += string.Format("'{0}',", userInfo.UserID); } } } userIds = userIds.TrimEnd(','); sbWhere.AppendFormat(" And OrderUserId in({0}) ", userIds); } if (!string.IsNullOrEmpty(supplierUserId)) { if (supplierUserId == "none") { sbWhere.AppendFormat(" And (SupplierUserId='' Or SupplierUserId IS NULL)", ""); } else { sbWhere.AppendFormat(" And SupplierUserId ='{0}' ", supplierUserId); } } sbWhere.AppendFormat(" Order by InsertDate Desc "); List <WXMallOrderInfo> orderList = bllMall.GetList <WXMallOrderInfo>(sbWhere.ToString()); //sbExport.Append("会员ID\t"); DataTable dt1 = new DataTable(); DataTable dt2 = new DataTable(); dt1.Columns.Add("会员ID"); dt1.Columns.Add("线上卡号"); dt1.Columns.Add("OpenId"); dt1.Columns.Add("订单时间"); dt1.Columns.Add("父订单编号"); dt1.Columns.Add("订单号"); dt1.Columns.Add("订单状态"); dt1.Columns.Add("商品编号"); dt1.Columns.Add("商品编码"); dt1.Columns.Add("商品名称"); if (!string.IsNullOrEmpty(isYuYueOrder)) { dt1.Columns.Add("预约时间"); } dt1.Columns.Add("商品原价"); dt1.Columns.Add("商品均摊价格"); dt1.Columns.Add("商品单价"); dt1.Columns.Add("商品规格"); dt1.Columns.Add("商品条码"); dt1.Columns.Add("商品数量"); dt1.Columns.Add("商品总金额"); dt1.Columns.Add("运费"); dt1.Columns.Add("实付金额"); dt1.Columns.Add("收货人姓名"); dt1.Columns.Add("电话"); dt1.Columns.Add("收货地址"); dt1.Columns.Add("留言"); dt1.Columns.Add("支付状态"); dt1.Columns.Add("基础价"); dt1.Columns.Add("使用积分"); dt1.Columns.Add("使用余额"); dt1.Columns.Add("优惠券名称"); dt1.Columns.Add("优惠券ID"); dt1.Columns.Add("退款"); dt1.Columns.Add("主订单号"); dt1.Columns.Add("商户名称"); dt1.Columns.Add("商家备注"); dt1.Columns.Add("快递公司"); dt1.Columns.Add("快递单号"); dt2.Columns.Add("订单时间"); dt2.Columns.Add("订单号"); dt2.Columns.Add("订单状态"); dt2.Columns.Add("商品编号"); dt2.Columns.Add("商品名称"); dt2.Columns.Add("商品规格"); dt2.Columns.Add("商品数量"); dt2.Columns.Add("实付金额"); dt2.Columns.Add("收货人姓名"); dt2.Columns.Add("电话"); dt2.Columns.Add("收货地址"); dt2.Columns.Add("支付状态"); dt2.Columns.Add("退款"); dt2.Columns.Add("主订单号"); dt2.Columns.Add("商户名称"); dt2.Columns.Add("商家备注"); dt2.Columns.Add("快递公司"); dt2.Columns.Add("快递单号"); for (int i = 0; i < orderList.Count; i++) { var userInfo = bllUser.GetUserInfo(orderList[i].OrderUserID); if (userInfo == null) { userInfo = new UserInfo(); } string cardId = string.Empty; string cardName = string.Empty; if (!string.IsNullOrEmpty(orderList[i].MyCouponCardId)) { switch (orderList[i].CouponType) { case 0: MyCardCoupons myCardModel = bllCardcoupon.GetMyCardCoupon(Convert.ToInt32(orderList[i].MyCouponCardId)); if (myCardModel != null) { CardCoupons coupns = bllCardcoupon.GetCardCoupon(myCardModel.CardId); cardId = coupns.CardId.ToString(); cardName = coupns.Name; } break; case 1: int cardIdInt = Convert.ToInt32(orderList[i].MyCouponCardId); StoredValueCardRecord storedCard = bllStoredValueCard.GetStoredValueCardRecord(cardIdInt); if (storedCard != null) { StoredValueCard cardModel = bllStoredValueCard.GetStoredValueCard(storedCard.CardId); cardId = cardModel.AutoId.ToString(); cardName = cardModel.Name; } break; default: break; } } foreach (var item in bllMall.GetOrderDetailsList(orderList[i].OrderID)) { if (orderList[i].IsRefund == 1 && string.IsNullOrEmpty(item.RefundStatus) && status == "退款退货") { continue; } DataRow newRow = dt1.NewRow(); DataRow newRow1 = dt2.NewRow(); newRow["会员ID"] = userInfo.AutoID.ToString(); newRow["OpenId"] = userInfo.WXOpenId; newRow["订单时间"] = orderList[i].InsertDate.ToString(); newRow1["订单时间"] = orderList[i].InsertDate.ToString(); WXMallProductInfo product = bllMall.GetProduct(item.PID); switch (orderList[i].OrderType) { case 0: newRow["父订单编号"] = ""; break; case 1: newRow["父订单编号"] = orderList[i].ParentOrderId; break; case 2: newRow["父订单编号"] = orderList[i].GroupBuyParentOrderId; break; default: break; } newRow["订单号"] = orderList[i].OrderID; newRow1["订单号"] = orderList[i].OrderID; newRow["订单状态"] = orderList[i].Status; newRow1["订单状态"] = orderList[i].Status; newRow["商品编号"] = product == null ? "" : product.PID; newRow1["商品编号"] = product == null ? "" : product.PID; newRow["商品编码"] = product == null ? "" : product.ProductCode; newRow["商品名称"] = product == null ? item.SkuShowProp : product.PName; newRow1["商品名称"] = product == null ? item.SkuShowProp : product.PName; if (!string.IsNullOrEmpty(isYuYueOrder)) { if (isYuYueOrder == "MeetingRoom") { if (!string.IsNullOrEmpty(product.RelationProductId)) { newRow["预约时间"] = item.StartDate.ToString("yyyy-MM-dd HH:mm") + "-" + item.EndDate.ToString("HH:mm"); } else { newRow["预约时间"] = ""; } } else { newRow["预约时间"] = item.StartDate.ToString("yyyy-MM-dd HH:mm") + "-" + item.EndDate.ToString("HH:mm"); } } newRow["商品原价"] = product.PreviousPrice; newRow["商品均摊价格"] = item.PaymentFt; newRow["商品单价"] = item.OrderPrice; if (item.SkuId.HasValue) { newRow["商品规格"] = item.SkuShowProp; newRow1["商品规格"] = item.SkuShowProp; newRow["商品条码"] = item.SkuId; } else { newRow["商品规格"] = ""; newRow1["商品规格"] = ""; newRow["商品条码"] = ""; } newRow["商品数量"] = item.TotalCount; newRow1["商品数量"] = item.TotalCount; newRow["商品总金额"] = item.TotalCount * item.OrderPrice; newRow["运费"] = orderList[i].Transport_Fee; newRow["实付金额"] = orderList[i].TotalAmount; newRow1["实付金额"] = orderList[i].TotalAmount; newRow["收货人姓名"] = orderList[i].Consignee; newRow1["收货人姓名"] = orderList[i].Consignee; newRow["电话"] = orderList[i].Phone; newRow1["电话"] = orderList[i].Phone; newRow["收货地址"] = orderList[i].ReceiverProvince + orderList[i].ReceiverCity + orderList[i].ReceiverDist + orderList[i].Address; newRow1["收货地址"] = orderList[i].ReceiverProvince + orderList[i].ReceiverCity + orderList[i].ReceiverDist + orderList[i].Address; newRow["留言"] = orderList[i].OrderMemo; newRow["支付状态"] = ConvertPaymentStatus(orderList[i].PaymentStatus); newRow1["支付状态"] = ConvertPaymentStatus(orderList[i].PaymentStatus); newRow["基础价"] = item.BasePrice; newRow["使用积分"] = orderList[i].UseScore; newRow["使用余额"] = orderList[i].UseAmount; newRow["优惠券名称"] = cardName; newRow["优惠券ID"] = cardId; newRow["退款"] = ConvertRefundStatus(item.RefundStatus); newRow1["退款"] = ConvertRefundStatus(item.RefundStatus); newRow["主订单号"] = orderList[i].ParentOrderId; newRow1["主订单号"] = orderList[i].ParentOrderId; newRow["商户名称"] = orderList[i].SupplierName; newRow1["商户名称"] = orderList[i].SupplierName; newRow["商家备注"] = orderList[i].Ex21; newRow1["商家备注"] = orderList[i].Ex21; newRow["快递公司"] = orderList[i].ExpressCompanyName; newRow1["快递公司"] = orderList[i].ExpressCompanyName; newRow["快递单号"] = orderList[i].ExpressNumber; newRow1["快递单号"] = orderList[i].ExpressNumber; newRow["线上卡号"] = userInfo.Ex2; dt1.Rows.Add(newRow); dt2.Rows.Add(newRow1); } //if (orderList[i].OrderType == 2)//团购订单 //{ // foreach (var item in bllMall.GetList<WXMallOrderInfo>(string.Format(" GroupBuyParentOrderId='{0}' And PaymentStatus=1", orderList[i].OrderID))) // { // foreach (var detail in bllMall.GetOrderDetailsList(item.OrderID)) // { // DataRow nowRow1 = dt1.NewRow(); // DataRow nowRow2 = dt2.NewRow(); // WXMallProductInfo product = bllMall.GetProduct(detail.PID); // nowRow1["订单时间"] = item.InsertDate.ToString(); // nowRow2["订单时间"] = item.InsertDate.ToString(); // nowRow1["父订单编号"] = item.GroupBuyParentOrderId; // nowRow1["订单号"] = item.OrderID; // nowRow2["订单号"] = item.OrderID; // nowRow1["订单状态"] = item.Status; // nowRow2["订单状态"] = item.Status; // nowRow1["商品编号"] = product == null ? "" : product.PID; // nowRow2["商品编号"] = product == null ? "" : product.PID; // nowRow1["商品编码"] = product == null ? "" : product.ProductCode; // nowRow1["商品名称"] = product == null ? "" : product.PName; // nowRow2["商品名称"] = product == null ? "" : product.PName; // nowRow1["商品原价"] = product.PreviousPrice; // nowRow1["商品均摊价格"] = detail.PaymentFt; // nowRow1["商品单价"] = detail.OrderPrice; // if (detail.SkuId.HasValue) // { // nowRow1["商品规格"] = detail.SkuShowProp; // nowRow2["商品规格"] = detail.SkuShowProp; // nowRow1["商品条码"] = detail.SkuId; // } // else // { // nowRow1["商品规格"] = ""; // nowRow2["商品规格"] = ""; // nowRow1["商品条码"] = ""; // } // nowRow1["商品数量"] = detail.TotalCount; // nowRow2["商品数量"] = detail.TotalCount; // nowRow1["商品总金额"] = detail.TotalCount * detail.OrderPrice; // nowRow1["运费"] = item.Transport_Fee; // nowRow1["实付金额"] = item.TotalAmount; // nowRow2["实付金额"] = item.TotalAmount; // nowRow1["收货人姓名"] = item.Consignee; // nowRow2["收货人姓名"] = item.Consignee; // nowRow1["电话"] = item.Phone; // nowRow2["电话"] = item.Phone; // nowRow1["收货地址"] = item.ReceiverProvince + item.ReceiverCity + item.ReceiverDist + item.Address; // nowRow2["收货地址"] = item.ReceiverProvince + item.ReceiverCity + item.ReceiverDist + item.Address; // nowRow1["留言"] = item.OrderMemo; // nowRow1["支付状态"] = ConvertPaymentStatus(item.PaymentStatus); // nowRow2["支付状态"] = ConvertPaymentStatus(item.PaymentStatus); // nowRow1["基础价"] =detail.BasePrice; // nowRow1["使用积分"] = orderList[i].UseScore; // nowRow1["使用余额"] = orderList[i].UseAmount; // nowRow1["优惠券名称"] = cardName; // nowRow1["优惠券ID"] = cardId; // nowRow1["退款"] =ConvertRefundStatus(detail.RefundStatus); // nowRow2["退款"] = ConvertRefundStatus(detail.RefundStatus); // dt1.Rows.Add(nowRow1); // dt2.Rows.Add(nowRow2); // } // } //} } dt1.TableName = "订单列表"; dt2.TableName = "精简订单列表"; DataTable[] dt3 = { dt1, dt2 }; DataLoadTool.ExportDataTable(dt3, string.Format("{0}_data.xls", DateTime.Now.ToString())); }
public void ProcessRequest(HttpContext context) { string addressId = context.Request["address"]; string isGroup = context.Request["is_group"]; string isShow = context.Request["is_show"]; string startTime = context.Request["start"]; string stopTime = context.Request["stop"]; string userId = context.Request["user_id"]; int totalCount = 0; List <SignInLog> list = bllSignIn.GetSignLogList(1, int.MaxValue, "", addressId, out totalCount, startTime, stopTime, userId, ""); SignInAddress signModel = bllSignIn.GetSignInAddress(bllSignIn.WebsiteOwner, addressId); apiResp.status = true; DataTable dt = new DataTable(); dt.Columns.Add("微信昵称"); dt.Columns.Add("姓名"); dt.Columns.Add("手机"); if (!string.IsNullOrEmpty(signModel.SignInTime) && !string.IsNullOrEmpty(isGroup)) { var userList = list.Select(p => p.UserID).Distinct().ToList(); List <TimeList> timeList = JsonConvert.DeserializeObject <List <TimeList> >(signModel.SignInTime); for (int i = 0; i < timeList.Count; i++) { dt.Columns.Add(timeList[i].name); dt.Columns.Add(timeList[i].name + "签到距离"); } for (var i = 0; i < userList.Count; i++) { DataRow dr = dt.NewRow(); string user = userList[i]; UserInfo userModel = bllUser.GetUserInfo(user); dr["微信昵称"] = userModel.WXNickname; dr["姓名"] = userModel.TrueName; dr["手机"] = userModel.Phone; for (int j = 0; j < timeList.Count; j++) { SignInLog log = list.Where(p => p.UserID == user && p.CreateDate >= timeList[j].start && p.CreateDate <= timeList[j].stop).OrderBy(p => p.AutoID).FirstOrDefault(); if (log != null) { dr[timeList[j].name] = log.CreateDate.ToString("yyyy-MM-dd HH:mm:ss"); dr[timeList[j].name + "签到距离"] = log.Distance; } else { dr[timeList[j].name] = ""; dr[timeList[j].name + "签到距离"] = ""; } } dt.Rows.Add(dr); } } else { dt.Columns.Add("签到时间"); dt.Columns.Add("说明"); dt.Columns.Add("距离"); if (!string.IsNullOrEmpty(isShow)) { var userList = list.Select(p => p.UserID).Distinct().ToList(); SignInLog log = new SignInLog(); for (int i = 0; i < userList.Count; i++) { string user = userList[i]; log = list.Where(p => p.UserID == user && p.Status == 1).OrderBy(p => p.AutoID).FirstOrDefault(); if (log == null) { log = list.Where(p => p.UserID == user && p.Status == 0).OrderBy(p => p.AutoID).FirstOrDefault(); } if (log == null) { continue; } UserInfo userModel = bllUser.GetUserInfo(user); DataRow dr = dt.NewRow(); dr["微信昵称"] = userModel.WXNickname; dr["姓名"] = userModel.TrueName; dr["手机"] = userModel.Phone; dr["签到时间"] = list[i].CreateDate.ToString("yyyy-MM-dd HH:mm:ss"); dr["说明"] = list[i].Remark; dr["距离"] = list[i].Distance; dt.Rows.Add(dr); } } else { for (var i = 0; i < list.Count; i++) { UserInfo userModel = bllUser.GetUserInfo(list[i].UserID); DataRow dr = dt.NewRow(); dr["微信昵称"] = userModel.WXNickname; dr["姓名"] = userModel.TrueName; dr["手机"] = userModel.Phone; dr["签到时间"] = list[i].CreateDate.ToString("yyyy-MM-dd HH:mm:ss"); dr["说明"] = list[i].Remark; dr["距离"] = list[i].Distance; dt.Rows.Add(dr); } } } DataLoadTool.ExportDataTable(dt, string.Format("{0}_{1}_data.xls", signModel.Address, DateTime.Now.ToString())); return; }