public MyGridControl12()
{
InitializeComponent();
gridView = this.gridView1;
gridControl = this.gridControl1;
MyDevExpressFunctions.InitGridControl(this.gridView1, 0);
gridView.Columns.Add(new DevExpress.XtraGrid.Columns.GridColumn()
{
FieldName = "Checked", Caption = "Checked", Visible = true, Width = 50
});
gridView.Columns.Add(new DevExpress.XtraGrid.Columns.GridColumn()
{
FieldName = "Count", Caption = "Count", Visible = true, Width = 50
});
gridView.Columns.Add(new DevExpress.XtraGrid.Columns.GridColumn()
{
FieldName = "Name", Caption = "Name", Visible = true, Width = 50
});
gridView.Columns.Add(new DevExpress.XtraGrid.Columns.GridColumn()
{
FieldName = "Age", Caption = "Age", Visible = true, Width = 50
});
gridView.Columns.Add(new DevExpress.XtraGrid.Columns.GridColumn()
{
FieldName = "Height", Caption = "Height", Visible = true, Width = 50
});
this.gridView1.MouseDown += GridView1_MouseDown;
this.gridView.FocusedRowChanged += GridView_FocusedRowChanged;
gridControl.DataSource = CreateTable(10);
}
// 1.Selenium 예제 http://www.csharpstudy.com/web/article/17-Web-Automation
// 2_1.Selenium 다운로드 https://www.seleniumhq.org/download/
// 2_2. Selenium ChromeDriver 다운로드
// 3. Invisible Console, Chrome https://stackoverflow.com/questions/11501623/chromedriver-console-application-hide
public SeleniumUserControl()
{
InitializeComponent();
MyDevExpressFunctions.MakeWindowsUIButtonPanel(this.windowsUIButtonPanel1, new string[] { "검색" });
WindowsUIButton btnSearch = this.windowsUIButtonPanel1.Buttons["검색"] as WindowsUIButton;
WindowsUIButton btnChart = this.windowsUIButtonPanel1.Buttons["차트"] as WindowsUIButton;
btnSearch.Click += BtnSearch_Click;
IList <AutomationDTO> tempList = AutomationDAO.SelectSiteList(new AutomationDTO());
AutomationDTO createTableResult = AutomationDAO.CreateTable1(new AutomationDTO());
}
public MyTileBar04()
{
InitializeComponent();
MyDevExpressFunctions.InitSearchLookUpEdit(this.slueSelect, "DEPT_NAME", "DEPT_CODE", true);
MyDevExpressFunctions.SetVisibleColumnSearchLookUpEdit(this.slueSelect, new string[] { "DEPT_NAME", "DEPT_CODE" }, new string[] { "부서명", "부서코드" });
this.slueSelect.Properties.DataSource = new MyDatabaseConnect01().connection2();
//this.slueSelect.EditValueChanged += SlueSelect_EditValueChanged;
MyDevExpressFunctions.MakeWindowsUIButtonPanel(this.windowsUIButtonPanel1, new string[] { "검색", "초기화", "저장", "프린트", "차트" });
WindowsUIButton btnSearch = this.windowsUIButtonPanel1.Buttons["검색"] as WindowsUIButton;
WindowsUIButton btnReset = this.windowsUIButtonPanel1.Buttons["초기화"] as WindowsUIButton;
btnSearch.Click += BtnSearch_Click;
btnReset.Click += BtnReset_Click;
}
private void FlyoutPanel1_ButtonClick(object sender, FlyoutPanelButtonClickEventArgs e)
{
try
{
string caption = e.Button.Caption.ToString();
switch (caption)
{
case "작업이동":
if (FlyoutDialog.Show(this.FindForm(), MyDevExpressFunctions.CreateCloseAction()) == System.Windows.Forms.DialogResult.Yes)
{
List <DashboardDTO> gridList = this.gridControl2.DataSource as List <DashboardDTO>;
IList <DashboardDTO> resultList = new List <DashboardDTO>();
for (int x = 0; x < gridList.Count; x++)
{
// https://stackoverflow.com/questions/12762617/how-to-get-the-selected-row-values-of-devexpress-xtragrid
if (gridList[x].CHK2.ToString() == "True")
{
DashboardDTO vo = gridList[x];
vo.EQP_ID = gridList[checkedGridView1].EQP_ID;
vo.ORDER_COUNT = gridList[checkedGridView1].ORDER_COUNT;
resultList.Add(vo);
}
}
this.gridControl3.DataSource = resultList;
}
;
break;
case "적용":
//(sender as FlyoutPanel).HidePopup();
//this.panelComparence.Visible = false; this.flyoutPanel1.OptionsButtonPanel.ShowButtonPanel = false;
(sender as FlyoutPanel).HidePopup();
this.panelComparence.Visible = false; this.flyoutPanel1.OptionsButtonPanel.ShowButtonPanel = false; this.gridControl3.Visible = false; this.gridControl3.DataSource = null;
break;
case "취소":
// . . .
(sender as FlyoutPanel).HidePopup();
this.panelComparence.Visible = false; this.flyoutPanel1.OptionsButtonPanel.ShowButtonPanel = false; this.gridControl3.Visible = false; this.gridControl3.DataSource = null;
break;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public MySearchLookUpEdit01()
{
InitializeComponent();
MyDevExpressFunctions.SetVisibleColumnSearchLookUpEdit(this.slueTest, new string[] { "BIG_CLASS", "BIG_CLASS_DESC" }, new string[] { "대분류", "대분류명" });
MyDevExpressFunctions.InitSearchLookUpEdit(this.slueTest, "BIG_CLASS_DESC", "ROWINDEX", true);
slueTest.Properties.View.OptionsSelection.CheckBoxSelectorColumnWidth = 40;
slueTest.Properties.View.OptionsSelection.MultiSelect = true;
slueTest.Properties.View.OptionsSelection.MultiSelectMode = GridMultiSelectMode.CheckBoxRowSelect;
slueTest.Properties.ShowAddNewButton = true;
slueTest.Enter += slueTest_Enter;
slueTest.EditValueChanged += slueTest_EditValueChanged;
slueTest.CustomDisplayText += slueTest_CustomDisplayText;
slueTest.Closed += searchLookUpEdit_Closed;
slueTest.Popup += AddNewButtonChangeCaption_Popup; // AddNewButton Caption
MyDevExpressFunctions.SetBestFitPopupSearchLookUpEdit(this.slueTest, 25);
this.simpleButton1.Click += SimpleButton1_Click;
}
public MyUserControl02(string _eqpDesc, string _eqpId, string _workCenter, string _state)
{
InitializeComponent();
try
{
this.gridControl1.DoubleClick += GridControl1_DoubleClick;
//this.gridControl1.Click += GridControl1_Click;
//this.gridView1.RowCellStyle += GridView1_RowCellStyle;
this.labelControl1.Text = _eqpDesc;
this.labelControl2.Text = _eqpId;
eqpDesc = _eqpDesc;
eqpId = _eqpId;
workCenter = _workCenter;
backColor = _state;
MyDevExpressFunctions.InitGridControl(this.gridView1, 1);
int iColumnCount = oHeaderText.Length;
DevExpress.XtraGrid.Columns.GridColumn[] cCols = new DevExpress.XtraGrid.Columns.GridColumn[iColumnCount];
for (int i = 0; i < iColumnCount; i++)
{
cCols[i] = new DevExpress.XtraGrid.Columns.GridColumn()
{
FieldName = Enum.GetNames(typeof(DbColumnIndex))[i].ToString(), Name = Enum.GetNames(typeof(DbColumnIndex))[i], Caption = oHeaderText[i], Visible = true, Width = HeaderWidth[i]
};
if (oHeaderText[i] == "생산순서")
{
cCols[i].Visible = false;
}
this.gridView1.Columns.Add(cCols[i]);
MyDevExpressFunctions.SetHeaderAlignmentGridView(this.gridView1, gridView1.Columns.Count - 1);
MyDevExpressFunctions.SetCellAlignmentGridView(this.gridView1, gridView1.Columns.Count - 1);
}
//this.gridControl1.DataSource = new MyDatabaseConnect01().connection7(_eqpId, _workCenter);
this.gridControl1.DataSource = DashboardDAO.SelectOrderOfEquipmentList(new DashboardDTO()
{
EQP_ID = _eqpId, WORK_CENTER = _workCenter
});
this.labelControl5.Text = "오더수량 : " + gridView1.RowCount.ToString();
if (_state == "Run")
{
this.panel1.BackColor = Color.DarkGreen; this.panel2.BackColor = Color.Green;
}
else if (_state == "Idle" || _state == "Ready")
{
this.panel1.BackColor = Color.DarkGray; this.panel2.BackColor = Color.Gray;
}
else if (_state == "Down")
{
this.panel1.BackColor = Color.DarkRed; this.panel2.BackColor = Color.Red;
}
else if (_state == "Setup")
{
this.panel1.BackColor = Color.DarkBlue; this.panel2.BackColor = Color.Blue;;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public MyGridControl13()
{
InitializeComponent();
gridView = this.gridView1;
gridControl = this.gridControl1;
MyDevExpressFunctions.InitGridControl(this.gridView1, 0);
gridView.Columns.Add(new DevExpress.XtraGrid.Columns.GridColumn()
{
FieldName = "Checked", Caption = "Checked", Visible = true, Width = 100
});
gridView.Columns.Add(new DevExpress.XtraGrid.Columns.GridColumn()
{
FieldName = "Count", Caption = "Count", Visible = true, Width = 100
});
gridView.Columns.Add(new DevExpress.XtraGrid.Columns.GridColumn()
{
FieldName = "Name", Caption = "Name", Visible = true, Width = 100
});
gridView.Columns.Add(new DevExpress.XtraGrid.Columns.GridColumn()
{
FieldName = "Age", Caption = "Age", Visible = true, Width = 100
});
gridView.Columns.Add(new DevExpress.XtraGrid.Columns.GridColumn()
{
FieldName = "Height", Caption = "Height", Visible = true, Width = 100
});
gridView.Columns.Add(new DevExpress.XtraGrid.Columns.GridColumn()
{
FieldName = "Date", Caption = "Date", Visible = true, Width = 200
});
//this.gridView1.CustomColumnDisplayText += gridView1_CustomColumnDisplayText;
this.gridView.FocusedRowChanged += GridView_FocusedRowChanged;
// 정렬
gridView.Columns["Name"].AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Near;
// 숫자 포맷일 경우
DevExpress.XtraEditors.Repository.RepositoryItemTextEdit repositoryItemTextEditNumber = new DevExpress.XtraEditors.Repository.RepositoryItemTextEdit();
repositoryItemTextEditNumber.Mask.UseMaskAsDisplayFormat = true;
repositoryItemTextEditNumber.Mask.EditMask = "N0"; // 1,234
repositoryItemTextEditNumber.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.Numeric;
gridView.Columns["Height"].ColumnEdit = repositoryItemTextEditNumber;
gridView.Columns["Age"].ColumnEdit = repositoryItemTextEditNumber;
//RepositoryItemDateEdit rDate = new RepositoryItemDateEdit();
//rDate.DisplayFormat.FormatType = DevExpress.Utils.FormatType.DateTime;
//rDate.Mask.UseMaskAsDisplayFormat = true;
//rDate.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.DateTime;
//rDate.Mask.EditMask = "yyyy-MM-dd HH:mm:ss";
//gridView.Columns["Date"].ColumnEdit = rDate;
DevExpress.XtraEditors.Repository.RepositoryItemTextEdit riteTextEditColumn = new DevExpress.XtraEditors.Repository.RepositoryItemTextEdit();
riteTextEditColumn.Mask.EditMask = "####-##-## ##:##:##"; // 0000-00-00 00:00:00
riteTextEditColumn.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.Simple;
riteTextEditColumn.Mask.UseMaskAsDisplayFormat = true;
riteTextEditColumn.Mask.IgnoreMaskBlank = true;
riteTextEditColumn.Mask.ShowPlaceHolders = false;
riteTextEditColumn.NullText = " ";
riteTextEditColumn.NullValuePrompt = string.Empty;
riteTextEditColumn.NullValuePromptShowForEmptyValue = false;
//riteTextEditColumn.ShowNullValuePromptWhenFocused = false;
gridView.Columns["Date"].ColumnEdit = riteTextEditColumn;
this.gridView.CustomColumnDisplayText += gridView1_CustomColumnDisplayText;
//gridView.Columns["Date"].DisplayFormat.FormatType = FormatType.Custom;
//gridView.Columns["Date"].DisplayFormat.FormatType = FormatType.Custom;
//gridView.Columns["Date"].DisplayFormat.FormatString = "{0:####-##-## ##:##:##}";
//gridView.Columns["Date"].DisplayFormat.FormatString = "{0:####}";
//gridView.Columns["Date"].DisplayFormat.FormatString = DateTime.ParseExact("{0}", "yyyyMMdd", null).ToString("yyyy-MM-dd");
gridControl.DataSource = CreateTable(10);
}
private void BtnSearch_Click(object sender, EventArgs e)
{
BtnReset_Click(null, null);
MyDevExpressFunctions.MakeLayoutContol(this.layoutControlGroup2, this.slueSelect.EditValue.ToString());
this.groupControl2.Focus();
}
public MyTileBar05()
{
InitializeComponent();
try
{
MyDevExpressFunctions.InitSearchLookUpEdit(this.slueSelect, "DEPT_NAME", "DEPT_CODE", true);
MyDevExpressFunctions.SetVisibleColumnSearchLookUpEdit(this.slueSelect, new string[] { "DEPT_NAME", "DEPT_CODE" }, new string[] { "부서명", "부서코드" });
this.slueSelect.Properties.DataSource = DashboardDAO.SelectDepartmentList(new DashboardDTO());
//this.slueSelect.EditValueChanged += SlueSelect_EditValueChanged;
MyDevExpressFunctions.MakeWindowsUIButtonPanel(this.windowsUIButtonPanel1, new string[] { "검색", "초기화", "구분자", "미리보기", "차트", "작업이동", "구분자", "저장", "프린트" });
WindowsUIButton btnSearch = this.windowsUIButtonPanel1.Buttons["검색"] as WindowsUIButton;
WindowsUIButton btnReset = this.windowsUIButtonPanel1.Buttons["초기화"] as WindowsUIButton;
WindowsUIButton btnChart = this.windowsUIButtonPanel1.Buttons["차트"] as WindowsUIButton;
WindowsUIButton btnPreview = this.windowsUIButtonPanel1.Buttons["미리보기"] as WindowsUIButton;
WindowsUIButton btnMoveWork = this.windowsUIButtonPanel1.Buttons["작업이동"] as WindowsUIButton;
//PeekFormButton btnPanelMoveWork = this.flyoutPanel1.OptionsButtonPanel.Buttons["작업이동"] as PeekFormButton;
//PeekFormButton btnPanelAccept = this.flyoutPanel1.OptionsButtonPanel.Buttons["적용"] as PeekFormButton;
//PeekFormButton btnPanelDecline = this.flyoutPanel1.OptionsButtonPanel.Buttons["취소"] as PeekFormButton;
this.flyoutPanel1.ButtonClick += FlyoutPanel1_ButtonClick;
//btn.clik
btnSearch.Click += BtnSearch_Click;
btnReset.Click += BtnReset_Click;
btnChart.Click += BtnChart_Click;
btnPreview.Click += BtnPreview_Click;
//btnMoveWork.Click += BtnMoveWork_Click;
//btnPanelMoveWork.Click += BtnMoveWork_Click;
this.gridControl1.Click += GridControl1_Click;
// https://enginhak.tistory.com/entry/XtraGridView-Column-Header-Checkbox-Add
this.gridView2.CellValueChanging += GridView2_CellValueChanging;
//this.gridView2.MouseUp += GridView2_MouseUp;
this.panelComparence.Visible = false;
//flowLayoutPanel1.MouseDown += FlowLayoutPanel1_MouseDown;
//MyDevExpressFunctions.InitGridControl(this.gridView1, 0);
//int iColumnCount = oHeaderText.Length;
//DevExpress.XtraGrid.Columns.GridColumn[] cCols = new DevExpress.XtraGrid.Columns.GridColumn[iColumnCount];
//for (int i = 0; i < iColumnCount; i++)
//{
// cCols[i] = new DevExpress.XtraGrid.Columns.GridColumn() { FieldName = Enum.GetNames(typeof(DbColumnIndex))[i].ToString(), Name = Enum.GetNames(typeof(DbColumnIndex))[i], Caption = oHeaderText[i], Visible = true, Width = HeaderWidth[i] };
// this.gridView1.Columns.Add(cCols[i]);
// MyDevExpressFunctions.SetHeaderAlignmentGridView(this.gridView1, gridView1.Columns.Count - 1);
// MyDevExpressFunctions.SetCellAlignmentGridView(this.gridView1, gridView1.Columns.Count - 1);
//}
MyDevExpressFunctions.InitGridControl(this.gridView1, 0);
int iColumnCount = oHeaderText2.Length;
DevExpress.XtraGrid.Columns.GridColumn[] cCols = new DevExpress.XtraGrid.Columns.GridColumn[iColumnCount];
for (int i = 0; i < iColumnCount; i++)
{
cCols[i] = new DevExpress.XtraGrid.Columns.GridColumn()
{
FieldName = Enum.GetNames(typeof(DbColumnIndex2))[i].ToString(), Name = Enum.GetNames(typeof(DbColumnIndex2))[i], Caption = oHeaderText2[i], Visible = true, Width = HeaderWidth2[i]
};
if (oHeaderText2[i] == "생산순서")
{
cCols[i].Visible = false;
}
this.gridView1.Columns.Add(cCols[i]);
MyDevExpressFunctions.SetHeaderAlignmentGridView(this.gridView1, gridView1.Columns.Count - 1);
MyDevExpressFunctions.SetCellAlignmentGridView(this.gridView1, gridView1.Columns.Count - 1);
}
MyDevExpressFunctions.InitGridControl(this.gridView2, 0);
this.gridView2.OptionsBehavior.Editable = true;
iColumnCount = oHeaderText3.Length;
cCols = new DevExpress.XtraGrid.Columns.GridColumn[iColumnCount];
for (int i = 0; i < iColumnCount; i++)
{
RepositoryItemCheckEdit repositoryItemCheckEdit = new RepositoryItemCheckEdit();
repositoryItemCheckEdit.ValueChecked = "True";
repositoryItemCheckEdit.ValueUnchecked = "False";
repositoryItemCheckEdit.CheckedChanged += RepositoryItemCheckEdit_CheckedChanged;
cCols[i] = new DevExpress.XtraGrid.Columns.GridColumn()
{
FieldName = Enum.GetNames(typeof(DbColumnIndex3))[i].ToString(), Name = Enum.GetNames(typeof(DbColumnIndex3))[i], Caption = oHeaderText3[i], Visible = true, Width = HeaderWidth3[i]
};
if (oHeaderText3[i] == "선택")
{
cCols[i].ColumnEdit = repositoryItemCheckEdit;
}
if (oHeaderText3[i] == "선택2")
{
cCols[i].ColumnEdit = repositoryItemCheckEdit;
}
this.gridView2.Columns.Add(cCols[i]);
MyDevExpressFunctions.SetHeaderAlignmentGridView(this.gridView2, gridView2.Columns.Count - 1);
MyDevExpressFunctions.SetCellAlignmentGridView(this.gridView2, gridView2.Columns.Count - 1);
}
this.gridView2.OptionsSelection.ShowCheckBoxSelectorInColumnHeader = DevExpress.Utils.DefaultBoolean.True; // 체크박스 전체 선택가능 헤더만들지 여부
this.gridView2.OptionsSelection.ResetSelectionClickOutsideCheckboxSelector = true; // 셀밖에 값을 눌러도 체크박스 온오프만 적용됨
//gridView2.OptionsSelection.MultiSelect = true;
//gridView2.OptionsSelection.MultiSelectMode = DevExpress.XtraGrid.Views.Grid.GridMultiSelectMode.CheckBoxRowSelect;
gridView2.VisibleColumns[2].OptionsColumn.ShowCaption = false;
//this.gridView2.CustomDrawColumnHeader += GridView2_CustomDrawColumnHeader;
MyDevExpressFunctions.InitGridControl(this.gridView3, 0);
this.gridView3.OptionsBehavior.Editable = true;
iColumnCount = oHeaderText3.Length;
cCols = new DevExpress.XtraGrid.Columns.GridColumn[iColumnCount];
for (int i = 0; i < iColumnCount; i++)
{
cCols[i] = new DevExpress.XtraGrid.Columns.GridColumn()
{
FieldName = Enum.GetNames(typeof(DbColumnIndex3))[i].ToString(), Name = Enum.GetNames(typeof(DbColumnIndex3))[i], Caption = oHeaderText3[i], Visible = true, Width = HeaderWidth3[i]
};
if (oHeaderText3[i] == "선택")
{
cCols[i].Visible = false;
}
if (oHeaderText3[i] == "선택2")
{
cCols[i].Visible = false;
}
this.gridView3.Columns.Add(cCols[i]);
MyDevExpressFunctions.SetHeaderAlignmentGridView(this.gridView3, gridView3.Columns.Count - 1);
MyDevExpressFunctions.SetCellAlignmentGridView(this.gridView3, gridView3.Columns.Count - 1);
}
this.slueSelect.Text = "50000198";
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
