private void buttonImport_Click(object sender, EventArgs e)
{
this.standardImportForm = new StandardImportForm <ShipmentTicketItem>(
ShipmentTicketItemViewMetaData.KeyNames,
importItemHandler,
null,
"导入发货单条目"
);
this.standardImportForm.AddButton("置入套餐", Properties.Resources.check, this.buttonAddCategoryClickedCallback);
//搜索默认值，首先精确匹配，没有再模糊匹配
standardImportForm.AddDefaultValue("Unit", string.Format("SELECT DefaultShipmentUnit FROM Supply WHERE [No] = @SupplyNoOrComponentName AND ProjectID = {0} AND WarehouseID = {1} AND IsHistory=0;", this.projectID, this.warehouseID));
standardImportForm.AddDefaultValue("UnitAmount", string.Format("SELECT DefaultShipmentUnitAmount FROM Supply WHERE [No] = @SupplyNoOrComponentName AND ProjectID = {0} AND WarehouseID = {1} AND IsHistory=0;", this.projectID, this.warehouseID));
standardImportForm.AddDefaultValue("Unit", string.Format("SELECT DefaultShipmentUnit FROM SupplyView WHERE ComponentName = @SupplyNoOrComponentName AND ProjectID = {0} AND WarehouseID = {1} AND IsHistory=0;", this.projectID, this.warehouseID));
standardImportForm.AddDefaultValue("UnitAmount", string.Format("SELECT DefaultShipmentUnitAmount FROM SupplyView WHERE ComponentName = @SupplyNoOrComponentName AND ProjectID = {0} AND WarehouseID = {1} AND IsHistory=0;", this.projectID, this.warehouseID));
standardImportForm.AddDefaultValue("Unit", string.Format("SELECT TOP 2 DefaultShipmentUnit FROM Supply WHERE [No] LIKE '%'+@SupplyNoOrComponentName+'%' AND ProjectID = {0} AND WarehouseID = {1} AND IsHistory=0;", this.projectID, this.warehouseID));
standardImportForm.AddDefaultValue("UnitAmount", string.Format("SELECT TOP 2 DefaultShipmentUnitAmount FROM Supply WHERE [No] LIKE '%'+@SupplyNoOrComponentName+'%' AND ProjectID = {0} AND WarehouseID = {1} AND IsHistory=0;", this.projectID, this.warehouseID));
standardImportForm.AddDefaultValue("Unit", string.Format("SELECT TOP 2 DefaultShipmentUnit FROM SupplyView WHERE ComponentName LIKE '%'+@SupplyNoOrComponentName+'%' AND ProjectID = {0} AND WarehouseID = {1} AND IsHistory=0;", this.projectID, this.warehouseID));
standardImportForm.AddDefaultValue("UnitAmount", string.Format("SELECT TOP 2 DefaultShipmentUnitAmount FROM SupplyView WHERE ComponentName LIKE '%'+@SupplyNoOrComponentName+'%' AND ProjectID = {0} AND WarehouseID = {1} AND IsHistory=0;", this.projectID, this.warehouseID));
standardImportForm.AddAssociation("SupplyNoOrComponentName", string.Format("SELECT No,SupplierName FROM SupplyView WHERE ProjectID={0} AND WarehouseID = {1} AND IsHistory=0 AND No LIKE '%'+@value+'%'; ", this.projectID, this.warehouseID));
standardImportForm.AddAssociation("SupplyNoOrComponentName", string.Format("SELECT DISTINCT ComponentName FROM SupplyView WHERE ProjectID={0} AND WarehouseID = {1} AND IsHistory=0 AND ComponentName LIKE '%'+@value+'%'; ", this.projectID, this.warehouseID));
standardImportForm.AddAssociation("JobPersonName", string.Format("SELECT Name FROM Person WHERE Name LIKE '%'+@value+'%'"));
standardImportForm.AddAssociation("ConfirmPersonName", string.Format("SELECT Name FROM Person WHERE Name LIKE '%'+@value+'%'"));
//standardImportForm.AddDefaultValue("ShipmentAmount", "SELECT CASE WHEN @focus = 'ShipmentAmount' THEN NULL WHEN LEN(@UnitAmount)>0 AND LEN(@Unit)>0 THEN CAST(@UnitAmount AS DECIMAL(18,3))*CAST(@Unit AS DECIMAL(18,3)) ELSE NULL END", true, true);
//standardImportForm.AddDefaultValue("Unit", "SELECT CASE WHEN @focus = 'Unit' THEN NULL WHEN LEN(@ShipmentAmount)>0 AND LEN(@UnitAmount)>0 THEN CAST(@ShipmentAmount AS DECIMAL(18,3))/CAST(@UnitAmount AS DECIMAL(18,3)) ELSE NULL END", true, true);
standardImportForm.Show();
}
private void buttonImport_Click(object sender, EventArgs e)
{
//创建导入窗口
StandardImportForm <DataAccess.Component> formImport =
new StandardImportForm <DataAccess.Component>
(
//参数1：KeyName
ComponenViewMetaData.componenkeyNames,
(results, unimportedColumns) => //参数2：导入数据二次处理回调函数
{
for (int i = 0; i < results.Count; i++)
{
string componentnameimport;
componentnameimport = results[i].Name;
//检查导入列表中是否重名
for (int j = i + 1; j < results.Count; j++)
{
if (componentnameimport == results[j].Name)
{
MessageBox.Show("您输入的零件名" + componentnameimport + "在导入列表中重复", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return(false);
}
}
//检查数据库中同名
try
{
var sameNameUsers = (from u in wmsEntities.Component
where u.Name == componentnameimport
select u).ToArray();
if (sameNameUsers.Length > 0)
{
MessageBox.Show("导入零件失败，已存在同名零件：" + componentnameimport, "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return(false);
}
}
catch
{
MessageBox.Show("操作失败，请检查网络连接", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
return(false);
}
}
return(true);
},
() => //参数3：导入完成回调函数
{
this.searchWidget.Search();
}
);
//显示导入窗口
formImport.Text = "导入零件信息";
formImport.Show();
}
private void buttonImport_Click(object sender, EventArgs e)
{
StandardImportForm <StockInfo> formImport = new StandardImportForm <StockInfo>(
StockInfoViewMetaData.KeyNames,
importHandler,
() =>
{
this.searchWidget.Search();
},
"导入库存信息");
formImport.Show();
}
private void buttonReturnSupply_Click(object sender, EventArgs e)
{
if (MessageBox.Show("※重要提示：\n\n批量退件只能将退件作为新的库存批次入库\n此操作会使零件的有效期从本次退回入库日期开始重新计算\n若要退回到原批次中，请在出库单的零件条目中填写退回数\n\n确定使用此功能吗？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) != DialogResult.Yes)
{
return;
}
formImport = new StandardImportForm <ReturnSupply>(returnKeyNames, this.importHandler, null, "批量退件");
formImport.AddDefaultValue("ReturnQualityAmount", "SELECT 0");
formImport.AddDefaultValue("ReturnQualityUnit", "SELECT '个'");
formImport.AddDefaultValue("ReturnQualityUnitAmount", "SELECT 1");
formImport.AddDefaultValue("ReturnRejectAmount", "SELECT 0");
formImport.AddDefaultValue("ReturnRejectUnit", "SELECT '个'");
formImport.AddDefaultValue("ReturnRejectUnitAmount", "SELECT 1");
formImport.AddAssociation("SupplyNo", string.Format("SELECT No,SupplierName FROM SupplyView WHERE ProjectID={0} AND WarehouseID = {1} AND IsHistory=0 AND No LIKE '%'+@value+'%'; ", this.projectID, this.warehouseID));
formImport.Show();
}
