public void SaveSheetWidth(FarPoint.Win.Spread.SheetView shtSaveWidth, string ScreenCode)
{
List <SheetWidthDTO> listSize = new List <SheetWidthDTO>();
SheetWidthDTO objSize = null;
//Header
objSize = new SheetWidthDTO();
objSize.COL_INDEX = (-1).ToNZInt();
objSize.COL_WIDTH = shtSaveWidth.RowHeader.Columns[0].Width.ToNZDecimal();
objSize.SCREEN_CD = ScreenCode.ToNZString();
objSize.SHEET_ID = shtSaveWidth.SheetName.ToNZString();
listSize.Add(objSize);
for (int i = 0; i < shtSaveWidth.Columns.Count; i++)
{
objSize = new SheetWidthDTO();
objSize.COL_INDEX = i.ToNZInt();
objSize.COL_WIDTH = shtSaveWidth.Columns[i].Width.ToNZDecimal();
objSize.SCREEN_CD = ScreenCode.ToNZString();
objSize.SHEET_ID = shtSaveWidth.SheetName.ToNZString();
listSize.Add(objSize);
}
SheetWidthBIZ biz = new SheetWidthBIZ();
biz.SaveColumnWidth(listSize);
}
public void SetSheetWidth(FarPoint.Win.Spread.SheetView shtSetWidth, string ScreenCode)
{
SheetWidthBIZ biz = new SheetWidthBIZ();
SheetWidthDTO objSize = new SheetWidthDTO();
objSize.SCREEN_CD = ScreenCode.ToNZString();
objSize.SHEET_ID = shtSetWidth.SheetName.ToNZString();
List <SheetWidthDTO> listColumnWidth = biz.LoadColumnWidth(objSize);
if (listColumnWidth != null)
{
for (int i = 0; i < listColumnWidth.Count; i++)
{
if (i < shtSetWidth.Columns.Count)
{
int index = (int)listColumnWidth[i].COL_INDEX.NVL(0);
if (index < 0)
{
shtSetWidth.RowHeader.Columns[0].Width = (float)listColumnWidth[i].COL_WIDTH.NVL(25);
}
else
{
//shtSetWidth.Columns[i].Width = (float)listColumnWidth[i].COL_WIDTH.NVL(25);
shtSetWidth.Columns[index].Width = (float)listColumnWidth[i].COL_WIDTH.NVL(25);
}
}
}
}
}
