protected override void AttachChildControls()
{
DistributorsInfo currentDistributors = DistributorsBrower.GetCurrentDistributors(Globals.GetCurrentMemberUserId(false), true);
if (currentDistributors.ReferralStatus != 0)
{
System.Web.HttpContext.Current.Response.Redirect("MemberCenter.aspx");
}
else
{
this.vshopcommssion = (VshopTemplatedRepeater)this.FindControl("vshopcommssion");
CommissionsQuery commissionsQuery = new CommissionsQuery();
commissionsQuery.StartTime = (commissionsQuery.EndTime = "");
commissionsQuery.PageIndex = 1;
commissionsQuery.PageSize = 100000;
commissionsQuery.UserId = Globals.GetCurrentMemberUserId(false);
DbQueryResult commissions = DistributorsBrower.GetCommissions(commissionsQuery);
if (commissions.TotalRecords > 0)
{
this.vshopcommssion.DataSource = commissions.Data;
this.vshopcommssion.DataBind();
}
}
}
private void BindProducts(int couponId)
{
System.Data.DataTable selectedProducts = this.GetSelectedProducts(couponId);
string text = this.txt_name.Text;
string text2 = this.txt_minPrice.Text;
string text3 = this.txt_maxPrice.Text;
decimal?minPrice = null;
decimal?maxPrice = null;
decimal value = 0m;
if (!this.bDecimal(text2, ref value))
{
minPrice = null;
}
else
{
minPrice = new decimal?(value);
}
if (!this.bDecimal(text3, ref value))
{
maxPrice = null;
}
else
{
maxPrice = new decimal?(value);
}
ProductQuery productQuery = new ProductQuery
{
Keywords = text,
ProductCode = "",
CategoryId = null,
PageSize = this.pager.PageSize,
PageIndex = this.pager.PageIndex,
SortOrder = SortAction.Desc,
SortBy = "DisplaySequence",
StartDate = null,
BrandId = null,
EndDate = null,
TypeId = null,
SaleStatus = this.status,
minPrice = minPrice,
maxPrice = maxPrice
};
Globals.EntityCoding(productQuery, true);
DbQueryResult products = ProductHelper.GetProducts(productQuery);
System.Data.DataTable dataTable = (System.Data.DataTable)products.Data;
dataTable.Columns.Add("seledStatus");
dataTable.Columns.Add("canSelStatus");
dataTable.Columns.Add("canChkStatus");
if (dataTable != null && selectedProducts != null)
{
if (dataTable.Rows.Count > 0 && selectedProducts.Rows.Count > 0)
{
for (int i = 0; i < dataTable.Rows.Count; i++)
{
int num = int.Parse(dataTable.Rows[i]["ProductId"].ToString());
if (selectedProducts.Select(string.Format("ProductId={0}", num)).Length > 0)
{
dataTable.Rows[i]["seledStatus"] = "''";
dataTable.Rows[i]["canSelStatus"] = "none";
dataTable.Rows[i]["canChkStatus"] = "disabled";
}
else
{
dataTable.Rows[i]["seledStatus"] = "none";
dataTable.Rows[i]["canSelStatus"] = "''";
dataTable.Rows[i]["canChkStatus"] = string.Empty;
}
}
}
else if (dataTable.Rows.Count > 0)
{
for (int j = 0; j < dataTable.Rows.Count; j++)
{
dataTable.Rows[j]["seledStatus"] = "none";
dataTable.Rows[j]["canSelStatus"] = "''";
dataTable.Rows[j]["canChkStatus"] = string.Empty;
}
}
}
this.grdProducts.DataSource = products.Data;
this.grdProducts.DataBind();
this.pager.TotalRecords = products.TotalRecords;
this.lbsaleNumber.Text = products.TotalRecords.ToString();
this.lblJoin.Text = ((selectedProducts != null) ? selectedProducts.Rows.Count.ToString() : "0");
this.setInStock();
}
private void BindData()
{
decimal?minValue = null;
decimal?maxValue = null;
System.DateTime?beginDate = null;
System.DateTime?endDate = null;
string text = this.txt_name.Text;
decimal value = 0m;
System.DateTime now = System.DateTime.Now;
if (this.bDecimal(this.txt_minVal.Text, ref value))
{
minValue = new decimal?(value);
}
if (this.bDecimal(this.txt_maxVal.Text, ref value))
{
maxValue = new decimal?(value);
}
if (this.bDate(this.calendarStartDate.Text, ref now))
{
beginDate = new System.DateTime?(now);
}
if (this.bDate(this.calendarEndDate.Text, ref now))
{
endDate = new System.DateTime?(now);
}
DbQueryResult couponInfos = CouponHelper.GetCouponInfos(new CouponsSearch
{
CouponName = text,
minValue = minValue,
maxValue = maxValue,
beginDate = beginDate,
endDate = endDate,
IsCount = true,
PageIndex = this.pager1.PageIndex,
PageSize = this.pager1.PageSize,
SortBy = "CouponId",
SortOrder = SortAction.Desc
});
System.Data.DataTable dataTable = (System.Data.DataTable)couponInfos.Data;
if (dataTable.Rows.Count > 0)
{
dataTable.Columns.Add("useConditon");
dataTable.Columns.Add("ReceivNum");
for (int i = 0; i < dataTable.Rows.Count; i++)
{
decimal d = decimal.Parse(dataTable.Rows[i]["ConditionValue"].ToString());
if (d == 0m)
{
dataTable.Rows[i]["useConditon"] = "不限制";
}
else
{
dataTable.Rows[i]["useConditon"] = "满" + d.ToString("F2") + "可使用";
}
string text2 = dataTable.Rows[i]["maxReceivNum"].ToString();
if (text2 == "0")
{
dataTable.Rows[i]["ReceivNum"] = "无限制";
}
else
{
dataTable.Rows[i]["ReceivNum"] = text2 + "/张每人";
}
}
}
this.grdCoupondsList.DataSource = dataTable;
this.grdCoupondsList.DataBind();
this.pager1.TotalRecords = couponInfos.TotalRecords;
}
protected override void AttachChildControls()
{
if (!int.TryParse(this.Page.Request.QueryString["productId"], out this.productId))
{
base.GotoResourceNotFound("错误的商品信息!");
}
SiteSettings masterSettings = SettingsManager.GetMasterSettings(true);
this.litProdcutName = (System.Web.UI.WebControls.Literal) this.FindControl("litProdcutName");
this.litSalePrice = (System.Web.UI.WebControls.Literal) this.FindControl("litSalePrice");
this.litShortDescription = (System.Web.UI.WebControls.Literal) this.FindControl("litShortDescription");
this.litSoldCount = (System.Web.UI.WebControls.Literal) this.FindControl("litSoldCount");
this.productImage = (System.Web.UI.HtmlControls.HtmlImage) this.FindControl("productImage");
this.productLink = (System.Web.UI.WebControls.HyperLink) this.FindControl("productLink");
this.txtTotal = (System.Web.UI.HtmlControls.HtmlInputHidden) this.FindControl("txtTotal");
ProductInfo productSimpleInfo = ProductBrowser.GetProductSimpleInfo(this.productId);
if (productSimpleInfo == null)
{
base.GotoResourceNotFound("该件商品已经被管理员删除");
}
this.litProdcutName.SetWhenIsNotNull(productSimpleInfo.ProductName);
this.litSalePrice.SetWhenIsNotNull(productSimpleInfo.MinSalePrice.ToString("F2"));
this.litShortDescription.SetWhenIsNotNull(productSimpleInfo.ShortDescription);
this.litSoldCount.SetWhenIsNotNull(productSimpleInfo.ShowSaleCounts.ToString());
if (!string.IsNullOrEmpty(productSimpleInfo.ThumbnailUrl180))
{
this.productImage.Src = productSimpleInfo.ThumbnailUrl180;
}
else
{
this.productImage.Src = masterSettings.DefaultProductThumbnail5;
}
this.productLink.NavigateUrl = "ProductDetails.aspx?ProductId=" + productSimpleInfo.ProductId;
int pageIndex;
if (!int.TryParse(this.Page.Request.QueryString["page"], out pageIndex))
{
pageIndex = 1;
}
int pageSize;
if (!int.TryParse(this.Page.Request.QueryString["size"], out pageSize))
{
pageSize = 20;
}
ProductReviewQuery productReviewQuery = new ProductReviewQuery();
productReviewQuery.productId = this.productId;
productReviewQuery.IsCount = true;
productReviewQuery.PageIndex = pageIndex;
productReviewQuery.PageSize = pageSize;
productReviewQuery.SortBy = "ReviewId";
productReviewQuery.SortOrder = SortAction.Desc;
this.rptProducts = (AliOHTemplatedRepeater)this.FindControl("rptProducts");
DbQueryResult productReviews = ProductBrowser.GetProductReviews(productReviewQuery);
this.rptProducts.DataSource = productReviews.Data;
this.rptProducts.DataBind();
this.txtTotal.SetWhenIsNotNull(productReviews.TotalRecords.ToString());
PageTitle.AddSiteNameTitle("商品评价");
}
/// <summary>
/// Конструктор.
/// </summary>
public DbQueryResponse(TResult result, DbQueryResult queryResult) : base(queryResult)
{
Result = result;
}
private void BindData()
{
string text = "";
decimal? nullable = null;
decimal? nullable2 = null;
DateTime?nullable3 = null;
DateTime?nullable4 = null;
text = this.txt_name.Text;
decimal i = 0M;
DateTime now = DateTime.Now;
if (this.bDecimal(this.txt_minVal.Text, ref i))
{
nullable = new decimal?(i);
}
if (this.bDecimal(this.txt_maxVal.Text, ref i))
{
nullable2 = new decimal?(i);
}
if (this.bDate(this.calendarStartDate.Text, ref now))
{
nullable3 = new DateTime?(now);
}
if (this.bDate(this.calendarEndDate.Text, ref now))
{
nullable4 = new DateTime?(now);
}
CouponsSearch search = new CouponsSearch
{
CouponName = text,
minValue = nullable,
maxValue = nullable2,
beginDate = nullable3,
endDate = nullable4,
IsCount = true,
PageIndex = this.pager1.PageIndex,
PageSize = this.pager1.PageSize,
SortBy = "CouponId",
SortOrder = SortAction.Desc
};
DbQueryResult couponInfos = CouponHelper.GetCouponInfos(search);
DataTable data = (DataTable)couponInfos.Data;
if (data.Rows.Count > 0)
{
data.Columns.Add("useConditon");
data.Columns.Add("ReceivNum");
for (int j = 0; j < data.Rows.Count; j++)
{
decimal num3 = decimal.Parse(data.Rows[j]["ConditionValue"].ToString());
if (num3 == 0M)
{
data.Rows[j]["useConditon"] = "不限制";
}
else
{
data.Rows[j]["useConditon"] = "满" + num3.ToString("F2") + "可使用";
}
string str2 = data.Rows[j]["maxReceivNum"].ToString();
if (str2 == "0")
{
data.Rows[j]["ReceivNum"] = "无限制";
}
else
{
data.Rows[j]["ReceivNum"] = str2 + "/张每人";
}
}
}
this.grdCoupondsList.DataSource = data;
this.grdCoupondsList.DataBind();
this.pager1.TotalRecords = couponInfos.TotalRecords;
}
private void BindProducts(int couponId)
{
DataTable selectedProducts = this.GetSelectedProducts(couponId);
string text = this.txt_name.Text;
string val = this.txt_minPrice.Text;
string str3 = this.txt_maxPrice.Text;
decimal? nullable = null;
decimal? nullable2 = null;
decimal i = 0M;
if (!this.bDecimal(val, ref i))
{
nullable = null;
}
else
{
nullable = new decimal?(i);
}
if (!this.bDecimal(str3, ref i))
{
nullable2 = null;
}
else
{
nullable2 = new decimal?(i);
}
ProductQuery entity = new ProductQuery
{
Keywords = text,
ProductCode = "",
CategoryId = null,
PageSize = this.pager.PageSize,
PageIndex = this.pager.PageIndex,
SortOrder = SortAction.Desc,
SortBy = "DisplaySequence",
StartDate = null,
BrandId = null,
EndDate = null,
TypeId = null,
SaleStatus = this.status,
minPrice = nullable,
maxPrice = nullable2,
TwoSaleStatus = "OnStock"
};
Globals.EntityCoding(entity, true);
DbQueryResult products = ProductHelper.GetProducts(entity);
DataTable data = (DataTable)products.Data;
data.Columns.Add("seledStatus");
data.Columns.Add("canSelStatus");
data.Columns.Add("canChkStatus");
if ((data != null) && (selectedProducts != null))
{
if ((data.Rows.Count > 0) && (selectedProducts.Rows.Count > 0))
{
for (int j = 0; j < data.Rows.Count; j++)
{
int num3 = int.Parse(data.Rows[j]["ProductId"].ToString());
if (selectedProducts.Select(string.Format("ProductId={0}", num3)).Length > 0)
{
data.Rows[j]["seledStatus"] = "''";
data.Rows[j]["canSelStatus"] = "none";
data.Rows[j]["canChkStatus"] = "disabled";
}
else
{
data.Rows[j]["seledStatus"] = "none";
data.Rows[j]["canSelStatus"] = "''";
data.Rows[j]["canChkStatus"] = string.Empty;
}
}
}
else if (data.Rows.Count > 0)
{
for (int k = 0; k < data.Rows.Count; k++)
{
data.Rows[k]["seledStatus"] = "none";
data.Rows[k]["canSelStatus"] = "''";
data.Rows[k]["canChkStatus"] = string.Empty;
}
}
}
this.grdProducts.DataSource = products.Data;
this.grdProducts.DataBind();
this.pager.TotalRecords = products.TotalRecords;
this.lbwareNumber.Text = products.TotalRecords.ToString();
this.lblJoin.Text = selectedProducts.Rows.Count.ToString();
this.setInSale();
}
private DataGridViewModel <Dictionary <string, object> > GetOrderList(OrderQuery query)
{
DataGridViewModel <Dictionary <string, object> > dataGridViewModel = new DataGridViewModel <Dictionary <string, object> >();
DbQueryResult orders = OrderHelper.GetOrders(query);
dataGridViewModel.rows = DataHelper.DataTableToDictionary(orders.Data);
dataGridViewModel.total = orders.TotalRecords;
string[] orderIds = (from d in dataGridViewModel.rows
select d["OrderId"].ToString()).ToArray();
List <RefundInfo> refundInfos = TradeHelper.GetRefundInfos(orderIds);
foreach (Dictionary <string, object> row in dataGridViewModel.rows)
{
OrderInfo order = TradeHelper.GetOrderInfo(row["OrderId"].ToString());
row.Add("OrderStatusText", OrderHelper.GetOrderStatusText(order.OrderStatus, order.ShippingModeId, order.IsConfirm, order.Gateway, 0, order.PreSaleId, order.DepositDate, false, order.ItemStatus, OrderType.NormalOrder));
row.Add("CanConfirmOrder", order.CanConfirmOrder());
row.Add("canCheckTake", order.CanConfirmTakeCode());
row.Add("canCloseOrder", order.CanClose(base.CurrentSiteSetting.OpenMultStore, true));
row.Add("canOfflineReceipt", OrderHelper.CanConfirmOfflineReceipt(order, true));
row.Add("canSendGoods", order.CanSendGoods(base.CurrentSiteSetting.OpenMultStore));
row.Add("canFinishTrade", order.OrderStatus == OrderStatus.SellerAlreadySent && order.ItemStatus == OrderItemStatus.Nomarl);
row.Add("SupplierOrderTotals", order.OrderCostPrice + order.Freight);
if (order.IsStoreCollect)
{
row.Add("isShowCheckRefund", order.OrderStatus == OrderStatus.ApplyForRefund && order.StoreId == base.CurrentManager.StoreId);
}
row.Add("InvoiceTypeText", string.IsNullOrEmpty(order.InvoiceTitle) ? "" : EnumDescription.GetEnumDescription((Enum)(object)order.InvoiceType, 0));
bool flag = false;
if (order.FightGroupId > 0)
{
FightGroupInfo fightGroup = VShopHelper.GetFightGroup(order.FightGroupId);
if (fightGroup != null)
{
row.Add("FightGroupActivityId", fightGroup.FightGroupActivityId);
if (fightGroup.Status == FightGroupStatus.FightGroupIn && order.OrderStatus != OrderStatus.WaitBuyerPay && order.OrderStatus != OrderStatus.Closed)
{
flag = true;
}
}
}
row.Add("FightGrouping", flag);
row.Add("isGiftOrder", order.LineItems.Count <= 0);
row["IsError"] = order.IsError;
row["ErrorMessage"] = order.ErrorMessage;
RefundInfo refundInfo = refundInfos.FirstOrDefault((RefundInfo d) => d.OrderId == order.OrderId);
if (refundInfo != null)
{
row.Add("RefundId", refundInfo.RefundId);
}
int num = 0;
int num2 = 0;
bool flag2 = false;
string value = "订单中有商品正在进行退货/退款";
AfterSaleTypes?nullable = null;
if (order.ItemStatus != 0 || order.OrderStatus == OrderStatus.ApplyForRefund)
{
if (order.OrderStatus == OrderStatus.ApplyForRefund)
{
RefundInfo refundInfo2 = TradeHelper.GetRefundInfo(order.OrderId);
if (refundInfo2 != null)
{
flag2 = true;
value = "订单已申请退款";
}
}
else
{
int num3 = 0;
AfterSaleTypes afterSaleTypes = AfterSaleTypes.ReturnAndRefund;
int num4 = 0;
foreach (LineItemInfo value2 in order.LineItems.Values)
{
if (value2.ReturnInfo != null || value2.ReplaceInfo != null)
{
ReturnInfo returnInfo = value2.ReturnInfo;
ReplaceInfo replaceInfo = value2.ReplaceInfo;
if (num3 == 0 || (returnInfo != null && returnInfo.HandleStatus != ReturnStatus.Refused && returnInfo.HandleStatus != ReturnStatus.Returned) || (replaceInfo != null && (replaceInfo.HandleStatus != ReplaceStatus.Refused || replaceInfo.HandleStatus != ReplaceStatus.Replaced)))
{
if (value2.ReturnInfo != null)
{
afterSaleTypes = AfterSaleTypes.ReturnAndRefund;
num4 = value2.ReturnInfo.ReturnId;
}
else
{
afterSaleTypes = AfterSaleTypes.Replace;
num4 = value2.ReplaceInfo.ReplaceId;
}
}
num3++;
}
}
if (order.ItemStatus == OrderItemStatus.HasReturnOrReplace)
{
value = "订单中有商品正在退货/换货中";
}
else if (order.ItemStatus == OrderItemStatus.HasReplace)
{
value = "订单中有商品正在进行换货";
}
else if (order.ItemStatus == OrderItemStatus.HasReturn)
{
value = "订单中有商品在进行退货/退款操作";
}
else if (order.ReturnedCount > 0)
{
value = "订单中有商品已退货完成";
}
if (num3 > 0)
{
flag2 = true;
nullable = afterSaleTypes;
if (afterSaleTypes == AfterSaleTypes.ReturnAndRefund)
{
num = num4;
}
else
{
num2 = num4;
}
}
}
}
row.Add("ReturnId", num);
row.Add("ReplaceId", num2);
row.Add("AfterSaleType", nullable);
row.Add("isShowRefund", flag2);
row.Add("RefundStatus", value);
}
return(dataGridViewModel);
}
private void BindProducts(int eId)
{
if (this.exchangeId != 0)
{
string text = this.txt_name.Text;
string val = this.txt_minPrice.Text;
string str3 = this.txt_maxPrice.Text;
decimal?nullable = null;
decimal?nullable2 = null;
decimal i = 0M;
if (!this.bDecimal(val, ref i))
{
nullable = null;
}
else
{
nullable = new decimal?(i);
}
if (!this.bDecimal(str3, ref i))
{
nullable2 = null;
}
else
{
nullable2 = new decimal?(i);
}
ProductQuery entity = new ProductQuery {
Keywords = text,
ProductCode = "",
CategoryId = null,
PageSize = this.pager.PageSize,
PageIndex = this.pager.PageIndex,
SortOrder = SortAction.Desc,
SortBy = "DisplaySequence",
StartDate = null,
BrandId = null,
EndDate = null,
TypeId = null,
SaleStatus = this.status,
minPrice = nullable,
maxPrice = nullable2,
selectQuery = string.Format(" ProductId in ( select ProductId from Hishop_PointExChange_Products where exChangeId={0})", this.exchangeId)
};
Globals.EntityCoding(entity, true);
DbQueryResult products = ProductHelper.GetProducts(entity);
DataTable data = (DataTable)products.Data;
data.Columns.Add("ProductNumber");
data.Columns.Add("PointNumber");
data.Columns.Add("eachMaxNumber");
data.Columns.Add("status");
data.Columns.Add("seledStatus");
data.Columns.Add("canSelStatus");
data.Columns.Add("canChkStatus");
DataTable table2 = PointExChangeHelper.GetProducts(this.exchangeId);
if ((data != null) && (data.Rows.Count > 0))
{
for (int j = data.Rows.Count - 1; j >= 0; j--)
{
DataRow[] rowArray = table2.Select(" productId='" + data.Rows[j]["ProductId"].ToString() + "'");
if (rowArray.Length > 0)
{
data.Rows[j]["ProductNumber"] = rowArray[0]["ProductNumber"];
data.Rows[j]["PointNumber"] = rowArray[0]["PointNumber"];
data.Rows[j]["eachMaxNumber"] = rowArray[0]["eachMaxNumber"];
data.Rows[j]["status"] = rowArray[0]["status"];
}
else
{
data.Rows.RemoveAt(j);
}
}
}
if (table2 != null)
{
if ((data.Rows.Count > 0) && (table2.Rows.Count > 0))
{
for (int k = 0; k < data.Rows.Count; k++)
{
int num4 = int.Parse(data.Rows[k]["ProductId"].ToString());
if (table2.Select(string.Format("ProductId={0}", num4)).Length > 0)
{
data.Rows[k]["seledStatus"] = "''";
data.Rows[k]["canSelStatus"] = "none";
data.Rows[k]["canChkStatus"] = "disabled";
}
else
{
data.Rows[k]["seledStatus"] = "none";
data.Rows[k]["canSelStatus"] = "''";
data.Rows[k]["canChkStatus"] = string.Empty;
}
}
}
else if (data.Rows.Count > 0)
{
for (int m = 0; m < data.Rows.Count; m++)
{
data.Rows[m]["seledStatus"] = "none";
data.Rows[m]["canSelStatus"] = "''";
data.Rows[m]["canChkStatus"] = string.Empty;
}
}
}
this.grdProducts.DataSource = products.Data;
this.grdProducts.DataBind();
this.pager.TotalRecords = products.TotalRecords;
this.lbSelectNumber.Text = (table2 != null) ? table2.Rows.Count.ToString() : "0";
this.setInSaleAndStock();
}
}
public DbQueryResult GetSaleStoreOrderLineItemsStatistics(SaleStatisticsQuery query)
{
//StringBuilder stringBuilder = new StringBuilder();
//stringBuilder.AppendFormat(" 1=1 ");
//if (query.StartDate.HasValue)
//{
// stringBuilder.AppendFormat(" AND orderDate >= '{0}'", query.StartDate.Value);
//}
//if (query.EndDate.HasValue)
//{
// stringBuilder.AppendFormat(" AND orderDate <= '{0}'", query.EndDate.Value.AddDays(1.0));
//}
//if (!string.IsNullOrEmpty(query.ProductName))
//{
// stringBuilder.AppendFormat(" AND ProductName LIKE '%{0}%'", DataHelper.CleanSearchString(query.ProductName));
//}
//if (query.SupplierId.HasValue && query.SupplierId != 0)
//{
// stringBuilder.AppendFormat(" AND SupplierId = {0}", query.SupplierId);
//}
//return DataHelper.PagingByRownumber(query.PageIndex, query.PageSize, query.SortBy, query.SortOrder, query.IsCount, "vw_Ecshop_SaleStoreDetails", "SkuId", (stringBuilder.Length > 0) ? stringBuilder.ToString() : null, "*");
DbCommand storedProcCommand = this.database.GetStoredProcCommand("cp_Ecshop_SaleStoreDetails");
this.database.AddInParameter(storedProcCommand, "PageIndex", DbType.Int32, query.PageIndex);
this.database.AddInParameter(storedProcCommand, "PageSize", DbType.Int32, query.PageSize);
this.database.AddInParameter(storedProcCommand, "IsCount", DbType.Boolean, query.IsCount);
if (!query.StartDate.HasValue)
{
query.StartDate = new DateTime(2000, 1, 1);
}
this.database.AddInParameter(storedProcCommand, "ParamStartTime", DbType.DateTime, query.StartDate.Value);
if (!query.EndDate.HasValue)
{
query.EndDate = DateTime.Now;
}
else
{
query.EndDate = query.EndDate.Value.AddDays(1);
}
this.database.AddInParameter(storedProcCommand, "ParamEndTime", DbType.DateTime, query.EndDate.Value);
this.database.AddInParameter(storedProcCommand, "ParamProductName", DbType.String, DataHelper.CleanSearchString(query.ProductName));
this.database.AddInParameter(storedProcCommand, "ParamSupplierId", DbType.Int32, query.SupplierId);
this.database.AddOutParameter(storedProcCommand, "TotalProductSales", DbType.Int32, 4);
DataTable result = null;
using (IDataReader dataReader = this.database.ExecuteReader(storedProcCommand))
{
result = DataHelper.ConverDataReaderToDataTable(dataReader);
}
int totalProductSales = (int)this.database.GetParameterValue(storedProcCommand, "TotalProductSales");
DbQueryResult dbresult = new DbQueryResult();
dbresult.Data = result;
dbresult.TotalRecords = totalProductSales;
return(dbresult);
}
public void BindData()
{
StoresInfo storeById = StoresHelper.GetStoreById(this.storeId);
ManagerInfo managerInfo = ManagerHelper.FindManagerByStoreId(this.storeId, SystemRoles.StoreAdmin);
if (storeById == null)
{
base.Response.Redirect("StoresList.aspx");
}
else
{
DbQueryResult storeDeliveryScop = StoresHelper.GetStoreDeliveryScop(new DeliveryScopeQuery
{
StoreId = storeById.StoreId,
PageIndex = 1,
PageSize = 2147483647
});
this.repStoreDeliveryScop.DataSource = storeDeliveryScop.Data;
this.repStoreDeliveryScop.DataBind();
this.lblState.Text = (storeById.State.Equals(0) ? "关闭" : "开启");
this.lblUserName.Text = managerInfo.UserName;
this.lblStoreName.Text = storeById.StoreName;
this.lblRegions.Text = RegionHelper.GetFullRegion(storeById.RegionId, string.Empty, true, 0);
this.lblAddress.Text = storeById.Address;
this.lblContactMan.Text = storeById.ContactMan;
this.lblTel.Text = storeById.Tel;
this.lblCategoryName.Text = storeById.WXCategoryName;
Literal literal = this.lblServeRadius;
double? nullable = storeById.ServeRadius;
literal.Text = nullable.ToString();
this.lblStoreOpenTime.Text = (string.IsNullOrEmpty(storeById.StoreOpenTime) ? "无" : storeById.StoreOpenTime);
this.lblIsAboveSelf.Text = (storeById.IsAboveSelf ? "是" : "否");
this.lblWXBusinessName.Text = storeById.WXBusinessName;
this.lblWXBranchName.Text = storeById.WXBranchName;
this.lblWxAddress.Text = storeById.WxAddress;
HiddenField hiddenField = this.hfLongitude;
nullable = storeById.Longitude;
hiddenField.Value = nullable.ToString();
HiddenField hiddenField2 = this.hfLatitude;
nullable = storeById.Latitude;
hiddenField2.Value = nullable.ToString();
this.lblWXTelephone.Text = storeById.WXTelephone;
Literal literal2 = this.lblWXAvgPrice;
int? nullable2 = storeById.WXAvgPrice;
literal2.Text = nullable2.ToString();
this.lblWXOpenTime.Text = storeById.WXOpenTime;
this.lblWXRecommend.Text = storeById.WXRecommend;
this.lblWXSpecial.Text = storeById.WXSpecial;
this.lblWXIntroduction.Text = storeById.WXIntroduction;
HiddenField hiddenField3 = this.hidIsWX;
nullable2 = storeById.WXState;
hiddenField3.Value = nullable2.ToString();
if (!string.IsNullOrEmpty(storeById.StoreImages))
{
string[] array = storeById.StoreImages.Split(',');
foreach (string text in array)
{
if (!string.IsNullOrEmpty(text.Trim()))
{
Literal literal3 = this.lblImages;
literal3.Text += $"<img src='{text}' width='98' height='98' style='padding:0 10px;'/>";
}
}
}
}
}
private void BindProducts(int couponId)
{
DataTable selectedProducts = this.GetSelectedProducts(couponId);
string text = this.txt_name.Text;
string val = this.txt_minPrice.Text;
string str3 = this.txt_maxPrice.Text;
decimal? nullable = null;
decimal? nullable2 = null;
decimal i = 0M;
if (!this.bDecimal(val, ref i))
{
nullable = null;
}
else
{
nullable = new decimal?(i);
}
if (!this.bDecimal(str3, ref i))
{
nullable2 = null;
}
else
{
nullable2 = new decimal?(i);
}
ProductQuery entity = new ProductQuery
{
Keywords = text,
ProductCode = "",
CategoryId = null,
PageSize = this.pager.PageSize,
PageIndex = this.pager.PageIndex,
SortOrder = SortAction.Desc,
SortBy = "DisplaySequence",
StartDate = null,
BrandId = null,
EndDate = null,
TypeId = null,
SaleStatus = this._status,
minPrice = nullable,
maxPrice = nullable2,
selectQuery = string.Format("productId in (select productId from Hishop_Activities_Product where ActivitiesId={0})", this._id)
};
Globals.EntityCoding(entity, true);
DbQueryResult products = ProductHelper.GetProducts(entity);
DataTable data = (DataTable)products.Data;
data.Columns.Add("setStatus");
if (((data != null) && (selectedProducts != null)) && ((data.Rows.Count > 0) && (selectedProducts.Rows.Count > 0)))
{
for (int j = 0; j < data.Rows.Count; j++)
{
int num3 = int.Parse(data.Rows[j]["ProductId"].ToString());
DataRow[] rowArray = selectedProducts.Select(string.Format("ProductId={0}", num3));
if (rowArray.Length > 0)
{
data.Rows[j]["setStatus"] = (rowArray[0]["status"].ToString() == "0") ? "暂停" : "恢复";
}
}
}
this.grdProducts.DataSource = products.Data;
this.grdProducts.DataBind();
this.pager.TotalRecords = products.TotalRecords;
this.lblJoin.Text = (selectedProducts != null) ? selectedProducts.Rows.Count.ToString() : "0";
this.setInSaleAndStock();
}
protected void BindSearch()
{
ProductBrowseQuery productBrowseQuery = this.GetCurrProductBrowseQuery();
if (this.serach_text != null)
{
this.serach_text.Value = productBrowseQuery.Keywords;
}
if (search_Subtext != null)
{
search_Subtext.Value = productBrowseQuery.SubKeywords;
}
DbQueryResult browseProductList = ProductBrowser.GetCurrBrowseProductList(productBrowseQuery);
this.rptProducts.DataSource = browseProductList.Data;
this.rptProducts.DataBind();
#region 获取控件品牌、产地过滤条件
List <string> search_BrandStr = new List <string>();
List <string> search_ProducingStr = new List <string>();
if (common_attributeslist != null)
{
DataTable dt = ProductBrowser.GetBrowseProductImportSourceIdAndBrandIdList(productBrowseQuery);
foreach (DataRow r in dt.Rows)
{
string str = r["BrandId"].ToString();
if (!search_BrandStr.Contains(str) && !string.IsNullOrWhiteSpace(str))
{
search_BrandStr.Add(str);
}
str = r["ImportSourceId"].ToString();
if (!search_ProducingStr.Contains(str) && !string.IsNullOrWhiteSpace(str) && !str.Equals("0"))
{
search_ProducingStr.Add(str);
}
}
//更新品牌、产地控件显示值
this.common_attributeslist.search_BrandStr = search_BrandStr;
this.common_attributeslist.search_ProducingStr = search_ProducingStr;
}
#endregion
this.hotSale = (Common_GoodsList_HotSale)this.FindControl("list_Common_GoodsList_HotSale");//销售排行
if (this.hotSale != null)
{
int cid = 0;
int brandId = 0;
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["categoryId"]))
{
int.TryParse(this.Page.Request.QueryString["categoryId"], out cid);
}
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["brand"]))
{
int.TryParse(this.Page.Request.QueryString["brand"], out brandId);
}
this.hotSale.DataSource = ProductBrowser.GetBrowseHotProductList(cid, brandId).DBHotSale;
this.hotSale.DataBind();
}
this.pager.TotalRecords = browseProductList.TotalRecords;
int pageCount = browseProductList.TotalRecords / this.pager.PageSize;
if (browseProductList.TotalRecords % this.pager.PageSize > 0)
{
pageCount++;
}
if (pageCount <= 1)
{
//this.litSearchResultPage.Text = string.Format("共<span>{0}</span>件商品<span class=\"pager\"><<span class=\"cur-page\">{1}</span>/<span class=\"total-page\">{1}</span>></span>", browseProductList.TotalRecords, pageCount);
this.litSearchResultPage.Text = string.Format("<span class=\"fb\">共<span class=\"total-count\">{0}</span>件商品</span><span class=\"pager\"><span class=\"cur-page\">{1}</span>/<span class=\"total-page\">{1}页</span></span>", browseProductList.TotalRecords, pageCount);
return;
}
#region 分页控件代码
int pageIndex = 1;
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["pageindex"]))
{
int.TryParse(this.Page.Request.QueryString["pageindex"], out pageIndex);
}
if (browseProductList.TotalRecords <= 0)
{
pageIndex = 0;
}
string previousPager = "";
string nextPager = "";
Regex regex = new Regex(@"(pageindex=\d+)");
MatchCollection tempMatches = regex.Matches(this.Page.Request.RawUrl);
if (tempMatches.Count == 0)
{
previousPager = this.Page.Request.RawUrl + (this.Page.Request.RawUrl.Contains("?") ? "&" : "?") + "pageindex=1";
if (pageCount > 1)
{
nextPager = this.Page.Request.RawUrl + (this.Page.Request.RawUrl.Contains("?") ? "&" : "?") + "pageindex=2";
}
else
{
nextPager = previousPager;
}
}
if (tempMatches.Count == 1)
{
foreach (Match item in tempMatches)
{
string pagerInfo = item.Value;
if (pageIndex <= pageCount)
{
if ((pageIndex - 1) > 0)
{
previousPager = this.Page.Request.RawUrl.Replace(pagerInfo, "") + "pageindex=" + (pageIndex - 1);
}
else
{
previousPager = this.Page.Request.RawUrl.Replace(pagerInfo, "") + "pageindex=1";
}
if ((pageIndex + 1) <= pageCount)
{
nextPager = this.Page.Request.RawUrl.Replace(pagerInfo, "") + "pageindex=" + (pageIndex + 1);
}
else
{
nextPager = this.Page.Request.RawUrl.Replace(pagerInfo, "") + "pageindex=" + pageCount;
}
}
}
}
#endregion
if (pageCount > 1 && pageIndex == 1)
{
this.litSearchResultPage.Text = string.Format("<span class=\"fb\">共<span>{0}</span>件商品</span><span class=\"pager\"><span class=\"cur-page\">{2}</span>/<span class=\"total-page\">{3}页</span><a class=\"prev-page disabled\" href=\"{1}\">上一页</a><a class=\"next-page\" href=\"{4}\">下一页</a></span>", new object[]
{
browseProductList.TotalRecords,
previousPager,
pageIndex,
pageCount,
nextPager
});
}
else
{
this.litSearchResultPage.Text = string.Format("<span class=\"fb\">共<span>{0}</span>件商品</span><span class=\"pager\"><span class=\"cur-page\">{2}</span>/<span class=\"total-page\">{3}页</span><a class=\"prev-page\" href=\"{1}\">上一页</a><a class=\"next-page\" href=\"{4}\">下一页</a></span>", new object[]
{
browseProductList.TotalRecords,
previousPager,
pageIndex,
pageCount,
nextPager
});
}
}
private void btnCreateReport_Click(object sender, System.EventArgs e)
{
ManagerHelper.CheckPrivilege(Privilege.ReconciOrdersDetailsExcel);
string startDate = this.calendarStart.SelectedDate.ToString();
string EndSdate = this.calendarEnd.SelectedDate.ToString();
if (string.IsNullOrEmpty(startDate) || string.IsNullOrEmpty(EndSdate))
{
this.ShowMsg("起止时间不能为空！", false);
return;
}
System.TimeSpan ND = Convert.ToDateTime(EndSdate) - Convert.ToDateTime(startDate);
double mday = ND.Days;
if (mday > 31)
{
this.ShowMsg("查询起止时间不能大于31天！", false);
return;
}
//获取搜索所有数据 PageIndex=0 为获取所有数据
DbQueryResult ExpressFeeDetails = MemberHelper.GetReconciliationExpressFeeDetails(new ReconciliationExpressFeeQuery
{
BeginTime = !this.dateStart.HasValue ? "" : this.dateStart.Value.ToString("yyyy-MM-dd HH:mm:ss"),
EndTime = !this.dateEnd.HasValue ? "" : (this.dateEnd.Value.ToString("yyyy-MM-dd") + " 23:59:59"),
PageIndex = 0,
PageSize = 0,
Supplier = int.Parse(string.IsNullOrWhiteSpace(this.sysupperId) ? "0" : this.sysupperId)
});
DataTable dtResult = (DataTable)ExpressFeeDetails.Data;
if (dtResult == null || dtResult.Rows.Count == 0)
{
this.ShowMsg("没有数据！", false);
return;
}
foreach (DataColumn cl in dtResult.Columns)
{
if (cl.ColumnName == "OrderId")
{
cl.ColumnName = "子订单编号";
}
else if (cl.ColumnName == "SupplierName")
{
cl.ColumnName = "供应商";
}
else if (cl.ColumnName == "SourceOrderId")
{
cl.ColumnName = "订单号";
}
else if (cl.ColumnName == "TradingTime")
{
cl.ColumnName = "交易时间";
}
else if (cl.ColumnName == "ExpressCompanyName")
{
cl.ColumnName = "快递公司";
}
else if (cl.ColumnName == "ShipOrderNumber")
{
cl.ColumnName = "快递单号";
}
else if (cl.ColumnName.ToLower().Trim() == "shippingdate")
{
cl.ColumnName = "发货时间";
}
else if (cl.ColumnName.ToLower().Trim() == "adjustedfreight")
{
cl.ColumnName = "快递费用";
}
}
MemoryStream ms = NPOIExcelHelper.ExportToExcel(dtResult, "快递费用报表明细");
this.Page.Response.Clear();
this.Page.Response.Buffer = false;
this.Page.Response.Charset = "GB2312";
//this.Page.Response.AppendHeader("Content-Disposition", "attachment;filename=ReconciliationOrdersDetailed.xlsx");
if (!(this.calendarStart.SelectedDate.HasValue && this.calendarEnd.SelectedDate.HasValue))
{
this.Page.Response.AppendHeader("Content-Disposition", "attachment;filename=快递费用报表明细.xlsx");
}
else
{
this.Page.Response.AppendHeader("Content-Disposition", "attachment;filename=快递费用报表明细_" + this.dateStart.Value.ToString("yyyyMMdd") + "-" + this.dateEnd.Value.ToString("yyyyMMdd") + ".xlsx");
}
this.Page.Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
this.Page.Response.ContentType = "application/octet-stream";
this.Page.EnableViewState = false;
this.Page.Response.BinaryWrite(ms.ToArray());
ms.Dispose();
ms.Close();
EventLogs.WriteOperationLog(Privilege.ReconciOrdersDetailsExcel, string.Format(CultureInfo.InvariantCulture, "用户{0}生成对快递费用明细报告成功", new object[]
{
this.User.Identity.Name
}));
this.Page.Response.End();
}
private void DoAction(string Action)
{
int num = Globals.RequestFormNum("pageIndex");
string s;
if (num > 0)
{
int userid = Globals.GetCurrentMemberUserId();
DbQueryResult oneyuanPartInDataTable = OneyuanTaoHelp.GetOneyuanPartInDataTable(new OneyuanTaoPartInQuery
{
PageIndex = num,
PageSize = 10,
ActivityId = "",
UserId = Globals.GetCurrentMemberUserId(),
state = 3,
SortBy = "BuyTime",
IsPay = -1
});
DataTable dataTable = new DataTable();
if (oneyuanPartInDataTable.Data != null)
{
dataTable = (DataTable)oneyuanPartInDataTable.Data;
dataTable.Columns.Add("LuckNumList");
dataTable.Columns.Add("PostSate");
dataTable.Columns.Add("PostBtn");
dataTable.Columns.Add("tabid");
System.Collections.IEnumerator enumerator = dataTable.Rows.GetEnumerator();
try
{
while (enumerator.MoveNext())
{
DataRow Item = (DataRow)enumerator.Current;
System.Collections.Generic.IList <LuckInfo> list = OneyuanTaoHelp.getLuckInfoList(true, Item["ActivityId"].ToString());
list = (from t in list
where t.UserId == userid && t.Pid == Item["Pid"].ToString()
select t).ToList <LuckInfo>();
Item["PostBtn"] = "0";
Item["tabid"] = "0";
if (list != null)
{
System.Collections.Generic.List <string> list2 = new System.Collections.Generic.List <string>();
foreach (LuckInfo current in list)
{
list2.Add(current.PrizeNum);
}
Item["LuckNumList"] = string.Join(",", list2);
DataTable dataTable2 = OneyuanTaoHelp.PrizesDeliveryRecord(Item["Pid"].ToString());
if (dataTable2 == null || dataTable2.Rows.Count == 0)
{
Item["PostSate"] = "收货地址未确认";
}
else
{
Item["PostSate"] = OneyuanTaoHelp.GetPrizesDeliveStatus(dataTable2.Rows[0]["status"].ToString());
Item["PostBtn"] = dataTable2.Rows[0]["status"].ToString();
Item["tabid"] = dataTable2.Rows[0]["Id"].ToString();
}
}
}
}
finally
{
System.IDisposable disposable = enumerator as System.IDisposable;
if (disposable != null)
{
disposable.Dispose();
}
}
}
string str = JsonConvert.SerializeObject(dataTable, new JsonConverter[]
{
new IsoDateTimeConverter
{
DateTimeFormat = "yyyy-MM-dd HH:mm:ss"
}
});
s = "{\"state\":true,\"msg\":\"读取成功\",\"Data\":" + str + "}";
}
else
{
s = "{\"state\":false,\"msg\":\"参数不正确\"}";
}
this.Page.Response.ClearContent();
this.Page.Response.ContentType = "application/json";
this.Page.Response.Write(s);
this.Page.Response.End();
}
public override void OnLoad(HttpContext context)
{
base.OnLoad(context);
if (context.Request["flag"] == "GetFinishedVerificationRecord")
{
int storeId = base.CurrentManager.StoreId;
int managerId = 0;
if (base.CurrentManager.RoleId == -3)
{
managerId = base.CurrentManager.ManagerId;
}
string keyword = context.Request["keyword"].ToNullString();
Pagination pagination = new Pagination();
int num = context.Request["PageIndex"].ToInt(0);
if (num < 1)
{
num = 1;
}
int num2 = context.Request["PageSize"].ToInt(0);
if (num2 < 1)
{
num2 = 10;
}
pagination.PageIndex = num;
pagination.PageSize = num2;
pagination.SortOrder = SortAction.Desc;
pagination.SortBy = "VerificationDate";
DbQueryResult finishedVerificationRecord = OrderHelper.GetFinishedVerificationRecord(pagination, storeId, keyword, managerId);
string s = JsonConvert.SerializeObject(new
{
Result = new
{
RecordCount = finishedVerificationRecord.TotalRecords,
List = from d in finishedVerificationRecord.Data.AsEnumerable()
select new
{
OrderId = d.Field <string>("OrderId"),
ProductName = d.Field <string>("ItemDescription"),
ThumbnailsUrl = Globals.FullPath(d.Field <string>("ThumbnailsUrl")),
Price = d.Field <decimal>("ItemAdjustedPrice").F2ToString("f2"),
num = d.Field <int>("num"),
UserName = d.Field <string>("UserName"),
VerificationDate = d.Field <DateTime>("VerificationDate").ToString("yyyy-MM-dd HH:mm:ss")
}
}
});
context.Response.Write(s);
context.Response.End();
}
DateTime value;
if (context.Request["flag"] == "CheckVerification")
{
int storeId2 = base.CurrentManager.StoreId;
string verificationPassword = context.Request["VerificationItems"];
OrderVerificationItemInfo verificationInfoByPassword = OrderHelper.GetVerificationInfoByPassword(verificationPassword);
if (verificationInfoByPassword == null)
{
context.Response.Write(this.GetErrorJosn(801, "该核销码无效，请重新输入"));
return;
}
if (verificationInfoByPassword.StoreId != storeId2)
{
context.Response.Write(this.GetErrorJosn(802, "非本门店核销码，请买家核对信息"));
return;
}
if (verificationInfoByPassword.VerificationStatus == 1)
{
HttpResponse response = context.Response;
value = verificationInfoByPassword.VerificationDate.Value;
response.Write(this.GetErrorJosn(801, "该核销码 于" + value.ToString("yyyy-MM-dd HH:mm:ss") + "已核销"));
return;
}
if (verificationInfoByPassword.VerificationStatus == 3)
{
context.Response.Write(this.GetErrorJosn(801, "核销码已过期，无法核销"));
return;
}
if (verificationInfoByPassword.VerificationStatus == 5)
{
context.Response.Write(this.GetErrorJosn(801, "此核销码已进行售后，无法核销"));
return;
}
if (verificationInfoByPassword.VerificationStatus == 4)
{
context.Response.Write(this.GetErrorJosn(801, "此核销码正在进行售后，无法核销"));
return;
}
string s2 = JsonConvert.SerializeObject(new
{
Result = new
{
Success = new
{
Status = true,
Msg = "核销码可用"
}
}
});
context.Response.Write(s2);
context.Response.End();
}
decimal num3 = default(decimal);
if (context.Request["flag"] == "OrderVerification")
{
int storeId3 = base.CurrentManager.StoreId;
string text = context.Request["VerificationItems"];
string[] array = text.Split(',');
DateTime now = DateTime.Now;
string text2 = "";
OrderVerificationItemInfo orderVerificationItemInfo = null;
for (int i = 0; i < array.Length; i++)
{
if (!string.IsNullOrEmpty(array[i]))
{
OrderVerificationItemInfo verificationInfoByPassword2 = OrderHelper.GetVerificationInfoByPassword(array[i]);
if (i == 0)
{
orderVerificationItemInfo = verificationInfoByPassword2;
orderVerificationItemInfo.VerificationDate = DateTime.Now;
}
if (verificationInfoByPassword2 == null)
{
context.Response.Write(this.GetErrorJosn(801, "该核销码无效，请重新输入"));
return;
}
if (verificationInfoByPassword2.StoreId != storeId3)
{
context.Response.Write(this.GetErrorJosn(802, "非本门店核销码，请买家核对信息"));
return;
}
if (verificationInfoByPassword2.VerificationStatus == 1)
{
HttpResponse response2 = context.Response;
value = verificationInfoByPassword2.VerificationDate.Value;
response2.Write(this.GetErrorJosn(801, "该核销码 于" + value.ToString("yyyy-MM-dd HH:mm:ss") + "已核销"));
return;
}
if (verificationInfoByPassword2.VerificationStatus == 3)
{
context.Response.Write(this.GetErrorJosn(801, "核销码已过期，无法核销"));
return;
}
if (verificationInfoByPassword2.VerificationStatus == 5)
{
context.Response.Write(this.GetErrorJosn(801, "此核销码已进行售后，无法核销"));
return;
}
if (verificationInfoByPassword2.VerificationStatus == 4)
{
context.Response.Write(this.GetErrorJosn(801, "此核销码正在进行售后，无法核销"));
return;
}
verificationInfoByPassword2.VerificationStatus = 1;
verificationInfoByPassword2.VerificationDate = now;
verificationInfoByPassword2.ManagerId = base.CurrentManager.ManagerId;
verificationInfoByPassword2.UserName = base.CurrentManager.UserName;
OrderHelper.UpdateVerificationItem(verificationInfoByPassword2);
text2 = verificationInfoByPassword2.OrderId;
}
WXAppletFormDataInfo wxFormData = WeChartAppletHelper.GetWxFormData(WXAppletEvent.ServiceProductValid, text2);
if (wxFormData != null)
{
wxFormData.EventValue += now.ToString("yyyyMMddHHmmss");
new WeChatAppletDao().Update(wxFormData, null);
}
}
OrderInfo serviceProductOrderInfo = OrderHelper.GetServiceProductOrderInfo(text2);
if (serviceProductOrderInfo != null)
{
num3 = serviceProductOrderInfo.GetTotal(false) / (decimal)serviceProductOrderInfo.GetBuyQuantity() * (decimal)array.Length;
MemberInfo user = Users.GetUser(serviceProductOrderInfo.UserId);
string storeName = "";
string productName = "";
if (serviceProductOrderInfo.StoreId > 0)
{
storeName = DepotHelper.GetStoreNameByStoreId(serviceProductOrderInfo.StoreId);
}
if (serviceProductOrderInfo.LineItems != null && serviceProductOrderInfo.LineItems.Count > 0)
{
productName = serviceProductOrderInfo.LineItems.Values.FirstOrDefault().ItemDescription;
}
Messenger.ServiceOrderValidSuccess(orderVerificationItemInfo, user, serviceProductOrderInfo, productName, storeName, text, num3);
if (OrderHelper.IsVerificationFinished(text2) && serviceProductOrderInfo.ItemStatus == OrderItemStatus.Nomarl)
{
serviceProductOrderInfo.OrderStatus = OrderStatus.Finished;
serviceProductOrderInfo.FinishDate = DateTime.Now;
TradeHelper.UpdateOrderInfo(serviceProductOrderInfo);
}
}
string s3 = JsonConvert.SerializeObject(new
{
Result = new
{
Status = "SUCCESS",
VerificationDate = now.ToString("yyyy-MM-dd HH:mm:ss")
}
});
context.Response.Write(s3);
context.Response.End();
}
}
protected void btnExportButton_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["ActitivyTitle"]))
{
this.ActitivyTitle = this.Page.Request.QueryString["ActitivyTitle"];
}
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["AddrReggion"]))
{
this.AddrReggion = base.Server.UrlDecode(this.Page.Request.QueryString["AddrReggion"]);
this.SelReggion.SetSelectedRegionId(new int?(int.Parse(this.AddrReggion)));
}
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["ShowTabNum"]))
{
this.ShowTabNum = base.Server.UrlDecode(this.Page.Request.QueryString["ShowTabNum"]);
}
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["Receiver"]))
{
this.Receiver = base.Server.UrlDecode(this.Page.Request.QueryString["Receiver"]);
}
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["ProductName"]))
{
this.ProductName = base.Server.UrlDecode(this.Page.Request.QueryString["ProductName"]);
}
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["StartDate"]))
{
this.StartDate = base.Server.UrlDecode(this.Page.Request.QueryString["StartDate"]);
this.calendarStartDate.SelectedDate = new DateTime?(DateTime.Parse(this.StartDate));
}
else
{
this.StartDate = "";
}
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["EndDate"]))
{
this.EndDate = base.Server.UrlDecode(this.Page.Request.QueryString["EndDate"]);
this.calendarEndDate.SelectedDate = new DateTime?(DateTime.Parse(this.EndDate));
}
else
{
this.EndDate = "";
}
PrizesDeliveQuery entity = new PrizesDeliveQuery {
Status = int.Parse(this.ShowTabNum) - 1,
StartDate = this.StartDate,
EndDate = this.EndDate,
SortBy = "WinTime",
PrizeType = 2,
SortOrder = SortAction.Desc,
PageIndex = this.pager.PageIndex,
PageSize = this.pager.PageSize,
ProductName = this.ProductName,
Receiver = this.Receiver,
ReggionId = this.AddrReggion,
ActivityTitle = this.ActitivyTitle
};
Globals.EntityCoding(entity, true);
DbQueryResult result = GameHelper.GetAllPrizesDeliveryList(entity, "", "*");
StringBuilder builder = new StringBuilder();
builder.AppendLine("<table cellspacing=\"0\" cellpadding=\"5\" rules=\"all\" border=\"1\">");
builder.AppendLine("<tr style=\"font-weight: bold; white-space: nowrap;\">");
builder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >活动名称</td>");
builder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >商品名称</td>");
builder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >奖品等级</td>");
builder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >中奖时间</td>");
builder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >收货人</td>");
builder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >联系电话</td>");
builder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >详细地址</td>");
builder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >快递公司</td>");
builder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >快递编号</td>");
builder.AppendLine("</tr>");
DataTable data = (DataTable)result.Data;
string str = string.Empty;
string str2 = string.Empty;
new List <int>();
if (!string.IsNullOrEmpty(this.hidLogId.Value) || !string.IsNullOrEmpty(this.hidPid.Value))
{
str = this.hidLogId.Value;
str2 = this.hidPid.Value;
string[] collection = str.Split(new char[] { ',' });
string[] strArray2 = str2.Split(new char[] { ',' });
List <string> list = new List <string>(collection);
List <string> list2 = new List <string>(strArray2);
for (int i = 0; i < data.Rows.Count; i++)
{
string item = data.Rows[i]["LogId"].ToString();
string str4 = data.Rows[i]["Pid"].ToString();
if (list.Contains(item) || list2.Contains(str4))
{
builder.AppendLine("<tr>");
builder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >" + data.Rows[i]["Title"] + "</td>");
builder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >" + data.Rows[i]["ProductName"] + "</td>");
builder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >" + GameHelper.GetPrizeGradeName(data.Rows[i]["PrizeGrade"].ToString()) + "</td>");
builder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >" + data.Rows[i]["WinTime"] + "</td>");
builder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >" + data.Rows[i]["Receiver"] + "</td>");
builder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >" + data.Rows[i]["Tel"] + "</td>");
builder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >" + data.Rows[i]["Address"] + "</td>");
builder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >" + data.Rows[i]["ExpressName"] + "</td>");
builder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >" + data.Rows[i]["CourierNumber"] + "</td>");
builder.AppendLine("</tr>");
}
}
}
else
{
for (int j = 0; j < data.Rows.Count; j++)
{
data.Rows[j]["LogId"].ToString();
builder.AppendLine("<tr>");
builder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >" + data.Rows[j]["Title"] + "</td>");
builder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >" + data.Rows[j]["ProductName"] + "</td>");
builder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >" + GameHelper.GetPrizeGradeName(data.Rows[j]["PrizeGrade"].ToString()) + "</td>");
builder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >" + data.Rows[j]["WinTime"] + "</td>");
builder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >" + data.Rows[j]["Receiver"] + "</td>");
builder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >" + data.Rows[j]["Tel"] + "</td>");
builder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >" + data.Rows[j]["Address"] + "</td>");
builder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >" + data.Rows[j]["ExpressName"] + "</td>");
builder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >" + data.Rows[j]["CourierNumber"] + "</td>");
builder.AppendLine("</tr>");
}
}
if (data.Rows.Count == 0)
{
builder.AppendLine("<tr><td></td></tr>");
}
builder.AppendLine("</table>");
this.Page.Response.Clear();
this.Page.Response.Buffer = false;
this.Page.Response.Charset = "UTF-8";
this.Page.Response.AppendHeader("Content-Disposition", "attachment;filename=PrizeLists_" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".xls");
this.Page.Response.ContentEncoding = Encoding.GetEncoding("UTF-8");
this.Page.Response.ContentType = "application/ms-excel";
this.Page.EnableViewState = false;
this.Page.Response.Write(builder.ToString());
this.Page.Response.End();
}
private string getOrderList(HttpContext context)
{
int num = 0;
int num2 = 0;
num = Convert.ToInt32(context.Request["PageSize"]);
num2 = Convert.ToInt32(context.Request["Page"]);
int num3 = Convert.ToInt32(context.Request["OrderStatus"]);
string text = null;
string text2 = null;
if (!string.IsNullOrWhiteSpace(context.Request["Start_Modified"]))
{
text = context.Request["Start_Modified"];
}
if (!string.IsNullOrWhiteSpace(context.Request["End_Modified"]))
{
text2 = context.Request["End_Modified"];
}
OrderQuery orderQuery = new OrderQuery();
switch (num3)
{
case 0:
orderQuery.Status = OrderStatus.WaitBuyerPay;
goto default;
case 1:
orderQuery.Status = OrderStatus.BuyerAlreadyPaid;
goto default;
case -1:
return("<?xml version=\"1.0\" encoding=\"UTF-8\"?><Order><Result>1</Result><OrderCount>0</OrderCount><OrderList></OrderList></Order>");
default:
{
if (!string.IsNullOrEmpty(text) && !string.IsNullOrEmpty(text2))
{
orderQuery.StartDate = DateTime.Parse(text);
orderQuery.EndDate = DateTime.Parse(text2);
}
orderQuery.PageIndex = num2;
orderQuery.PageSize = num;
orderQuery.SupplierId = 0;
DbQueryResult orders = OrderHelper.GetOrders(orderQuery);
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append("<?xml version=\"1.0\" encoding=\"UTF-8\"?>");
stringBuilder.Append("<Order>");
stringBuilder.Append($"<OrderCount>{orders.TotalRecords}</OrderCount>");
stringBuilder.Append("<Result>1</Result>");
stringBuilder.Append("<Cause></Cause>");
stringBuilder.Append($"<Page>{num2}</Page>");
stringBuilder.Append("<OrderList>");
DataTable data = orders.Data;
for (int i = 0; i < data.Rows.Count; i++)
{
stringBuilder.Append(string.Format("<OrderNO>{0}</OrderNO>", data.Rows[i]["OrderId"]));
}
stringBuilder.Append("</OrderList>");
stringBuilder.Append("</Order>");
return(stringBuilder.ToString());
}
}
}
public IHttpActionResult HelpByCategory(int categoryId, string accessToken, int channel, int platform, string ver)
{
Logger.WriterLogger("Common.HelpByCategory, Params: " + string.Format("accessToken={0}&channel={1}&platform={2}&ver={3}&categoryId={4}", accessToken, channel, platform, ver, categoryId), LoggerType.Info);
// 保存访问信息
base.SaveVisitInfo("", channel, platform, ver);
// 验证令牌
int accessTookenCode = VerifyAccessToken(accessToken);
if (accessTookenCode > 0)
{
return(base.JsonFaultResult(new CommonException(accessTookenCode).GetMessage(), "Common.HelpByCategory"));
}
IList <HelpCategoryInfo> categories = CommentBrowser.GetHelpCategorys();
HelpQuery helpQuery = new HelpQuery();
if (categoryId > 0)
{
helpQuery.CategoryId = categoryId;
}
helpQuery.PageIndex = 1;
helpQuery.PageSize = int.MaxValue;
helpQuery.SortBy = "AddedDate";
helpQuery.SortOrder = EcShop.Core.Enums.SortAction.Desc;
List <HelpListItem> items = new List <HelpListItem>();
DbQueryResult dbQueryResult = CommentBrowser.GetHelpList(helpQuery);
DataTable dt = dbQueryResult.Data as DataTable;
if (dt != null)
{
HelpListItem item = null;
foreach (DataRow row in dt.Rows)
{
item = new HelpListItem();
item.CategoryId = (int)row["CategoryId"];
item.Id = (int)row["HelpId"];
item.Title = (string)row["Title"];
item.Description = "";
if (row["Description"] != DBNull.Value)
{
item.Description = (string)row["Description"];
}
item.AddedDate = "";
if (row["AddedDate"] != DBNull.Value)
{
item.AddedDate = ((DateTime)row["AddedDate"]).ToString("yyyy-MM-dd HH:mm:ss");
}
items.Add(item);
}
}
return(base.JsonActionResult(new StandardResult <ListResult <HelpListItem> >()
{
code = 0,
msg = "",
data = new ListResult <HelpListItem>()
{
TotalNumOfRecords = items.Count,
Results = items
}
}));
}
private string findProduct(HttpContext context)
{
int num = 0;
int num2 = 0;
num = Convert.ToInt32(context.Request["PageSize"]);
num2 = Convert.ToInt32(context.Request["Page"]);
string text = null;
string productCode = null;
string keywords = null;
ProductSaleStatus saleStatus = ProductSaleStatus.All;
if (!string.IsNullOrWhiteSpace(context.Request["GoodsType"]))
{
text = context.Request["GoodsType"];
if (text.Equals("Onsale"))
{
saleStatus = ProductSaleStatus.OnSale;
}
else if (text.Equals("InStock"))
{
saleStatus = ProductSaleStatus.OnStock;
}
}
if (!string.IsNullOrWhiteSpace(context.Request["OuterID"]))
{
productCode = context.Request["OuterID"];
}
else if (!string.IsNullOrWhiteSpace(context.Request["GoodsName"]))
{
keywords = context.Request["GoodsName"];
}
ProductQuery productQuery = new ProductQuery
{
Keywords = keywords,
ProductCode = productCode,
PageSize = num,
PageIndex = num2,
SortOrder = SortAction.Desc,
SortBy = "DisplaySequence",
SaleStatus = saleStatus,
SupplierId = 0
};
Globals.EntityCoding(productQuery, true);
DbQueryResult products = ProductHelper.GetProducts(productQuery);
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append("<?xml version=\"1.0\" encoding=\"UTF-8\"?>");
stringBuilder.Append("<Goods>");
stringBuilder.Append($"<TotalCount>{products.TotalRecords}</TotalCount>");
stringBuilder.Append("<Result>1</Result>");
stringBuilder.Append("<Cause></Cause>");
DataTable data = products.Data;
for (int i = 0; i < data.Rows.Count; i++)
{
stringBuilder.Append("<Ware>");
int num3 = Convert.ToInt32(data.Rows[i]["ProductId"]);
int num4 = Convert.ToInt32(data.Rows[i]["HasSKU"]);
stringBuilder.Append($"<ItemID>{num3}</ItemID>");
stringBuilder.Append(string.Format("<ItemName><![CDATA[{0}]]></ItemName>", data.Rows[i]["ProductName"]));
stringBuilder.Append(string.Format("<OuterID><![CDATA[{0}]]></OuterID>", data.Rows[i]["ProductCode"]));
stringBuilder.Append(string.Format("<Price>{0}</Price>", data.Rows[i]["SalePrice"]));
stringBuilder.Append(string.Format("<Num>{0}</Num>", data.Rows[i]["Stock"]));
stringBuilder.Append($"<IsSku>{num4}</IsSku>");
stringBuilder.Append("<Items>");
if (num4 > 0)
{
DataTable dataTable = ProductBrowser.ApiGetSkusByProductId(num3);
for (int j = 0; j < dataTable.Rows.Count; j++)
{
stringBuilder.Append("<Item>");
stringBuilder.Append(string.Format("<Unit>{0}</Unit>", dataTable.Rows[j]["valuestr"]));
stringBuilder.Append(string.Format("<SkuID>{0}</SkuID>", dataTable.Rows[j]["skuId"]));
stringBuilder.Append(string.Format("<Num>{0}</Num>", dataTable.Rows[j]["Stock"]));
stringBuilder.Append(string.Format("<SkuOuterID>{0}</SkuOuterID>", dataTable.Rows[j]["SKU"]));
stringBuilder.Append(string.Format("<SkuPrice>{0}</SkuPrice>", dataTable.Rows[j]["SalePrice"]));
stringBuilder.Append("</Item>");
}
}
stringBuilder.Append("</Items>");
stringBuilder.Append("</Ware>");
}
stringBuilder.Append("</Goods>");
return(stringBuilder.ToString());
}
private void BindData()
{
OneyuanTaoPartInQuery query = new OneyuanTaoPartInQuery {
PageIndex = this.pager.PageIndex,
PageSize = this.pager.PageSize,
IsPay = 1,
SortBy = "Pid",
UserName = this.UserName,
PayWay = this.PayWay,
CellPhone = this.phone,
Atitle = this.atitle
};
if (this.state == 0)
{
query.state = 5;
}
else
{
query.state = 4;
}
DbQueryResult oneyuanPartInDataTable = OneyuanTaoHelp.GetOneyuanPartInDataTable(query);
if (oneyuanPartInDataTable.Data != null)
{
DataTable data = (DataTable)oneyuanPartInDataTable.Data;
data.Columns.Add("ActionBtn");
data.Columns.Add("ASate");
foreach (DataRow row in data.Rows)
{
if ((bool)row["IsRefund"])
{
row["ASate"] = "<span class='green'>已退款</span>";
}
else if ((bool)row["RefundErr"])
{
row["ASate"] = "<span class='red'>退款错误</span>";
}
else
{
row["ASate"] = "<span class='red'>待退款</span>";
}
string str = string.Concat(new object[] { "<a class=\"btn btn-xs btn-danger\" onclick=\"DoRefund('", row["Pid"], "','", row["PayWay"], "')\" >退款</a> " });
if ((bool)row["RefundErr"])
{
str = "<a class=\"btn btn-xs btn-primary\" Remark='" + Globals.HtmlEncode(row["Remark"].ToString()) + "' onclick=\"AView(this)\" >原因</a> " + str;
}
if ((bool)row["IsRefund"])
{
str = "";
if (row["RefundTime"] != DBNull.Value)
{
str = "<span>" + ((DateTime)row["RefundTime"]).ToString("yyyy-MM-dd") + "</span> ";
}
this.actionTd.InnerText = "退款时间";
}
row["ActionBtn"] = str;
}
this.Datalist.DataSource = data;
this.Datalist.DataBind();
this.pager.TotalRecords = oneyuanPartInDataTable.TotalRecords;
int hasRefund = 0;
this.ListWait.Text = "待退款(" + OneyuanTaoHelp.GetRefundTotalNum(out hasRefund).ToString() + ")";
this.ListEnd.Text = "已退款(" + hasRefund.ToString() + ")";
}
}
private void BindProducts(int couponId)
{
DataTable selectedProducts = this.GetSelectedProducts(couponId);
string text = this.txt_name.Text;
string val = this.txt_minPrice.Text;
string str3 = this.txt_maxPrice.Text;
decimal? nullable = null;
decimal? nullable2 = null;
decimal i = 0M;
if (!this.bDecimal(val, ref i))
{
nullable = null;
}
else
{
nullable = new decimal?(i);
}
if (!this.bDecimal(str3, ref i))
{
nullable2 = null;
}
else
{
nullable2 = new decimal?(i);
}
ProductQuery entity = new ProductQuery {
Keywords = text,
ProductCode = "",
CategoryId = null,
PageSize = this.pager.PageSize,
PageIndex = this.pager.PageIndex,
SortOrder = SortAction.Desc,
SortBy = "DisplaySequence",
StartDate = null,
BrandId = null,
EndDate = null,
TypeId = null,
SaleStatus = ProductSaleStatus.All,
minPrice = nullable,
maxPrice = nullable2
};
string str4 = string.Empty;
foreach (DataRow row in selectedProducts.Rows)
{
str4 = str4 + row["ProductId"].ToString() + ",";
}
Globals.EntityCoding(entity, true);
DbQueryResult productsFromGroup = ProductHelper.GetProductsFromGroup(entity, str4.TrimEnd(new char[] { ',' }));
DataTable data = (DataTable)productsFromGroup.Data;
data.Columns.Add("canstopStatus");
data.Columns.Add("canopenStatus");
if ((data != null) && (selectedProducts != null))
{
if ((data.Rows.Count > 0) && (selectedProducts.Rows.Count > 0))
{
for (int j = 0; j < data.Rows.Count; j++)
{
string str5 = data.Rows[j]["ProductId"].ToString();
if (selectedProducts.Select(" productId='" + str5 + "'")[0]["status"].ToString() == "0")
{
data.Rows[j]["canstopStatus"] = "''";
data.Rows[j]["canopenStatus"] = "none";
}
else
{
data.Rows[j]["canstopStatus"] = "none";
data.Rows[j]["canopenStatus"] = "''";
}
}
}
else if (data.Rows.Count > 0)
{
for (int k = 0; k < data.Rows.Count; k++)
{
data.Rows[k]["canstopStatus"] = "none";
data.Rows[k]["canopenStatus"] = "''";
}
}
}
this.grdProducts.DataSource = productsFromGroup.Data;
this.grdProducts.DataBind();
this.pager.TotalRecords = productsFromGroup.TotalRecords;
this.lblJoin.Text = selectedProducts.Rows.Count.ToString();
this.setInSaleAndStock();
}
public static DbQueryResult GetPhotoList(string keyword, int?categoryId, int pageIndex, PhotoListOrder order, int type, int pagesize = 20)
{
DbQueryResult photoList = GalleryHelper.GetPhotoList(keyword, categoryId, pageIndex, pagesize, order, type);
return(photoList);
}
private DataGridViewModel <Dictionary <string, object> > GetDataList(OrderQuery query)
{
DataGridViewModel <Dictionary <string, object> > dataGridViewModel = new DataGridViewModel <Dictionary <string, object> >();
if (query != null)
{
DbQueryResult orders = OrderHelper.GetOrders(query);
dataGridViewModel.rows = DataHelper.DataTableToDictionary(orders.Data);
dataGridViewModel.total = orders.TotalRecords;
string[] orderIds = (from d in dataGridViewModel.rows
select d["OrderId"].ToString()).ToArray();
List <RefundInfo> refundInfos = TradeHelper.GetRefundInfos(orderIds);
foreach (Dictionary <string, object> row in dataGridViewModel.rows)
{
OrderInfo order = TradeHelper.GetOrderInfo(row["OrderId"].ToString());
row.Add("OrderStatusText", OrderHelper.GetOrderStatusText(order.OrderStatus, order.ShippingModeId, order.IsConfirm, order.Gateway, 0, order.PreSaleId, order.DepositDate, false, order.ItemStatus, OrderType.NormalOrder));
row.Add("CanConfirmOrder", order.CanConfirmOrder());
row.Add("canCheckTake", order.CanConfirmTakeCode());
row.Add("canCloseOrder", this.CanClose(order, base.CurrentSiteSetting.OpenMultStore));
row.Add("canOfflineReceipt", OrderHelper.CanConfirmOfflineReceipt(order, false));
row.Add("CanEditPrice", this.CanEditPrice(order));
row.Add("InvoiceTypeText", string.IsNullOrEmpty(order.InvoiceTitle) ? "" : EnumDescription.GetEnumDescription((Enum)(object)order.InvoiceType, 0));
bool flag = order.CanSendGoods(base.CurrentSiteSetting.OpenMultStore);
if (base.CurrentSiteSetting.OpenMultStore && order.StoreId != 0)
{
flag = false;
}
row.Add("canSendGoods", flag);
row.Add("canFinishTrade", order.OrderStatus == OrderStatus.SellerAlreadySent && order.ItemStatus == OrderItemStatus.Nomarl);
bool flag2 = false;
if (base.CurrentSiteSetting.OpenMultStore && order.CountDownBuyId == 0 && order.BundlingId == 0 && order.ItemStatus == OrderItemStatus.Nomarl && (order.OrderStatus == OrderStatus.BuyerAlreadyPaid || (order.OrderStatus == OrderStatus.WaitBuyerPay && order.Gateway == "hishop.plugins.payment.podrequest")))
{
if (order.StoreId == -1)
{
flag2 = (order.LineItems.Count > 0);
}
else if (order.StoreId > 0)
{
flag2 = !order.IsConfirm;
}
else if (order.StoreId == 0)
{
flag2 = (order.ShippingModeId != -2 && order.LineItems.Count > 0);
}
}
row.Add("CanAllotStore", flag2);
RefundInfo refundInfo = refundInfos.FirstOrDefault((RefundInfo d) => d.OrderId == order.OrderId);
if (refundInfo != null)
{
row.Add("IsCheckRefund", order.OrderStatus == OrderStatus.ApplyForRefund && !order.IsStoreCollect);
row.Add("RefundId", refundInfo.RefundId);
}
bool flag3 = false;
string value = string.Empty;
string value2 = string.Empty;
if (order.ItemStatus != 0 || order.OrderStatus == OrderStatus.ApplyForRefund)
{
if (refundInfo != null && order.OrderStatus == OrderStatus.ApplyForRefund)
{
flag3 = true;
value2 = "订单已申请退款";
value = "/Admin/sales/RefundApplyDetail?RefundId=" + refundInfo.RefundId;
}
else
{
int num = 0;
AfterSaleTypes afterSaleTypes = AfterSaleTypes.ReturnAndRefund;
int num2 = 0;
foreach (LineItemInfo value4 in order.LineItems.Values)
{
if (value4.ReturnInfo != null || value4.ReplaceInfo != null)
{
ReturnInfo returnInfo = value4.ReturnInfo;
ReplaceInfo replaceInfo = value4.ReplaceInfo;
if (num == 0 || (returnInfo != null && returnInfo.HandleStatus != ReturnStatus.Refused && returnInfo.HandleStatus != ReturnStatus.Returned) || (replaceInfo != null && (replaceInfo.HandleStatus != ReplaceStatus.Refused || replaceInfo.HandleStatus != ReplaceStatus.Replaced)))
{
if (value4.ReturnInfo != null)
{
afterSaleTypes = AfterSaleTypes.ReturnAndRefund;
num2 = value4.ReturnInfo.ReturnId;
}
else
{
afterSaleTypes = AfterSaleTypes.Replace;
num2 = value4.ReplaceInfo.ReplaceId;
}
}
num++;
}
}
if (order.ItemStatus == OrderItemStatus.HasReturnOrReplace)
{
value2 = "订单中有商品正在退货/换货中";
}
else if (order.ReturnedCount > 0)
{
value2 = "订单中有商品已退货完成";
}
else if (order.ItemStatus == OrderItemStatus.HasReplace)
{
value2 = "订单中有商品正在进行换货操作";
}
else if (order.ItemStatus == OrderItemStatus.HasReturn)
{
value2 = "订单中有商品正在进行退货操作";
}
if (num > 0)
{
flag3 = true;
value = ((afterSaleTypes != AfterSaleTypes.ReturnAndRefund) ? ("ReplaceApplyDetail?ReplaceId=" + num2) : ("ReturnApplyDetail?ReturnId=" + num2));
}
}
}
row.Add("IsShowRefundIcon", flag3);
row.Add("RefundOperUrl", value);
row.Add("RefundTips", value2);
bool flag4 = false;
if (order.FightGroupId > 0)
{
FightGroupInfo fightGroup = VShopHelper.GetFightGroup(order.FightGroupId);
if (fightGroup != null)
{
row.Add("FightGroupActivityId", fightGroup.FightGroupActivityId);
if (fightGroup.Status == FightGroupStatus.FightGroupIn && order.OrderStatus != OrderStatus.WaitBuyerPay && order.OrderStatus != OrderStatus.Closed)
{
flag4 = true;
}
}
}
row.Add("FightGrouping", flag4);
if (order.StoreId > 0)
{
row.Add("StoreName", this.GetStoreName(order.StoreId));
}
if (order.LineItems.Count <= 0)
{
if (order.UserAwardRecordsId > 0)
{
row.Add("IsAwardOrder", true);
}
else
{
row.Add("IsGiftOrder", true);
}
}
if (order.PreSaleId > 0 && order.OrderStatus == OrderStatus.BuyerAlreadyPaid)
{
ProductPreSaleInfo productPreSaleInfo = ProductPreSaleHelper.GetProductPreSaleInfo(order.PreSaleId);
if (productPreSaleInfo != null)
{
string value3 = "";
DateTime dateTime;
if (productPreSaleInfo.DeliveryDate.HasValue)
{
dateTime = productPreSaleInfo.DeliveryDate.Value;
value3 = "<span>预计发货时间：" + dateTime.ToString("yyyy-MM-dd") + "</span>";
}
else
{
DateTime payDate = order.PayDate;
if (order.PayDate != DateTime.MinValue)
{
dateTime = order.PayDate;
dateTime = dateTime.AddDays((double)productPreSaleInfo.DeliveryDays);
value3 = "<span>预计发货时间：" + dateTime.ToString("yyyy-MM-dd") + "</span>";
}
}
row.Add("SendGoodsTips", value3);
}
}
}
}
return(dataGridViewModel);
}
private void BindData()
{
string text = "";
string selectedValue = "";
decimal? nullable = null;
decimal? nullable2 = null;
DateTime?selectedDate = null;
DateTime?nullable4 = null;
text = this.txt_name.Text;
decimal i = 0M;
DateTime now = DateTime.Now;
if (this.bDecimal(this.txt_minVal.Text, ref i))
{
nullable = new decimal?(i);
}
if (this.bDecimal(this.txt_maxVal.Text, ref i))
{
nullable2 = new decimal?(i);
}
selectedDate = this.calendarStartDate.SelectedDate;
nullable4 = this.calendarEndDate.SelectedDate;
selectedValue = this.ddlCouponType.SelectedValue;
CouponsSearch search = new CouponsSearch
{
CouponName = text,
minValue = nullable,
maxValue = nullable2,
beginDate = selectedDate,
endDate = nullable4,
IsCount = true,
PageIndex = this.pager1.PageIndex,
PageSize = this.pager1.PageSize,
SortBy = "CouponId",
SortOrder = SortAction.Desc,
Finished = new bool?(bFininshed),
SearchType = new int?(string.IsNullOrEmpty(selectedValue) ? 0 : int.Parse(selectedValue))
};
DbQueryResult couponInfos = CouponHelper.GetCouponInfos(search);
if (couponInfos != null)
{
DataTable data = (DataTable)couponInfos.Data;
if (data.Rows.Count > 0)
{
data.Columns.Add("useConditon");
data.Columns.Add("ReceivNum");
data.Columns.Add("expire");
for (int j = 0; j < data.Rows.Count; j++)
{
decimal num3 = decimal.Parse(data.Rows[j]["ConditionValue"].ToString());
if (num3 == 0M)
{
data.Rows[j]["useConditon"] = "不限制";
}
else
{
data.Rows[j]["useConditon"] = "满" + num3.ToString("F2") + "可使用";
}
string str3 = data.Rows[j]["maxReceivNum"].ToString();
if (str3 == "0")
{
data.Rows[j]["ReceivNum"] = "无限制";
}
else
{
data.Rows[j]["ReceivNum"] = str3 + "/张每人";
}
data.Rows[j]["expire"] = DateTime.Parse(data.Rows[j]["EndDate"].ToString()) <= DateTime.Now;
}
}
this.grdCoupondsList.DataSource = data;
this.grdCoupondsList.DataBind();
}
this.pager1.TotalRecords = couponInfos.TotalRecords;
}
private void GetProducts(System.Web.HttpContext context)
{
int pageIndex = 1;
int pageSize = 10;
if (!string.IsNullOrEmpty(context.Request["pageIndex"]))
{
int.TryParse(context.Request["pageIndex"], out pageIndex);
}
if (!string.IsNullOrEmpty(context.Request["pageSize"]))
{
int.TryParse(context.Request["pageSize"], out pageSize);
}
ProductBrowseQuery productBrowseQuery = new ProductBrowseQuery();
productBrowseQuery.PageIndex = pageIndex;
productBrowseQuery.PageSize = pageSize;
if (!string.IsNullOrEmpty(context.Request["cId"]))
{
int num = 0;
int.TryParse(context.Request["cId"], out num);
if (num != 0)
{
productBrowseQuery.CategoryId = new int?(num);
}
}
productBrowseQuery.Keywords = context.Request["keyword"];
productBrowseQuery.SortBy = "DisplaySequence";
productBrowseQuery.SortOrder = SortAction.Desc;
if (!string.IsNullOrEmpty(context.Request["sortBy"]))
{
productBrowseQuery.SortBy = context.Request["sortBy"];
}
if (!string.IsNullOrEmpty(context.Request["sortOrder"]) && context.Request["sortOrder"] == "asc")
{
productBrowseQuery.SortOrder = SortAction.Asc;
}
DbQueryResult browseProductList = ProductBrowser.GetBrowseProductList(productBrowseQuery);
System.Data.DataTable dataTable = (System.Data.DataTable)browseProductList.Data;
if (dataTable == null || dataTable.Rows.Count == 0)
{
context.Response.Write(this.GetErrorJosn(103, "没获取到相应的商品"));
return;
}
System.Text.StringBuilder stringBuilder = new System.Text.StringBuilder();
stringBuilder.Append("{\"result\":{");
stringBuilder.AppendFormat("\"totals\":{0},", browseProductList.TotalRecords);
stringBuilder.Append("\"products\":[");
foreach (System.Data.DataRow dataRow in dataTable.Rows)
{
stringBuilder.Append("{");
stringBuilder.AppendFormat("\"pid\":{0},", dataRow["ProductId"]);
stringBuilder.AppendFormat("\"name\":\"{0}\",", dataRow["ProductName"]);
stringBuilder.AppendFormat("\"pic\":\"{0}\",", (dataRow["ThumbnailUrl60"] == System.DBNull.Value) ? Globals.FullPath(this.siteSettings.DefaultProductThumbnail4) : Globals.FullPath((string)dataRow["ThumbnailUrl60"]));
stringBuilder.AppendFormat("\"price\":\"{0}\",", ((decimal)dataRow["SalePrice"]).ToString("F2"));
stringBuilder.AppendFormat("\"saleCounts\":\"{0}\",", ((int)dataRow["SaleCounts"]).ToString());
stringBuilder.AppendFormat("\"url\":\"{0}\"", Globals.FullPath(string.Format("/AppShop/ProductDetails.aspx?productId={0}", dataRow["ProductId"])));
stringBuilder.Append("},");
}
stringBuilder.Remove(stringBuilder.Length - 1, 1);
stringBuilder.Append("]}}");
context.Response.Write(stringBuilder.ToString());
}
void BindData()
{
OneyuanTaoQuery query = new OneyuanTaoQuery();
query.PageIndex = pager.PageIndex;
query.PageSize = pager.PageSize;
query.title = atitle;
query.state = state;
query.ReachType = ReachType;
DbQueryResult ListData = OneyuanTaoHelp.GetOneyuanTao(query);
if (ListData.Data != null)
{
DataTable dt = (DataTable)ListData.Data;
dt.Columns.Add("ActionBtn"); //显示的按钮
dt.Columns.Add("ASate"); //当前状态
dt.Columns.Add("PrizeState"); //开奖状态
dt.Columns.Add("CanDel"); //开奖状态
foreach (DataRow Item in dt.Rows)
{
OneyuanTaoInfo tempItem = OneyuanTaoHelp.DataRowToOneyuanTaoInfo(Item);
OneTaoState rowState = OneyuanTaoHelp.getOneTaoState(tempItem);
OneTaoPrizeState rowPrizeState = OneyuanTaoHelp.getPrizeState(tempItem);
Item["ASate"] = rowState;
Item["PrizeState"] = rowPrizeState;
Item["CanDel"] = 0;
if (rowPrizeState == OneTaoPrizeState.成功开奖)
{
Item["PrizeState"] = "<span class='success'>" + rowPrizeState + "<span>";
}
else if (rowPrizeState == OneTaoPrizeState.已关闭)
{
Item["PrizeState"] = "<span class='normal'>" + rowPrizeState + "<span>";
}
else if (rowPrizeState == OneTaoPrizeState.待退款)
{
Item["PrizeState"] = "<span class='green'>" + rowPrizeState + "<span>";
}
else
{
Item["PrizeState"] = "<span class='errcss'>" + rowPrizeState + "<span>";
}
string btnstr = "<a class=\"btn btn-xs btn-primary\" onclick=\"AView('" + Item["ActivityId"] + "')\" >查看</a> ";
if (rowState == OneTaoState.进行中 || rowState == OneTaoState.未开始)
{
btnstr += "<a class=\"btn btn-xs btn-primary\" onclick=\"AEdit('" + Item["ActivityId"] + "')\" >编辑</a> ";
}
if (rowState == OneTaoState.未开始)
{
btnstr += "<a class=\"btn btn-xs btn-success\" onclick=\"AStart('" + Item["ActivityId"] + "')\" >开启</a> ";
}
if (rowState == OneTaoState.进行中)
{
btnstr += "<a class=\"btn btn-xs btn-danger\" onclick=\"AEnd('" + Item["ActivityId"] + "','" + Item["FinishedNum"] + "','" + Item["ReachType"] + "','" + Item["ReachNum"] + "')\" >结束</a> ";
}
if ((rowState == OneTaoState.已结束 && (int)Item["FinishedNum"] == 0) || rowState == OneTaoState.未开始)
{
//可删除的活动，1未开始，2已结束且没有人参与的活动
btnstr += "<a class=\"btn btn-xs btn-danger\" onclick=\"ADel('" + Item["ActivityId"] + "')\" >删除</a> ";
Item["CanDel"] = 1;
}
if (rowState == OneTaoState.开奖失败)
{
btnstr += "<a class=\"btn btn-xs btn-danger\" onclick=\"BatchRefund('" + Item["ActivityId"] + "')\" >批量退款</a> ";
}
Item["ActionBtn"] = btnstr;
}
Datalist.DataSource = dt;
Datalist.DataBind();
pager.TotalRecords = ListData.TotalRecords;
int hasStart = 0;
int waitStart = 0;
int Total = 0;
int hasEnd = 0;
Total = OneyuanTaoHelp.GetOneyuanTaoTotalNum(out hasStart, out waitStart, out hasEnd);
ListTotal.Text = "所有夺宝(" + Total.ToString() + ")";
ListStart.Text = "进行中(" + hasStart.ToString() + ")";
ListWait.Text = "未开始(" + waitStart.ToString() + ")";
Listend.Text = "已结束(" + hasEnd.ToString() + ")";
}
//DataTable dt = (DataTable)productSet.Data;
//dt.Columns.Add("setStatus");
pager.TotalRecords = ListData.TotalRecords;
}
private void BindProducts(int actId)
{
DataTable selectedProducts = this.GetSelectedProducts();
string text = this.txt_name.Text;
string val = this.txt_minPrice.Text;
string str3 = this.txt_maxPrice.Text;
decimal? nullable = null;
decimal? nullable2 = null;
decimal i = 0M;
if (!this.bDecimal(val, ref i))
{
nullable = null;
}
else
{
nullable = new decimal?(i);
}
if (!this.bDecimal(str3, ref i))
{
nullable2 = null;
}
else
{
nullable2 = new decimal?(i);
}
ProductQuery entity = new ProductQuery {
Keywords = text,
ProductCode = "",
CategoryId = null,
PageSize = this.pager.PageSize,
PageIndex = this.pager.PageIndex,
SortOrder = SortAction.Desc,
SortBy = "DisplaySequence",
StartDate = null,
BrandId = null,
EndDate = null,
TypeId = null,
SaleStatus = this._status,
minPrice = nullable,
maxPrice = nullable2
};
Globals.EntityCoding(entity, true);
DbQueryResult products = ProductHelper.GetProducts(entity);
DataTable data = (DataTable)products.Data;
data.Columns.Add("seledStatus");
data.Columns.Add("canSelStatus");
data.Columns.Add("canChkStatus");
data.Columns.Add("btnCode");
if (data != null)
{
if (data.Rows.Count > 0)
{
string str4 = "0";
for (int j = 0; j < data.Rows.Count; j++)
{
int num3 = int.Parse(data.Rows[j]["ProductId"].ToString());
DataRow[] rowArray = selectedProducts.Select(string.Format("ProductId={0}", num3));
if (rowArray.Length > 0)
{
bool flag = false;
foreach (DataRow row in rowArray)
{
if (row["ActivitiesId"].ToString() == this._id.ToString())
{
flag = true;
break;
}
str4 = row["ActivitiesId"].ToString();
}
if (flag)
{
data.Rows[j]["btnCode"] = "<button type=\"button\" class=\"btn btn-success resetSize\" name=\"selectBtn\" disabled>已加入本次活动</button>";
}
else
{
data.Rows[j]["btnCode"] = "<a title=\"点击新窗口打开该活动\" href=\"AddProductToActivity.aspx?id=" + str4 + "\" target=\"_blank\" class=\"btn btn-warning resetSize\">已加入其他活动</button>";
}
continue;
}
data.Rows[j]["btnCode"] = "<input type=\"button\" class=\"btn btn-info resetSize\" name=\"selectBtn\" value=\"选取加入\" onclick=\"var obj=this;HiTipsShow('<strong>确定要加入该活动吗？</strong><p>加入该活动后，其他满减活动将不能选择该商品！</p>', 'confirmII', function () {saveSingle(" + data.Rows[j]["ProductId"].ToString() + ")});\"/>";
}
}
else if (data.Rows.Count > 0)
{
for (int k = 0; k < data.Rows.Count; k++)
{
}
}
}
this.grdProducts.DataSource = products.Data;
this.grdProducts.DataBind();
this.pager.TotalRecords = products.TotalRecords;
this.lbsaleNumber.Text = products.TotalRecords.ToString();
DataTable table3 = this.GetSelectedProducts(actId);
this.lblJoin.Text = (table3 != null) ? table3.Rows.Count.ToString() : "0";
this.setInStock();
}
protected void Page_Load(object sender, EventArgs e)
{
Utility.RegisterTypeForAjax(typeof(DistributorList));
this.localUrl = base.Request.Url.ToString();
string str = base.Request.QueryString["task"];
if (!base.IsPostBack)
{
string str2 = DateTime.Now.ToString("yyyyMMddHHmmss");
this.hdVery.Value = str2;
this.Session["modifyCommissionVeryCode"] = str2;
}
if (!string.IsNullOrEmpty(str))
{
string s = "{error:1,msg:'未定义操作！'}";
if (str == "readinfo")
{
int num;
if (int.TryParse(this.Page.Request.QueryString["UserId"], out num))
{
DistributorsQuery entity = new DistributorsQuery
{
UserId = int.Parse(this.Page.Request.QueryString["UserId"]),
ReferralStatus = -1,
PageIndex = 1,
PageSize = 1,
SortOrder = SortAction.Desc,
SortBy = "userid"
};
Globals.EntityCoding(entity, true);
DbQueryResult result = VShopHelper.GetDistributors(entity, null, null);
if (result.Data != null)
{
DataTable data = new DataTable();
data = (DataTable)result.Data;
s = s = "{error:0,Data:" + JsonConvert.SerializeObject(data) + "}";
}
else
{
s = "{error:1,msg:'分销商信息不存在'}";
}
}
else
{
s = "{error:1,msg:'userid错误'}";
}
}
base.Response.Write(s);
base.Response.End();
}
this.reDistributor.ItemCommand += new RepeaterCommandEventHandler(this.reDistributor_ItemCommand);
this.btnSearchButton.Click += new EventHandler(this.btnSearchButton_Click);
this.FrozenCheck.Click += new EventHandler(this.FrozenCheck_Click);
this.CancleCheck.Click += new EventHandler(this.CancleCheck_Click);
this.PassCheck.Click += new EventHandler(this.PassCheck_Click);
this.GradeCheck.Click += new EventHandler(this.GradeCheck_Click);
this.EditSave.Click += new EventHandler(this.EditSave_Click);
this.UpdateCommission.Click += new EventHandler(this.UpdateCommission_Click);
this.LoadParameters();
if (!base.IsPostBack)
{
this.BindData();
this.GradeCheckList.DataBind();
this.DrGrade.DataBind();
this.DrGrade.SelectedValue = new int?(int.Parse(this.Grade));
}
}
protected void btnExportButton_Click(object sender, System.EventArgs e)
{
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["ActitivyTitle"]))
{
this.ActitivyTitle = this.Page.Request.QueryString["ActitivyTitle"];
}
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["AddrReggion"]))
{
this.AddrReggion = base.Server.UrlDecode(this.Page.Request.QueryString["AddrReggion"]);
this.SelReggion.SetSelectedRegionId(new int?(int.Parse(this.AddrReggion)));
}
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["ShowTabNum"]))
{
this.ShowTabNum = base.Server.UrlDecode(this.Page.Request.QueryString["ShowTabNum"]);
}
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["Receiver"]))
{
this.Receiver = base.Server.UrlDecode(this.Page.Request.QueryString["Receiver"]);
}
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["ProductName"]))
{
this.ProductName = base.Server.UrlDecode(this.Page.Request.QueryString["ProductName"]);
}
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["StartDate"]))
{
this.StartDate = base.Server.UrlDecode(this.Page.Request.QueryString["StartDate"]);
this.calendarStartDate.SelectedDate = new System.DateTime?(System.DateTime.Parse(this.StartDate));
}
else
{
this.StartDate = "";
}
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["EndDate"]))
{
this.EndDate = base.Server.UrlDecode(this.Page.Request.QueryString["EndDate"]);
this.calendarEndDate.SelectedDate = new System.DateTime?(System.DateTime.Parse(this.EndDate));
}
else
{
this.EndDate = "";
}
PrizesDeliveQuery prizesDeliveQuery = new PrizesDeliveQuery();
prizesDeliveQuery.Status = int.Parse(this.ShowTabNum) - 1;
prizesDeliveQuery.StartDate = this.StartDate;
prizesDeliveQuery.EndDate = this.EndDate;
prizesDeliveQuery.SortBy = "WinTime";
prizesDeliveQuery.PrizeType = 2;
prizesDeliveQuery.SortOrder = SortAction.Desc;
prizesDeliveQuery.PageIndex = this.pager.PageIndex;
prizesDeliveQuery.PageSize = this.pager.PageSize;
prizesDeliveQuery.ProductName = this.ProductName;
prizesDeliveQuery.Receiver = this.Receiver;
prizesDeliveQuery.ReggionId = this.AddrReggion;
prizesDeliveQuery.ActivityTitle = this.ActitivyTitle;
Globals.EntityCoding(prizesDeliveQuery, true);
DbQueryResult allPrizesDeliveryList = GameHelper.GetAllPrizesDeliveryList(prizesDeliveQuery, "", "*");
System.Text.StringBuilder stringBuilder = new System.Text.StringBuilder();
stringBuilder.AppendLine("<table cellspacing=\"0\" cellpadding=\"5\" rules=\"all\" border=\"1\">");
stringBuilder.AppendLine("<tr style=\"font-weight: bold; white-space: nowrap;\">");
stringBuilder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >活动名称</td>");
stringBuilder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >商品名称</td>");
stringBuilder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >奖品等级</td>");
stringBuilder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >中奖时间</td>");
stringBuilder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >收货人</td>");
stringBuilder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >联系电话</td>");
stringBuilder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >详细地址</td>");
stringBuilder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >快递公司</td>");
stringBuilder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >快递编号</td>");
stringBuilder.AppendLine("</tr>");
System.Data.DataTable dataTable = (System.Data.DataTable)allPrizesDeliveryList.Data;
string text = string.Empty;
new System.Collections.Generic.List <int>();
if (!string.IsNullOrEmpty(base.Request["CheckBoxGroup"]))
{
text = base.Request["CheckBoxGroup"];
string[] collection = text.Split(new char[]
{
','
});
System.Collections.Generic.List <string> list = new System.Collections.Generic.List <string>(collection);
for (int i = 0; i < dataTable.Rows.Count; i++)
{
string item = dataTable.Rows[i]["LogId"].ToString();
if (list.Contains(item))
{
stringBuilder.AppendLine("<tr>");
stringBuilder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >" + dataTable.Rows[i]["Title"] + "</td>");
stringBuilder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >" + dataTable.Rows[i]["ProductName"] + "</td>");
stringBuilder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >" + GameHelper.GetPrizeGradeName(dataTable.Rows[i]["PrizeGrade"].ToString()) + "</td>");
stringBuilder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >" + dataTable.Rows[i]["WinTime"] + "</td>");
stringBuilder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >" + dataTable.Rows[i]["Receiver"] + "</td>");
stringBuilder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >" + dataTable.Rows[i]["Tel"] + "</td>");
stringBuilder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >" + dataTable.Rows[i]["Address"] + "</td>");
stringBuilder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >" + dataTable.Rows[i]["ExpressName"] + "</td>");
stringBuilder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >" + dataTable.Rows[i]["CourierNumber"] + "</td>");
stringBuilder.AppendLine("</tr>");
}
}
}
else
{
for (int j = 0; j < dataTable.Rows.Count; j++)
{
dataTable.Rows[j]["LogId"].ToString();
stringBuilder.AppendLine("<tr>");
stringBuilder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >" + dataTable.Rows[j]["Title"] + "</td>");
stringBuilder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >" + dataTable.Rows[j]["ProductName"] + "</td>");
stringBuilder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >" + GameHelper.GetPrizeGradeName(dataTable.Rows[j]["PrizeGrade"].ToString()) + "</td>");
stringBuilder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >" + dataTable.Rows[j]["WinTime"] + "</td>");
stringBuilder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >" + dataTable.Rows[j]["Receiver"] + "</td>");
stringBuilder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >" + dataTable.Rows[j]["Tel"] + "</td>");
stringBuilder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >" + dataTable.Rows[j]["Address"] + "</td>");
stringBuilder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >" + dataTable.Rows[j]["ExpressName"] + "</td>");
stringBuilder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >" + dataTable.Rows[j]["CourierNumber"] + "</td>");
stringBuilder.AppendLine("</tr>");
}
}
if (dataTable.Rows.Count == 0)
{
stringBuilder.AppendLine("<tr><td></td></tr>");
}
stringBuilder.AppendLine("</table>");
this.Page.Response.Clear();
this.Page.Response.Buffer = false;
this.Page.Response.Charset = "UTF-8";
this.Page.Response.AppendHeader("Content-Disposition", "attachment;filename=PrizeLists_" + System.DateTime.Now.ToString("yyyyMMddHHmmss") + ".xls");
this.Page.Response.ContentEncoding = System.Text.Encoding.GetEncoding("UTF-8");
this.Page.Response.ContentType = "application/ms-excel";
this.Page.EnableViewState = false;
this.Page.Response.Write(stringBuilder.ToString());
this.Page.Response.End();
}
