Hl.WebMain/AdmPage/PartsBaoJManage/PartsAvgCostAndSalePrice.aspx.cs
(开头部分) 7KB这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using Hl.Code;
using Hl.WebMain.Common;
namespace Hl.WebMain.AdmPage.PartsBaoJManage
{
public partial class PartsAvgCostAndSalePrice : System.Web.UI.Page
{
#region "全局变量"
#endregion
#region "页面加载"
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Test_Perm();
Bind_Info();
Bind_Data();
}
}
#endregion
#region "数据绑定"
protected void Bind_Info()
{
WebDataHelper.BindSelectByData(lookBrand, DataBll.BizVehicleBrandInfo.Select("", "Id,Name", "", "", "Order By SortNumber ASC"), "Name", "Name");
}
protected void Test_Perm()
{
}
protected void Bind_Data()
{
string op = DataConvert.ToString(Request.QueryString["op"], "");
if (op != "")
{
string returnInfo = "";
switch (op)
{
case "Select":
#region "查询"
{
DataModel.DataHelp dataHelp = new DataModel.DataHelp();
dataHelp.DataComm.TopNum = "";
dataHelp.DataComm.Fields = " BizServicePart.*"
+ ",(Select Avg(PartPrice) From BizServicePartOrderPurchaseDetail Left Join BizServicePartOrderPurchase On BizServicePartOrderPurchase.Id=BizServicePartOrderPurchaseDetail.OrderPurchaseId Where BizServicePartOrderPurchaseDetail.PartId=BizServicePart.Id And BizServicePartOrderPurchase.Status<>" + (int)Enum.BizServicePartOrderPurchaseStatus.待入库 + ") As PartPrictCostAvg"//配件平均进价
+ ",(Select Avg(PartPrice) From BizServicePartStockChuKuDetail Where BizServicePartStockChuKuDetail.PartId=BizServicePart.Id) As PartPrictSaleAvg"//配件平均销价
+ ",(Select SUM(PartCount-GuiKuCount) From BizServicePartStockChuKuDetail Where BizServicePartStockChuKuDetail.PartId=BizServicePart.Id) As PartCountChuKu"//配件出库总数
后面还有 44 行代码,购买后查看完整代码
24 小时内免费解锁 3 个项目,之后 1 算力/个。 规则说明
AI 解读 AI
登录后可用,每次 10 算力,解读结果公开显示在下面。
还没有人解读过这个文件。
