コード例 #1
0
        protected override void AddQueryControls(VLayoutPanel vPanel)
        {
            var customPanel = new LayoutManager("Main", mainInfo, mQueryContainer);

            //查询条件包括::{日期}、{计划号}、{会计单位}、{部门}、{经办人}、{生产环节}、{存货名称}、{存货编码},


            customPanel.Add("ID", new SimpleLabel("单号"), goodsName = QueryCreator.DFTextBox(mainInfo.Fields["ID"]));

            customPanel.Add("AccountingUnit_ID", QueryCreator.DFChoiceBoxEnableMultiSelection(mainInfo.Fields["AccountingUnit_ID"], mQueryContainer, "AccountingUnit_ID", B3FrameworksConsts.DataSources.授权会计单位全部));
            customPanel["AccountingUnit_ID"].NotAutoAddToContainer = true;

            customPanel.Add("Department_ID", QueryCreator.DFChoiceBoxEnableMultiSelection(mainInfo.Fields["Department_ID"], mQueryContainer, "Department_ID", B3FrameworksConsts.DataSources.授权部门全部));
            customPanel["Department_ID"].NotAutoAddToContainer = true;

            customPanel.Add("Employee_ID", QueryCreator.DFChoiceBoxEnableMultiSelection(mainInfo.Fields["Employee_ID"], mQueryContainer, "Employee_ID", B3FrameworksConsts.DataSources.授权员工全部));
            customPanel["Employee_ID"].NotAutoAddToContainer = true;

            customPanel.Add("PlanNumber", mQueryContainer.Add(QueryCreator.DFTextBox(mainInfo.Fields["PlanNumber"]), "PlanNumber"));
            customPanel["PlanNumber"].NotAutoAddToContainer = true;


            customPanel.Add("Goods_Name", new SimpleLabel("存货名称"), goodsName = QueryCreator.DFTextBox(detailInfo.Fields["Goods_Name"]));
            customPanel.Add("Goods_Code", new SimpleLabel("存货编号"), goodsCode = QueryCreator.DFTextBox(detailInfo.Fields["Goods_Code"]));
            customPanel.CreateDefaultConfig(2).Expand = false;
            vPanel.Add(customPanel.CreateLayout());
        }
コード例 #2
0
        protected override void AddQueryControls(VLayoutPanel vPanel)
        {
            var customPanel = new LayoutManager("Main", _mainInfo, mQueryContainer);

            customPanel.Add("ID", QueryCreator.DFChoiceBoxEnableMultiSelection(_mainInfo.Fields["ID"], mQueryContainer, "ID", B3ButcheryDataSource.生产通知单ID));
            customPanel["ID"].NotAutoAddToContainer = true;
            customPanel.Add("BillState", QueryCreator.一般单据状态(_mainInfo.Fields["BillState"]));
            customPanel.Add("AccountingUnit_ID", QueryCreator.DFChoiceBoxEnableMultiSelection(_mainInfo.Fields["AccountingUnit_ID"], mQueryContainer, "AccountingUnit_ID", B3FrameworksConsts.DataSources.授权会计单位全部));
            customPanel["AccountingUnit_ID"].NotAutoAddToContainer = true;
            customPanel.Add("Department_ID", QueryCreator.DFChoiceBoxEnableMultiSelection(_mainInfo.Fields["Department_ID"], mQueryContainer, "Department_ID", B3FrameworksConsts.DataSources.授权部门全部));
            customPanel["Department_ID"].NotAutoAddToContainer = true;

            customPanel.Add("Customer_ID", QueryCreator.DFChoiceBoxEnableMultiSelection(_mainInfo.Fields["Customer_ID"], mQueryContainer, "Customer_ID", "B3Sale_客户全部"));
            customPanel["Customer_ID"].NotAutoAddToContainer = true;
            customPanel.Add("ProductionUnit_ID", QueryCreator.DFChoiceBoxEnableMultiSelection(_mainInfo.Fields["ProductionUnit_ID"], mQueryContainer, "ProductionUnit_ID", B3ProduceUnitedInfosDataSources.生产单位全部));
            customPanel["ProductionUnit_ID"].NotAutoAddToContainer = true;

            customPanel.Add("Employee_ID", QueryCreator.DFChoiceBoxEnableMultiSelection(_mainInfo.Fields["Employee_ID"], mQueryContainer, "Employee_ID", B3FrameworksConsts.DataSources.授权员工全部));
            customPanel["Employee_ID"].NotAutoAddToContainer = true;

            AddQueryControlsByBrandItem_ID(customPanel, _detailInfo);

            customPanel.Add("Goods_ID", new SimpleLabel("存货"), QueryCreator.DFChoiceBoxEnableMultiSelection(_detailInfo.Fields["Goods_ID"], mQueryContainer, "Goods_ID", B3UnitedInfosConsts.DataSources.存货));
            customPanel["Goods_ID"].NotAutoAddToContainer = true;


            摘要 = new DFTextBox(_mainInfo.Fields["Remark"]);
            备注 = new DFTextBox(_detailInfo.Fields["Remark"]);
            customPanel.Add("摘要", new SimpleLabel("摘要"), 摘要);
            customPanel.Add("备注", new SimpleLabel("备注"), 备注);

            customPanel.CreateDefaultConfig(2).Expand = false;
            vPanel.Add(customPanel.CreateLayout());
        }
