private void BindStatistics()
{
SupplierStatisticsInfo statisticsInfo = SupplierHelper.GetStatisticsInfo(HiContext.Current.Manager.StoreId);
this.lblTodayOrderAmout.Text = ((statisticsInfo.OrderPriceToday > decimal.Zero) ? ("￥" + Globals.FormatMoney(statisticsInfo.OrderPriceToday)) : string.Empty);
ClassShowOnDataLitl classShowOnDataLitl = this.lblTodayFinishOrder;
object text;
int num;
if (statisticsInfo.OrderNumbToday <= 0)
{
text = string.Empty;
}
else
{
num = statisticsInfo.OrderNumbToday;
text = num.ToString();
}
classShowOnDataLitl.Text = (string)text;
ClassShowOnDataLitl classShowOnDataLitl2 = this.ltrTodayAddMemberNumber;
object text2;
if (statisticsInfo.ProductNumbOnSale <= 0)
{
text2 = string.Empty;
}
else
{
num = statisticsInfo.ProductNumbOnSale;
text2 = num.ToString();
}
classShowOnDataLitl2.Text = (string)text2;
if (statisticsInfo.OrderNumbWaitConsignment > 0)
{
string arg = "javascript:ShowSecondMenuLeft('订单','sales/manageorder.aspx','sales/ManageOrder.aspx?orderStatus=2')";
this.ltrWaitSendOrdersNumber.Text = $"<a href=\"{arg}\"><em>{statisticsInfo.OrderNumbWaitConsignment}</em>条</a>";
}
if (statisticsInfo.OrderReplaceNum > 0)
{
string arg2 = "javascript:ShowSecondMenuLeft('订单','sales/replaceapply.aspx','sales/replaceapply.aspx')";
this.lblOrderReplaceNum.Text = $"<a href=\"{arg2}\"><em>{statisticsInfo.OrderReplaceNum}</em>条</a>";
}
if (statisticsInfo.OrderReturnNum > 0)
{
string arg3 = "javascript:ShowSecondMenuLeft('订单','sales/returnsapply.aspx','sales/returnsapply.aspx')";
this.lblOrderReturnNum.Text = $"<a href=\"{arg3}\"><em>{statisticsInfo.OrderReturnNum}</em>条</a>";
}
int productIsWarningStockNum = ProductHelper.GetProductIsWarningStockNum(HiContext.Current.Manager.StoreId);
if (productIsWarningStockNum > 0)
{
string arg4 = "javascript:ShowSecondMenuLeft('商品','Product/ProductList.aspx','Product/ProductList.aspx?isWarningStock=1')";
this.hpkIsWarningStockNum.Text = $"<a href=\"{arg4}\"><em>{productIsWarningStockNum}</em>件</a>";
}
this.lblBalance.Text = ((statisticsInfo.Balance > decimal.Zero) ? ("￥" + (statisticsInfo.Balance - statisticsInfo.ApplyRequestWaitDispose).F2ToString("f2")) : string.Empty);
this.lblBalanceDrawRequested.Text = ((statisticsInfo.BalanceDrawRequested > decimal.Zero) ? ("￥" + statisticsInfo.BalanceDrawRequested.F2ToString("f2")) : string.Empty);
this.lblApplyRequestWaitDispose.Text = ((statisticsInfo.ApplyRequestWaitDispose > decimal.Zero) ? ("￥" + statisticsInfo.ApplyRequestWaitDispose.F2ToString("f2")) : string.Empty);
this.grdProducts.DataSource = SupplierHelper.GetTop10Product10Info(HiContext.Current.Manager.StoreId);
this.grdProducts.DataBind();
}
public SupplierStatisticsInfo Statistics(int supplierId)
{
SupplierStatisticsInfo supplierStatisticsInfo = new SupplierStatisticsInfo();
try
{
StringBuilder stringBuilder = new StringBuilder("SELECT");
stringBuilder.AppendFormat("(select isnull(SUM(OrderCostPrice)+SUM(Freight),0) from Hishop_Orders where datediff(d,OrderDate,getdate())=0 and (OrderStatus<>1 AND OrderStatus<>4 AND OrderStatus<>9) and ParentOrderId<>'-1' AND SupplierId={0}) as OrderPriceToday", supplierId);
stringBuilder.AppendFormat(",(select count(1) from Hishop_Orders where datediff(dd,getdate(),OrderDate)=0 and (OrderStatus<>1 AND OrderStatus<>4 AND OrderStatus<>9) and ParentOrderId<>'-1' AND SupplierId={0}) as OrderNumbToday", supplierId);
stringBuilder.AppendFormat(",(select count(1) from Hishop_Products where SaleStatus=1 and SupplierId={0}) as ProductNumbOnSale", supplierId);
stringBuilder.AppendFormat(",(select Balance from Hishop_Supplier where SupplierId={0}) as Balance", supplierId);
stringBuilder.AppendFormat(",(select isnull(sum(Amount),0) from Hishop_SupplierBalanceDrawRequest where SupplierId={0} and IsPass is null) as ApplyRequestWaitDispose", supplierId);
stringBuilder.AppendFormat(",(select isnull(sum(Amount),0) from Hishop_SupplierBalanceDrawRequest where SupplierId={0} and IsPass=1) as BalanceDrawRequested", supplierId);
stringBuilder.AppendFormat(",(select count(1) from Hishop_Orders where OrderStatus = 2 and ParentOrderId<>'-1' AND SupplierId={0} ) as OrderNumbWaitConsignment", supplierId);
stringBuilder.AppendFormat(",(select count(1) from vw_Hishop_OrderReturns where HandleStatus =4 AND SupplierId={0} ) as OrderReturnNum", supplierId);
stringBuilder.AppendFormat(",(select count(1) from vw_Hishop_OrderReplace where HandleStatus =4 AND SupplierId={0} ) as OrderReplaceNum", supplierId);
stringBuilder.AppendFormat(",(SELECT COUNT(1) FROM vw_Hishop_BrowseProductList WHERE WarningStockNum > 0 AND SaleStatus<>{0} and SupplierId={1}) as ProductNumStokWarning", 0, supplierId);
DbCommand sqlStringCommand = base.database.GetSqlStringCommand(stringBuilder.ToString());
using (IDataReader dataReader = base.database.ExecuteReader(sqlStringCommand))
{
if (dataReader.Read())
{
supplierStatisticsInfo.OrderPriceToday = (decimal)((IDataRecord)dataReader)["OrderPriceToday"];
supplierStatisticsInfo.OrderNumbToday = (int)((IDataRecord)dataReader)["OrderNumbToday"];
supplierStatisticsInfo.ProductNumbOnSale = (int)((IDataRecord)dataReader)["ProductNumbOnSale"];
supplierStatisticsInfo.Balance = (decimal)((IDataRecord)dataReader)["Balance"];
supplierStatisticsInfo.ApplyRequestWaitDispose = (decimal)((IDataRecord)dataReader)["ApplyRequestWaitDispose"];
supplierStatisticsInfo.BalanceDrawRequested = (decimal)((IDataRecord)dataReader)["BalanceDrawRequested"];
supplierStatisticsInfo.OrderNumbWaitConsignment = (int)((IDataRecord)dataReader)["OrderNumbWaitConsignment"];
supplierStatisticsInfo.OrderReturnNum = (int)((IDataRecord)dataReader)["OrderReturnNum"];
supplierStatisticsInfo.OrderReplaceNum = (int)((IDataRecord)dataReader)["OrderReplaceNum"];
supplierStatisticsInfo.ProductNumStokWarning = (int)((IDataRecord)dataReader)["ProductNumStokWarning"];
}
}
}
catch (Exception)
{
}
return(supplierStatisticsInfo);
}
