private void btnRecycle_Click(object sender, EventArgs e) { OpenFileDialog diaFile = new OpenFileDialog(); diaFile.InitialDirectory = Path.GetDirectoryName(Application.ExecutablePath); diaFile.CheckFileExists = true; diaFile.Filter = "xlsx|*.xlsx"; diaFile.ShowDialog(); string strFilePath = diaFile.FileName; if (string.IsNullOrEmpty(strFilePath)) { return; } //读取蓝图数据 Classes.CEVEMarketFile.ExcelOreRecycle(strFilePath); //读取矿价 Classes.CEVEMarketAPI.SearchChart(); //查询用对象 List <Objects.SearchingItem> lstSeach = new List <Objects.SearchingItem>(); foreach (Objects.Ore Item in Classes.CEVEMarketFile.lstOre) { Objects.SearchingItem newSearch = new Objects.SearchingItem(); newSearch.Name = Item.Name; newSearch.Volume = Item.Volume; newSearch.BasePrice = Item.Tri * Classes.CEVEMarketAPI.baseChart.Tri + Item.Pye * Classes.CEVEMarketAPI.baseChart.Pye + Item.Mex * Classes.CEVEMarketAPI.baseChart.Mex + Item.Iso * Classes.CEVEMarketAPI.baseChart.Iso + Item.Noc * Classes.CEVEMarketAPI.baseChart.Noc + Item.Zyd * Classes.CEVEMarketAPI.baseChart.Zyd + Item.Meg * Classes.CEVEMarketAPI.baseChart.Meg; newSearch.BasePrice = (newSearch.BasePrice * 0.724) / Item.Volume; newSearch.Size = Item.Size; lstSeach.Add(newSearch); } //查询,设置,显示 Classes.CEVEMarketAPI.SearchPrice(lstSeach); frmOre frmResult = new frmOre(); frmResult.SearchResult = Classes.CEVEMarketAPI.lstResult; frmResult.Show(); }
private void btnP4_Click(object sender, EventArgs e) { OpenFileDialog diaFile = new OpenFileDialog(); diaFile.InitialDirectory = Path.GetDirectoryName(Application.ExecutablePath); diaFile.CheckFileExists = true; diaFile.Filter = "xlsx|*.xlsx"; diaFile.ShowDialog(); string strFilePath = diaFile.FileName; if (string.IsNullOrEmpty(strFilePath)) { return; } //读取蓝图数据 Classes.CEVEMarketFile.ExcelP4Break(strFilePath); //查询用对象 List <Objects.SearchingItem> lstSeach = new List <Objects.SearchingItem>(); List <string> lstSourceName = new List <string>(); foreach (Objects.T2Product Item in Classes.CEVEMarketFile.lstP4Break) { Objects.SearchingItem objSearch = new Objects.SearchingItem(); objSearch.Name = Item.Name; foreach (string strSourceName in Item.Items.Keys) { if (!lstSourceName.Contains(strSourceName)) { lstSourceName.Add(strSourceName); } } lstSeach.Add(objSearch); } foreach (string strName in lstSourceName) { lstSeach.Add(new Objects.SearchingItem() { Name = strName }); } //查询,设置,显示 Classes.CEVEMarketAPI.SearchPrice(lstSeach); foreach (Objects.T2Product Item in Classes.CEVEMarketFile.lstP4Break) { double dBasePrice = 0; Objects.SearchingResult T2Item = Classes.CEVEMarketAPI.lstResult.Find(X => X.Name == Item.Name); foreach (string strKeys in Item.Items.Keys) { //组件 Objects.SearchingResult result = Classes.CEVEMarketAPI.lstResult.Find(X => X.Name == strKeys); if (result != null) { //组件挂单价 dBasePrice += double.Parse(result.Buy1) * Item.Items[strKeys]; } } //平均成本 T2Item.BasePrice = dBasePrice / Item.Volume; } frmOre frmResult = new frmOre(); frmResult.SearchResult = Classes.CEVEMarketAPI.lstResult; frmResult.Show(); }