protected override void InitQueryPanel(QueryPanel queryPanel) { base.InitQueryPanel(queryPanel); var panel = queryPanel.CreateTab("显示字段"); _checkbox = new CheckBoxListWithReverseSelect { RepeatColumns = 6, RepeatDirection = RepeatDirection.Horizontal }; _checkbox.Items.Add(new ListItem("入库日期", "Date")); _checkbox.Items.Add(new ListItem("计划号", "ProductionPlan_PlanNumber")); _checkbox.Items.Add(new ListItem("会计单位", "AccountingUnit_Name")); _checkbox.Items.Add(new ListItem("部门", "Department_Name")); _checkbox.Items.Add(new ListItem("经办人", "Employee_Name")); _checkbox.Items.Add(new ListItem("速冻库", "Store_Name")); _checkbox.Items.Add(new ListItem("入库类型", "OtherInStoreType_Name")); _checkbox.Items.Add(new ListItem("摘要", "Remark")); _checkbox.Items.Add(new ListItem("存货名称", "Goods_Name")); _checkbox.Items.Add(new ListItem("存货编码", "Goods_Code")); _checkbox.Items.Add(new ListItem("规格", "Goods_Spec")); _checkbox.Items.Add(new ListItem("主数量", "Number")); _checkbox.Items.Add(new ListItem("主单位", "Goods_MainUnit")); _checkbox.Items.Add(new ListItem("生产数量", "SecondNumber2")); _checkbox.Items.Add(new ListItem("生产单位", "Goods_SecondUnit2")); _checkbox.Items.Add(new ListItem("创建人", "CreateUser_Name")); _checkbox.Items.Add(new ListItem("备注", "Remark")); panel.EAdd(_checkbox); var hPanel = new HLayoutPanel(); CreateDataRangePanel(hPanel); queryPanel.ConditonPanel.EAdd(hPanel); mQueryControls.Add("显示字段", _checkbox); mQueryControls.EnableHoldLastControlNames.Add("显示字段"); }
protected override void InitQueryPanel(QueryPanel queryPanel) { base.InitQueryPanel(queryPanel); var panel = queryPanel.CreateTab("显示字段"); checkbox = new CheckBoxListWithReverseSelect() { RepeatColumns = 6, RepeatDirection = RepeatDirection.Horizontal }; //显示字段包括:{日期}、{计划号}、{会计单位}、{部门}、{经办人}、{生产环节}、{存货名称}、{存货编码}、{规格}、{主数量}、{主单位}、{辅数量}、{辅单位}、{备注} checkbox.Items.Add(new ListItem("单号", "ID")); checkbox.Items.Add(new ListItem("开始日期", "Date")); checkbox.Items.Add(new ListItem("结束日期", "EndDate")); checkbox.Items.Add(new ListItem("计划号", "PlanNumber")); checkbox.Items.Add(new ListItem("会计单位", "AccountingUnit_Name")); checkbox.Items.Add(new ListItem("部门", "Department_Name")); checkbox.Items.Add(new ListItem("经办人", "Employee_Name")); checkbox.Items.Add(new ListItem("存货名称", "Name")); checkbox.Items.Add(new ListItem("存货编码", "Code")); checkbox.Items.Add(new ListItem("规格", "Spec")); checkbox.Items.Add(new ListItem("主数量", "PlanNumber")); checkbox.Items.Add(new ListItem("主单位", "MainUnit")); checkbox.Items.Add(new ListItem("辅数量", "PlanSecondNumber")); checkbox.Items.Add(new ListItem("辅单位", "SecondUnit")); checkbox.Items.Add(new ListItem("备注", "Remark")); panel.EAdd(checkbox); queryPanel.ConditonPanel.EAdd(CreateDataRangePanel()); }
protected override void InitQueryPanel(QueryPanel queryPanel) { base.InitQueryPanel(queryPanel); var panel = queryPanel.CreateTab("显示字段"); checkbox = new CheckBoxListWithReverseSelect() { RepeatColumns = 6, RepeatDirection = RepeatDirection.Horizontal }; checkbox.Items.Add(new ListItem("存货名称", "Goods_Name")); checkbox.Items.Add(new ListItem("存货编码", "Goods_Code")); checkbox.Items.Add(new ListItem("重量", "Weight")); checkbox.Items.Add(new ListItem("数量", "Number")); checkbox.Items.Add(new ListItem("出成率", "OutputPrecent")); checkbox.Items.Add(new ListItem("单价", "Price")); checkbox.Items.Add(new ListItem("金额", "金额")); panel.EAdd(checkbox); queryPanel.ConditonPanel.EAdd(CreateDataRangePanel()); }
protected override void InitQueryPanel(QueryPanel queryPanel) { base.InitQueryPanel(queryPanel); var panel = queryPanel.CreateTab("显示字段"); checkbox = new CheckBoxListWithReverseSelect() { RepeatColumns = 6, RepeatDirection = RepeatDirection.Horizontal }; //显示字段包括:{会计单位}、{计划号}、{存货名称}、{存货编码}、{产出数量}(产出单存货主数量)、{入库数量}(入库单存货主数量)、{差异数量}(产出数量-入库数量) checkbox.Items.Add(new ListItem("会计单位", "AccountingUnit_Name")); checkbox.Items.Add(new ListItem("计划号", "PlanNumber_Name")); checkbox.Items.Add(new ListItem("存货名称", "Name")); checkbox.Items.Add(new ListItem("存货编码", "Code")); checkbox.Items.Add(new ListItem("产出数量", "OutputNumber")); checkbox.Items.Add(new ListItem("入库数量", "InStoreNumber")); checkbox.Items.Add(new ListItem("差异数量", "DiffNumber")); panel.EAdd(checkbox); queryPanel.ConditonPanel.EAdd(CreateDataRangePanel()); }
protected override void InitQueryPanel(QueryPanel queryPanel) { base.InitQueryPanel(queryPanel); var panel = queryPanel.CreateTab("显示字段"); _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("业务员", "Employee_Name")); _checkbox.Items.Add(new ListItem("单据状态", "BillState")); AddQueryPanelByBrandItem_Name(_checkbox); _checkbox.Items.Add(new ListItem("日期", "Date")); _checkbox.Items.Add(new ListItem("生产单位", "ProductionUnit_Name")); _checkbox.Items.Add(new ListItem("加工要求", "ProduceRequest")); _checkbox.Items.Add(new ListItem("生产日期", "ProduceDate")); _checkbox.Items.Add(new ListItem("交货日期", "DeliveryDate")); _checkbox.Items.Add(new ListItem("源单据号", "DmoID")); _checkbox.Items.Add(new ListItem("存货名称", "Goods_Name")); _checkbox.Items.Add(new ListItem("存货属性", "GoodsProperty_Name")); _checkbox.Items.Add(new ListItem("属性分类", "GoodsPropertyCatalog_Name")); _checkbox.Items.Add(new ListItem("主数量", "Number")); _checkbox.Items.Add(new ListItem("主单位", "Goods_MainUnit")); _checkbox.Items.Add(new ListItem("辅数量", "SecondNumber")); _checkbox.Items.Add(new ListItem("辅单位", "Goods_SecondUnit")); _checkbox.Items.Add(new ListItem("单价", "Price")); _checkbox.Items.Add(new ListItem("摘要", "摘要")); _checkbox.Items.Add(new ListItem("备注", "Remark")); panel.EAdd(_checkbox); var hPanel = new HLayoutPanel(); CreateDataRangePanel(hPanel); queryPanel.ConditonPanel.EAdd(hPanel); mQueryControls.Add("显示字段", _checkbox); mQueryControls.EnableHoldLastControlNames.Add("显示字段"); }
protected override void InitQueryPanel(QueryPanel queryPanel) { base.InitQueryPanel(queryPanel); var panel = queryPanel.CreateTab("显示字段"); _checkbox = new CheckBoxListWithReverseSelect { RepeatColumns = 6, RepeatDirection = RepeatDirection.Horizontal }; var list = new List <Tuple <string, string> >(); list.Add(new Tuple <string, string>("AccountingUnit_Name", "会计单位")); list.Add(new Tuple <string, string>("Department_Name", "部门")); list.Add(new Tuple <string, string>("_pr_Goods_Name", "产出单品名")); list.Add(new Tuple <string, string>("_pr_Number", "产出数量")); list.Add(new Tuple <string, string>("_pr_SecondNumber2", "产出辅数量")); list.Add(new Tuple <string, string>("_fr_Goods_Name", "速冻出库品名")); list.Add(new Tuple <string, string>("AllNumber", "速冻出库数量")); list.Add(new Tuple <string, string>("AllSecondNumber2", "速冻出库辅数量")); list.Add(new Tuple <string, string>("产出单差异(重量)", "产出单差异(重量)")); list.Add(new Tuple <string, string>("产出单差异(袋数)", "产出单差异(袋数)")); list.Add(new Tuple <string, string>("成品Name", "包装品名")); list.Add(new Tuple <string, string>("_pa_Number", "包装数量")); list.Add(new Tuple <string, string>("_pa_SecondNumber2", "包装辅数量")); var section = mPageLayoutManager.AddSection("显示字段", "显示字段"); section.ApplyLayout(list, mPageLayoutManager); foreach (var item in list) { section.SetDisplayName(item.Item1, item.Item2); _checkbox.Items.Add(new ListItem(item.Item2, item.Item1)); } panel.EAdd(_checkbox); mQueryControls.Add("显示字段", _checkbox); mQueryControls.EnableHoldLastControlNames.Add("显示字段"); queryPanel.ConditonPanel.EAdd(CreateDataRangePanel()); }
void AddResultControls(Control vPanel) { vPanel.Controls.Add(new LiteralControl("选择要导出到Excel的字段")); _list = new CheckBoxListWithReverseSelect() { RepeatColumns = 6 }; _list.RepeatDirection = RepeatDirection.Horizontal; var fields = new[] { "ID", "Name", "PrintShortName", "Code", "Spec", "GoodsProperty_Name", "Feature", "Origin", "Brand", "ProductLine_Name", "TaxRate", "MainUnit", "SecondUnit", "MainUnitRatio", "SecondUnitRatio", "UnitConvertDirection", "Barcode", "OuterCode", "SecondUnitII", "SecondUnitII_MainUnitRatio", "SecondUnitII_SecondUnitRatio", "Remark", "属性分类" }; foreach (string field in fields) { IDmoFieldInfo dmoFieldInfo; if (field == "属性分类") { var item = new ListItem(); item.Text = field; item.Value = "属性分类"; item.Selected = true; _list.Items.Add(item); continue; } if (!_dmoInfo.Fields.TryGetValue(field, out dmoFieldInfo)) { continue; } var dfField = mDFInfo.Fields.FirstOrDefault(x => field == x.Name); AddCheckBoxField(dfField, _list); } vPanel.Controls.Add(_list); HLayoutPanel hPanel = new HLayoutPanel(); vPanel.Controls.Add(hPanel); var button = new LinkButton(); button.Text = "导出到Excel"; hPanel.Add(button); var exporter = new Exporter(); hPanel.Add(exporter); button.Click += delegate { var dom = GetQueryDom(); dom.OrderBy.Expressions.Clear(); dom.Columns.Clear(); var alias = dom.From.RootSource.Alias; foreach (ListItem item in _list.Items) { if (item.Selected) { if (item.Text == "属性分类") { var goodsPropertyAlias = new JoinAlias("gpy", typeof(GoodsProperty)); dom.From.AddJoin(JoinType.Left, new DQDmoSource(goodsPropertyAlias), DQCondition.EQ(dom.From.RootSource.Alias, "GoodsProperty_ID", goodsPropertyAlias, "ID")); dom.Columns.Add(DQSelectColumn.Field("GoodsPropertyCatalog_Name", goodsPropertyAlias, "属性分类")); } else { dom.Columns.Add(DQSelectColumn.Field(item.Value, item.Text)); } } } dom.OrderBy.Expressions.Add(DQOrderByExpression.Create(alias, "ID", true)); exporter.Export(new DQueryExcelExporter(LogicName + ".xls", new LoadArguments(dom))); }; }
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("显示字段"); }
protected virtual void AddDisplayfield(CheckBoxListWithReverseSelect checkBox) { }
protected virtual void AddQueryPanelByBrandItem_Name(CheckBoxListWithReverseSelect _checkbox) { _checkbox.Items.Add(new ListItem("客户", "Customer_Name")); }