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