private void InitializeSpread()
{
shtView.ActiveSkin = Common.ACTIVE_SKIN;
LookupDataBIZ biz = new LookupDataBIZ();
NZString[] classInfos =
{
(NZString)DataDefine.Convert2ClassCode(DataDefine.eTRANS_TYPE.Receiving),
(NZString)DataDefine.Convert2ClassCode(DataDefine.eTRANS_TYPE.Receive_Return)
};
LookupData receiveTypeLookupData = biz.LoadLookupClassType(DataDefine.TRANS_TYPE.ToNZString(), classInfos);
shtView.Columns[(int)eColView.TRANS_CLS].CellType = CtrlUtil.CreateReadOnlyPairCellType(receiveTypeLookupData);
LookupData locationLookupData = biz.LoadLookupLocation();
shtView.Columns[(int)eColView.LOC_CD].CellType = CtrlUtil.CreateReadOnlyPairCellType(locationLookupData);
shtView.Columns[(int)eColView.DEALING_NO].CellType = CtrlUtil.CreateReadOnlyPairCellType(locationLookupData);
LookupData umClassLookupData = biz.LoadLookupClassType(DataDefine.UM_CLS.ToNZString());
shtView.Columns[(int)eColView.ORDER_UM_CLS].CellType = CtrlUtil.CreateReadOnlyPairCellType(umClassLookupData);
shtView.Columns[(int)eColView.INV_UM_CLS].CellType = CtrlUtil.CreateReadOnlyPairCellType(umClassLookupData);
LookupData refTypeLookupData = biz.LoadLookupClassType(DataDefine.REF_SLIP_CLS.ToNZString());
shtView.Columns[(int)eColView.REF_SLIP_CLS].CellType = CtrlUtil.CreateReadOnlyPairCellType(refTypeLookupData);
shtView.Columns[(int)eColView.TRANS_DATE].CellType = CtrlUtil.CreateDateTimeCellType();
CtrlUtil.MappingDataFieldWithEnum(shtView, typeof(eColView));
}
private void InitializeSpread()
{
shtPackingList.ActiveSkin = Common.ACTIVE_SKIN;
#region Initial Cell Type
LookupDataBIZ biz = new LookupDataBIZ();
LookupData shiftCls = biz.LoadLookupClassType(DataDefine.SHIFT_CLS.ToNZString());
shtPackingList.Columns[(int)eColView.SHIFT_CLS].CellType = CtrlUtil.CreateReadOnlyPairCellType(shiftCls);
LookupData PersonInCharge = biz.LoadPersonInCharge();
shtPackingList.Columns[(int)eColView.PERSON_IN_CHARGE].CellType = CtrlUtil.CreateReadOnlyPairCellType(PersonInCharge);
shtPackingList.Columns[(int)eColView.TRANS_DATE].CellType = CtrlUtil.CreateDateTimeCellType();
#endregion
#region Initial export column
shtPackingList.Columns[(int)eColView.TRANS_ID].StyleName = DataDefine.EXPORT_LAST.ToString();
shtPackingList.Columns[(int)eColView.GROUP_TRANS_ID].StyleName = DataDefine.EXPORT_LAST.ToString();
shtPackingList.Columns[(int)eColView.TRANS_ID].Visible = false;
shtPackingList.Columns[(int)eColView.GROUP_TRANS_ID].Visible = false;
shtPackingList.Columns[(int)eColView.SHIFT_CLS_NAME].Visible = false;
shtPackingList.Columns[(int)eColView.PERSON_IN_CHARGE_NAME].Visible = false;
#endregion
CtrlUtil.MappingDataFieldWithEnum(shtPackingList, typeof(eColView));
}
private void PUR020_PurchaseOrderEntry_Load(object sender, EventArgs e)
{
dtmPODate.Format = Common.CurrentUserInfomation.DateFormatString;
shtView.Columns[(int)eColumn.DUE_DATE].CellType = CtrlUtil.CreateDateTimeCellType();
this.SetDefault(m_HDTOPurchaseOrder);
m_bIsActived = true;
}
private void ShowColumnName()
{
shtQueryList.RowCount = 0;
for (int i = 0; i < m_SheetViewData.ColumnCount; i++)
{
if (m_SheetViewData.Columns[i].Visible == true)
{
int iRowCount = shtQueryList.RowCount++;
shtQueryList.Cells[iRowCount, (int)eCol.ColumnName].Text = m_SheetViewData.ColumnHeader.Cells[0, i].Text;
shtQueryList.Cells[iRowCount, (int)eCol.ColumnIndex].Text = i.ToString();
ICellType cellType = m_SheetViewData.GetCellType(0, i);
if (cellType is NumberCellType)
{
shtQueryList.Cells[iRowCount, (int)eCol.ColumnType].Value = eColumnType.Number;
shtQueryList.Cells[iRowCount, (int)eCol.Sign].Value = eSign.Between.ToString();
shtQueryList.Cells[iRowCount, (int)eCol.Value1].CellType = CtrlUtil.CreateNumberCellType();
shtQueryList.Cells[iRowCount, (int)eCol.Value2].CellType = CtrlUtil.CreateNumberCellType();
}
else if (cellType is DateTimeCellType)
{
shtQueryList.Cells[iRowCount, (int)eCol.ColumnType].Value = eColumnType.DateTime;
shtQueryList.Cells[iRowCount, (int)eCol.Sign].Value = eSign.Between.ToString();
shtQueryList.Cells[iRowCount, (int)eCol.Value1].CellType = CtrlUtil.CreateDateTimeCellType();
shtQueryList.Cells[iRowCount, (int)eCol.Value2].CellType = CtrlUtil.CreateDateTimeCellType();
}
//else
//{
// shtQueryList.Cells[iRowCount, (int)eCol.ColumnType].Value = eColumnType.String;
// shtQueryList.Cells[iRowCount, (int)eCol.Sign].Value = eSign.Like.ToString();
// shtQueryList.Cells[iRowCount, (int)eCol.Value1].CellType = CtrlUtil.CreateTextCellType();
// shtQueryList.Cells[iRowCount, (int)eCol.Value2].Locked = true;
// shtQueryList.Cells[iRowCount, (int)eCol.Value2].BackColor = Color.LightGray;
//}
else if (m_SheetViewData.ColumnHeader.Cells[0, i].Text != DataDefine.MASTER_NO_FIELD_NAME)
{
shtQueryList.Cells[iRowCount, (int)eCol.ColumnType].Value = eColumnType.String;
shtQueryList.Cells[iRowCount, (int)eCol.Sign].Value = eSign.Like.ToString();
shtQueryList.Cells[iRowCount, (int)eCol.Value1].CellType = CtrlUtil.CreateTextCellType();
shtQueryList.Cells[iRowCount, (int)eCol.Value2].Locked = true;
shtQueryList.Cells[iRowCount, (int)eCol.Value2].BackColor = Color.LightGray;
}
// Add by Pongthorn S. @ 2012-05-18
if (m_SheetViewData.ColumnHeader.Cells[0, i].Text == DataDefine.MASTER_NO_FIELD_NAME)
{
shtQueryList.Cells[iRowCount, (int)eCol.ColumnType].Value = eColumnType.String;
shtQueryList.Cells[iRowCount, (int)eCol.Sign].Value = eSign.Between.ToString();
shtQueryList.Cells[iRowCount, (int)eCol.Value1].CellType = CtrlUtil.CreateTextCellType();
shtQueryList.Cells[iRowCount, (int)eCol.Value2].CellType = CtrlUtil.CreateTextCellType();
}
}
}
}
private void InitailSpread()
{
shtView.ActiveSkin = Common.ACTIVE_SKIN;
string[] names = Enum.GetNames(typeof(eColView));
for (int i = 0; i < names.Length; i++)
{
shtView.Columns[i].DataField = names[i];
CtrlUtil.SpreadSetColumnsLocked(shtView, true, i);
}
shtView.Columns[(int)eColView.ISSUE_DATE].CellType = CtrlUtil.CreateDateTimeCellType();
}
private void InitialSpread()
{
shtView.ActiveSkin = Common.ACTIVE_SKIN;
LookupDataBIZ biz = new LookupDataBIZ();
LookupData shiftLookupData = biz.LoadLookupClassType(DataDefine.SHIFT_CLS.ToNZString());
shtView.Columns[(int)eColumns.SHIFT_CLS].CellType = CtrlUtil.CreateReadOnlyPairCellType(shiftLookupData);
LookupData workresultLookupData = biz.LoadLookupClassType(DataDefine.TRAN_SUB_CLS.ToNZString());
shtView.Columns[(int)eColumns.TRAN_SUB_CLS].CellType = CtrlUtil.CreateReadOnlyPairCellType(workresultLookupData);
shtView.Columns[(int)eColumns.TRANS_DATE].CellType = CtrlUtil.CreateDateTimeCellType();
}
private void ExportCost()
{
try
{
InventoryOnhandController ctlInvent = new InventoryOnhandController();
if (shtView.Rows.Count == 0)
{
return;
}
int row = shtView.Rows.Count;
//int rowfilter= shtView.RowFilter.SheetView.Rows.Count;
List <string> ItemCodes = new List <string>();
for (int i = 0; i < row; i++)
{
if (shtView.Cells[i, (int)eColView.ITEM_CODE].Value != null)
{
if (!ItemCodes.Contains(shtView.Cells[i, (int)eColView.ITEM_CODE].Value.ToString()))
{
ItemCodes.Add(shtView.Cells[i, (int)eColView.ITEM_CODE].Value.ToString());
}
}
}
DataTable dtCostView = ctlInvent.GetCostView(ItemCodes);
if (dtCostView == null)
{
return;
}
FarPoint.Win.Spread.FpSpread fpCost = new FarPoint.Win.Spread.FpSpread();
FarPoint.Win.Spread.SheetView shtCost = new FarPoint.Win.Spread.SheetView();
shtCost.DataSource = dtCostView;
shtCost.Columns[0].CellType = CtrlUtil.CreateDateTimeCellType();
fpCost.Sheets.Add(shtCost);
ExportDialog frmExport = new ExportDialog(fpCost);
frmExport.DefaultExcel_Filename = Environment.CurrentDirectory + "\\Cost View.xls";
//frmExport.de
frmExport.ShowDialog(this);
}
catch (Exception ex)
{
MessageDialog.ShowBusiness(this, ex.Message);
}
}
private void InitializeSpread()
{
shtView.ActiveSkin = Common.ACTIVE_SKIN;
shtView.Columns[(int)eColView.TRANS_DATE].CellType = CtrlUtil.CreateDateTimeCellType(Common.CurrentUserInfomation.DateFormatString);
shtView.Columns[(int)eColView.TRANS_ID].StyleName = DataDefine.EXPORT_LAST.ToString();
shtView.Columns[(int)eColView.TRANS_ID].Visible = false;
shtView.Columns[(int)eColView.IN_OUT_CLS_NAME].Visible = false;
shtView.Columns[(int)eColView.LOC_DESC].Visible = false;
shtView.Columns[(int)eColView.TRAN_SUB_CLS_NAME].Visible = false;
shtView.Columns[(int)eColView.PACK_NO].Visible = false;
shtView.Columns[(int)eColView.FG_NO].Visible = false;
shtView.Columns[(int)eColView.LOT_NO].Visible = false;
CtrlUtil.MappingDataFieldWithEnum(shtView, typeof(eColView));
}
private void InitializeScreen()
{
shtView.ActiveSkin = Common.ACTIVE_SKIN;
// Mapping DataField.
CtrlUtil.MappingDataFieldWithEnum(shtView, typeof(eColView));
txtItem.KeyPress += CtrlUtil.SetNextControl;
txtLocation.KeyPress += CtrlUtil.SetNextControl;
txtLotNo.KeyPress += CtrlUtil.SetNextControl;
txtInvPeriod.KeyPress += CtrlUtil.SetNextControl;
txtOnHandQty.KeyPress += CtrlUtil.SetNextControl;
cboItemType.KeyPress += CtrlUtil.SetNextControl;
// Set default Column Cell Type.
LookupDataBIZ bizLookupData = new LookupDataBIZ();
LookupData transTypelookupData = bizLookupData.LoadLookupClassType(DataDefine.TRANS_TYPE.ToNZString());
LookupData refClassTypelookupData = bizLookupData.LoadLookupClassType(DataDefine.REF_SLIP_CLS.ToNZString());
shtView.Columns[(int)eColView.TRANS_INFO].CellType = CtrlUtil.CreateReadOnlyPairCellType(transTypelookupData);
shtView.Columns[(int)eColView.REF_TYPE].CellType = CtrlUtil.CreateReadOnlyPairCellType(refClassTypelookupData);
shtView.Columns[(int)eColView.TRANS_DATE].CellType = CtrlUtil.CreateDateTimeCellType(Common.CurrentUserInfomation.DateFormatString);
cboItemType.Format += Common.ComboBox_Format;
LookupData itemTypelookupData = bizLookupData.LoadLookupClassType(DataDefine.ITEM_CLS.ToNZString());
cboItemType.LoadLookupData(itemTypelookupData);
// Enable/Disable Controls
CtrlUtil.EnabledControl(false, txtItem, txtLocation, txtLotNo, txtInvPeriod, txtOnHandQty, txtUnitMeasure, txtPackNo);
CtrlUtil.EnabledControl(true, fpView);
// Load data.
txtItem.Text = ItemCode.NVL(string.Empty);
txtLocation.Text = WareHouseCode.NVL(string.Empty);
txtLotNo.Text = LotNo.NVL(string.Empty);
txtInvPeriod.Text = String.Format("{0} - {1}",
CtrlUtil.ConvertDateTimeToCurrentFormat(PeriodBeginDate),
CtrlUtil.ConvertDateTimeToCurrentFormat(PeriodEndDate));
CtrlUtil.EnabledControl(false, cboItemType);
LoadData();
}
private void PUR010_Load(object sender, EventArgs e)
{
InventoryPeriodBIZ biz = new InventoryPeriodBIZ();
InventoryPeriodDTO dto = biz.LoadCurrentPeriodWithQueryRange();
dtPeriodBegin.NZValue = dto.PERIOD_BEGIN_DATE;
dtPeriodEnd.NZValue = dto.PERIOD_END_DATE;
dtPeriodBegin.Format = Common.CurrentUserInfomation.DateFormatString;
dtPeriodEnd.Format = Common.CurrentUserInfomation.DateFormatString;
shtView.Columns[(int)eColumn.DUE_DATE].CellType = CtrlUtil.CreateDateTimeCellType();
shtView.Columns[(int)eColumn.PO_DATE].CellType = CtrlUtil.CreateDateTimeCellType();
this.m_dtShown = m_BizPurchaseOrder.LoadPurchaseOrderDByPONo(Convert.ToDateTime(dtPeriodBegin.Value), Convert.ToDateTime(dtPeriodEnd.Value));
ShowSheet(this.m_dtShown);
SetSpreadBGColor();
SetContextMenu();
}
private void InitializeSpread()
{
shtMovePartList.ActiveSkin = Common.ACTIVE_SKIN;
LookupDataBIZ biz = new LookupDataBIZ();
NZString[] locationtype = new NZString[1];
locationtype[0] = DataDefine.Convert2ClassCode(DataDefine.eLOCATION_CLS.Production).ToNZString();
LookupData fromProcess = biz.LoadLookupLocation(locationtype);
shtMovePartList.Columns[(int)eColView.FROM_PROCESS].CellType = CtrlUtil.CreateReadOnlyPairCellType(fromProcess);
LookupData toProcess = biz.LoadLookupLocation(locationtype);
shtMovePartList.Columns[(int)eColView.TO_PROCESS].CellType = CtrlUtil.CreateReadOnlyPairCellType(toProcess);
LookupData moveReason = biz.LoadLookupClassType(DataDefine.MOVE_REASON.ToNZString());
shtMovePartList.Columns[(int)eColView.REASON].CellType = CtrlUtil.CreateReadOnlyPairCellType(moveReason);
LookupData shiftCls = biz.LoadLookupClassType(DataDefine.SHIFT_CLS.ToNZString());
shtMovePartList.Columns[(int)eColView.SHIFT_CLS].CellType = CtrlUtil.CreateReadOnlyPairCellType(shiftCls);
shtMovePartList.Columns[(int)eColView.MOVE_DATE].CellType = CtrlUtil.CreateDateTimeCellType();
shtMovePartList.Columns[(int)eColView.TRANS_ID_FROM].StyleName = DataDefine.EXPORT_LAST.ToString();
shtMovePartList.Columns[(int)eColView.TRANS_ID_TO].StyleName = DataDefine.EXPORT_LAST.ToString();
shtMovePartList.Columns[(int)eColView.CUSTOMER_CD].StyleName = DataDefine.NO_EXPORT.ToString();
shtMovePartList.Columns[(int)eColView.WEIGHT].StyleName = DataDefine.NO_EXPORT.ToString();
shtMovePartList.Columns[(int)eColView.TRANS_ID_FROM].Visible = false;
shtMovePartList.Columns[(int)eColView.TRANS_ID_TO].Visible = false;
shtMovePartList.Columns[(int)eColView.CUSTOMER_CD].Visible = false;
shtMovePartList.Columns[(int)eColView.SHIFT_CLS_NAME].Visible = false;
shtMovePartList.Columns[(int)eColView.FROM_PROCESS_NAME].Visible = false;
shtMovePartList.Columns[(int)eColView.TO_PROCESS_NAME].Visible = false;
shtMovePartList.Columns[(int)eColView.REASON_NAME].Visible = false;
shtMovePartList.Columns[(int)eColView.WEIGHT].Visible = false;
CtrlUtil.MappingDataFieldWithEnum(shtMovePartList, typeof(eColView));
}
private void InitializeSpread()
{
shtView.ActiveSkin = Common.ACTIVE_SKIN;
LookupDataBIZ biz = new LookupDataBIZ();
LookupData locationLookupData = biz.LoadLookupLocation();
shtView.Columns[(int)eColView.LOC_CD].CellType = CtrlUtil.CreateReadOnlyPairCellType(locationLookupData);
LookupData shiftLookupData = biz.LoadLookupClassType(DataDefine.SHIFT_CLS.ToNZString());
shtView.Columns[(int)eColView.SHIFT_CLS].CellType = CtrlUtil.CreateReadOnlyPairCellType(shiftLookupData);
shtView.Columns[(int)eColView.TRANS_DATE].CellType = CtrlUtil.CreateDateTimeCellType();
CtrlUtil.MappingDataFieldWithEnum(shtView, typeof(eColView));
}
private void InitializeSpread()
{
shtView.ActiveSkin = Common.ACTIVE_SKIN;
LookupDataBIZ biz = new LookupDataBIZ();
LookupData locationLookupData = biz.LoadLookupLocation();
shtView.Columns[(int)eColView.ORDER_LOC_CD].CellType = CtrlUtil.CreateReadOnlyPairCellType(locationLookupData);
LookupData umClassLookupData = biz.LoadLookupClassType(DataDefine.UM_CLS.ToNZString());
shtView.Columns[(int)eColView.ORDER_UM_CLS].CellType = CtrlUtil.CreateReadOnlyPairCellType(umClassLookupData);
shtView.Columns[(int)eColView.INV_UM_CLS].CellType = CtrlUtil.CreateReadOnlyPairCellType(umClassLookupData);
LookupData itemClassLookupData = biz.LoadLookupClassType(DataDefine.ITEM_CLS.ToNZString());
shtView.Columns[(int)eColView.ITEM_CLS].CellType = CtrlUtil.CreateReadOnlyPairCellType(itemClassLookupData);
LookupData ordClassLookupData = biz.LoadLookupClassType(DataDefine.ORDER_PROCESS_CLS.ToNZString());
shtView.Columns[(int)eColView.ORDER_PROCESS_CLS].CellType = CtrlUtil.CreateReadOnlyPairCellType(ordClassLookupData);
LookupData ordcClassLookupData = biz.LoadLookupClassType(DataDefine.ORDER_CONDITION.ToNZString());
shtView.Columns[(int)eColView.ORDER_CONDITION].CellType = CtrlUtil.CreateReadOnlyPairCellType(ordcClassLookupData);
LookupData ordpClassLookupData = biz.LoadLookupClassType(DataDefine.ORDER_PROCESS_CLS.ToNZString());
shtView.Columns[(int)eColView.ORDER_PROCESS_CLS].CellType = CtrlUtil.CreateReadOnlyPairCellType(ordpClassLookupData);
LookupData mrpClassLookupData = biz.LoadLookupClassType(DataDefine.MRP_FLAG.ToNZString());
shtView.Columns[(int)eColView.MRP_FLAG].CellType = CtrlUtil.CreateReadOnlyPairCellType(mrpClassLookupData);
shtView.Columns[(int)eColView.CRT_DATE].CellType = CtrlUtil.CreateDateTimeCellType(Common.CurrentUserInfomation.DateFormatString);
shtView.Columns[(int)eColView.CRT_DATE].HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Center;
shtView.Columns[(int)eColView.UPD_DATE].CellType = CtrlUtil.CreateDateTimeCellType(Common.CurrentUserInfomation.DateFormatString);
shtView.Columns[(int)eColView.UPD_DATE].HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Center;
shtView.Columns[(int)eColView.AT_DATE].CellType = CtrlUtil.CreateDateTimeCellType(Common.CurrentUserInfomation.DateFormatString);
shtView.Columns[(int)eColView.AT_DATE].HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Center;
shtView.Columns[(int)eColView.IS_ACTIVE].CellType = CtrlUtil.CreateCheckboxCellType("", "");
shtView.Columns[(int)eColView.CRT_BY].Visible = false;
shtView.Columns[(int)eColView.CRT_DATE].Visible = false;
shtView.Columns[(int)eColView.CRT_MACHINE].Visible = false;
shtView.Columns[(int)eColView.UPD_BY].Visible = false;
shtView.Columns[(int)eColView.UPD_DATE].Visible = false;
shtView.Columns[(int)eColView.UPD_MACHINE].Visible = false;
shtView.Columns[(int)eColView.IS_ACTIVE].Visible = false;
shtView.Columns[(int)eColView.BAL_QTY].Visible = false;
shtView.Columns[(int)eColView.ITEM_CLS].Visible = false;
shtView.Columns[(int)eColView.MAX_CAPACITY].Visible = false;
CtrlUtil.MappingDataFieldWithEnum(shtView, typeof(eColView));
for (int i = 0; i < shtView.ColumnCount; i++)
{
shtView.Columns[i].AllowAutoFilter = true;
shtView.Columns[i].AllowAutoSort = true;
}
}
private void InitializeSpread()
{
shtView.ActiveSkin = Common.ACTIVE_SKIN;
LookupDataBIZ biz = new LookupDataBIZ();
LookupData locationLookupData = biz.LoadLookupLocation();
shtView.Columns[(int)eColView.CUSTOMER_CD].CellType = CtrlUtil.CreateReadOnlyPairCellType(locationLookupData);
//LookupData umClassLookupData = biz.LoadLookupClassType(DataDefine.UM_CLS.ToNZString());
//shtView.Columns[(int)eColView.ORDER_UM_CLS].CellType = CtrlUtil.CreateReadOnlyPairCellType(umClassLookupData);
//shtView.Columns[(int)eColView.INV_UM_CLS].CellType = CtrlUtil.CreateReadOnlyPairCellType(umClassLookupData);
//LookupData itemClassLookupData = biz.LoadLookupClassType(DataDefine.ITEM_CLS.ToNZString());
//shtView.Columns[(int)eColView.ITEM_CLS].CellType = CtrlUtil.CreateReadOnlyPairCellType(itemClassLookupData);
//LookupData ordClassLookupData = biz.LoadLookupClassType(DataDefine.ORDER_PROCESS_CLS.ToNZString());
//shtView.Columns[(int)eColView.ORDER_PROCESS_CLS].CellType = CtrlUtil.CreateReadOnlyPairCellType(ordClassLookupData);
//LookupData ordcClassLookupData = biz.LoadLookupClassType(DataDefine.ORDER_CONDITION.ToNZString());
//shtView.Columns[(int)eColView.ORDER_CONDITION].CellType = CtrlUtil.CreateReadOnlyPairCellType(ordcClassLookupData);
//LookupData ordpClassLookupData = biz.LoadLookupClassType(DataDefine.ORDER_PROCESS_CLS.ToNZString());
//shtView.Columns[(int)eColView.ORDER_PROCESS_CLS].CellType = CtrlUtil.CreateReadOnlyPairCellType(ordpClassLookupData);
//LookupData mrpClassLookupData = biz.LoadLookupClassType(DataDefine.MRP_FLAG.ToNZString());
//shtView.Columns[(int)eColView.MRP_FLAG].CellType = CtrlUtil.CreateReadOnlyPairCellType(mrpClassLookupData);
//shtView.Columns[(int)eColView.CRT_DATE].CellType = CtrlUtil.CreateDateTimeCellType();
//shtView.Columns[(int)eColView.UPD_DATE].CellType = CtrlUtil.CreateDateTimeCellType();
//shtView.Columns[(int)eColView.AT_DATE].CellType = CtrlUtil.CreateDateTimeCellType();
//shtView.Columns[(int)eColView.IS_ACTIVE].CellType = CtrlUtil.CreateCheckboxCellType("","");
int[] iHideColumn =
{
(int)eColView.CRT_BY,
(int)eColView.CRT_DATE,
(int)eColView.CRT_MACHINE,
(int)eColView.UPD_BY,
(int)eColView.UPD_DATE,
(int)eColView.UPD_MACHINE,
(int)eColView.IS_ACTIVE,
(int)eColView.ORDER_TYPE,
(int)eColView.PRIORITY,
(int)eColView.Reserve,
(int)eColView.REVISION,
(int)eColView.ORDER_ID,
(int)eColView.YEAR_MONTH
};
for (int iColumn = 0; iColumn < iHideColumn.Length; iColumn++)
{
shtView.Columns[iHideColumn[iColumn]].Visible = false;
}
CtrlUtil.MappingDataFieldWithEnum(shtView, typeof(eColView));
shtView.Columns[(int)eColView.DUE_DATE].CellType = CtrlUtil.CreateDateTimeCellType();
}