public void SaveColumnWidth(Database database, SheetWidthDTO objWidth) { Database db = UseDatabase(database); StringBuilder sb = new StringBuilder(); #region SQL Statement string tableName = EVOFramework.Data.DTOUtility.ReadTableName(typeof(SheetWidthDTO)); sb.AppendLine(" INSERT INTO TZ_SCREEN_SHEET_WIDTH_MS (SCREEN_CD,SHEET_ID,COL_INDEX,COL_WIDTH)"); sb.AppendLine(" VALUES "); sb.AppendLine(" (@SCREEN_CD,@SHEET_ID,@COL_INDEX,@COL_WIDTH)"); #endregion DataRequest req = new DataRequest(sb.ToString()); #region Parameters req.Parameters.Add("@SCREEN_CD", DataType.VarChar, objWidth.SCREEN_CD.Value); req.Parameters.Add("@SHEET_ID", DataType.VarChar, objWidth.SHEET_ID.Value); req.Parameters.Add("@COL_INDEX", DataType.Int32, objWidth.COL_INDEX.Value); req.Parameters.Add("@COL_WIDTH", DataType.Decimal, objWidth.COL_WIDTH.Value); #endregion db.ExecuteNonQuery(req); }
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); } } } } }
public List <SheetWidthDTO> LoadColumnWidth(Database database, SheetWidthDTO objWidth) { Database db = UseDatabase(database); StringBuilder sb = new StringBuilder(); #region SQL Statement string tableName = EVOFramework.Data.DTOUtility.ReadTableName(typeof(SheetWidthDTO)); sb.AppendLine(" SELECT SCREEN_CD, COL_INDEX ,COL_WIDTH FROM TZ_SCREEN_SHEET_WIDTH_MS "); sb.AppendLine(" WHERE "); sb.AppendLine(" SCREEN_CD=@SCREEN_CD "); sb.AppendLine(" AND SHEET_ID=@SHEET_ID "); #endregion DataRequest req = new DataRequest(sb.ToString()); #region Parameters req.Parameters.Add("@SCREEN_CD", DataType.VarChar, objWidth.SCREEN_CD.Value); req.Parameters.Add("@SHEET_ID", DataType.VarChar, objWidth.SHEET_ID.Value); #endregion return(db.ExecuteForList <SheetWidthDTO>(req)); }
public void ClearColumnWidth(Database database, SheetWidthDTO objWidth) { Database db = UseDatabase(database); StringBuilder sb = new StringBuilder(); #region SQL Statement string tableName = EVOFramework.Data.DTOUtility.ReadTableName(typeof(SheetWidthDTO)); sb.AppendLine(" DELETE FROM TZ_SCREEN_SHEET_WIDTH_MS "); sb.AppendLine(" WHERE "); sb.AppendLine(" SCREEN_CD=@SCREEN_CD "); sb.AppendLine(" AND SHEET_ID=@SHEET_ID"); #endregion DataRequest req = new DataRequest(sb.ToString()); #region Parameters req.Parameters.Add("@SCREEN_CD", DataType.VarChar, objWidth.SCREEN_CD.Value); req.Parameters.Add("@SHEET_ID", DataType.VarChar, objWidth.SHEET_ID.Value); #endregion db.ExecuteNonQuery(req); }
public List <SheetWidthDTO> LoadColumnWidth(SheetWidthDTO objWidth) { SheetWidthDAO dao = new SheetWidthDAO(CommonLib.Common.CurrentDatabase); return(dao.LoadColumnWidth(null, objWidth)); }