private bool checkTwoDateTypeColumnRelationExist(TwoDateColumnRelationContainer <string> twoDateColumnRelationContainer)
        {
            bool exist = false;

            foreach (TwoDateColumnRelationContainer <string> relationContainer in relationContainerList)
            {
                if (relationContainer[0].Equals(twoDateColumnRelationContainer[0]) && relationContainer[1].Equals(twoDateColumnRelationContainer[1]))
                {
                    exist = true;
                }
            }
            return(exist);
        }
 public SetDateTypeParameterForm(TransmitData transmitData)
 {
     this.transmitData = transmitData;
     InitializeComponent();
     loadGlobalChineseCharacters       = LoadGlobalChineseCharacters.GetInstance();
     this.selectColumnList             = transmitData.selectedColumn;
     this.columnTypeDict               = transmitData.columnTypeDict;
     this.selectedColumnVariableDict   = transmitData.selectedColumnVariableDict;
     tmpTwoDateColumnRelationContainer = new TwoDateColumnRelationContainer <string>();
     //relationContainerList = new List<TwoDateColumnRelationContainer<string>>();
     excelHandle           = new ExcelHandle();
     relationContainerList = excelHandle.getExistRelationFormExistExcel();
     initUI();
 }
 private void addTwoDateTypeColumnRelation()
 {
     if (!checkTwoDateTypeColumnRelationExist(this.tmpTwoDateColumnRelationContainer))
     {
         addRelationForCheckedListBox();
         addThisTaskDateRelationCheckedListBox();
         TwoDateColumnRelationContainer <string> newTwoDateColumnRelationContainer = new TwoDateColumnRelationContainer <string>();
         newTwoDateColumnRelationContainer.Add(tmpTwoDateColumnRelationContainer[0]);
         newTwoDateColumnRelationContainer.Add(tmpTwoDateColumnRelationContainer[1]);
         relationContainerList.Add(newTwoDateColumnRelationContainer);
         addRelationExcelFile();
         setExcelDataToCurrentRelationContentDataGridView(tmpTwoDateColumnRelationContainer[0] + "-" + tmpTwoDateColumnRelationContainer[1] + ExcelHandle.excelExtensions[0]);
     }
     else
     {
         DialogResult dr1 = MessageBox.Show(loadGlobalChineseCharacters.GlobalChineseCharactersDict["exception10"], "exception");
     }
 }