public ChangeInfo GetAllBrokerChangeInfo(Worksheet worksheet, int lastRowContainInfo) { ChangeInfo ChangedBrokerInfo = new ChangeInfo(); ChangedBrokerInfo.AllChangedBrokerList = new List <BrokerChangeInfo>(); for (int rowNum = 2; rowNum <= lastRowContainInfo; rowNum++) { BrokerChangeInfo brokerChangeInfo = new BrokerChangeInfo(); brokerChangeInfo.Name = ExcelUtil.GetRange(rowNum, 1, worksheet).Value2.ToString(); brokerChangeInfo.Ric = ExcelUtil.GetRange(rowNum, 2, worksheet).Value2.ToString(); brokerChangeInfo.Type = ExcelUtil.GetRange(rowNum, 3, worksheet).Value2.ToString(); brokerChangeInfo.Date = ExcelUtil.GetRange(rowNum, 4, worksheet).Value2.ToString(); ChangedBrokerInfo.AllChangedBrokerList.Add(brokerChangeInfo); } ChangedBrokerInfo.DifDayChangeInfo = ChangedBrokerInfo.GetDifDayChangeInfo(); //ChangedBrokerInfo.AllChangedBrokerList.Sort(); return(ChangedBrokerInfo); }
public List <SameDayChangeInfo> GetDifDayChangeInfo() { List <SameDayChangeInfo> sameDayChangeList = new List <SameDayChangeInfo>(); SameDayChangeInfo sameDayChangeInfo = null; string date = string.Empty; for (int i = 0; i < AllChangedBrokerList.Count; i++) { BrokerChangeInfo broker = AllChangedBrokerList[i]; if (broker.Date == date) { if (broker.Type.ToLower() == "new") { sameDayChangeInfo.NewBrokerList.Add(broker); } else if (broker.Type.ToLower() == "delete") { sameDayChangeInfo.DeleteBrokerList.Add(broker); } else if (broker.Type.ToLower() == "change") { sameDayChangeInfo.BordLotSizeChangeList.Add(broker); } else if (broker.Type.ToLower() == "name chg to") { sameDayChangeInfo.NameChangeToList.Add(broker); } } else { if (i != 0) { sameDayChangeList.Add(sameDayChangeInfo); sameDayChangeInfo.RicChangeToList = sameDayChangeInfo.GetChangeToList(); } sameDayChangeInfo = new SameDayChangeInfo(); sameDayChangeInfo.Date = broker.Date; date = broker.Date; sameDayChangeInfo.NewBrokerList = new List <BrokerChangeInfo>(); sameDayChangeInfo.DeleteBrokerList = new List <BrokerChangeInfo>(); sameDayChangeInfo.NameChangeToList = new List <BrokerChangeInfo>(); sameDayChangeInfo.RicChangeToList = new List <StockNameRicChange>(); sameDayChangeInfo.BordLotSizeChangeList = new List <BrokerChangeInfo>(); if (broker.Type.ToLower() == "new") { sameDayChangeInfo.NewBrokerList.Add(broker); } else if (broker.Type.ToLower() == "delete") { sameDayChangeInfo.DeleteBrokerList.Add(broker); } else if (broker.Type.ToLower() == "change") { sameDayChangeInfo.BordLotSizeChangeList.Add(broker); } else if (broker.Type.ToLower() == "name chg to") { sameDayChangeInfo.NameChangeToList.Add(broker); } } } sameDayChangeList.Add(sameDayChangeInfo); return(sameDayChangeList); }