Hl.WebMain/AdmPage/PartsInfoOutbound/BizServicePartOrderWxd-Repair-StockSelect.aspx.cs

这里只显示每个文件的开头 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.PartsInfoOutbound
{
    public partial class BizServicePartOrderWxd_Repair_StockSelect : System.Web.UI.Page
    {
        #region "全局变量及属性"

        public Hl.DataModel.BizServiceInfo ServInfo = null;

        #endregion

        #region "页面初始及加载"

        protected void Page_Load(object sender, EventArgs e)
        {
            if (DataConvert.ToString(Request["op"], "") == "Select")
            {
                string returnInfo = "";
                #region "查询"
                DataModel.DataHelp dataHelp = new DataModel.DataHelp();
                dataHelp.DataComm.TopNum = "";
                dataHelp.DataComm.Fields = "BizServicePartOrderPurchaseDetail.Id"
                                         + ",BizServicePartOrderPurchaseDetail.OrderPurchaseId As 入库主键"
                                         + ",BizServicePartOrderPurchaseDetail.OrderPurchaseNo As 入库单号"
                                         + ",BizServicePartOrderPurchaseDetail.PartId  As 配件主键"
                                         + ",BizServicePartOrderPurchaseDetail.PartNo As 配件编号"
                                         + ",BizServicePart.Name     As 配件名称"
                                         + ",BizServicePart.UnitName As 计量单位"
                                         + ",BizServicePart.BrandNo  As 配件厂牌"
                                         + ",BizServicePart.VtypeNo  As 适用车型"
                                         + ",BizServicePartOrderPurchaseDetail.PartCount As 配件数量"
                                         + ",BizServicePartOrderPurchaseDetail.PartPrice As 成本单价"
                                         + ",BizServicePart.SpecifiedPrice   As 指定售价"
                                         + ",BizServicePartStock.WarehouseNo As 仓位"
                                         + ",BizServicePartOrderPurchaseDetail.PartFlowNote As 流向"
                                         + ",(Cast(BizServicePartOrderPurchaseDetail.PartCountSurplus as decimal(18,2))) As 可出库数"
                                         + ",(Cast((Select Count(Stock) From BizServicePartStock Where BizServicePartStock.PartId=BizServicePartOrderPurchaseDetail.Id And AdmShopId<>" + (int)DataBll.AdmSafe.ReadCurrUser().ShopId + ") As decimal(18,2))) As 其他门店库存总数"
                                         + ",BizServicePartOrderPurchase.OrderNote As 备注"
                                         + ",BizServicePartOrderPurchase.SupplierName As 供应商"
                                         + "";
                dataHelp.DataComm.SWhere = " And BizServicePartOrderPurchaseDetail.OrderPurchaseId>0 "
                                         + " And BizServicePartOrderPurchase.DeleteFlag=0 "
                                         + " And BizServicePartOrderPurchase.Status<>" + (int)Enum.BizServicePartOrderPurchaseStatus.待入库 + " "
                                         + " And BizServicePartOrderPurchase.AdmShopId=" + DataBll.AdmSafe.ReadCurrUser().ShopId + " "
                                         + " And BizServicePartOrderPurchaseDetail.PartId<>0 "
                                         + "";
                #region "条　件"
                dataHelp.DataComm.SWhere += HtmlHelper.FieldWhereByStrParm("PartCode", "  And replace(BizServicePartOrderPurchaseDetail.PartNo,' ','') {0} ");
                dataHelp.DataComm.SWhere += HtmlHelper.FieldWhereByStrParm("PartName", "  And replace(BizServicePart.Name,' ','') {0} ");
                dataHelp.DataComm.SWhere += HtmlHelper.FieldWhereByIntParm("PartClass", "   And BizServicePart.ClassId In (" + TreeHelper.InitTreeString(DataBll.BizServicePartClass.Select("", "*", "", "", "Order By SortNumber ASC").Tables[0], DataConvert.ToInt(Request["ClassId"], 0).ToString()) + ") ");
                dataHelp.DataComm.SWhere += HtmlHelper.FieldWhereByIntParm("PartBrand", " And BizServicePart.BrandId={0} ");