/// <summary> /// 保存手写的数据,为了和新更新的数据比较 /// 点击更新时把旧表保存在IList中 /// </summary> /// <param name="BeginCol">要保存的起始行</param> /// <param name="BeginRow">要保存的起始列</param> /// <param name="indexX">二维数组的一维个数</param> /// <param name="indexY">二维数组的二维个数</param> public void SaveData(FarPoint.Win.Spread.SheetView obj, int IntRow, int IntCol, int indexX, int indexY) { list.Clear(); for (int i = IntRow; i < (obj.RowCount); i += 2)//行从第IntRow行开始保存 { SSheet11_2 SS11_2 = new SSheet11_2(); SS11_2.strDQ = null; SS11_2.strType = null; SS11_2.data = new object[indexX, indexY]; for (int j = IntCol; j < obj.ColumnCount; ++j)//列从第IntCol列开始保存 { SS11_2.strType = PF.ReturnStr(obj, i, 1).ToString(); SS11_2.strDQ = PF.ReturnStr(obj, i, 2).ToString(); SS11_2.data[0, j - IntCol] = obj.Cells[i, j].Value; SS11_2.data[1, j - IntCol] = obj.Cells[i + 1, j].Value; } list.Add(SS11_2); } }
/// <summary> /// 保存手写的数据,为了和新更新的数据比较 /// 点击更新时把旧表保存在IList中 /// </summary> /// <param name="BeginCol">要保存的起始行</param> /// <param name="BeginRow">要保存的起始列</param> /// <param name="indexX">二维数组的一维个数</param> /// <param name="indexY">二维数组的二维个数</param> public void SaveData(FarPoint.Win.Spread.SheetView obj, int IntRow, int IntCol,int indexX,int indexY) { list.Clear(); for (int i = IntRow; i < (obj.RowCount); i += 2)//行从第IntRow行开始保存 { SSheet11_2 SS11_2 = new SSheet11_2(); SS11_2.strDQ = null; SS11_2.strType = null; SS11_2.data = new object[indexX, indexY]; for (int j = IntCol; j < obj.ColumnCount; ++j)//列从第IntCol列开始保存 { SS11_2.strType = PF.ReturnStr(obj, i,1).ToString(); SS11_2.strDQ = PF.ReturnStr(obj, i, 2).ToString(); SS11_2.data[0, j - IntCol] = obj.Cells[i, j].Value; SS11_2.data[1, j - IntCol] = obj.Cells[i + 1, j].Value; } list.Add(SS11_2); } }