protected override void CreateQueryGridColumns(DFBrowseGrid grid)
{
grid.Columns.Add(new DFBrowseGridColumn("Name"));
grid.Columns.Add(new DFBrowseGridColumn("Spec"));
grid.Columns.Add(new DFBrowseGridColumn("GoodsProperty_Name"));
grid.Columns.EAdd(new DFBrowseGridColumn("GoodsPropertyCatalog_Name")).HeaderText = "属性分类";
grid.Columns.Add(new DFBrowseGridColumn("SecondUnit"));
grid.Columns.EAdd(new DFEditGridColumn <DFTextBox>("辅数量")).InitEditControl += (sender, e) =>
{
e.Control.Attributes["onchange"] = @"
if({convertDirection}=='双向转换'||{convertDirection}=='由辅至主'){
{setMainNumber}
}".Replace("{setMainNumber}", setMainNumber).Replace("{convertDirection}", ConvertDirection);
};
grid.Columns.Add(new DFBrowseGridColumn("MainUnit"));
grid.Columns.EAdd(new DFEditGridColumn <DFTextBox>("主数量")).InitEditControl += (sender, e) =>
{
e.Control.Attributes["onchange"] = @"
if({convertDirection}=='双向转换'||{convertDirection}=='由主至辅'){
{setSecondNumber}
}".Replace("{setSecondNumber}", setSecondNumber).Replace("{convertDirection}", ConvertDirection);
};
grid.ValueColumns.Add("MainUnitRatio");
grid.ValueColumns.Add("SecondUnitRatio");
grid.ValueColumns.Add("UnitConvertDirection");
}
private void AddQueryResult(VLayoutPanel vPanel)
{
vPanel.Add(new LiteralControl("<BR/>"));
grid = vPanel.Add(new DFBrowseGrid(new DFDataTableEditor())
{
Width = Unit.Percentage(100)
});
grid.Columns.Add(new DFBrowseGridColumn("Name"));
grid.Columns.Add(new DFBrowseGridColumn("Code"));
grid.Columns.Add(new DFBrowseGridColumn("Spec"));
var goods2Name = new DFEditGridColumn <DFChoiceBox>("Goods2_ID");
goods2Name.InitEditControl += delegate(object sender, InitEditControlEventArgs <DFChoiceBox> e)
{
e.Control.DataKind = B3ButcheryDataSource.存货带编号;
e.Control.DFDisplayField = "Goods2_Name";
e.Control.EnableInputArgument = true;
e.Control.EnableTopItem = true;
e.Control.Width = Unit.Pixel(120);
};
grid.Columns.EAdd(goods2Name).HeaderText = "半成品名称";
grid.Columns.Add(new DFEditGridColumn <DFValueLabel>("Goods2_Code"));
grid.Columns.Add(new DFEditGridColumn <DFValueLabel>("Goods2_Spec"));
grid.Columns.Add(new DFEditGridColumn("Remark"));
vPanel.Add(new TSButton("保存", SaveBtnClick));
}
public static void CreateExportExcelPart(VLayoutPanel vPanel, DFBrowseGrid grid, string displayName)
{
HLayoutPanel hbox = vPanel.Add(new HLayoutPanel(), new VLayoutOption(HorizontalAlign.Left));
var exporter = new Exporter();
hbox.Add(new TSButton("导出到Excel", delegate
{
var lastQuery = grid.LastQuery;
if (lastQuery == null)
{
throw new Exception("请先进行查询");
}
var dom = new LoadArguments((DQueryDom)lastQuery.DQuery.Clone());
foreach (var colIndex in lastQuery.SumColumns)
{
dom.SumColumns.Add(colIndex);
}
foreach (var colIndex in lastQuery.GroupSumColumns)
{
dom.GroupSumColumns.Add(colIndex);
}
dom.DQuery.Range = SelectRange.All;
exporter.Export(new TSingSoft.WebPluginFramework.Exports.QueryResultExcelExporter(displayName, GetQueryResult(dom)));
}));
hbox.Add(exporter);
}
protected override void AddDFBrowseGridColumn(DFBrowseGrid grid, string field)
{
base.AddDFBrowseGridColumn(grid, field);
if (field == "ID")
{
AddDFBrowseGridColumn(grid, "Code");
}
}
protected override void AddDFBrowseGridColumn(DFBrowseGrid grid, string field)
{
base.AddDFBrowseGridColumn(grid, field);
if (field == "Name")
{
AddDFBrowseGridColumn(grid, "IfWeight");
}
}
protected override void AddDFBrowseGridColumn(DFBrowseGrid grid, string field)
{
base.AddDFBrowseGridColumn(grid, field);
if (field == "Name")
{
AddDFBrowseGridColumn(grid, "ProductLine_Name");
AddDFBrowseGridColumn(grid, "ChargePerson_Name");
}
}
protected override void AddDFBrowseGridColumn(DFBrowseGrid grid, string field)
{
base.AddDFBrowseGridColumn(grid, field);
if (field == "Name")
{
AddDFBrowseGridColumn(grid, "WorkshopCategory_Name");
AddDFBrowseGridColumn(grid, "No");
}
}
private void AddQueryResult(VLayoutPanel vPanel)
{
_mGrid = vPanel.Add(new DFBrowseGrid(new DFDataTableEditor())
{
Width = Unit.Percentage(100), MultiSelectionEnabled = true
});
_mGrid.Columns.Add(new DFBrowseGridAutoColumn());
AddUpdatePanel(vPanel);
}
protected override void CreateQueryGridColumns(DFBrowseGrid grid)
{
grid.Columns.Add(new DFBrowseGridColumn("Name"));
grid.Columns.Add(new DFBrowseGridColumn("Code"));
grid.Columns.Add(new DFBrowseGridColumn("CalculateCatalog_Name"));
grid.Columns.Add(new DFBrowseGridColumn("MainUnit"));
grid.Columns.Add(new DFBrowseGridColumn("SecondUnit"));
grid.ValueColumns.Add("ID");
}
protected override void AddDFBrowseGridColumn(DFBrowseGrid grid, string field)
{
base.AddDFBrowseGridColumn(grid, field);
if (field == "BillState")
{
AddDFBrowseGridColumn(grid, "AccountingUnit_Name");
AddDFBrowseGridColumn(grid, "Department_Name");
AddDFBrowseGridColumn(grid, "StartDate");
AddDFBrowseGridColumn(grid, "Store_ID");
}
}
protected override void AddDFBrowseGridColumn(DFBrowseGrid grid, string field)
{
base.AddDFBrowseGridColumn(grid, field);
if (field == "Name")
{
AddDFBrowseGridColumn(grid, "AccountingUnit_Name");
AddDFBrowseGridColumn(grid, "Department_Name");
AddDFBrowseGridColumn(grid, "InStoreType_Name");
AddDFBrowseGridColumn(grid, "Employee_Name");
}
}
protected override void AddDFBrowseGridColumn(DFBrowseGrid grid, string field)
{
base.AddDFBrowseGridColumn(grid, field);
if (field == "Name")
{
AddDFBrowseGridColumn(grid, "AccountingUnit_Name");
AddDFBrowseGridColumn(grid, "Department_Name");
AddDFBrowseGridColumn(grid, "ProductLinks_Name");
AddDFBrowseGridColumn(grid, "CollectType");
}
}
protected override void AddDFBrowseGridColumn(DFBrowseGrid grid, string field)
{
base.AddDFBrowseGridColumn(grid, field);
if (field == "ID")
{
AddDFBrowseGridColumn(grid, "Name");
AddDFBrowseGridColumn(grid, "Employee_Name");
AddDFBrowseGridColumn(grid, "Packing_Attr");
}
}
protected override void AddDFBrowseGridColumn(DFBrowseGrid grid, string field)
{
base.AddDFBrowseGridColumn(grid, field);
if (field == "BillState")
{
AddDFBrowseGridColumn(grid, "Date");
AddDFBrowseGridColumn(grid, "AccountingUnit_Name");
AddDFBrowseGridColumn(grid, "ProductionUnit_Name");
AddDFBrowseGridColumn(grid, "Customer_Name");
AddDFBrowseGridColumn(grid, "Employee_Name");
}
}
protected override void AddDFBrowseGridColumn(DFBrowseGrid grid, string field)
{
base.AddDFBrowseGridColumn(grid, field);
if (field == "ID")
{
AddDFBrowseGridColumn(grid, "Code");
AddDFBrowseGridColumn(grid, "CalculateCatalog_Name");
AddDFBrowseGridColumn(grid, "MainUnit");
AddDFBrowseGridColumn(grid, "SecondUnit");
AddDFBrowseGridColumn(grid, "DefaultNumber1");
AddDFBrowseGridColumn(grid, "Goods_Name");
}
}
protected override void AddDFBrowseGridColumn(DFBrowseGrid grid, string field)
{
base.AddDFBrowseGridColumn(grid, field);
if (field == "BillState")
{
AddDFBrowseGridColumn(grid, "AccountingUnit_Name");
AddDFBrowseGridColumn(grid, "Department_Name");
AddDFBrowseGridColumn(grid, "Employee_Name");
AddDFBrowseGridColumn(grid, "ProductPlan_Name");
AddDFBrowseGridColumn(grid, "Date");
AddDFBrowseGridColumn(grid, "TemporaryStorageType");
}
}
protected override void AddDFBrowseGridColumn(DFBrowseGrid grid, string field)
{
base.AddDFBrowseGridColumn(grid, field);
if (field == "BillState")
{
AddDFBrowseGridColumn(grid, "AccountingUnit_Name");
AddDFBrowseGridColumn(grid, "Department_Name");
AddDFBrowseGridColumn(grid, "Name");
AddDFBrowseGridColumn(grid, "Date");
AddDFBrowseGridColumn(grid, "WorkshopCategory_Name");
AddDFBrowseGridColumn(grid, "CheckUser_Name");
AddDFBrowseGridColumn(grid, "Remark");
}
}
private void AddQueryResult(VLayoutPanel vPanel)
{
vPanel.Add(new LiteralControl("<BR/>"));
grid = vPanel.Add(new DFBrowseGrid(new DFDataTableEditor())
{
Width = Unit.Percentage(100)
});
grid.Columns.Add(new DFBrowseGridColumn("Name"));
grid.Columns.Add(new DFBrowseGridColumn("Code"));
grid.Columns.Add(new DFBrowseGridColumn("Spec"));
grid.Columns.Add(new DFEditGridColumn("ReferencePrice"));
grid.Columns.Add(new DFEditGridColumn("Remark"));
vPanel.Add(new TSButton("保存", SaveBtnClick));
}
protected override void AddDFBrowseGridColumn(DFBrowseGrid grid, string field)
{
base.AddDFBrowseGridColumn(grid, field);
if (field == "Name")
{
AddDFBrowseGridColumn(grid, "存货属性");
AddDFBrowseGridColumn(grid, "存货属性分类");
AddDFBrowseGridColumn(grid, "ProductShift_Name");
AddDFBrowseGridColumn(grid, "PackageModel");
AddDFBrowseGridColumn(grid, "MainUnit");
AddDFBrowseGridColumn(grid, "SecondUnit");
AddDFBrowseGridColumn(grid, "SecondUnitII");
}
}
protected override void AddDFBrowseGridColumn(DFBrowseGrid grid, string field)
{
base.AddDFBrowseGridColumn(grid, field);
if (field == "BillState")
{
AddDFBrowseGridColumn(grid, "AccountingUnit_Name");
AddDFBrowseGridColumn(grid, "Department_Name");
AddDFBrowseGridColumn(grid, "Employee_Name");
AddDFBrowseGridColumn(grid, "Date");
AddDFBrowseGridColumn(grid, "ProductLine_Name");
AddDFBrowseGridColumn(grid, "Store_Name");
AddCustomerDFBrowseGridColumn(grid);
AddDFBrowseGridColumn(grid, "Remark");
}
}
protected override void AddDFBrowseGridColumn(DFBrowseGrid grid, string field)
{
base.AddDFBrowseGridColumn(grid, field);
if (field == "ID")
{
AddDFBrowseGridColumn(grid, "Name");
AddDFBrowseGridColumn(grid, "Department_Name");
AddDFBrowseGridColumn(grid, "Employee_Name");
AddDFBrowseGridColumn(grid, "DisplayMark");
AddDFBrowseGridColumn(grid, "Packing_Attr");
AddDFBrowseGridColumn(grid, "Packing_Pattern");
AddDFBrowseGridColumn(grid, "ProductShift_Name");
AddDFBrowseGridColumn(grid, "Abbreviation");
}
}
protected override void AddDFBrowseGridColumn(DFBrowseGrid grid, string field)
{
base.AddDFBrowseGridColumn(grid, field);
if (field == "BillState")
{
AddDFBrowseGridColumn(grid, "AccountingUnit_Name");
AddDFBrowseGridColumn(grid, "Department_Name");
AddDFBrowseGridColumn(grid, "Employee_Name");
AddDFBrowseGridColumn(grid, "Date");
AddDFBrowseGridColumn(grid, "Store_Name");
AddDFBrowseGridColumn(grid, "OtherInStoreType_Name");
AddDFBrowseGridColumn(grid, "ProductionPlan_PlanNumber");
AddDFBrowseGridColumn(grid, "CheckUser_Name");
AddDFBrowseGridColumn(grid, "Remark");
}
}
protected override void CreateQueryGridColumns(DFBrowseGrid grid)
{
grid.Columns.Add(new DFBrowseGridColumn("ID"));
grid.Columns.Add(new DFBrowseGridColumn("ProductionUnit_Name"));
grid.Columns.Add(new DFBrowseGridColumn("Date"));
grid.Columns.Add(new DFBrowseGridColumn("ProduceDate"));
grid.Columns.Add(new DFBrowseGridColumn("DeliveryDate"));
grid.Columns.Add(new DFBrowseGridColumn("ProduceRequest"));
grid.Columns.Add(new DFBrowseGridColumn("AccountingUnit_Name"));
TakeValuesCustomer(grid);
grid.Columns.Add(new DFBrowseGridColumn("Goods_Name"));
grid.Columns.Add(new DFBrowseGridColumn("Goods_MainUnit"));
grid.Columns.Add(new DFBrowseGridColumn("Goods_SecondUnit"));
grid.Columns.Add(new DFBrowseGridColumn("Number"));
grid.Columns.Add(new DFBrowseGridColumn("SecondNumber"));
if (_useBrand)
{
grid.Columns.Add(new DFBrowseGridColumn("BrandItem_Name"));
}
}
private void CreateQueryGrid(VLayoutPanel vPanel)
{
_grid = new DFBrowseGrid(new DFDataTableEditor())
{
Width = Unit.Percentage(100)
};
_grid.MultiSelectionEnabled = true;
CreateQueryGridColumns(_grid);
var hPanel = new HLayoutPanel()
{
Align = HorizontalAlign.Left
};
vPanel.Add(_grid);
var button = new TSButton("选中");
hPanel.Add(button);
vPanel.Add(hPanel);
button.Click += GridMultiSelection;
}
private void CreateDetailPanel(VLayoutPanel vPanel)
{
detailGrid = vPanel.Add(new DFBrowseGrid(new DFDataTableEditor())
{
Width = Unit.Percentage(100)
});
detailGrid.EnableRowsGroup = true;
detailGrid.Columns.Add(new DFBrowseGridColumn("会计单位"));
detailGrid.Columns.Add(new DFBrowseGridColumn("部门"));
detailGrid.Columns.Add(new DFBrowseGridColumn("产出品名"));
detailGrid.Columns.Add(new DFBrowseGridColumn("产出数量"));
detailGrid.Columns.Add(new DFBrowseGridColumn("产出辅数量"));
detailGrid.Columns.Add(new DFBrowseGridColumn("速冻出库品名"));
detailGrid.Columns.Add(new DFBrowseGridColumn("速冻出库数量"));
detailGrid.Columns.Add(new DFBrowseGridColumn("速冻出库辅数量"));
detailGrid.Columns.Add(new DFBrowseGridColumn("速冻库差异数量"));
detailGrid.Columns.Add(new DFBrowseGridColumn("速冻库差异辅数量II"));
detailGrid.Columns.Add(new DFBrowseGridColumn("包装品名"));
detailGrid.Columns.EAdd(new DFBrowseGridColumn("包装数量")).SumMode = SumMode.Sum;
detailGrid.Columns.EAdd(new DFBrowseGridColumn("包装辅数量")).SumMode = SumMode.Sum;
detailGrid.Columns.Add(new DFBrowseGridColumn("对比值"));
//detailGrid.Columns.Add(new DFBrowseGridColumn("包材领用"));
}
private void AddQueryResult(VLayoutPanel vPanel)
{
var btn = vPanel.Add(new DialogButton {
Text = "增加记录", Url = "AddSettingDialog.aspx"
}, new VLayoutOption(HorizontalAlign.Left));
btn.Click += delegate { StartQuery(); };
_mGrid = vPanel.Add(new DFBrowseGrid(new DFDataTableEditor())
{
Width = Unit.Percentage(100)
});
_mGrid.Columns.Add(new DFBrowseGridCustomExtColumn(delegate(DFDataRow row, HtmlTableCell cell, int rowIndex)
{
var delBtn = new LinkButton
{
Text = "x"
};
delBtn.Click += delegate
{
var id = (long?)_mGrid.CurrentData.Data.Rows[rowIndex]["ID"];
var dom = new DQDeleteDom(typeof(Goods_Accounting_Store));
dom.Where.Conditions.Add(DQExpression.EQ(DQExpression.Field("ID"), DQExpression.Value(id)));
using (var session = Dmo.NewSession())
{
session.ExecuteNonQuery(dom);
session.Commit();
}
StartQuery();
};
delBtn.OnClientClick = "return confirm('确定删除吗？')";
cell.Controls.Add(delBtn);
}));
_mGrid.Columns.Add(new DFBrowseGridAutoColumn());
}
void CreateQueryGridColumns(DFBrowseGrid grid)
{
grid.Columns.Add(new DFBrowseGridAutoColumn("DetailID", "AccountingUnit_ID", "Department_ID", "Employee_ID", "Store_ID", "InStoreType_ID", "CheckEmployee_ID", "InStoreDate", "CheckDate"));
}
protected virtual void TakeValuesCustomer(DFBrowseGrid grid)
{
grid.Columns.Add(new DFBrowseGridColumn("Customer_Name"));
}
protected virtual void AddCustomerDFBrowseGridColumn(DFBrowseGrid grid)
{
}