コード例 #3
0
        protected override void AddQueryControls(VLayoutPanel vPanel)
        {
            var customPanel = new LayoutManager("Main", mainInfo, mQueryContainer);

            customPanel.Add("ID", QueryCreator.DFTextBox(mainInfo.Fields["ID"]));
            customPanel.Add("AccountingUnit_ID", QueryCreator.DFChoiceBoxEnableMultiSelection(mainInfo.Fields["AccountingUnit_ID"], mQueryContainer, "AccountingUnit_ID", DataKind.授权会计单位全部));
            customPanel["AccountingUnit_ID"].NotAutoAddToContainer = true;
            customPanel.Add("Department_ID", QueryCreator.DFChoiceBoxEnableMultiSelection(mainInfo.Fields["Department_ID"], mQueryContainer, "Department_ID", DataKind.授权部门全部));
            customPanel["Department_ID"].NotAutoAddToContainer = true;
            customPanel.Add("Store_ID", _storeInput            = QueryCreator.DFChoiceBoxEnableMultiSelection(mainInfo.Fields["Store_ID"], mQueryContainer, "Store_ID", DataKind.授权仓库全部), false);
            customPanel["Store_ID"].NotAutoAddToContainer      = true;
            customPanel.Add("InStoreType_ID", QueryCreator.DFChoiceBoxEnableMultiSelection(mainInfo.Fields["InStoreType_ID"], mQueryContainer, "InStoreType_ID", B3ButcheryDataSource.屠宰分割入库类型全部));
            customPanel["InStoreType_ID"].NotAutoAddToContainer = true;
            customPanel.Add("CheckDate", QueryCreator.DateRange(mainInfo.Fields["CheckDate"], mQueryContainer, "MinCheckDate", "MaxCheckDate"));

            customPanel.Add("InStoreDate", new SimpleLabel("生产日期"), QueryCreator.DateRange(detailInfo.Fields["ProductionDate"], mQueryContainer, "MinProductionDate", "MaxProductionDate"));
            customPanel.Add("ProductPlan_ID", new SimpleLabel("生产计划号"), QueryCreator.DFChoiceBoxEnableMultiSelection(detailInfo.Fields["ProductPlan_ID"], mQueryContainer, "ProductPlan_ID", B3ButcheryDataSource.计划号));
            customPanel["ProductPlan_ID"].NotAutoAddToContainer = true;
            customPanel.Add("Remark", QueryCreator.DFTextBox(mainInfo.Fields["Remark"]));
            DFChoiceBox goodsInput;

            customPanel.Add("Goods_ID", new SimpleLabel("存货名称"), goodsInput = QueryCreator.DFChoiceBoxEnableMultiSelection(detailInfo.Fields["Goods_ID"], mQueryContainer, "Goods_ID", B3ButcheryDataSource.存货带编号全部));
            goodsInput.PlaceHolder = "名称 编号 简拼";
            customPanel["Goods_ID"].NotAutoAddToContainer = true;
            customPanel.Add("Origin", new SimpleLabel("存货产地"), goodsOrigin   = QueryCreator.DFTextBox(detailInfo.Fields["Goods_Code"]));
            customPanel.Add("Goods_Name", new SimpleLabel("存货名称"), goodsName = QueryCreator.DFTextBox(detailInfo.Fields["Goods_Name"]));
            customPanel.Add("Goods_Code", new SimpleLabel("存货编号"), QueryCreator.DFTextBox(detailInfo.Fields["Goods_Code"]));
            customPanel.Add("Goods_Brand", new SimpleLabel("存货品牌"), QueryCreator.DFChoiceBox(detailInfo.Fields["Goods_Name"], B3ButcheryDataSource.存货品牌));
            customPanel.Add("GoodsProperty_ID", new SimpleLabel("存货属性"), QueryCreator.DFChoiceBox(detailInfo.Fields["ID"], B3UnitedInfos.B3UnitedInfosConsts.DataSources.存货属性全部));
            customPanel.Add("PropertyCatalog_ID", new SimpleLabel("属性分类"), QueryCreator.DFChoiceBox(detailInfo.Fields["ID"], B3UnitedInfos.B3UnitedInfosConsts.DataSources.存货属性分类全部));
            customPanel.Add("DRemark", new SimpleLabel("备注"), QueryCreator.DFTextBox(detailInfo.Fields["Remark"]));
            customPanel.Add("CargoSpace_ID", new SimpleLabel("货位"), cargoSpaceName = QueryCreator.DFChoiceBoxEnableMultiSelection(detailInfo.Fields["CargoSpace_ID"], mQueryContainer, "CargoSpace_ID", B3ButcheryDataSource.货位), false);
            customPanel["CargoSpace_ID"].NotAutoAddToContainer = true;

            customPanel.Add("ProductLine_ID", new SimpleLabel("产品线"), _productLine = QueryCreator.DFChoiceBoxEnableMultiSelection(detailInfo.Fields["ID"], mQueryContainer, "ProductLine_ID", B3UnitedInfosConsts.DataSources.产品线全部));
            customPanel["ProductLine_ID"].NotAutoAddToContainer = true;

            customPanel.Add("ProductLineCategory_ID", new SimpleLabel("产品线分类"), _producttypeLine = QueryCreator.DFChoiceBoxEnableMultiSelection(detailInfo.Fields["ID"], mQueryContainer, "ProductLineCategory_ID", B3UnitedInfosConsts.DataSources.产品线分类));
            customPanel["ProductLineCategory_ID"].NotAutoAddToContainer = true;



            AddOtherQuery(customPanel, mainInfo);
            customPanel.Add("BillState", QueryCreator.一般单据状态(mainInfo.Fields["BillState"]));
            if (_useBrand)
            {
                customPanel.Add("BrandItem_ID", new SimpleLabel("品牌项"), QueryCreator.DFChoiceBoxEnableMultiSelection(detailInfo.Fields["ID"], B3UnitedInfosConsts.DataSources.品牌项));
            }
            var config = customPanel.CreateDefaultConfig(4);

            config.Expand = false;
            TagWebUtil.AddTagQueryInput(mDmoTypeID, customPanel, config, mQueryContainer);
            vPanel.Add(customPanel.CreateLayout());
        }
