private void InitialComboBox()
{
cboToLoc.Format += Common.ComboBox_Format;
cboFromLoc.Format += Common.ComboBox_Format;
cboForCustomer.Format += CommonLib.Common.ComboBox_Format;
cboSubType.Format += CommonLib.Common.ComboBox_Format;
LookupDataBIZ bizLookup = new LookupDataBIZ();
// Lookup From Loc
LookupData lookupLocationFrom = bizLookup.LoadLookupLocation();
cboFromLoc.LoadLookupData(lookupLocationFrom);
// Lookup To Loc
LookupData lookupLocationTo = bizLookup.LoadLookupLocation();
cboToLoc.LoadLookupData(lookupLocationTo);
// Lookup To CustomerLocation
LookupData lookupCustomer = bizLookup.LoadLookupLocation(new NZString[] { (NZString)DataDefine.Convert2ClassCode(DataDefine.eLOCATION_CLS.Customer)
, (NZString)DataDefine.Convert2ClassCode(DataDefine.eLOCATION_CLS.CustomerVendor) });
cboForCustomer.LoadLookupData(lookupCustomer);
// Lookup SubType
LookupData lookupSubType = bizLookup.LoadLookupClassType(new NZString(null, "ISSUE_SUBTYPE"));
cboSubType.LoadLookupData(lookupSubType);
}
private void InitialComboBox()
{
cboFromLoc.Format += CommonLib.Common.ComboBox_Format;
cboInventoryUM.Format += CommonLib.Common.ComboBox_Format;
cboToLoc.Format += CommonLib.Common.ComboBox_Format;
cboForCustomer.Format += CommonLib.Common.ComboBox_Format;
//cboSubType.Format += CommonLib.Common.ComboBox_Format;
LookupDataBIZ bizLookup = new LookupDataBIZ();
// Lookup To Location
LookupData lookupOrderLocation = bizLookup.LoadLookupLocation(null);
cboToLoc.LoadLookupData(lookupOrderLocation);
// Lookup From Location
LookupData lookupStoreLocation = bizLookup.LoadLookupLocation(null);
cboFromLoc.LoadLookupData(lookupStoreLocation);
// Lookup Inventory U/M
LookupData lookupInventoryUM = bizLookup.LoadLookupClassType(DataDefine.UM_CLS.ToNZString());
cboInventoryUM.LoadLookupData(lookupInventoryUM);
// Lookup To CustomerLocation
LookupData lookupCustomer = bizLookup.LoadLookupLocation(new NZString[] { (NZString)DataDefine.Convert2ClassCode(DataDefine.eLOCATION_CLS.Customer)
, (NZString)DataDefine.Convert2ClassCode(DataDefine.eLOCATION_CLS.CustomerVendor) });
cboForCustomer.LoadLookupData(lookupCustomer);
//// Lookup SubType
//LookupData lookupSubType = bizLookup.LoadLookupClassType(new NZString(null, "ISSUE_SUBTYPE"));
//cboSubType.LoadLookupData(lookupSubType);
}
private void InitializeSpread()
{
shtProductionReportList.ActiveSkin = Common.ACTIVE_SKIN;
#region Cell Type
LookupDataBIZ m_bizLookupData = new LookupDataBIZ();
LookupData dataShiftCls = m_bizLookupData.LoadLookupClassType(DataDefine.SHIFT_CLS.ToNZString());
shtProductionReportList.Columns[(int)eColView.SHIFT].CellType = CtrlUtil.CreateReadOnlyPairCellType(dataShiftCls);
NZString[] locationtype = new NZString[1];
locationtype[0] = DataDefine.Convert2ClassCode(DataDefine.eLOCATION_CLS.Production).ToNZString();
LookupData dataProductionProcess = m_bizLookupData.LoadLookupLocation(locationtype);
shtProductionReportList.Columns[(int)eColView.PROCESS].CellType = CtrlUtil.CreateReadOnlyPairCellType(dataProductionProcess);
LookupData dataMachine = m_bizLookupData.LoadMachineAll();
shtProductionReportList.Columns[(int)eColView.MACHINE_NO].CellType = CtrlUtil.CreateReadOnlyPairCellType(dataMachine);
LookupData dataPersonInCharge = m_bizLookupData.LoadPersonInCharge();
shtProductionReportList.Columns[(int)eColView.PERSON_IN_CHARGE].CellType = CtrlUtil.CreateReadOnlyPairCellType(dataPersonInCharge);
NZString[] supplier = new NZString[2];
supplier[0] = DataDefine.Convert2ClassCode(DataDefine.eLOCATION_CLS.Vendor).ToNZString();
supplier[1] = DataDefine.Convert2ClassCode(DataDefine.eLOCATION_CLS.CustomerVendor).ToNZString();
LookupData supplierData = m_bizLookupData.LoadLookupLocation(supplier);
shtProductionReportList.Columns[(int)eColView.SUPPLIER].CellType = CtrlUtil.CreateReadOnlyPairCellType(supplierData);
//NZString[] suppliertype = new NZString[1]; //04 = Supplier
//suppliertype[0] = DataDefine.Convert2ClassCode(DataDefine.eLOCATION_CLS.Vendor).ToNZString();
//LookupData dataSupplier = m_bizLookupData.LoadLookupLocation(suppliertype);
//shtProductionReportList.Columns[(int)eColView.Fo].CellType = CtrlUtil.CreateReadOnlyPairCellType(dataSupplier);
shtProductionReportList.Columns[(int)eColView.REWORK].CellType = CtrlUtil.CreateCheckboxCellType();
shtProductionReportList.Columns[(int)eColView.REWORK].HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Center;
#endregion
#region Export Type
shtProductionReportList.Columns[(int)eColView.TRANS_ID].StyleName = DataDefine.EXPORT_LAST.ToString();
shtProductionReportList.Columns[(int)eColView.MACHINE_NAME].StyleName = DataDefine.NO_EXPORT.ToString();
#endregion
#region Visible
shtProductionReportList.Columns[(int)eColView.TRANS_ID].Visible = false;
shtProductionReportList.Columns[(int)eColView.MACHINE_NAME].Visible = false;
shtProductionReportList.Columns[(int)eColView.SHIFT_NAME].Visible = false;
shtProductionReportList.Columns[(int)eColView.PROCESS_NAME].Visible = false;
shtProductionReportList.Columns[(int)eColView.PERSON_IN_CHARGE_NAME].Visible = false;
shtProductionReportList.Columns[(int)eColView.SUPPLIER_NAME].Visible = false;
// 14 Feb 2013: hide lot no and cust lot no
shtProductionReportList.Columns[(int)eColView.LOT_NO].Visible = false;
shtProductionReportList.Columns[(int)eColView.CUST_LOT_NO].Visible = false;
// end 14 Feb 2013
#endregion
CtrlUtil.MappingDataFieldWithEnum(shtProductionReportList, typeof(eColView));
}
private void InitialComboBox()
{
LookupDataBIZ bizLookup = new LookupDataBIZ();
// Lookup Lot Control
LookupData lookupIssueType = bizLookup.LoadLookupClassType(new NZString(null, "TRANS_TYPE"));
ReadOnlyPairCellType ItemTypecellType = new ReadOnlyPairCellType(lookupIssueType, CommonLib.Common.COMBOBOX_SEPERATOR_SYMBOL);
shtView.Columns[(int)eColView.ISSUE_TYPE].CellType = ItemTypecellType;
// Lookup OrderLoc
LookupData lookupOrderLoc = bizLookup.LoadLookupLocation();
ReadOnlyPairCellType OrderLoc = new ReadOnlyPairCellType(lookupOrderLoc, CommonLib.Common.COMBOBOX_SEPERATOR_SYMBOL);
shtView.Columns[(int)eColView.FROM_LOC].CellType = OrderLoc;
// Lookup StoreLoc
LookupData lookupStoreLoc = bizLookup.LoadLookupLocation();
ReadOnlyPairCellType StoreLoc = new ReadOnlyPairCellType(lookupStoreLoc, CommonLib.Common.COMBOBOX_SEPERATOR_SYMBOL);
shtView.Columns[(int)eColView.TO_LOC].CellType = StoreLoc;
// Lookup CustomerLoc
LookupData lookupCustomerLoc = bizLookup.LoadLookupLocation();
ReadOnlyPairCellType CustomerLoc = new ReadOnlyPairCellType(lookupCustomerLoc, Common.COMBOBOX_SEPERATOR_SYMBOL);
shtView.Columns[(int)eColView.FOR_CUSTOMER].CellType = CustomerLoc;
// Lookup SubType
LookupData lookupSubType = bizLookup.LoadLookupClassType(DataDefine.ISSUE_SUBTYPE.ToNZString());
ReadOnlyPairCellType SubType = new ReadOnlyPairCellType(lookupSubType, Common.COMBOBOX_SEPERATOR_SYMBOL);
shtView.Columns[(int)eColView.TRAN_SUB_CLS].CellType = SubType;
}
private void InitialComboBox()
{
LookupDataBIZ bizLookup = new LookupDataBIZ();
LookupData lookupOPERATION_TYPE = bizLookup.LoadLookupClassType(new NZString(null, DataDefine.OPERATION_TYPE));
ReadOnlyPairCellType OPERATION_TYPE = new ReadOnlyPairCellType(lookupOPERATION_TYPE, Common.COMBOBOX_SEPERATOR_SYMBOL);
shtView.Columns[(int)eColView.OPERATION_TYPE].CellType = OPERATION_TYPE;
LookupData lookupTRANS_CLS = bizLookup.LoadLookupClassType(new NZString(null, DataDefine.TRANS_TYPE));
ReadOnlyPairCellType TRANS_CLS = new ReadOnlyPairCellType(lookupTRANS_CLS, Common.COMBOBOX_SEPERATOR_SYMBOL);
shtView.Columns[(int)eColView.TRANS_CLS].CellType = TRANS_CLS;
LookupData lookupIN_OUT_CLS = bizLookup.LoadLookupClassType(new NZString(null, DataDefine.IN_OUT_CLASS));
ReadOnlyPairCellType IN_OUT_CLS = new ReadOnlyPairCellType(lookupIN_OUT_CLS, Common.COMBOBOX_SEPERATOR_SYMBOL);
shtView.Columns[(int)eColView.IN_OUT_CLS].CellType = IN_OUT_CLS;
// Lookup StoreLoc
LookupData lookupStoreLoc = bizLookup.LoadLookupLocation();
ReadOnlyPairCellType StoreLoc = new ReadOnlyPairCellType(lookupStoreLoc, Common.COMBOBOX_SEPERATOR_SYMBOL);
shtView.Columns[(int)eColView.LOC_CD].CellType = StoreLoc;
// Lookup CustomerLoc
LookupData lookupCustomerLoc = bizLookup.LoadLookupLocation();
ReadOnlyPairCellType CustomerLoc = new ReadOnlyPairCellType(lookupCustomerLoc, Common.COMBOBOX_SEPERATOR_SYMBOL);
shtView.Columns[(int)eColView.FOR_CUSTOMER].CellType = CustomerLoc;
// Lookup SubType
LookupData lookupSubType = bizLookup.LoadLookupClassType(DataDefine.ISSUE_SUBTYPE.ToNZString());
ReadOnlyPairCellType SubType = new ReadOnlyPairCellType(lookupSubType, Common.COMBOBOX_SEPERATOR_SYMBOL);
shtView.Columns[(int)eColView.TRAN_SUB_CLS].CellType = SubType;
LookupData lookupSHIFT_CLS = bizLookup.LoadLookupClassType(DataDefine.SHIFT_CLS.ToNZString());
ReadOnlyPairCellType SHIFT_CLS = new ReadOnlyPairCellType(lookupSHIFT_CLS, Common.COMBOBOX_SEPERATOR_SYMBOL);
shtView.Columns[(int)eColView.SHIFT_CLS].CellType = SHIFT_CLS;
LookupData lookupSCREEN_TYPE = bizLookup.LoadLookupClassType(DataDefine.SCREEN_TYPE.ToNZString());
ReadOnlyPairCellType SCREEN_TYPE = new ReadOnlyPairCellType(lookupSCREEN_TYPE, Common.COMBOBOX_SEPERATOR_SYMBOL);
shtView.Columns[(int)eColView.SCREEN_TYPE].CellType = SCREEN_TYPE;
LookupData lookupSCREEN_TYPE_CBO = bizLookup.LoadLookupClassType(DataDefine.SCREEN_TYPE.ToNZString());
cboScreenType.LoadLookupData(lookupSCREEN_TYPE_CBO);
}
private void InitailSpread()
{
shtDelivery.ActiveSkin = CommonLib.Common.ACTIVE_SKIN;
CtrlUtil.MappingDataFieldWithEnum(shtDelivery, typeof(eColView));
//shtView.Columns[(int)eColView.SHIP_DATE].CellType = CtrlUtil.CreateDateTimeCellType();
shtDelivery.Columns[(int)eColView.TRANS_ID].StyleName = DataDefine.EXPORT_LAST.ToString();
shtDelivery.Columns[(int)eColView.GROUP_TRANS_ID].StyleName = DataDefine.EXPORT_LAST.ToString();
shtDelivery.Columns[(int)eColView.LOC_CD].StyleName = DataDefine.NO_EXPORT.ToString();
shtDelivery.Columns[(int)eColView.CURRENCY].StyleName = DataDefine.NO_EXPORT.ToString();
shtDelivery.Columns[(int)eColView.RETURN_QTY].StyleName = DataDefine.NO_EXPORT.ToString();
shtDelivery.Columns[(int)eColView.TRANS_ID].Visible = false;
shtDelivery.Columns[(int)eColView.GROUP_TRANS_ID].Visible = false;
shtDelivery.Columns[(int)eColView.ORDER_DETAIL_NO].Visible = false;
shtDelivery.Columns[(int)eColView.LOC_CD].Visible = false;
shtDelivery.Columns[(int)eColView.LOC_DESC].Visible = false;
shtDelivery.Columns[(int)eColView.CURRENCY].Visible = false;
shtDelivery.Columns[(int)eColView.RETURN_QTY].Visible = false;
LookupDataBIZ m_bizLookupData = new LookupDataBIZ();
LookupData locData = m_bizLookupData.LoadLookupLocation();
shtDelivery.Columns[(int)eColView.DEALING_NO].CellType = CtrlUtil.CreateReadOnlyPairCellType(locData);
}
private void LookupData()
{
string strTableName = EVOFramework.Data.DTOUtility.ReadTableName(typeof(MachineDTO));
LookupDataBIZ biz = new LookupDataBIZ();
LookupData MachineProjectData = biz.LoadLookupClassType(DataDefine.MACHINE_PROJECT.ToNZString());
cboProject.LoadLookupData(MachineProjectData);
cboProject.SelectedIndex = -1;
NZString[] locationtype = new NZString[1];
locationtype[0] = DataDefine.Convert2ClassCode(DataDefine.eLOCATION_CLS.Production).ToNZString();
LookupData ProductionProcessData = biz.LoadLookupLocation(locationtype);
//LookupData ProductionProcessData = biz.LoadLookupClassType(DataDefine.PRODUCTION_PROCESS.ToNZString());
cboProcess.LoadLookupData(ProductionProcessData);
cboProcess.SelectedIndex = -1;
//LookupData lookupMachineType = biz.LoadLookupTextHelper(strTableName, MachineDTO.eColumns.MACHINE_TYPE.ToString());
//cboMachineType.LoadLookupData(lookupMachineType);
//cboMachineType.SelectedIndex = -1;
LookupData lookupMachineType = biz.LoadLookupClassType(DataDefine.MACHINE_TYPE.ToNZString());
cboMachineType.LoadLookupData(lookupMachineType);
cboMachineType.SelectedIndex = -1;
LookupData lookupMachineGroup = biz.LoadLookupTextHelper(strTableName, MachineDTO.eColumns.MACHINE_GROUP.ToString());
cboMachineGroup.LoadLookupData(lookupMachineGroup);
cboMachineGroup.SelectedIndex = -1;
}
private void InitializeComboBox()
{
LookupDataBIZ bizLookupData = new LookupDataBIZ();
cboStoredLoc.Format += Common.ComboBox_Format;
cboInventoryUM.Format += Common.ComboBox_Format;
cboReasonCode.Format += Common.ComboBox_Format;
NZString[] locationtype = new NZString[1];
locationtype[0] = DataDefine.Convert2ClassCode(DataDefine.eLOCATION_CLS.Production).ToNZString();
LookupData locationLookup = bizLookupData.LoadLookupLocation(locationtype);
cboStoredLoc.LoadLookupData(locationLookup);
// Lookup Inventory U/M
LookupData lookupInventoryUM = bizLookupData.LoadLookupClassType(new NZString(null, DataDefine.UM_CLS));
cboInventoryUM.LoadLookupData(lookupInventoryUM);
// Lookup Reason code
LookupData lookupReason = bizLookupData.LoadLookupClassType(new NZString(null, DataDefine.ADJ_SUBTYPE));
cboReasonCode.LoadLookupData(lookupReason);
cboReasonCode.SelectedIndex = -1;
cboInventoryUM.SelectedIndex = -1;
cboStoredLoc.SelectedIndex = -1;
}
private void InitializeSpread()
{
shtCustomerOrderList.ActiveSkin = Common.ACTIVE_SKIN;
shtCustomerOrderList.Columns[(int)eColView.ORDER_DETAIL_NO].Visible = false;
shtCustomerOrderList.Columns[(int)eColView.LOC_DESC].Visible = false;
LookupDataBIZ biz = new LookupDataBIZ();
NZString[] customerInfo = { (NZString)DataDefine.Convert2ClassCode(DataDefine.eLOCATION_CLS.Customer)
, (NZString)DataDefine.Convert2ClassCode(DataDefine.eLOCATION_CLS.CustomerVendor)
, (NZString)DataDefine.Convert2ClassCode(DataDefine.eLOCATION_CLS.Vendor) };
LookupData customerLookup = biz.LoadLookupLocation(customerInfo);
shtCustomerOrderList.Columns[(int)eColView.CUSTOMER_CD].CellType = CtrlUtil.CreateReadOnlyPairCellType(customerLookup);
LookupData orderTypeLookup = biz.LoadLookupClassType(DataDefine.CUSTOMER_ORDER_TYPE.ToNZString());
shtCustomerOrderList.Columns[(int)eColView.ORDER_TYPE].CellType = CtrlUtil.CreateReadOnlyPairCellType(orderTypeLookup);
//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(shtCustomerOrderList, typeof(eColView));
CtrlUtil.SpreadUpdateColumnSorting(shtCustomerOrderList);
}
protected void MAS051_ReigsterBOM_Load(object sender, EventArgs e)
{
txtItemCode.KeyPress += CtrlUtil.SetNextControl;
txtItemDesc.KeyPress += CtrlUtil.SetNextControl;
txtUpperQty.KeyPress += CtrlUtil.SetNextControl;
txtLowerQty.KeyPress += CtrlUtil.SetNextControl;
cboOrderLoc.KeyPress += CtrlUtil.SetNextControl;
chkChildOrderLoc.KeyPress += CtrlUtil.SetNextControl;
cboMRPFlag.KeyPress += CtrlUtil.SetNextControl;
chkMRPFlag.KeyPress += CtrlUtil.SetNextControl;
cboOrderLoc.Format += Common.ComboBox_Format;
cboMRPFlag.Format += Common.ComboBox_Format;
txtUpperQty.PathValue = 1;
txtLowerQty.PathValue = 1;
CtrlUtil.EnabledControl(false, txtParentItemCode, txtParentItemDesc, txtItemDesc);
CtrlUtil.EnabledControl(true, txtItemCode, txtUpperQty, txtLowerQty, cboOrderLoc, cboMRPFlag);
LookupDataBIZ m_bizLookupData = new LookupDataBIZ();
LookupData locationData = m_bizLookupData.LoadLookupLocation();
cboOrderLoc.LoadLookupData(locationData);
cboOrderLoc.SelectedIndex = -1;
LookupData lookupMRPFlag = m_bizLookupData.LoadLookupClassType(DataDefine.MRP_FLAG.ToNZString());
cboMRPFlag.LoadLookupData(lookupMRPFlag);
cboMRPFlag.SelectedIndex = -1;
chkChildOrderLoc_CheckedChanged(this, null);
chkMRPFlag_CheckedChanged(this, null);
}
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 InitializeLookupData()
{
LookupDataBIZ biz = new LookupDataBIZ();
LookupData locationLookup = biz.LoadLookupLocation();
NZString[] SupplierType = new NZString[] { (NZString)DataDefine.Convert2ClassCode(DataDefine.eLOCATION_CLS.CustomerVendor),
(NZString)DataDefine.Convert2ClassCode(DataDefine.eLOCATION_CLS.Vendor) };
LookupData SupplierLookup = biz.LoadLookupLocation(SupplierType);
cboStoredLoc.LoadLookupData(locationLookup);
cboSupplierCode.LoadLookupData(SupplierLookup);
LookupData umClsData = biz.LoadLookupClassType(DataDefine.UM_CLS.ToNZString());
shtView.Columns[(int)eColView.ORDER_UM_CLS].CellType = CtrlUtil.CreateReadOnlyPairCellType(umClsData);
shtView.Columns[(int)eColView.INV_UM_CLS].CellType = CtrlUtil.CreateReadOnlyPairCellType(umClsData);
}
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 InitialScreen()
{
//txtFilter.KeyPress += CommonLib.CtrlUtil.SetRestrictKeyInput;
//txtFilter.KeyUp += CommonLib.CtrlUtil.FilterRestrictChar;
// add search button
tsbSearch = new ToolStripButton("Refresh");
tsbSearch.Image = Forms.Properties.Resources.REFRESH;
tslControl.Items.Insert(0, tsbSearch);
tsbSearch.Click += tsbSearch_Click;
// add Export Cost button
tsbExportCost = new ToolStripButton("Export Cost");
tsbExportCost.Image = Forms.Properties.Resources.EXPORT;
tslControl.Items.Add(tsbExportCost);
tsbExportCost.Click += new EventHandler(tsbExportCost_Click);
//Disable function
tsbExportCost.Visible = false;
chkToEndMonth.Checked = false;
CtrlUtil.EnabledControl(false, dtPeriodEnd);
shtView.ActiveSkin = Common.ACTIVE_SKIN;
MapSpreadData();
LookupDataBIZ bizLookup = new LookupDataBIZ();
switch (Common.CurrentUserInfomation.DateFormat)
{
case eDateFormat.YMD:
dtPeriodBegin.Format = "yyyy/MM";
break;
case eDateFormat.MDY:
case eDateFormat.DMY:
dtPeriodBegin.Format = "MM/yyyy";
break;
}
dtPeriodEnd.Format = Common.CurrentUserInfomation.DateFormatString;
rdoGroupItem.Checked = true;
LoadDefaultPeriod();
LookupDataBIZ biz = new LookupDataBIZ();
LookupData locationLookupData = biz.LoadLookupLocation();
shtView.Columns[(int)eColView.CUSTOMER_CD].CellType = CtrlUtil.CreateReadOnlyPairCellType(locationLookupData);
LoadData(dtPeriodBegin.NZValue, dtPeriodEnd.NZValue, txtFilter.Text.Trim(), false);
}
private void InitializeLookupData()
{
LookupDataBIZ lookupDataBiz = new LookupDataBIZ();
LookupData adjustmentType = lookupDataBiz.LoadLookupClassType(DataDefine.IN_OUT_CLASS.ToNZString());
shtView.Columns[(int)eColView.IN_OUT_CLS].CellType = new ReadOnlyPairCellType(adjustmentType, Common.COMBOBOX_SEPERATOR_SYMBOL);
LookupData reasonCode = lookupDataBiz.LoadLookupClassType(DataDefine.ADJ_SUBTYPE.ToNZString());
shtView.Columns[(int)eColView.TRAN_SUB_CLS].CellType = new ReadOnlyPairCellType(reasonCode, Common.COMBOBOX_SEPERATOR_SYMBOL);
LookupData stockLocation = lookupDataBiz.LoadLookupLocation();
shtView.Columns[(int)eColView.LOC_CD].CellType = new ReadOnlyPairCellType(stockLocation, Common.COMBOBOX_SEPERATOR_SYMBOL);
}
private void InitializeSpread()
{
shtReturnProductList.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();
shtReturnProductList.Columns[(int)eColView.SLIP_NO].StyleName = DataDefine.NO_EXPORT.ToString();
shtReturnProductList.Columns[(int)eColView.RETURN_TRANS_ID].StyleName = DataDefine.EXPORT_LAST.ToString();
shtReturnProductList.Columns[(int)eColView.TRANS_ID].StyleName = DataDefine.EXPORT_LAST.ToString();
shtReturnProductList.Columns[(int)eColView.DELIVERY_TRANS_ID].StyleName = DataDefine.EXPORT_LAST.ToString();
shtReturnProductList.Columns[(int)eColView.SLIP_NO].Visible = false;
shtReturnProductList.Columns[(int)eColView.RETURN_TRANS_ID].Visible = false;
shtReturnProductList.Columns[(int)eColView.TRANS_ID].Visible = false;
shtReturnProductList.Columns[(int)eColView.DELIVERY_TRANS_ID].Visible = false;
shtReturnProductList.Columns[(int)eColView.LOC_DESC].Visible = false;
CtrlUtil.MappingDataFieldWithEnum(shtReturnProductList, typeof(eColView));
LookupDataBIZ m_bizLookupData = new LookupDataBIZ();
LookupData locData = m_bizLookupData.LoadLookupLocation();
shtReturnProductList.Columns[(int)eColView.DEALING_NO].CellType = CtrlUtil.CreateReadOnlyPairCellType(locData);
}
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 LoadLookupCellType()
{
LookupDataBIZ bizLookup = new LookupDataBIZ();
LookupData locationLookup = bizLookup.LoadLookupLocation();
this.shtItemView.Columns[(int)eColView.CUSTOMER_CD].CellType = CtrlUtil.CreateReadOnlyPairCellType(locationLookup);
//// Lookup Item Type
//LookupData lookupItemType = bizLookup.LoadLookupClassType(new NZString(null, DataDefine.ITEM_CLS));
//// Lookup Lot Control
//LookupData lookupLotControl = bizLookup.LoadLookupClassType(new NZString(null, DataDefine.LOT_CONTROL_CLS));
//ReadOnlyPairCellType ItemTypecellType = new ReadOnlyPairCellType(lookupItemType, CommonLib.Common.COMBOBOX_SEPERATOR_SYMBOL);
//shtItemView.Columns[(int)eColView.ITEM_CLS].CellType = ItemTypecellType;
//shtItemView.Columns[(int)eColView.ITEM_CLS_MINOR].CellType = CtrlUtil.CreateReadOnlyPairCellType(bizLookup.LoadLookupClassType((NZString)DataDefine.ITEM_CLS_MINOR04));
//ReadOnlyPairCellType LotControlcellType = new ReadOnlyPairCellType(lookupLotControl, CommonLib.Common.COMBOBOX_SEPERATOR_SYMBOL);
//shtItemView.Columns[(int)eColView.LOT_CONTROL_CLS].CellType = LotControlcellType;
}
private void LoadLookupCellType()
{
LookupDataBIZ bizLookup = new LookupDataBIZ();
LookupData machineTypeData = bizLookup.LoadLookupClassType(DataDefine.MACHINE_TYPE.ToNZString());
ReadOnlyPairCellType cellmachineType = new ReadOnlyPairCellType(machineTypeData, CommonLib.Common.COMBOBOX_SEPERATOR_SYMBOL);
shtView.Columns[(int)eColView.MACHINE_TYPE].CellType = cellmachineType;
LookupData machineProjectData = bizLookup.LoadLookupClassType(DataDefine.MACHINE_PROJECT.ToNZString());
ReadOnlyPairCellType cellProjectType = new ReadOnlyPairCellType(machineProjectData, CommonLib.Common.COMBOBOX_SEPERATOR_SYMBOL);
shtView.Columns[(int)eColView.PROJECT].CellType = cellProjectType;
NZString[] locationtype = new NZString[1];
locationtype[0] = DataDefine.Convert2ClassCode(DataDefine.eLOCATION_CLS.Production).ToNZString();
LookupData locationData = bizLookup.LoadLookupLocation(locationtype);
ReadOnlyPairCellType cellProcess = new ReadOnlyPairCellType(locationData, CommonLib.Common.COMBOBOX_SEPERATOR_SYMBOL);
shtView.Columns[(int)eColView.PROCESS_CD].CellType = cellProcess;
}
private void InitialComboBox()
{
cboCustomerCode.Format += Common.ComboBox_Format;
LookupDataBIZ bizLookup = new LookupDataBIZ();
// Lookup To CustomerLocation
LookupData lookupCustomer = bizLookup.LoadLookupLocation(new NZString[] { (NZString)DataDefine.Convert2ClassCode(DataDefine.eLOCATION_CLS.Customer)
, (NZString)DataDefine.Convert2ClassCode(DataDefine.eLOCATION_CLS.CustomerVendor) });
cboCustomerCode.LoadLookupData(lookupCustomer);
cboCustomerCode.SelectedIndex = -1;
ClassListBIZ biz = new ClassListBIZ();
DataTable dt = DTOUtility.ConvertListToDataTable <ClassListDTO>(biz.LoadByClassInfo("term_of_payment".ToNZString()));
cboTermOfPayment.DataSource = dt;
cboTermOfPayment.ValueMember = "CLS_CD";
cboTermOfPayment.DisplayMember = "TERM_OF_PAYMENT";
cboTermOfPayment.SelectedIndex = -1;
}
private void InitialSpread()
{
LookupDataBIZ biz = new LookupDataBIZ();
LookupData locationLookupData = biz.LoadLookupLocation();
shtViewHeader.Columns[(int)eHeader.OrderLocCD].CellType = CtrlUtil.CreateReadOnlyPairCellType(locationLookupData);
if (shtViewHeader.Columns.Count > 0)
{
SpreadVisibleColumn(false, shtViewHeader, (int)eHeader.ItemCLS,
(int)eHeader.OrderProcessCLS,
(int)eHeader.InvUMCLS,
(int)eHeader.OrderUMCLS,
(int)eHeader.MaxCapacity,
(int)eHeader.InventoryQty
);
}
if (shtViewDetail.Columns.Count > 0)
{
SpreadVisibleColumn(false, shtViewDetail, (int)eDetail.ItemCD, (int)eDetail.OrderLocCD, (int)eDetail.RecordNo);
}
}
private void LoadLookupCellType()
{
LookupDataBIZ bizLookup = new LookupDataBIZ();
// Lookup Item Type
LookupData lookupItemType = bizLookup.LoadLookupClassType(DataDefine.ITEM_CLS.ToNZString());
// Lookup Lot Control
LookupData lookupLotControl = bizLookup.LoadLookupClassType(DataDefine.LOT_CONTROL_CLS.ToNZString());
// Lookup Consumption
LookupData lookupConsumption = bizLookup.LoadLookupClassType(new NZString(null, DataDefine.CONSUMPTION_CLS));
// Lookup Location
LookupData lookupLocation = bizLookup.LoadLookupLocation();
shtItemView.Columns[(int)eColView.UPPER_ITEM_CLS].CellType = CtrlUtil.CreateReadOnlyPairCellType(lookupItemType);
shtItemView.Columns[(int)eColView.LOWER_ITEM_CLS].CellType = CtrlUtil.CreateReadOnlyPairCellType(lookupItemType);
shtItemView.Columns[(int)eColView.LOT_CONTROL_CLS].CellType = CtrlUtil.CreateReadOnlyPairCellType(lookupLotControl);
shtItemView.Columns[(int)eColView.CONSUMTION_CLS].CellType = CtrlUtil.CreateReadOnlyPairCellType(lookupConsumption);
shtItemView.Columns[(int)eColView.ORDER_PROCESS_CLS].CellType = CtrlUtil.CreateReadOnlyPairCellType(lookupLocation);
shtItemView.Columns[(int)eColView.ORDER_LOC_CD].CellType = CtrlUtil.CreateReadOnlyPairCellType(lookupLocation);
shtItemView.Columns[(int)eColView.STORE_LOC_CD].CellType = CtrlUtil.CreateReadOnlyPairCellType(lookupLocation);
shtItemView.Columns[(int)eColView.CHILD_ORDER_LOC_CD].CellType = CtrlUtil.CreateReadOnlyPairCellType(lookupLocation);
}
public PUR020_PurchaseOrderEntry(PurchaseOrderHDTO hdtoPurchaseOrder)
{
InitializeComponent();
#region Set Component
shtView.ActiveSkin = Common.ACTIVE_SKIN;
this.WindowState = FormWindowState.Maximized;
CtrlUtil.MappingDataFieldWithEnum(shtView, typeof(eColumn));
m_BIZPurchaseOrder = new PurchaseOrderBIZ();
LookupDataBIZ BIZLookupData = new LookupDataBIZ();
cboSupplierCode.Format += CommonLib.Common.ComboBox_Format;
cboSupplierCode.LoadLookupData(BIZLookupData.LoadLookupLocation(new NZString[] { (NZString)"04", (NZString)"05" }));
cboSupplierCode.SelectedIndex = -1;
cboDelivery.Format += CommonLib.Common.ComboBox_Format;
cboDelivery.LoadLookupData(BIZLookupData.LoadLookupLocation(new NZString[]
{ (NZString)DataDefine.Convert2ClassCode(DataDefine.eLOCATION_CLS.Customer),
(NZString)DataDefine.Convert2ClassCode(DataDefine.eLOCATION_CLS.CustomerVendor) }));
cboDelivery.SelectedIndex = -1;
cboTermOfPayment.Format += CommonLib.Common.ComboBox_Format;
cboTermOfPayment.LoadLookupData(BIZLookupData.LoadLookupClassType(DataDefine.TERM_OF_PAYMENT.ToNZString()));
cboTermOfPayment.SelectedIndex = -1;
cboCurrency.Format += CommonLib.Common.ComboBox_Format;
cboCurrency.LoadLookupData(BIZLookupData.LoadLookupClassType(DataDefine.CURRENCY.ToNZString()));
cboCurrency.SelectedIndex = -1;
shtView.Columns[(int)eColumn.UNIT].CellType = CtrlUtil.CreateComboBoxCellType(BIZLookupData.LoadLookupClassType(DataDefine.UM_CLS.ToNZString()), true);
shtView.Columns[(int)eColumn.INV_UM].CellType = CtrlUtil.CreateComboBoxCellType(BIZLookupData.LoadLookupClassType(DataDefine.UM_CLS.ToNZString()), true);
//shtView.Columns[(int)eColumn.STATUS].CellType = CtrlUtil.CreateComboBoxCellType(BIZLookupData.LoadLookupClassType(DataDefine.PO_STATUS.ToNZString()), true);
// ซ่อน column บางตัว
for (eColumn column = eColumn.PO_LINE; column < eColumn.STATUS; column++)
{
FarPoint.Win.Spread.Column hiddenColumn = shtView.Columns[(int)column];
hiddenColumn.Visible = false;
hiddenColumn.Label = column.ToString();
if (column == eColumn.PO_NO)
{
column = eColumn.BACK_ORDER_QTY;
}
}
shtView.Columns[(int)eColumn.ModifyState].Visible = false;
shtView.Columns[(int)eColumn.KeptStatus].Visible = false;
shtView.Columns[(int)eColumn.RATE].Visible = false;
for (int iColumn = 0; iColumn < shtView.ColumnCount; iColumn++)
{
if (iColumn != (int)eColumn.BUTTON)
{
shtView.Columns[iColumn].AllowAutoFilter = true;
shtView.Columns[iColumn].AllowAutoSort = true;
}
}
#endregion
this.m_HDTOPurchaseOrder = hdtoPurchaseOrder;
}
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();
}
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 InitialScreen()
{
cboProcess.Format += Common.ComboBox_Format;
rdoReportCheckingList.KeyPress += CtrlUtil.SetNextControl;
rdoReportCountingResult.KeyPress += CtrlUtil.SetNextControl;
//txtLocation.KeyPress += CtrlUtil.SetNextControl;
cboProcess.KeyPress += CtrlUtil.SetNextControl;
txtMasterNo.KeyPress += CtrlUtil.SetNextControl;
cboItemType.KeyPress += CtrlUtil.SetNextControl;
cboItemClassMinor04.KeyPress += CtrlUtil.SetNextControl;
chkIncomplete.KeyPress += CtrlUtil.SetNextControl;
chkDiff.KeyPress += CtrlUtil.SetNextControl;
chkNoMaster.KeyPress += CtrlUtil.SetNextControl;
LookupDataBIZ bizLookup = new LookupDataBIZ();
LookupData lookupItemType = bizLookup.LoadLookupClassType(new NZString(null, "ITEM_CLS"));
cboItemType.LoadLookupData(lookupItemType);
cboItemType.SelectedIndex = -1;
//------------ Location --------------------//
NZString[] locationtype = new NZString[1];
locationtype[0] = DataDefine.Convert2ClassCode(DataDefine.eLOCATION_CLS.Production).ToNZString();
LookupData dataProductionProcess = bizLookup.LoadLookupLocation(locationtype);
cboProcess.LoadLookupData(dataProductionProcess);
cboProcess.SelectedIndex = -1;
//------------ Location --------------------//
if (m_strPartSubType != null)
{
this.cboItemType.SelectedValue = m_strPartType;
}
if (m_strPartSubType != null)
{
this.cboItemClassMinor04.SelectedValue = m_strPartSubType;
}
dtStockTakingDate.Format = Common.CurrentUserInfomation.DateFormatString;
CtrlUtil.EnabledControl(false, dtStockTakingDate, txtPreProcessBy, txtRemark);
LoadCurrentStockTakingData();
if (btnPrintTag.Visible == false)
{
SysConfigBIZ sysBiz = new SysConfigBIZ();
SysConfigDTO argScreenInfo = new SysConfigDTO();
argScreenInfo.SYS_GROUP_ID = DataDefine.eSYSTEM_CONFIG.STK020.SYS_GROUP_ID;
argScreenInfo.SYS_KEY = (NZString)DataDefine.eSYSTEM_CONFIG.STK020.SYS_KEY.DEV_VERSION.ToString();
SysConfigDTO data = sysBiz.LoadByPK(argScreenInfo.SYS_GROUP_ID, argScreenInfo.SYS_KEY);
if (data != null && "1".Equals(data.CHAR_DATA.NVL("").Trim()))
{
btnPrintTag.Visible = true;
}
}
}
private void LoadLookupCellType()
{
LookupDataBIZ bizLookup = new LookupDataBIZ();
//Kind of Item
LookupData lookupKind = bizLookup.LoadLookupClassType(DataDefine.KIND_OF_PRODUCT.ToNZString());
ReadOnlyPairCellType cellmachineType = new ReadOnlyPairCellType(lookupKind.Clone(), CommonLib.Common.COMBOBOX_SEPERATOR_SYMBOL);
shtItemView.Columns[(int)eColView.KIND_OF_PRODUCT].CellType = cellmachineType;
//ReadOnlyPairCellType cellmatType = new ReadOnlyPairCellType(lookupKind.Clone(), CommonLib.Common.COMBOBOX_SEPERATOR_SYMBOL);
//shtItemView.Columns[(int)eColView.KIND_OF_MAT].CellType = cellmatType;
//BOI
LookupData lookupBOI = bizLookup.LoadLookupClassType(DataDefine.BOI_PROJECT.ToNZString());
ReadOnlyPairCellType cellBOI = new ReadOnlyPairCellType(lookupBOI, CommonLib.Common.COMBOBOX_SEPERATOR_SYMBOL);
shtItemView.Columns[(int)eColView.BOI].CellType = cellBOI;
//Customer
NZString[] CustomerType = new NZString[] { (NZString)DataDefine.Convert2ClassCode(DataDefine.eLOCATION_CLS.Customer), (NZString)DataDefine.Convert2ClassCode(DataDefine.eLOCATION_CLS.CustomerVendor) };
LookupData LookupCustomer = bizLookup.LoadLookupLocation(CustomerType);
ReadOnlyPairCellType cellCust = new ReadOnlyPairCellType(LookupCustomer, CommonLib.Common.COMBOBOX_SEPERATOR_SYMBOL);
shtItemView.Columns[(int)eColView.CUSTOMER_CD].CellType = cellCust;
// Production DI
LookupData LookupProductionDI = bizLookup.LoadLookupClassType(DataDefine.PRODUCTION_DI.ToNZString());
ReadOnlyPairCellType cellProductionDI = new ReadOnlyPairCellType(LookupProductionDI, CommonLib.Common.COMBOBOX_SEPERATOR_SYMBOL);
shtItemView.Columns[(int)eColView.PRODUCTION_DI].CellType = cellProductionDI;
// Matchine Supplier
NZString[] MatSupplier = new NZString[] { (NZString)DataDefine.Convert2ClassCode(DataDefine.eLOCATION_CLS.Vendor), (NZString)DataDefine.Convert2ClassCode(DataDefine.eLOCATION_CLS.CustomerVendor) };
LookupData LookupMatSupplier = bizLookup.LoadLookupLocation(MatSupplier);
ReadOnlyPairCellType cellMatSupplier = new ReadOnlyPairCellType(LookupMatSupplier.Clone(), CommonLib.Common.COMBOBOX_SEPERATOR_SYMBOL);
shtItemView.Columns[(int)eColView.MAT_SUPPLIER_CD].CellType = cellMatSupplier;
ReadOnlyPairCellType cellPlatingSupplier = new ReadOnlyPairCellType(LookupMatSupplier.Clone(), CommonLib.Common.COMBOBOX_SEPERATOR_SYMBOL);
shtItemView.Columns[(int)eColView.PLATING_SUPPLIER_CD].CellType = cellPlatingSupplier;
// Matchine DI
LookupData LookupMatDI = bizLookup.LoadLookupClassType(DataDefine.MAT_DI.ToNZString());
ReadOnlyPairCellType cellMatDI = new ReadOnlyPairCellType(LookupMatDI, CommonLib.Common.COMBOBOX_SEPERATOR_SYMBOL);
shtItemView.Columns[(int)eColView.MAT_DI].CellType = cellMatDI;
// Item Level
LookupData LookupItemLevel = bizLookup.LoadLookupClassType(DataDefine.ITEM_LEVEL.ToNZString());
ReadOnlyPairCellType cellItemLevel = new ReadOnlyPairCellType(LookupItemLevel, CommonLib.Common.COMBOBOX_SEPERATOR_SYMBOL);
shtItemView.Columns[(int)eColView.ITEM_LEVEL].CellType = cellItemLevel;
// Screw Kind
LookupData LookupScrewKind = bizLookup.LoadLookupClassType(DataDefine.SCREW_KIND.ToNZString());
ReadOnlyPairCellType cellScrewKind = new ReadOnlyPairCellType(LookupScrewKind, CommonLib.Common.COMBOBOX_SEPERATOR_SYMBOL);
shtItemView.Columns[(int)eColView.SCREW_KIND].CellType = cellScrewKind;
// Screw Head
LookupData LookupScrewHead = bizLookup.LoadLookupClassType(DataDefine.SCREW_HEAD.ToNZString());
ReadOnlyPairCellType cellScrewHead = new ReadOnlyPairCellType(LookupScrewHead, CommonLib.Common.COMBOBOX_SEPERATOR_SYMBOL);
shtItemView.Columns[(int)eColView.SCREW_HEAD].CellType = cellScrewHead;
// Screw Type
LookupData LookupScrewType = bizLookup.LoadLookupClassType(DataDefine.SCREW_TYPE.ToNZString());
ReadOnlyPairCellType cellScrewType = new ReadOnlyPairCellType(LookupScrewType, CommonLib.Common.COMBOBOX_SEPERATOR_SYMBOL);
shtItemView.Columns[(int)eColView.SCREW_TYPE].CellType = cellScrewType;
// Screw Remark1
LookupData LookupScrewRemark1 = bizLookup.LoadLookupClassType(DataDefine.SCREW_REMARK1.ToNZString());
ReadOnlyPairCellType cellScrewRemark1 = new ReadOnlyPairCellType(LookupScrewRemark1, CommonLib.Common.COMBOBOX_SEPERATOR_SYMBOL);
shtItemView.Columns[(int)eColView.SCREW_REMARK1].CellType = cellScrewRemark1;
// Screw Remark2
LookupData LookupScrewRemark2 = bizLookup.LoadLookupClassType(DataDefine.SCREW_REMARK2.ToNZString());
ReadOnlyPairCellType cellScrewRemark2 = new ReadOnlyPairCellType(LookupScrewRemark2, CommonLib.Common.COMBOBOX_SEPERATOR_SYMBOL);
shtItemView.Columns[(int)eColView.SCREW_REMARK2].CellType = cellScrewRemark2;
// Machine Type1
LookupData LookupMCType = bizLookup.LoadLookupClassType(DataDefine.MACHINE_TYPE.ToNZString());
ReadOnlyPairCellType cellMCType1 = new ReadOnlyPairCellType(LookupMCType.Clone(), CommonLib.Common.COMBOBOX_SEPERATOR_SYMBOL);
shtItemView.Columns[(int)eColView.MACHINE_TYPE1].CellType = cellMCType1;
// Machine Type2
ReadOnlyPairCellType cellMCType2 = new ReadOnlyPairCellType(LookupMCType.Clone(), CommonLib.Common.COMBOBOX_SEPERATOR_SYMBOL);
shtItemView.Columns[(int)eColView.MACHINE_TYPE2].CellType = cellMCType2;
// Machine Type3
ReadOnlyPairCellType cellMCType3 = new ReadOnlyPairCellType(LookupMCType.Clone(), CommonLib.Common.COMBOBOX_SEPERATOR_SYMBOL);
shtItemView.Columns[(int)eColView.MACHINE_TYPE3].CellType = cellMCType3;
// Machine Type4
ReadOnlyPairCellType cellMCType4 = new ReadOnlyPairCellType(LookupMCType.Clone(), CommonLib.Common.COMBOBOX_SEPERATOR_SYMBOL);
shtItemView.Columns[(int)eColView.MACHINE_TYPE4].CellType = cellMCType4;
// Machine Type5
ReadOnlyPairCellType cellMCType5 = new ReadOnlyPairCellType(LookupMCType.Clone(), CommonLib.Common.COMBOBOX_SEPERATOR_SYMBOL);
shtItemView.Columns[(int)eColView.MACHINE_TYPE5].CellType = cellMCType5;
// Machine Type6
ReadOnlyPairCellType cellMCType6 = new ReadOnlyPairCellType(LookupMCType.Clone(), CommonLib.Common.COMBOBOX_SEPERATOR_SYMBOL);
shtItemView.Columns[(int)eColView.MACHINE_TYPE6].CellType = cellMCType6;
// Process1
NZString[] Production = new NZString[] { (NZString)DataDefine.Convert2ClassCode(DataDefine.eLOCATION_CLS.Production) };
LookupData LookupProduction = bizLookup.LoadLookupLocation(Production);
ReadOnlyPairCellType cellProduction1 = new ReadOnlyPairCellType(LookupProduction.Clone(), CommonLib.Common.COMBOBOX_SEPERATOR_SYMBOL);
shtItemView.Columns[(int)eColView.PROCESS1].CellType = cellProduction1;
//Process2
ReadOnlyPairCellType cellProduction2 = new ReadOnlyPairCellType(LookupProduction.Clone(), CommonLib.Common.COMBOBOX_SEPERATOR_SYMBOL);
shtItemView.Columns[(int)eColView.PROCESS2].CellType = cellProduction2;
//Process3
ReadOnlyPairCellType cellProduction3 = new ReadOnlyPairCellType(LookupProduction.Clone(), CommonLib.Common.COMBOBOX_SEPERATOR_SYMBOL);
shtItemView.Columns[(int)eColView.PROCESS3].CellType = cellProduction3;
//Process4
ReadOnlyPairCellType cellProduction4 = new ReadOnlyPairCellType(LookupProduction.Clone(), CommonLib.Common.COMBOBOX_SEPERATOR_SYMBOL);
shtItemView.Columns[(int)eColView.PROCESS4].CellType = cellProduction4;
//Process5
ReadOnlyPairCellType cellProduction5 = new ReadOnlyPairCellType(LookupProduction.Clone(), CommonLib.Common.COMBOBOX_SEPERATOR_SYMBOL);
shtItemView.Columns[(int)eColView.PROCESS5].CellType = cellProduction5;
//Process6
ReadOnlyPairCellType cellProduction6 = new ReadOnlyPairCellType(LookupProduction.Clone(), CommonLib.Common.COMBOBOX_SEPERATOR_SYMBOL);
shtItemView.Columns[(int)eColView.PROCESS6].CellType = cellProduction6;
// HeatTreatmentType
LookupData LookupHeatTreatmentType = bizLookup.LoadLookupClassType(DataDefine.HEAT_TREATMENT_TYPE.ToNZString());
ReadOnlyPairCellType cellTreatmentType = new ReadOnlyPairCellType(LookupHeatTreatmentType, CommonLib.Common.COMBOBOX_SEPERATOR_SYMBOL);
shtItemView.Columns[(int)eColView.HEAT_TYPE].CellType = cellTreatmentType;
// KTC Plating
LookupData LookupKTCPlating = bizLookup.LoadLookupClassType(DataDefine.KTC_PLATING.ToNZString());
ReadOnlyPairCellType cellKTCPlating = new ReadOnlyPairCellType(LookupKTCPlating, CommonLib.Common.COMBOBOX_SEPERATOR_SYMBOL);
shtItemView.Columns[(int)eColView.PLATING_KTC].CellType = cellKTCPlating;
// Baking Time
LookupData LookupBakTime = bizLookup.LoadLookupClassType(DataDefine.BAKING_TIME.ToNZString());
ReadOnlyPairCellType cellBakTime = new ReadOnlyPairCellType(LookupBakTime, CommonLib.Common.COMBOBOX_SEPERATOR_SYMBOL);
shtItemView.Columns[(int)eColView.BAKING_TIME].CellType = cellBakTime;
// Baking Temp
LookupData LookupBakTemp = bizLookup.LoadLookupClassType(DataDefine.BAKING_TEMP.ToNZString());
ReadOnlyPairCellType cellBakTemp = new ReadOnlyPairCellType(LookupBakTemp, CommonLib.Common.COMBOBOX_SEPERATOR_SYMBOL);
shtItemView.Columns[(int)eColView.BAKING_TEMP].CellType = cellBakTemp;
// Other Kind
LookupData LookupOtherKind = bizLookup.LoadLookupClassType(DataDefine.OTHER_KIND.ToNZString());
ReadOnlyPairCellType cellOtherKind1 = new ReadOnlyPairCellType(LookupOtherKind.Clone(), CommonLib.Common.COMBOBOX_SEPERATOR_SYMBOL);
shtItemView.Columns[(int)eColView.OTHER_TREATMENT1_KIND].CellType = cellOtherKind1;
ReadOnlyPairCellType cellOtherKind2 = new ReadOnlyPairCellType(LookupOtherKind.Clone(), CommonLib.Common.COMBOBOX_SEPERATOR_SYMBOL);
shtItemView.Columns[(int)eColView.OTHER_TREATMENT2_KIND].CellType = cellOtherKind2;
// Other Condition
LookupData LookupOtherCon = bizLookup.LoadLookupClassType(DataDefine.OTHER_CONDITION.ToNZString());
ReadOnlyPairCellType cellOtherCon1 = new ReadOnlyPairCellType(LookupOtherCon.Clone(), CommonLib.Common.COMBOBOX_SEPERATOR_SYMBOL);
shtItemView.Columns[(int)eColView.OTHER_TREATMENT1_CONDITION].CellType = cellOtherCon1;
ReadOnlyPairCellType cellOtherCon2 = new ReadOnlyPairCellType(LookupOtherCon.Clone(), CommonLib.Common.COMBOBOX_SEPERATOR_SYMBOL);
shtItemView.Columns[(int)eColView.OTHER_TREATMENT2_CONDITION].CellType = cellOtherCon2;
//shtItemView.Columns[(int)eColView.CRT_DATE].CellType = CtrlUtil.CreateDateTimeCellType();
//shtItemView.Columns[(int)eColView.UPD_DATE].CellType = CtrlUtil.CreateDateTimeCellType();
shtItemView.Columns[(int)eColView.HEAT_FLAG].CellType = CtrlUtil.CreateCheckboxCellType();
shtItemView.Columns[(int)eColView.HEAT_FLAG].HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Center;
shtItemView.Columns[(int)eColView.PLATING_FLAG].CellType = CtrlUtil.CreateCheckboxCellType();
shtItemView.Columns[(int)eColView.PLATING_FLAG].HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Center;
shtItemView.Columns[(int)eColView.BAKING_FLAG].CellType = CtrlUtil.CreateCheckboxCellType();
shtItemView.Columns[(int)eColView.BAKING_FLAG].HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Center;
shtItemView.Columns[(int)eColView.OTHER_TREATMENT1_FLAG].CellType = CtrlUtil.CreateCheckboxCellType();
shtItemView.Columns[(int)eColView.OTHER_TREATMENT1_FLAG].HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Center;
shtItemView.Columns[(int)eColView.OTHER_TREATMENT2_FLAG].CellType = CtrlUtil.CreateCheckboxCellType();
shtItemView.Columns[(int)eColView.OTHER_TREATMENT2_FLAG].HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Center;
FormatUtil.SetNumberFormat(shtItemView.Columns[(int)eColView.WEIGHT], FormatUtil.eNumberFormat.Qty_Gram);
FormatUtil.SetNumberFormat(shtItemView.Columns[(int)eColView.ITEM_CD], FormatUtil.eNumberFormat.MasterNo);
FormatUtil.SetDateTimeFormat(shtItemView.Columns[(int)eColView.CRT_DATE]);
FormatUtil.SetDateTimeFormat(shtItemView.Columns[(int)eColView.UPD_DATE]);
//// Lookup Item Type
//LookupData lookupItemType = bizLookup.LoadLookupClassType(DataDefine.ITEM_CLS.ToNZString());
//// Lookup Lot Control
//LookupData lookupLotControl = bizLookup.LoadLookupClassType(DataDefine.LOT_CONTROL_CLS.ToNZString());
//// Lookup Lot Customer
//LookupData lookupCustomer = bizLookup.LoadLookupLocation();// bizLookup.LoadLookupClassType(DataDefine.LOCATION_CLS.ToNZString());
//// Lookup OrderLoc
//LookupData lookupOrderLoc = bizLookup.LoadLookupLocation();
//// Lookup ORDER_PROCESS_CLS
//LookupData lookupOrderProcess = bizLookup.LoadLookupClassType(new NZString(null, DataDefine.ORDER_PROCESS_CLS));
//// Lookup StoreLoc
//LookupData lookupStoreLoc = bizLookup.LoadLookupLocation();
//// Lookup CustoemrLoc
//LookupData lookupCustoemrLoc = bizLookup.LoadLookupLocation();
//// Lookup Consumption
//LookupData lookupConsumption = bizLookup.LoadLookupClassType(new NZString(null, DataDefine.CONSUMPTION_CLS));
//// Lookup InventUM
//LookupData lookupInventUM = bizLookup.LoadLookupClassType(new NZString(null, DataDefine.UM_CLS));
//// Lookup OrderUM
//LookupData lookupOrderUM = bizLookup.LoadLookupClassType(new NZString(null, DataDefine.UM_CLS));
//ReadOnlyPairCellType ItemTypecellType = new ReadOnlyPairCellType(lookupItemType, CommonLib.Common.COMBOBOX_SEPERATOR_SYMBOL);
//ReadOnlyPairCellType LotControlcellType = new ReadOnlyPairCellType(lookupLotControl, CommonLib.Common.COMBOBOX_SEPERATOR_SYMBOL);
//ReadOnlyPairCellType CustomercellType = new ReadOnlyPairCellType(lookupCustomer, CommonLib.Common.COMBOBOX_SEPERATOR_SYMBOL);
//ReadOnlyPairCellType OrderProcess = new ReadOnlyPairCellType(lookupOrderProcess, CommonLib.Common.COMBOBOX_SEPERATOR_SYMBOL);
//ReadOnlyPairCellType OrderLoc = new ReadOnlyPairCellType(lookupOrderLoc, CommonLib.Common.COMBOBOX_SEPERATOR_SYMBOL);
//ReadOnlyPairCellType StoreLoc = new ReadOnlyPairCellType(lookupStoreLoc, CommonLib.Common.COMBOBOX_SEPERATOR_SYMBOL);
//ReadOnlyPairCellType CustoemrLoc = new ReadOnlyPairCellType(lookupCustoemrLoc, CommonLib.Common.COMBOBOX_SEPERATOR_SYMBOL);
//ReadOnlyPairCellType Consumption = new ReadOnlyPairCellType(lookupConsumption, CommonLib.Common.COMBOBOX_SEPERATOR_SYMBOL);
//ReadOnlyPairCellType InventUM = new ReadOnlyPairCellType(lookupInventUM, CommonLib.Common.COMBOBOX_SEPERATOR_SYMBOL);
//ReadOnlyPairCellType OrderUM = new ReadOnlyPairCellType(lookupOrderUM, CommonLib.Common.COMBOBOX_SEPERATOR_SYMBOL);
//shtItemView.Columns[(int)eColView.ORDER_UM_CLS1].CellType = OrderUM;
//shtItemView.Columns[(int)eColView.INV_UM_CLS1].CellType = InventUM;
//shtItemView.Columns[(int)eColView.STORE_LOC_CD1].CellType = StoreLoc;
//shtItemView.Columns[(int)eColView.ORDER_LOC_CD1].CellType = OrderLoc;
//shtItemView.Columns[(int)eColView.ORDER_PROCESS_CLS1].CellType = OrderProcess;
//shtItemView.Columns[(int)eColView.FOR_CUSTOMER1].CellType = CustomercellType;
//shtItemView.Columns[(int)eColView.LOT_CONTROL_CLS1].CellType = LotControlcellType;
//shtItemView.Columns[(int)eColView.ITEM_CLS].CellType = ItemTypecellType;
//shtItemView.Columns[(int)eColView.ITEM_CLS_MINOR1].CellType = CtrlUtil.CreateReadOnlyPairCellType(bizLookup.LoadLookupClassType((NZString)DataDefine.ITEM_CLS_MINOR04));
//shtItemView.Columns[(int)eColView.CONSUMTION_CLS1].CellType = Consumption;
}