///// <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;
}
