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"));
}
