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); } } } } }