コード例 #4
0
        protected override void InitQueryPanel(QueryPanel queryPanel)
        {
            base.InitQueryPanel(queryPanel);
            var panel = queryPanel.CreateTab("显示字段");

            _showTypeList = new CheckBoxList
            {
                RepeatColumns   = 6,
                RepeatDirection = RepeatDirection.Horizontal
            };
            _showTypeList.Items.Add(new ListItem("合并单元格")
            {
                Selected = true
            });

            panel.EAdd(new HLayoutPanel()
            {
                new SimpleLabel("显示格式"), _showTypeList
            });
            mQueryControls.Add("显示格式", _showTypeList);
            checkbox = new CheckBoxListWithReverseSelect()
            {
                RepeatColumns = 6, RepeatDirection = RepeatDirection.Horizontal
            };
            checkbox.Items.Add(new ListItem("单号", "ID"));
            checkbox.Items.Add(new ListItem("会计单位", "AccountingUnit_Name"));
            checkbox.Items.Add(new ListItem("部门", "Department_Name"));
            checkbox.Items.Add(new ListItem("仓库", "Store_Name"));
            checkbox.Items.Add(new ListItem("入库类型", "InStoreType_Name"));
            checkbox.Items.Add(new ListItem("入库时间", "InStoreDate"));
            checkbox.Items.Add(new ListItem("验收日期", "CheckDate"));
            checkbox.Items.Add(new ListItem("生产日期", "ProductionDate"));
            checkbox.Items.Add(new ListItem("生产计划号", "ProductPlan_Name"));
            checkbox.Items.Add(new ListItem("摘要", "Remark"));
            checkbox.Items.Add(new ListItem("存货名称", "Name"));
            checkbox.Items.Add(new ListItem("产品线", "ProductLine_Name"));
            checkbox.Items.Add(new ListItem("产品线分类", "ProductLineCategory_ID"));

            checkbox.Items.Add(new ListItem("打印简称", "PrintShortName"));
            checkbox.Items.Add(new ListItem("存货属性", "GoodsProperty_Name"));
            checkbox.Items.Add(new ListItem("存货编码", "Code"));
            checkbox.Items.Add(new ListItem("规格", "Spec"));
            checkbox.Items.Add(new ListItem("产地", "Origin"));
            checkbox.Items.Add(new ListItem("存货品牌", "Brand"));
            checkbox.Items.Add(new ListItem("存货属性", "存货属性"));
            checkbox.Items.Add(new ListItem("属性分类", "属性分类"));
            checkbox.Items.Add(new ListItem("主数量", "Number"));
            checkbox.Items.Add(new ListItem("主单位", "MainUnit"));
            checkbox.Items.Add(new ListItem("辅数量", "SecondNumber"));
            checkbox.Items.Add(new ListItem("辅单位", "SecondUnit"));
            checkbox.Items.Add(new ListItem("单价", "Price"));
            checkbox.Items.Add(new ListItem("金额", "Money"));
            checkbox.Items.Add(new ListItem("创建人", "CreateUser_Name"));
            checkbox.Items.Add(new ListItem("备注", "DRemark"));
            checkbox.Items.Add(new ListItem("标签", "Names"));
            checkbox.Items.Add(new ListItem("单据状态", "BillState"));
            checkbox.Items.Add(new ListItem("每日"));
            checkbox.Items.Add(new ListItem("每月"));
            checkbox.Items.Add(new ListItem("每年"));

            checkbox.Items.Add(new ListItem("货位", "CargoSpace_Name"));
            if (_useBrand)
            {
                checkbox.Items.Add(new ListItem("品牌项", "BrandItem_Name"));
            }

            AddDisplayfield(checkbox);
            panel.EAdd(checkbox);
            panel.EAddLiteral("<BR/>");
            panel.EAddLiteral("<span style='color:red'>属性分类等级:</span>");
            depth       = panel.EAdd(new DFTextBox());
            depth.Width = Unit.Pixel(20);
            var hPanel = new HLayoutPanel();

            CreateDataRangePanel(hPanel);
            queryPanel.ConditonPanel.EAdd(hPanel);
            mQueryControls.Add("显示字段", checkbox);
            mQueryControls.EnableHoldLastControlNames.Add("显示字段");
        }