private void LoadData(NZDateTime dtPeriod, string keyFilter)
{
try
{
//== Start to search data.
InventoryOnhandController ctlInvent = new InventoryOnhandController();
//== 20091203 Add by Teerayt S.
//NZString yearMonth = GetLatestYearMonthInInvOnhand();
NZString yearMonth = dtMonth.Value.Value.ToString("yyyyMM").ToNZString();
//== 20091203 End Add by Teerayt S.
//List<InventorySummaryViewDTO> dtoView = ctlInvent.LoadInventorySummary(yearMonth);
//m_dtAllData = DTOUtility.ConvertListToDataTable(dtoView);
m_dtAllData = ctlInvent.LoadInventorySummary(yearMonth);
FindDataFromMemory(keyFilter);
CtrlUtil.SpreadUpdateColumnSorting(shtInventorySummary);
}
catch (Exception ex)
{
MessageDialog.ShowBusiness(this, ex.Message);
}
}
private void LoadData(NZDateTime from, NZDateTime to)
{
if (dtPeriodBegin.NZValue.IsNull || dtPeriodEnd.NZValue.IsNull)
{
if (dtPeriodBegin.NZValue.IsNull && dtPeriodEnd.NZValue.IsNull)
{
MessageDialog.ShowBusiness(this, Message.LoadMessage(TKPMessages.eValidate.VLM0105.ToString(), new object[] { "Return date begin and Delivery date end" }));
}
else if (dtPeriodBegin.NZValue.IsNull)
{
MessageDialog.ShowBusiness(this, Message.LoadMessage(TKPMessages.eValidate.VLM0105.ToString(), new object[] { "Return date begin" }));
}
else
{
MessageDialog.ShowBusiness(this, Message.LoadMessage(TKPMessages.eValidate.VLM0105.ToString(), new object[] { "Return date end" }));
}
return;
}
DataTable dt = m_controller.Load_ReturnProductionList(from, to, false);
//DataTable dt = DTOUtility.ConvertListToDataTable(list);
m_dtAllData = dt;
shtReturnProductList.RowCount = 0;
shtReturnProductList.DataSource = null;
FindDataFromMemory();
//shtReturnProductList.DataSource = m_dtAllData;
CtrlUtil.SpreadUpdateColumnSorting(shtReturnProductList);
}
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);
}
private void LoadData()
{
List <InventoryMovementInqUIDM> listModel = null;
//if (m_lotNo.StrongValue == Common.LOT_NO_GROUPBY)
if (m_QueryType == 1)//Query Type = 1 แปลว่า Group ตาม Item
{
// Load all movement.
listModel = m_inventoryMovementInqController.LoadDataInventoryMovementInquiry(YearMonth, PeriodBeginDate, PeriodEndDate, ItemCode, WareHouseCode, m_lotNo);
}
else
{
// Load movement only LotNo.
listModel = m_inventoryMovementInqController.LoadDataInventorymovementInquiryByLotNo(YearMonth, PeriodBeginDate, PeriodEndDate, ItemCode, WareHouseCode, m_lotNo, m_packNo);
}
DataTable dataTable = DTOUtility.ConvertListToDataTable(listModel);
shtView.DataSource = dataTable;
if (dataTable.Rows.Count > 0)
{
shtView.Cells[0, (int)eColView.TRANS_INFO].CellType = new FarPoint.Win.Spread.CellType.TextCellType();
txtOnHandQty.Text = CtrlUtil.GetCompleteNumberFormatValue(txtOnHandQty.MaxDecimalPlaces, listModel[listModel.Count - 1].BALANCE);// listModel[listModel.Count - 1].BALANCE.StrongValue.ToString();
}
else
{
txtOnHandQty.PathValue = 0;
}
CtrlUtil.SpreadUpdateColumnSorting(shtView);
}
private void FindDataFromMemory()
{
//CtrlUtil.FilterRestrictChar(txtSearch);
shtDelivery.DataSource = FilterData(m_AllShipTransData, txtSearch.Text);
CtrlUtil.SpreadUpdateColumnSorting(shtDelivery);
CalTotatValue();
}
private void FindDataFromMemory()
{
shtView.DataSource = FilterData(m_dtShown, txtSearch.Text);
CtrlUtil.SpreadUpdateColumnSorting(shtView);
SetSpreadBGColor();
SetContextMenu();
}
private void FindDataFromMemory()
{
//CtrlUtil.FilterRestrictChar(txtSearch);
shtView.RowCount = 0;
shtView.ColumnCount = 0;
shtView.DataSource = FilterData(m_dtLog, txtSearch.Text);
CtrlUtil.SpreadUpdateColumnSorting(shtView);
}
private void LoadData(bool LimitRow)
{
MachineBIZ biz = new MachineBIZ();
m_dtView = biz.LoadMachineList();
shtView.RowCount = 0;
shtView.DataSource = FilterData(m_dtView, txtFind.Text.Trim());
CtrlUtil.SpreadUpdateColumnSorting(shtView);
}
private void FindDataFromMemory()
{
if (m_dtAllData == null)
{
return;
}
shtView.DataSource = FilterData(m_dtAllData, txtFilter.Text);
CtrlUtil.SpreadUpdateColumnSorting(shtView);
}
private void LoadData(NZDateTime from, NZDateTime to)
{
//List<InventoryTransactionViewDTO> list = m_controller.LoadReceivingList(from, to);
//DataTable dt = DTOUtility.ConvertListToDataTable(list);
m_dtAllData = m_controller.LoadProductionReportList(from, to);
shtProductionReportList.RowCount = 0;
shtProductionReportList.DataSource = null;
FindDataFromMemory();
//shtProductionReportList.DataSource = m_dtAllData;
CtrlUtil.SpreadUpdateColumnSorting(shtProductionReportList);
}
private void InitializeScreen()
{
shtView.ActiveSkin = CommonLib.Common.ACTIVE_SKIN;
InitialFormat();
LoadLookupCellType();
CtrlUtil.MappingDataFieldWithEnum(shtView, typeof(eColView));
CtrlUtil.SpreadUpdateColumnSorting(shtView);
shtView.Columns[(int)eColView.CURRENCY_NAME].Visible = false;
LoadData(false);
}
private void LoadData(NZDateTime dtmFrom, NZDateTime dtmTo)
{
DataTable dt = m_BIZDemandOrder.LoadDemandOrderInRange(dtPeriodBegin.NZValue, dtPeriodEnd.NZValue);
m_dtAllData = dt;
shtView.DataSource = m_dtAllData;
ClearSpread();
FindDataFromMemory();
//shtView.DataSource = m_dtAllData;
CtrlUtil.SpreadUpdateColumnSorting(shtView);
}
private void LoadData(NZDateTime dtmFrom, NZDateTime dtmTo)
{
MRPBIZ biz = new MRPBIZ();
DataTable dt = biz.LoadMRPList(dtmFrom, dtmTo);
m_dtAllData = dt;
shtView.DataSource = m_dtAllData;
ClearSpread();
FindDataFromMemory();
//shtView.DataSource = m_dtAllData;
CtrlUtil.SpreadUpdateColumnSorting(shtView);
}
private void DeleteItem(NZString transactionID)
{
if (MessageDialog.ShowConfirmation(this, Message.LoadMessage(Messages.eConfirm.CFM9002.ToString()), MessageDialogButtons.YesNo) == MessageDialogResult.No)
{
return;
}
InventoryBIZ biz = new InventoryBIZ();
biz.DeleteInventoryTransaction(Common.CurrentDatabase, transactionID);
//LoadData(dtPeriodBegin.NZValue, dtPeriodEnd.NZValue);
shtView.RemoveRows(shtView.ActiveRowIndex, 1);
CtrlUtil.SpreadUpdateColumnSorting(shtView);
}
private void InitialScreen()
{
// add search button
tsbSearch = new ToolStripButton("Refresh");
tsbSearch.Image = Forms.Properties.Resources.REFRESH;
tslControl.Items.Insert(0, tsbSearch);
tsbSearch.Click += tsbSearch_Click;
shtInventorySummary.ActiveSkin = Common.ACTIVE_SKIN;
CtrlUtil.MappingDataFieldWithEnum(this.shtInventorySummary, typeof(eColView));
for (int i = 0; i < shtInventorySummary.Columns.Count; i++)
{
CtrlUtil.SpreadSetColumnsLocked(shtInventorySummary, true, i);
}
CtrlUtil.SpreadUpdateColumnSorting(shtInventorySummary);
//LookupDataBIZ bizLookup = new LookupDataBIZ();
//LookupData umClsLookup = bizLookup.LoadLookupClassType((NZString)DataDefine.UM_CLS);
//shtView.Columns[(int)eColView.INV_UM_CLS].CellType = CtrlUtil.CreateReadOnlyPairCellType(umClsLookup);
//LookupData itemClsLookup = bizLookup.LoadLookupClassType((NZString)DataDefine.ITEM_CLS);
//shtView.Columns[(int)eColView.ITEM_CLS].CellType = CtrlUtil.CreateReadOnlyPairCellType(itemClsLookup);
//LookupData itemClsMinorLookup = bizLookup.LoadLookupClassType((NZString)DataDefine.ITEM_CLS_MINOR04);
//shtView.Columns[(int)eColView.ITEM_CLS_MINOR].CellType = CtrlUtil.CreateReadOnlyPairCellType(itemClsMinorLookup);
//LookupData locCustomer = bizLookup.LoadLookupLocation();
//shtView.Columns[(int)eColView.FOR_CUSTOMER].CellType = CtrlUtil.CreateReadOnlyPairCellType(locCustomer);
switch (Common.CurrentUserInfomation.DateFormat)
{
case eDateFormat.YMD:
dtMonth.Format = "yyyy/MM";
break;
case eDateFormat.MDY:
case eDateFormat.DMY:
dtMonth.Format = "MM/yyyy";
break;
}
LoadDefaultPeriod();
}
public override void OnRefresh()
{
// ค้นหา PO ตามเงื่อนไข
DateTime dtmBegin = Convert.ToDateTime(dtPeriodBegin.Value);
DateTime dtmEnd = Convert.ToDateTime(dtPeriodEnd.Value);
bool bIncludeCancelPO = chkIncludeCancel.Checked;
DataTable dtSearchData = m_BizPurchaseOrder.LoadPurchaseOrderDByPONoWithCriteria(dtmBegin, dtmEnd, bIncludeCancelPO);
m_dtShown = dtSearchData;
shtView.RowCount = 0;
// Filter ข้อมูลตาม textbox
shtView.DataSource = FilterData(m_dtShown, txtSearch.Text);
CtrlUtil.SpreadUpdateColumnSorting(shtView);
SetSpreadBGColor();
SetContextMenu();
}
private void FindDataFromMemory()
{
//CtrlUtil.FilterRestrictChar(txtSearch);
shtView.DataSource = FilterData(m_dtAllData, txtSearch.Text);
CtrlUtil.SpreadUpdateColumnSorting(shtView);
if (shtView.DataSource == null)
{
shtView.Rows.Count = 0;
}
if (shtView.Rows.Count == 0)
{
ctxMenu.Enabled = false;
}
else
{
ctxMenu.Enabled = true;
}
}
private void LoadItemData(string keyFilter)
{
try
{
ItemBIZ biz = new ItemBIZ();
m_dtAllData = biz.LoadItemList();
DataTable dtView = null;// m_dtAllData.Clone();
if (keyFilter != string.Empty)
{
string filterString = FilterStringUtil.GetFilterstring(typeof(eColView), keyFilter);
DataView dv = m_dtAllData.DefaultView;
dv.RowFilter = filterString;
dtView = dv.ToTable();
////get only the rows you want
//DataRow[] results = m_dtAllData.Select(filterString);
////populate new destination table
//foreach (DataRow dr in results)
// dtView.ImportRow(dr);
}
else
{
//foreach (DataRow dr in m_dtAllData.Rows)
// dtView.ImportRow(dr);
dtView = m_dtAllData.Copy();
}
fpItemView.DataSource = dtView;
CtrlUtil.SpreadUpdateColumnSorting(shtItemView);
}
catch (Exception ex)
{
MessageDialog.ShowBusiness(this, ex.Message);
}
}
private void FindDataFromMemory()
{
//CtrlUtil.FilterRestrictChar(txtSearch);
shtView.DataSource = FilterData(m_AllIssueTransData, txtSearch.Text);
CtrlUtil.SpreadUpdateColumnSorting(shtView);
}
private void FindDataFromMemory()
{
shtMovePartList.DataSource = FilterData(m_dtAllData, txtSearch.Text);
CtrlUtil.SpreadUpdateColumnSorting(shtMovePartList);
}
private void LoadData(NZDateTime FromPeriod, NZDateTime ToPeriod, string keyFilter, bool validate)
{
try
{
if (validate)
{
if (chkToEndMonth.Checked)
{
// Validate period date before search data.
InventoryOnhandInquiryValidator validator = new InventoryOnhandInquiryValidator();
try
{
validator.ValidatePeriodDateRange(FromPeriod, ToPeriod);
}
catch (ValidateException err)
{
MessageDialog.ShowBusiness(this, err.ErrorResults[0].Message);
err.ErrorResults[0].FocusOnControl();
return;
}
}
}
//== Start to search data.
InventoryOnhandController ctlInvent = new InventoryOnhandController();
bool GroupByItem = rdoGroupItem.Checked;
int iToEndOfMonth = 1;
if (chkToEndMonth.Checked)
{
iToEndOfMonth = 0;
}
else
{
iToEndOfMonth = 1;
}
//== 20091203 Add by Teerayt S.
//NZString yearMonth = GetLatestYearMonthInInvOnhand();
//InventoryPeriodBIZ biz = new InventoryPeriodBIZ();
//InventoryPeriodDTO dtoPeriod = biz.LoadCurrentPeriod();
NZString yearMonth = dtPeriodBegin.Value.Value.ToString("yyyyMM").ToNZString(); //dtoPeriod.YEAR_MONTH;
//== 20091203 End Add by Teerayt S.
List <InventoryOnhandInquiryViewDTO> dtoView = ctlInvent.LoadInventoryOnhand(yearMonth, FromPeriod, ToPeriod, GroupByItem, iToEndOfMonth);
m_dtAllData = DTOUtility.ConvertListToDataTable(dtoView);
DataTable dtView = m_dtAllData.Clone();
if (keyFilter != string.Empty)
{
string filterString = string.Format(@"
(
LOCATION LIKE '%{0}%' OR
ITEM_CODE LIKE '%{0}%' OR
CUSTOMER_CD LIKE '%{0}%' OR
LOT_NO LIKE '%{0}%' OR
PACK_NO LIKE '%{0}%' OR
EXTERNAL_LOT_NO LIKE '%{0}%' OR
SHORT_NAME LIKE '%{0}%' OR
LAST_RECEIVE_DATE = #{0:dd/MM/yyyy}#
)", keyFilter);
if (!chkZeroQty.Checked)
{
filterString = filterString + " AND ONHAND_QTY <> 0 ";
}
//get only the rows you want
DataRow[] results = m_dtAllData.Select(filterString, @"LOCATION,ITEM_CODE,LOT_NO,PACK_NO,EXTERNAL_LOT_NO");
//populate new destination table
foreach (DataRow dr in results)
{
dtView.ImportRow(dr);
}
}
else
{
if (!chkZeroQty.Checked)
{
string filterString = " ONHAND_QTY <> 0 ";
//get only the rows you want
DataRow[] results = m_dtAllData.Select(filterString, @"LOCATION,ITEM_CODE,LOT_NO,PACK_NO,EXTERNAL_LOT_NO");
//populate new destination table
foreach (DataRow dr in results)
{
dtView.ImportRow(dr);
}
}
else
{
foreach (DataRow dr in m_dtAllData.Rows)
{
dtView.ImportRow(dr);
}
}
}
fpView.DataSource = dtView;
CtrlUtil.SpreadUpdateColumnSorting(shtView);
}
catch (Exception ex)
{
MessageDialog.ShowBusiness(this, ex.Message);
}
}
private void FindDataFromMemory()
{
//CtrlUtil.FilterRestrictChar(txtFind);
shtView.DataSource = FilterData(m_dtView, txtFind.Text.Trim());
CtrlUtil.SpreadUpdateColumnSorting(shtView);
}
private void FindDataFromMemory()
{
//CtrlUtil.FilterRestrictChar(txtSearch);
shtReturnProductList.DataSource = FilterData(m_dtAllData, txtSearch.Text);
CtrlUtil.SpreadUpdateColumnSorting(shtReturnProductList);
}
private void InitialSpread()
{
LoadLookupCellType();
#region No Export Column
shtItemView.Columns[(int)eColView.KIND_OF_PRODUCT_NAME].StyleName = DataDefine.NO_EXPORT.ToString();
shtItemView.Columns[(int)eColView.BOI_NAME].StyleName = DataDefine.NO_EXPORT.ToString();
shtItemView.Columns[(int)eColView.PRODUCTION_DI_NAME].StyleName = DataDefine.NO_EXPORT.ToString();
shtItemView.Columns[(int)eColView.ITEM_LEVEL_NAME].StyleName = DataDefine.NO_EXPORT.ToString();
shtItemView.Columns[(int)eColView.KIND_OF_MAT_NAME].StyleName = DataDefine.NO_EXPORT.ToString();
shtItemView.Columns[(int)eColView.MAT_DI_NAME].StyleName = DataDefine.NO_EXPORT.ToString();
shtItemView.Columns[(int)eColView.SCREW_KIND_NAME].StyleName = DataDefine.NO_EXPORT.ToString();
shtItemView.Columns[(int)eColView.SCREW_HEAD_NAME].StyleName = DataDefine.NO_EXPORT.ToString();
shtItemView.Columns[(int)eColView.SCREW_TYPE_NAME].StyleName = DataDefine.NO_EXPORT.ToString();
shtItemView.Columns[(int)eColView.SCREW_REMARK1_NAME].StyleName = DataDefine.NO_EXPORT.ToString();
shtItemView.Columns[(int)eColView.SCREW_REMARK2_NAME].StyleName = DataDefine.NO_EXPORT.ToString();
shtItemView.Columns[(int)eColView.MACHINE_TYPE1_NAME].StyleName = DataDefine.NO_EXPORT.ToString();
shtItemView.Columns[(int)eColView.MACHINE_TYPE2_NAME].StyleName = DataDefine.NO_EXPORT.ToString();
shtItemView.Columns[(int)eColView.MACHINE_TYPE3_NAME].StyleName = DataDefine.NO_EXPORT.ToString();
shtItemView.Columns[(int)eColView.MACHINE_TYPE4_NAME].StyleName = DataDefine.NO_EXPORT.ToString();
shtItemView.Columns[(int)eColView.MACHINE_TYPE5_NAME].StyleName = DataDefine.NO_EXPORT.ToString();
shtItemView.Columns[(int)eColView.MACHINE_TYPE6_NAME].StyleName = DataDefine.NO_EXPORT.ToString();
shtItemView.Columns[(int)eColView.HEAT_TYPE_NAME].StyleName = DataDefine.NO_EXPORT.ToString();
shtItemView.Columns[(int)eColView.PLATING_KTC_NAME].StyleName = DataDefine.NO_EXPORT.ToString();
shtItemView.Columns[(int)eColView.BAKING_TIME_NAME].StyleName = DataDefine.NO_EXPORT.ToString();
shtItemView.Columns[(int)eColView.BAKING_TEMP_NAME].StyleName = DataDefine.NO_EXPORT.ToString();
shtItemView.Columns[(int)eColView.OTHER_TREATMENT1_KIND_NAME].StyleName = DataDefine.NO_EXPORT.ToString();
shtItemView.Columns[(int)eColView.OTHER_TREATMENT2_KIND_NAME].StyleName = DataDefine.NO_EXPORT.ToString();
#endregion
#region visible column
shtItemView.Columns[(int)eColView.CUSTOMER_NAME].Visible = false;
shtItemView.Columns[(int)eColView.BOI_NAME].Visible = false;
shtItemView.Columns[(int)eColView.PRODUCTION_DI_NAME].Visible = false;
shtItemView.Columns[(int)eColView.KIND_OF_PRODUCT_NAME].Visible = false;
shtItemView.Columns[(int)eColView.ITEM_LEVEL_NAME].Visible = false;
shtItemView.Columns[(int)eColView.MAT_SUPPLIER_NAME].Visible = false;
shtItemView.Columns[(int)eColView.KIND_OF_MAT_NAME].Visible = false;
shtItemView.Columns[(int)eColView.MAT_DI_NAME].Visible = false;
shtItemView.Columns[(int)eColView.SCREW_KIND_NAME].Visible = false;
shtItemView.Columns[(int)eColView.SCREW_HEAD_NAME].Visible = false;
shtItemView.Columns[(int)eColView.SCREW_TYPE_NAME].Visible = false;
shtItemView.Columns[(int)eColView.SCREW_REMARK1_NAME].Visible = false;
shtItemView.Columns[(int)eColView.SCREW_REMARK2_NAME].Visible = false;
shtItemView.Columns[(int)eColView.MACHINE_TYPE1_NAME].Visible = false;
shtItemView.Columns[(int)eColView.MACHINE_TYPE2_NAME].Visible = false;
shtItemView.Columns[(int)eColView.MACHINE_TYPE3_NAME].Visible = false;
shtItemView.Columns[(int)eColView.MACHINE_TYPE4_NAME].Visible = false;
shtItemView.Columns[(int)eColView.MACHINE_TYPE5_NAME].Visible = false;
shtItemView.Columns[(int)eColView.MACHINE_TYPE6_NAME].Visible = false;
shtItemView.Columns[(int)eColView.PROCESS1_NAME].Visible = false;
shtItemView.Columns[(int)eColView.PROCESS2_NAME].Visible = false;
shtItemView.Columns[(int)eColView.PROCESS3_NAME].Visible = false;
shtItemView.Columns[(int)eColView.PROCESS4_NAME].Visible = false;
shtItemView.Columns[(int)eColView.PROCESS5_NAME].Visible = false;
shtItemView.Columns[(int)eColView.PROCESS6_NAME].Visible = false;
shtItemView.Columns[(int)eColView.HEAT_TYPE_NAME].Visible = false;
shtItemView.Columns[(int)eColView.PLATING_KTC_NAME].Visible = false;
shtItemView.Columns[(int)eColView.PLATING_SUPPLIER_CD_NAME].Visible = false;
shtItemView.Columns[(int)eColView.BAKING_TIME_NAME].Visible = false;
shtItemView.Columns[(int)eColView.BAKING_TEMP_NAME].Visible = false;
shtItemView.Columns[(int)eColView.OTHER_TREATMENT1_KIND_NAME].Visible = false;
shtItemView.Columns[(int)eColView.OTHER_TREATMENT1_CONDITION_NAME].Visible = false;
shtItemView.Columns[(int)eColView.OTHER_TREATMENT2_KIND_NAME].Visible = false;
shtItemView.Columns[(int)eColView.OTHER_TREATMENT2_CONDITION_NAME].Visible = false;
#endregion
CtrlUtil.MappingDataFieldWithEnum(shtItemView, typeof(eColView));
CtrlUtil.SpreadUpdateColumnSorting(shtItemView);
}