public static void SetDateFormat(FarPoint.Win.Spread.Column col)
{
string strDateFormat = Common.CurrentUserInfomation.DateFormatString;
FarPoint.Win.Spread.CellType.DateTimeCellType type = new FarPoint.Win.Spread.CellType.DateTimeCellType();
type.DateTimeFormat = FarPoint.Win.Spread.CellType.DateTimeFormat.UserDefined;
type.UserDefinedFormat = strDateFormat;
col.CellType = type;
//type.user define FormatException
}
public static void SetNumberFormat(FarPoint.Win.Spread.Column col, eNumberFormat format)
{
FarPoint.Win.Spread.CellType.NumberCellType type = new FarPoint.Win.Spread.CellType.NumberCellType();
type.ButtonAlign = FarPoint.Win.ButtonAlign.Right;
col.HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Right;
switch (format)
{
case eNumberFormat.Amount:
type.DecimalPlaces = 2;
type.DecimalSeparator = ".";
type.Separator = ",";
type.ShowSeparator = true;
type.MaximumValue = (Math.Pow(10, 10 /*จำนวนหลัก*/) - 1);
break;
case eNumberFormat.Amount_THB:
type.DecimalPlaces = 2;
type.DecimalSeparator = ".";
type.Separator = ",";
type.ShowSeparator = true;
type.MaximumValue = (Math.Pow(10, 10 /*จำนวนหลัก*/) - 1);
break;
case eNumberFormat.Qty_KG:
type.DecimalPlaces = 2;
type.DecimalSeparator = ".";
type.Separator = ",";
type.ShowSeparator = true;
type.MinimumValue = 0;
type.MaximumValue = (Math.Pow(10, 5 /*จำนวนหลัก*/) - 1);
break;
case eNumberFormat.Qty_Adjust_KG:
type.DecimalPlaces = 2;
type.DecimalSeparator = ".";
type.Separator = ",";
type.ShowSeparator = true;
type.MinimumValue = 0;
type.MaximumValue = (Math.Pow(10, 5 /*จำนวนหลัก*/) - 1);
break;
case eNumberFormat.Qty_Gram:
type.DecimalPlaces = 4;
type.DecimalSeparator = ".";
type.Separator = ",";
type.ShowSeparator = true;
type.MinimumValue = 0;
type.MaximumValue = (Math.Pow(10, 4 /*จำนวนหลัก*/) - 1);
break;
case eNumberFormat.Qty_PCS:
type.DecimalPlaces = 0;
type.DecimalSeparator = ".";
type.Separator = ",";
type.ShowSeparator = true;
type.MinimumValue = 0;
type.MaximumValue = (Math.Pow(10, 9 /*จำนวนหลัก*/) - 1);
break;
case eNumberFormat.Qty_Adjust_PCS:
type.DecimalPlaces = 0;
type.DecimalSeparator = ".";
type.Separator = ",";
type.ShowSeparator = true;
type.MinimumValue = 0;
type.MaximumValue = (Math.Pow(10, 12 /*จำนวนหลัก*/) - 1);
break;
case eNumberFormat.UnitPrice:
type.DecimalPlaces = 4;
type.DecimalSeparator = ".";
type.Separator = ",";
type.ShowSeparator = true;
type.MaximumValue = (Math.Pow(10, 5 /*จำนวนหลัก*/) - 1);
break;
case eNumberFormat.ExchangeRate:
type.DecimalPlaces = 4;
type.DecimalSeparator = ".";
type.Separator = ",";
type.ShowSeparator = true;
type.MaximumValue = (Math.Pow(10, 4 /*จำนวนหลัก*/) - 1);
break;
case eNumberFormat.MasterNo:
type.DecimalPlaces = 0;
type.DecimalSeparator = ".";
type.Separator = "";
type.ShowSeparator = false;
type.MaximumValue = (Math.Pow(10, 10 /*จำนวนหลัก*/) - 1);
break;
case eNumberFormat.Total_Qty_PCS:
type.DecimalPlaces = 0;
type.DecimalSeparator = ".";
type.Separator = ",";
type.ShowSeparator = true;
type.MinimumValue = 0;
type.MaximumValue = (Math.Pow(10, 8 /*จำนวนหลัก*/) - 1);
break;
case eNumberFormat.Qty_Box:
type.DecimalPlaces = 0;
type.DecimalSeparator = ".";
type.Separator = ",";
type.ShowSeparator = true;
type.MinimumValue = 0;
type.MaximumValue = (Math.Pow(10, 4 /*จำนวนหลัก*/) - 1);
break;
case eNumberFormat.TagNo:
type.DecimalPlaces = 0;
type.DecimalSeparator = ".";
type.Separator = ",";
type.ShowSeparator = false;
type.MinimumValue = 0;
type.MaximumValue = (Math.Pow(10, 5 /*จำนวนหลัก*/) - 1);
break;
default: break;
}
col.CellType = type;
}
