/// <summary>
/// Open *.sql/*.txt file in new query window
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void OpenQueryFile_OnExecuted(object sender, ExecutedRoutedEventArgs e)
{
var dialog = new OpenFileDialog
{
Filter = "SQL Files|*.sql|Text Files|*.txt|All files|*.*",
Multiselect = false
};
bool?showDialog = dialog.ShowDialog(this);
if (!showDialog.Value)
{
return;
}
string text = File.ReadAllText(dialog.FileName);
var panel = new QueryPanel {
Text = text, FilePath = dialog.FileName
};
panel.QueryResultReady += PanelOnQueryResultReady;
panel.BuildNewQueryPanel(this, Path.GetFileNameWithoutExtension(dialog.FileName));
MainDocumentPane.Children.Add(panel.Anchorable);
int indexOf = MainDocumentPane.Children.IndexOf(panel.Anchorable);
MainDocumentPane.SelectedContentIndex = indexOf;
}
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("入库日期", "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("显示字段");
}
private void OtherOfferCatalog_OnSelectionChange(int selection)
{
var elemItem = OtherOfferCatalog.Selected[selection];
var item = OtherOffer.ObjectOffer.FirstOrDefault(x => x != null && (x.PID == (uint)elemItem.Tag || (x.PID < 3 && (uint)elemItem.Tag == x.GUID)));
if (item == null)
{
return;
}
var oldGUID = item.GUID;
if (item.LotID > 0)
{
item.GUID = (uint)((item.GUID == 1) ? 0x3495FC60 : 0x34B4B46A);
}
var BuyItem = CreateObjGroup(item);
item.GUID = oldGUID;
if (BuyItem == null)
{
return;
}
if (item.LotID > 0)
{
BuyItem.Name = elemItem.Item.Name;
}
QueryPanel.SetInfo(LotController.vm, BuyItem.Objects[0], true);
QueryPanel.Mode = 2;
QueryPanel.Tab = 1;
QueryPanel.Active = true;
BuyItem.Delete(LotController.vm.Context);
}
public void SetupPanel(Panel zPanel)
{
zQuery = new QueryPanel(zPanel, 80, false);
zQuery.AddLabel("The first page will be taken from File 1", 20);
SetupDragDropFile(zQuery.AddFileBrowseBox("File 1", string.Empty, PDF_FILTER_STRING, FILE_ONE));
SetupDragDropFile(zQuery.AddFileBrowseBox("File 2", string.Empty, PDF_FILTER_STRING, FILE_TWO));
zQuery.AddCheckBox("Open Result", false, OPEN_RESULT);
zQuery.FinalizeControls();
}
/// <summary>
/// Add new query panel
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private async void NewQuery_OnExecuted(object sender, ExecutedRoutedEventArgs e)
{
var title = await this.ShowInputAsync("New query", "Query name", new MetroDialogSettings { DefaultText = "SQL Query" });
if (title != string.Empty)
{
var panel = new QueryPanel();
panel.QueryResultReady += PanelOnQueryResultReady;
panel.BuildNewQueryPanel(this, title);
MainDocumentPane.Children.Add(panel.Anchorable);
int indexOf = MainDocumentPane.Children.IndexOf(panel.Anchorable);
MainDocumentPane.SelectedContentIndex = indexOf;
}
}
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());
}
private void Catalog_OnSelectionChange(int selection)
{
if (selection >= CurrentInventory.Count)
{
return;
}
var item = CurrentInventory[selection];
Catalog.SetActive(selection, true);
var BuyItem = LotController.vm.Context.CreateObjectInstance(item.Item.GUID, LotView.Model.LotTilePos.OUT_OF_WORLD, LotView.Model.Direction.NORTH, true);
if (BuyItem == null || BuyItem.Objects.Count == 0)
{
BuyItem = null;
return; //uh
}
if (item.Item.Name != null && item.Item.Name != "")
{
BuyItem.Name = item.Item.Name;
}
if (item.Item.DisableLevel > 1 && ((VMTSOAvatarState)LotController.ActiveEntity.TSOState).Permissions < VMTSOAvatarPermissions.Admin)
{
HIT.HITVM.Get().PlaySoundEvent(UISounds.Error);
QueryPanel.Active = false;
return; //can't trade this
}
QueryPanel.InInventory = 1;
QueryPanel.SetInfo(LotController.vm, BuyItem.Objects[0], false);
QueryPanel.Mode = 2;
QueryPanel.Tab = 0;
QueryPanel.Active = true;
BuyItem.Delete(LotController.vm.Context);
if (item.Tag is uint)
{
BeginDrag(item, (uint)(item.Tag));
}
}
/// <summary>
/// Generate DDL for current dialog
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void GenerateDdl_OnExecuted(object sender, ExecutedRoutedEventArgs e)
{
DatabaseModelDesigner designer;
if (TryGetSelectedDesigner(out designer))
{
var ddlGenerator = BaseGenerator.CreateGenerator(designer.ViewModel.TableViewModels.Select(t => t.Model),
designer.ViewModel.ConnectionInfoViewModels.Select(t => t.RelationshipModel),
SessionProvider.Instance.ConnectionType, SessionProvider.Instance.Username);
string sql = ddlGenerator.GenerateDdl();
var panel = new QueryPanel {
Text = sql
};
panel.QueryResultReady += PanelOnQueryResultReady;
panel.BuildNewQueryPanel(this, $"{designer.ViewModel.DiagramTitle}_DDL");
MainDocumentPane.Children.Add(panel.Anchorable);
int indexOf = MainDocumentPane.Children.IndexOf(panel.Anchorable);
MainDocumentPane.SelectedContentIndex = indexOf;
}
}
internal void PanelProd()
{
QueryPanel.Prod();
}
public void PanelHidden()
{
QueryPanel.PanelHidden();
}
public void PanelShown()
{
QueryPanel.PanelShown();
}
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("显示字段");
}
