//public SheetView SortingData { get { return m_SheetViewData; } }
#endregion
#region Handles and Overrides
private void AdvanceSearchDialog_Load(object sender, EventArgs e)
{
try
{
this.Cursor = Cursors.WaitCursor;
this.SuspendLayout();
shtQueryList.ActiveSkin = CommonLib.Common.ACTIVE_SKIN;
fpQueryList.Enabled = true;
shtQueryList.Columns[(int)eCol.ColumnIndex].Visible = false;
shtQueryList.Columns[(int)eCol.ColumnType].Visible = false;
CtrlUtil.SpreadSetColumnsLocked(shtQueryList, false, (int)eCol.Checkbox);
CtrlUtil.SpreadSetColumnsLocked(shtQueryList, true, (int)eCol.ColumnName);
CtrlUtil.SpreadSetColumnsLocked(shtQueryList, true, (int)eCol.Sign);
CtrlUtil.SpreadSetColumnsLocked(shtQueryList, true, (int)eCol.Value1);
CtrlUtil.SpreadSetColumnsLocked(shtQueryList, true, (int)eCol.Value2);
ShowColumnName();
// Add by Pongthorn S. @ 2012-05-18
//fpQueryList.KeyPress += CtrlUtil.SetRestrictKeyInput;
}
catch (Exception ex)
{
throw ex;
}
finally
{
this.ResumeLayout();
this.Cursor = Cursors.Default;
}
}
void m_keyboardSpread_RowAdded(object sender, int rowIndex)
{
// Unlock cells
//CtrlUtil.SpreadSetCellLocked(shtCustomerOrder, true, rowIndex, (int)eColCustomerOrder.PO_NO);
//CtrlUtil.SpreadSetCellLocked(shtCustomerOrder, true, rowIndex, (int)eColCustomerOrder.ORDER_NO);
//CtrlUtil.SpreadSetCellLocked(shtCustomerOrder, true, rowIndex, (int)eColCustomerOrder.ITEM_CD);
//CtrlUtil.SpreadSetCellLocked(shtCustomerOrder, true, rowIndex, (int)eColCustomerOrder.SHORT_NAME);
//CtrlUtil.SpreadSetCellLocked(shtCustomerOrder, true, rowIndex, (int)eColCustomerOrder.ITEM_DELIVERY_DATE);
//CtrlUtil.SpreadSetCellLocked(shtCustomerOrder, true, rowIndex, (int)eColCustomerOrder.REMAIN_QTY);
//CtrlUtil.SpreadSetCellLocked(shtCustomerOrder, true, rowIndex, (int)eColCustomerOrder.SHIP_QTY);
//CtrlUtil.SpreadSetCellLocked(shtCustomerOrder, true, rowIndex, (int)eColCustomerOrder.PRICE);
//CtrlUtil.SpreadSetCellLocked(shtCustomerOrder, true, rowIndex, (int)eColCustomerOrder.AMOUNT);
//CtrlUtil.SpreadSetCellLocked(shtCustomerOrder, false, rowIndex, (int)eColCustomerOrder.ChoosePart);
CtrlUtil.SpreadSetColumnsLocked(shtCustomerOrder, true, (int)eColView.PO_NO);
CtrlUtil.SpreadSetColumnsLocked(shtCustomerOrder, true, (int)eColView.ORDER_NO);
CtrlUtil.SpreadSetColumnsLocked(shtCustomerOrder, true, (int)eColView.ORDER_DETAIL_NO);
CtrlUtil.SpreadSetColumnsLocked(shtCustomerOrder, true, (int)eColView.ITEM_CD);
CtrlUtil.SpreadSetColumnsLocked(shtCustomerOrder, true, (int)eColView.SHORT_NAME);
CtrlUtil.SpreadSetColumnsLocked(shtCustomerOrder, false, (int)eColView.ITEM_DESC);
CtrlUtil.SpreadSetColumnsLocked(shtCustomerOrder, false, (int)eColView.UNIT);
CtrlUtil.SpreadSetColumnsLocked(shtCustomerOrder, false, (int)eColView.QTY);
CtrlUtil.SpreadSetColumnsLocked(shtCustomerOrder, false, (int)eColView.PRICE);
CtrlUtil.SpreadSetColumnsLocked(shtCustomerOrder, false, (int)eColView.AMOUNT);
//shtCustomerOrder.Cells[rowIndex, (int)eColView.ISSUE_QTY].Value = 0;
//shtCustomerOrder.Cells[rowIndex, (int)eColView.ONHAND_QTY].Value = 0;
//// DEFAULT LOT VALUE
//if (dtShipDate.Value.HasValue)
// shtCustomerOrder.Cells[shtCustomerOrder.Rows.Count - 1, (int)eColView.LOT_NO].Value = dtShipDate.Value.Value.ToString(DataDefine.LOT_NO_FORMAT);
}
private void InitialSpread()
{
shtIssueList.ActiveSkin = Common.ACTIVE_SKIN;
m_keyboardSpread = new KeyboardSpread(fpIssueList);
m_keyboardSpread.RowAdding += m_keyboardSpread_RowAdding;
m_keyboardSpread.RowAdded += m_keyboardSpread_RowAdded;
m_keyboardSpread.RowRemoved += m_keyboardSpread_RowRemoved;
if (m_Mode != eSaveMode.VIEW)
{
m_keyboardSpread.StartBind();
}
fpIssueList.SubEditorOpening += CtrlUtil.SpreadDisableSubEditorOpening;
string[] names = Enum.GetNames(typeof(eColView));
for (int i = 0; i < names.Length; i++)
{
shtIssueList.Columns[i].DataField = names[i];
CtrlUtil.SpreadSetColumnsLocked(shtIssueList, true, i);
}
if (m_Mode == eSaveMode.ADD || m_Mode == eSaveMode.UPDATE)
{
CtrlUtil.SpreadSetColumnsLocked(shtIssueList, false, (int)eColView.ISSUE_QTY);
}
if (m_Mode == eSaveMode.ADD)
{
CtrlUtil.SpreadSetColumnsLocked(shtIssueList, false, (int)eColView.LOT_NO);
CtrlUtil.SpreadSetColumnsLocked(shtIssueList, false, (int)eColView.LOT_BTN);
}
}
private void SetScreenMode(eScreenMode mode)
{
switch (mode)
{
case eScreenMode.ADD:
CtrlUtil.EnabledControl(true, dtWorkResultDate, cboShiftCls);
CtrlUtil.EnabledControl(true, txtItemCode, btnItemCode);
CtrlUtil.EnabledControl(false, txtPartNo, txtCustomerName);
CtrlUtil.EnabledControl(true, evoComboBox1, txtRemark);
CtrlUtil.EnabledControl(true, txtLotNo, btnGenerate);
CtrlUtil.EnabledControl(false, txtTotalQty);
m_keyboardSpread.StartBind();
shtView.OperationMode = OperationMode.Normal;
CtrlUtil.FocusControl(dtWorkResultDate);
CtrlUtil.SpreadSetColumnsLocked(shtView, false, (int)eColView.CHECKBOX);
CtrlUtil.SpreadSetColumnsLocked(shtView, true, (int)eColView.PACK_NO);
CtrlUtil.SpreadSetColumnsLocked(shtView, true, (int)eColView.LOT_NO);
CtrlUtil.SpreadSetColumnsLocked(shtView, true, (int)eColView.EXTERNAL_LOT_NO);
CtrlUtil.SpreadSetColumnsLocked(shtView, true, (int)eColView.ONHAND_QTY);
tsbSaveAndNew.Enabled = true;
tsbSaveAndClose.Enabled = true;
break;
}
m_screenMode = mode;
}
private void InitialData()
{
PackingEntryUIDM model = new PackingEntryUIDM();
shtView.DataSource = model.DATA_VIEW;
CtrlUtil.SpreadSetColumnsLocked(shtView, false, (int)eColView.LOT_NO);
CtrlUtil.SpreadSetColumnsLocked(shtView, false, (int)eColView.EXTERNAL_LOT_NO);
CtrlUtil.SpreadSetColumnsLocked(shtView, false, (int)eColView.QTY);
}
private void InitializeSpread()
{
shtView.ActiveSkin = Common.ACTIVE_SKIN;
CtrlUtil.MappingDataFieldWithEnum(shtView, typeof(eColumns));
CtrlUtil.SpreadSetColumnsLocked(shtView, true, (int)eColumns.LOT_NO);
CtrlUtil.SpreadSetColumnsLocked(shtView, true, (int)eColumns.ON_HAND_QTY);
}
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;
CtrlUtil.MappingDataFieldWithEnum(shtView, typeof(eColumns));
string[] names = Enum.GetNames(typeof(eColumns));
for (int i = 0; i < names.Length; i++)
{
shtView.Columns[i].DataField = names[i];
CtrlUtil.SpreadSetColumnsLocked(shtView, true, i);
}
CtrlUtil.SpreadSetColumnsLocked(shtView, false, (int)eColumns.EDIT_FLAG);
}
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();
}
private void InitialSpread()
{
shtView.ActiveSkin = Common.ACTIVE_SKIN;
CtrlUtil.MappingDataFieldWithEnum(shtView, typeof(eColumns));
shtView.OperationMode = OperationMode.Normal;
shtView.Columns[(int)eColumns.CHECK_FLAG].CellType = CtrlUtil.CreateCheckboxCellType();
shtView.Columns[(int)eColumns.CHECK_FLAG].HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Center;
CtrlUtil.SpreadSetColumnsLocked(shtView, false, (int)eColumns.CHECK_FLAG);
CtrlUtil.SpreadSetColumnsLocked(shtView, true, (int)eColumns.LAST_RECEIVE_DATE);
CtrlUtil.SpreadSetColumnsLocked(shtView, true, (int)eColumns.PACK_NO);
CtrlUtil.SpreadSetColumnsLocked(shtView, true, (int)eColumns.FG_NO);
CtrlUtil.SpreadSetColumnsLocked(shtView, true, (int)eColumns.LOT_NO);
CtrlUtil.SpreadSetColumnsLocked(shtView, true, (int)eColumns.EXTERNAL_LOT_NO);
CtrlUtil.SpreadSetColumnsLocked(shtView, true, (int)eColumns.ONHAND_QTY);
fpView.ContextMenuStrip = null;
fpView.SubEditorOpening += CtrlUtil.SpreadDisableSubEditorOpening;
}
private void InitialSpread()
{
shtView.ActiveSkin = Common.ACTIVE_SKIN;
//m_keyboardSpread = new KeyboardSpread(fpView);
//m_keyboardSpread.RowAdding += m_keyboardSpread_RowAdding;
//m_keyboardSpread.RowAdded += m_keyboardSpread_RowAdded;
//m_keyboardSpread.RowRemoved += m_keyboardSpread_RowRemoved;
//if (m_screenMode != Common.eScreenMode.VIEW)
// m_keyboardSpread.StartBind();
//fpNGInfo.SubEditorOpening += CtrlUtil.SpreadDisableSubEditorOpening;
//CtrlUtil.MappingDataFieldWithEnum(shtView, typeof(eNGInfoCol));
//fpCustomerOrderList.LeaveCell += new LeaveCellEventHandler(fpView_LeaveCell);
//fpCustomerOrderList.SubEditorOpening += CtrlUtil.SpreadDisableSubEditorOpening;
CtrlUtil.MappingDataFieldWithEnum(shtView, typeof(eColumns));
string[] names = Enum.GetNames(typeof(eColumns));
for (int i = 0; i < names.Length; i++)
{
shtView.Columns[i].DataField = names[i];
CtrlUtil.SpreadSetColumnsLocked(shtView, true, i);
}
CtrlUtil.SpreadSetColumnsLocked(shtView, false, (int)eColumns.EDIT_FLAG);
//if (m_screenMode == Common.eScreenMode.ADD || m_screenMode == Common.eScreenMode.EDIT)
//{
// CtrlUtil.SpreadSetColumnsLocked(shtCustomerOrderList, false, (int)eColView.ITEM_CD_BTN);
// CtrlUtil.SpreadSetColumnsLocked(shtCustomerOrderList, false, (int)eColView.ITEM_DELIVERY_DATE);
// CtrlUtil.SpreadSetColumnsLocked(shtCustomerOrderList, false, (int)eColView.QTY);
//}
//if (m_screenMode == Common.eScreenMode.ADD)
//{
// CtrlUtil.SpreadSetColumnsLocked(shtCustomerOrderList, false, (int)eColView.ITEM_CD_BTN);
// CtrlUtil.SpreadSetColumnsLocked(shtCustomerOrderList, false, (int)eColView.ITEM_DELIVERY_DATE);
// CtrlUtil.SpreadSetColumnsLocked(shtCustomerOrderList, false, (int)eColView.QTY);
//}
}
private void SetScreenMode(Common.eScreenMode mode)
{
switch (mode)
{
case Common.eScreenMode.VIEW:
CtrlUtil.EnabledControl(false, txtInvoiceNo, txtPONo, txtRemark, fpView);
CtrlUtil.EnabledControl(false, dtReceiveDate, rdoReceive, rdoReceiveReturn);
CtrlUtil.EnabledControl(false, txtInvoiceNo, txtPONo, txtRemark, cboStoredLoc, cboSupplierCode);
tsbSaveAndNew.Enabled = false;
tsbSaveAndClose.Enabled = false;
shtView.OperationMode = OperationMode.ReadOnly;
CtrlUtil.SpreadSetColumnsLocked(shtView, true, (int)eColView.ORDER_QTY);
CtrlUtil.SpreadSetColumnsLocked(shtView, true, (int)eColView.SUPP_LOT_NO);
CtrlUtil.SpreadSetColumnsLocked(shtView, true, (int)eColView.PRICE);
fpView.ContextMenuStrip = null;
break;
case Common.eScreenMode.ADD:
CtrlUtil.EnabledControl(true, dtReceiveDate, txtInvoiceNo, txtPONo
, txtRemark, fpView, rdoReceiveReturn, rdoReceive, cboSupplierCode, cboStoredLoc);
//m_keyboardSpread.StartBind();
break;
case Common.eScreenMode.EDIT:
CtrlUtil.EnabledControl(true, fpView);
CtrlUtil.EnabledControl(false, dtReceiveDate, rdoReceive, rdoReceiveReturn, cboStoredLoc, cboSupplierCode);
CtrlUtil.EnabledControl(true, txtInvoiceNo, txtPONo, txtRemark);
CtrlUtil.SpreadSetColumnsLocked(shtView, false, (int)eColView.ORDER_QTY);
CtrlUtil.SpreadSetColumnsLocked(shtView, false, (int)eColView.SUPP_LOT_NO);
CtrlUtil.SpreadSetColumnsLocked(shtView, false, (int)eColView.PRICE);
//m_keyboardSpread.StartBind();
break;
}
m_screenMode = mode;
}
private void SetScreenMode(Common.eScreenMode mode)
{
switch (mode)
{
case Common.eScreenMode.ADD:
CtrlUtil.EnabledControl(true, txtDeliveryNo, cboAddress, txtInvoiceNo,
dtInvoiceDate, cboTermOfPayment, dtPaymentDueDate,
txtReferTemNo, txtRemark, txtVat, txtVatTotal);
CtrlUtil.EnabledControl(false, cboCustomerCode, txtFullAddress, txtSubTotal, txtTotal);
shtCustomerOrder.OperationMode = OperationMode.Normal;
CtrlUtil.SpreadSetColumnsLocked(shtCustomerOrder, true, (int)eColView.PO_NO);
CtrlUtil.SpreadSetColumnsLocked(shtCustomerOrder, true, (int)eColView.ORDER_NO);
CtrlUtil.SpreadSetColumnsLocked(shtCustomerOrder, true, (int)eColView.ORDER_DETAIL_NO);
CtrlUtil.SpreadSetColumnsLocked(shtCustomerOrder, true, (int)eColView.ITEM_CD);
CtrlUtil.SpreadSetColumnsLocked(shtCustomerOrder, true, (int)eColView.SHORT_NAME);
CtrlUtil.SpreadSetColumnsLocked(shtCustomerOrder, false, (int)eColView.ITEM_DESC);
CtrlUtil.SpreadSetColumnsLocked(shtCustomerOrder, false, (int)eColView.UNIT);
CtrlUtil.SpreadSetColumnsLocked(shtCustomerOrder, false, (int)eColView.QTY);
CtrlUtil.SpreadSetColumnsLocked(shtCustomerOrder, false, (int)eColView.PRICE);
CtrlUtil.SpreadSetColumnsLocked(shtCustomerOrder, false, (int)eColView.AMOUNT);
break;
case Common.eScreenMode.EDIT:
CtrlUtil.EnabledControl(false, txtDeliveryNo, cboAddress, txtInvoiceNo,
dtInvoiceDate, cboTermOfPayment, dtPaymentDueDate,
txtVat, cboCustomerCode, txtFullAddress, txtSubTotal);
CtrlUtil.EnabledControl(true, txtReferTemNo, txtRemark, txtVatTotal, txtTotal);
shtCustomerOrder.OperationMode = OperationMode.Normal;
CtrlUtil.SpreadSetColumnsLocked(shtCustomerOrder, true, (int)eColView.PO_NO);
CtrlUtil.SpreadSetColumnsLocked(shtCustomerOrder, true, (int)eColView.ORDER_NO);
CtrlUtil.SpreadSetColumnsLocked(shtCustomerOrder, true, (int)eColView.ORDER_DETAIL_NO);
CtrlUtil.SpreadSetColumnsLocked(shtCustomerOrder, true, (int)eColView.ITEM_CD);
CtrlUtil.SpreadSetColumnsLocked(shtCustomerOrder, true, (int)eColView.SHORT_NAME);
CtrlUtil.SpreadSetColumnsLocked(shtCustomerOrder, false, (int)eColView.ITEM_DESC);
CtrlUtil.SpreadSetColumnsLocked(shtCustomerOrder, false, (int)eColView.UNIT);
CtrlUtil.SpreadSetColumnsLocked(shtCustomerOrder, false, (int)eColView.QTY);
CtrlUtil.SpreadSetColumnsLocked(shtCustomerOrder, false, (int)eColView.PRICE);
CtrlUtil.SpreadSetColumnsLocked(shtCustomerOrder, false, (int)eColView.AMOUNT);
break;
case Common.eScreenMode.VIEW:
shtCustomerOrder.OperationMode = OperationMode.ReadOnly;
CtrlUtil.EnabledControl(false, txtDeliveryNo, cboAddress, txtInvoiceNo,
dtInvoiceDate, cboTermOfPayment, dtPaymentDueDate,
txtVat, cboCustomerCode, txtFullAddress, txtSubTotal);
CtrlUtil.EnabledControl(false, txtReferTemNo, txtRemark, txtVatTotal, txtTotal);
shtCustomerOrder.OperationMode = OperationMode.ReadOnly;
CtrlUtil.SpreadSetColumnsLocked(shtCustomerOrder, true, (int)eColView.PO_NO);
CtrlUtil.SpreadSetColumnsLocked(shtCustomerOrder, true, (int)eColView.ORDER_NO);
CtrlUtil.SpreadSetColumnsLocked(shtCustomerOrder, true, (int)eColView.ORDER_DETAIL_NO);
CtrlUtil.SpreadSetColumnsLocked(shtCustomerOrder, true, (int)eColView.ITEM_CD);
CtrlUtil.SpreadSetColumnsLocked(shtCustomerOrder, true, (int)eColView.SHORT_NAME);
CtrlUtil.SpreadSetColumnsLocked(shtCustomerOrder, true, (int)eColView.ITEM_DESC);
CtrlUtil.SpreadSetColumnsLocked(shtCustomerOrder, true, (int)eColView.UNIT);
CtrlUtil.SpreadSetColumnsLocked(shtCustomerOrder, true, (int)eColView.QTY);
CtrlUtil.SpreadSetColumnsLocked(shtCustomerOrder, true, (int)eColView.PRICE);
CtrlUtil.SpreadSetColumnsLocked(shtCustomerOrder, true, (int)eColView.AMOUNT);
fpCustomerOrder.ContextMenuStrip = null;
tsbSaveAndClose.Enabled = false;
tsbSaveAndNew.Enabled = false;
break;
}
m_Mode = mode;
}