/// <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)
{
SaveList.Clear();
for (int i = IntRow; i < (obj.RowCount); i += 10)//行从第IntRow行开始保存
{
SSheet_1 SS_1 = new SSheet_1();
SS_1.strType = null;
SS_1.strDQ = null;
SS_1.data = new object[indexX, indexY];
for (int j = IntCol; j < obj.ColumnCount; ++j)//列从第IntCol列开始保存
{
SS_1.strType = PF.ReturnStr(obj, i, 0).ToString();
SS_1.strDQ = PF.ReturnStr(obj, i, 1).ToString();
SS_1.data[0, j - IntCol] = obj.Cells[i, j].Value;
SS_1.data[1, j - IntCol] = obj.Cells[i + 1, j].Value;
SS_1.data[2, j - IntCol] = obj.Cells[i + 2, j].Value;
SS_1.data[3, j - IntCol] = obj.Cells[i + 3, j].Value;
SS_1.data[4, j - IntCol] = obj.Cells[i + 4, j].Value;
SS_1.data[5, j - IntCol] = obj.Cells[i + 5, j].Value;
SS_1.data[6, j - IntCol] = obj.Cells[i + 6, j].Value;
SS_1.data[7, j - IntCol] = obj.Cells[i + 7, j].Value;
SS_1.data[8, j - IntCol] = obj.Cells[i + 8, j].Value;
SS_1.data[9, j - IntCol] = obj.Cells[i + 9, j].Value;
}
SaveList.Add(SS_1);
}
}
/// <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)
{
SaveList.Clear();
for (int i = IntRow; i < (obj.RowCount); i += 1)//行从第IntRow行开始保存
{
SSheet_1 SS_1 = new SSheet_1();
SS_1.strID = null;
SS_1.strProject = null;
SS_1.data = new object[indexX, indexY];
for (int j = IntCol; j < obj.ColumnCount; ++j)//列从第IntCol列开始保存
{
SS_1.strID = PF.ReturnStr(obj, i, 0).ToString();
SS_1.strProject = PF.ReturnStr(obj, i, 1).ToString();
SS_1.data[0, j - IntCol] = obj.Cells[i, j].Value;
}
SaveList.Add(SS_1);
}
}
/// <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)
{
SaveList.Clear();
for (int i = IntRow; i < (obj.RowCount); i++)//行从第IntRow行开始保存
{
SSheet_1 SS_1 = new SSheet_1();
SS_1.strTitle = null;
SS_1.strVC = null;
SS_1.data = new object[indexX, indexY];
for (int j = IntCol; j < obj.ColumnCount; ++j)//列从第IntCol列开始保存
{
SS_1.strTitle = PF.ReturnStr(obj, i, 0).ToString();
SS_1.strVC = PF.ReturnStr(obj, i, 1).ToString();
SS_1.data[0, j - IntCol] = obj.Cells[i, j].Value;
}
SaveList.Add(SS_1);
}
}
