コード例 #1
0
        public static bool ExcelCompare(ExcelRowEntry Expected, ExcelRowEntry Actual)
        {
            if (Actual.Dtp.Value.ToShortDateString().Equals(Expected.Dtp.Value.ToShortDateString()) 
                && Actual.EntData[0].Equals(Expected.EntData[0]) && Actual.EntData[1].Equals(Expected.EntData[1])
                && Actual.EntData[2].Equals(Expected.EntData[2]) && Actual.EntData[3].Equals(Expected.EntData[3])
                && Actual.EntData[4].Equals(Expected.EntData[4]) && Actual.EntData[5].Equals(Expected.EntData[5]))
            {
                return true;
            }

            else
            {
                return false;
            }
        
        }
コード例 #2
0
        private void PlaceUpdate(ExcelRowEntry excelEntryRow, ref Excel.Worksheet workSheet, int rowNumber)
        {
            ExcelRowEntry tempRowEntry = new ExcelRowEntry();

            while ((workSheet.get_Range(ExcelColumns.PROJECT + rowNumber).Value) != null)//allows insertion of updates before today
            {
                tempRowEntry.ExcelRetrieve(workSheet, rowNumber);
                excelEntryRow.ExcelSheetUpdater(ref workSheet, rowNumber);
                tempRowEntry.PutDataInto(ref excelEntryRow);
                rowNumber++;
            }
            excelEntryRow.ExcelSheetUpdater(ref workSheet, rowNumber);
        }
コード例 #3
0
 public void PutDataInto(ref ExcelRowEntry e)
 {
     e.CopyValue(Dtp, EntData, Bh, Ubh, ProjectType, HaveWork, ShiftTimings, UserStory, UpdatedTime, SubSystem);
 }