private void BtnOK_Click(object sender, EventArgs e) { DataTable dt = dtgCode.DataSource as DataTable; if (bAdmin) { this.ReturnCodeValue = "testadmin"; this.ReturnNameValue = "관리자"; this.ReturnCodeNameValue = ReturnCodeValue + " : " + ReturnNameValue; this.Close(); return; } if (CommonFuction.IsNullOrWhiteSpace(dtgCode.CurrentRow)) { MessageBox.Show("선택된 항목이 없습니다."); return; } DataGridViewRow gRow = dtgCode.CurrentRow; this.ReturnCodeValue = gRow.Cells["code"].Value.ToString(); this.ReturnNameValue = gRow.Cells["name"].Value.ToString(); this.ReturnCodeNameValue = ReturnCodeValue + " : " + ReturnNameValue; this.Close(); }
/// <summary> /// * 함 수 명 : TxtText_KeyPress /// * 작 성 자 : 황지희 /// * 개 요 : key 이벤트 영어(대문자), 숫자만 입력받도록 valid 체크 /// </summary> private void TxtText_KeyPress(object sender, KeyPressEventArgs e) { TextBox txt = (TextBox)sender; Control temp = txt.Parent; MaskTextBox mtb = null; while (temp.Parent != null) { if (temp is MaskTextBox) { mtb = temp as MaskTextBox; break; } temp = temp.Parent; } if (mtb == null) { return; } switch (mtb.Name) { case "txt_MaskNum": case "txt_EqpId": CommonFuction.TypingOnlyEngNum(sender, e, mtb); break; } }
private void InitGridView(string type) { string CodeColumn = ""; string NameColumn = ""; switch (type) { case "VENDER": CodeColumn = "venderid"; NameColumn = "vendername"; break; case "EQUIP": CodeColumn = "equipmentid"; NameColumn = "equipmentname"; break; case "USER": case "LOGIN": CodeColumn = "userid"; NameColumn = "username"; break; default: break; } dtgCode.AutoGenerateColumns = false; CommonFuction.SetDataGridViewColumnStyle(dtgCode, "코드", CodeColumn, "code", typeof(string), 130); CommonFuction.SetDataGridViewColumnStyle(dtgCode, "이름", NameColumn, "name", typeof(string), 250); }
/// <summary> /// 입력 컨트롤 전체 초기화 /// </summary> private void ClearInputBox() { try { SetEnabled(true); SetReadOnly(false); mtxtID.txtText.Text = CommonFuction.DurableIdCreator(); mtxtName.txtText.ResetText(); mtxtCode.txtText.ResetText(); mtxtVenderName.txtText.ResetText(); mtxtVenderCode.txtText.ResetText(); mtxtCreator.ucValue = Program.CurrentUserName; mtxtDesc.txtText.ResetText(); mcbmbInputResult.cboCombo.SelectedIndex = -1; mcbmRack.cboCombo.SelectedIndex = -1; mcmbModelCode.cboCombo.SelectedIndex = -1; txtCreateDate.ResetText(); GetProductInfo = false; } catch (Exception ee) { LogFactory.Log(ee); } }
private void GetData() { string connStr = CommonFuction.GetAppSetting("DBConnectionString"); Dictionary <string, string> connDic = new Dictionary <string, string>(); List <string> arrConnStr = new List <string>(); arrConnStr.AddRange(connStr.Split(';')); foreach (string x in arrConnStr) { string[] temp = x.Trim().Split('='); connDic.Add(temp[0], temp[1]); } string value = ""; if (connDic.TryGetValue("Data Source", out value)) { mtxtIP.ucValue = value; } if (connDic.TryGetValue("initial Catalog", out value)) { mtxtCatalog.ucValue = value; } if (connDic.TryGetValue("user", out value)) { mtxtID.ucValue = value; } if (connDic.TryGetValue("password", out value)) { mtxtPW.ucValue = value; } }
/// <summary> /// * 함 수 명 : TxtWidth_KeyPress /// * 개 요 : 숫자만 입력 가능 / 엔터 포커싱 /// </summary> /// private void TxtWidth_KeyPress(object sender, KeyPressEventArgs e) { CommonFuction.TypingOnlyNumber(sender, e, false); if (e.KeyChar == (char)Keys.Enter) { txtHeight.Focus(); } }
/// <summary> /// * 함 수 명 : MtxtUserID_KeyPress /// * 개 요 : mtxtUserID -> 영문대문자, 숫자만 입력가능 /// </summary> private void MtxtUserID_KeyPress(object sender, KeyPressEventArgs e) { CommonFuction.TypingOnlyEngNum(sender, e, mtxtUserID); if (e.KeyChar == (char)Keys.Enter) { mtxtUserName.Focus(); } }
/// <summary> /// 작성자 : 강선애 /// 단축 키 지정 이벤트를 위한 함수 추가 /// </summary> private void Btn_Save_Click() { //필수 입력값 확인 string ctrlname = ""; if (!CommonFuction.CheckMandatory(panel1, ref ctrlname)) { CustomMessageBox.Show(MessageBoxButtons.OK, "ERROR", ctrlname + "을 확인해주세요."); return; } string sValidReslt = Valid(); if (sValidReslt.Equals("SAVE_FALSE")) { return; } if (CustomMessageBox.Show(MessageBoxButtons.OKCancel, "저장", "저장 하시겠습니까?") == DialogResult.OK) { Dictionary <string, object> Params = new Dictionary <string, object>(); Params.Add("@durableid", this.txt_MaskNum.ucValue); //Mask 일련번호 Params.Add("@durableproductid", this.txt_ProdId.ucValue); //모델명 Params.Add("@useqty", this.txt_NowUse.ucValue); //사용 횟수 Params.Add("@totuseqty", iNewTotUseQty); //사용 횟수 Params.Add("@comment", this.txt_Comment.ucValue); //사양 정보 Params.Add("@modifier", Program.CurrentUser); //사용자 Params.Add("@workstate", "WORKSTATE_USED"); //WOKR STATE //Params.Add("@usedate",DateTime.Now); //WOKR STATE //rams.Add("@state", "STATE_ACTIVE"); //LOT STATE if (sValidReslt.Equals("SAVE_TERMINATED")) { Params.Add("@lotstate", "STATE_TERMINATED"); //LOT STATE //2019-05-14 황지희 폐기일 경우 RACKID 빈값 파람 추가 Params.Add("@rackid", ""); //RACK ID } else { Params.Add("@lotstate", "STATE_ACTIVE"); Params.Add("@rackid", this.txt_Rack.ucValue); } var PamasArr = DB.GetSqlParameters(Params); int SaveResult = DB.CallNonSelectProcedure("SaveMaskInfo", PamasArr); if (SaveResult > 0) { CustomMessageBox.Show(MessageBoxButtons.OK, "SAVE", "저장하였습니다."); //2019-05-08 황지희 저장후 MASK 일련번호로 포커스 추가 txt_MaskNum.Focus(); InitReset(); resetRack.ResetRackStatus(true); } } }
private void MMInspectPop_Load(object sender, EventArgs e) { //db connect DB.Open(); //SetComboBox(); CommonFuction.SetInputResultList(ref cmb_InspResult); //세척 검사 결과 this.cmb_InspResult.ucComboIndex = -1; //2019-05-15 황지희 설비 코드로 focus 되도록 변경 ActiveControl = txt_EqpId; }
/// <summary> /// 실제 Rack을 나타내는 컨트롤을 위치에 맞게 세팅해줌 /// </summary> public void DrawRacks() { if (MainDataSet != null) { //RackList = MainDataSet.Tables[1]; } tlpRack.Hide(); try { tlpRack.Controls.Clear(); foreach (DataRow x in RackList.Rows) { UserControls.RackControl NewCtrl = new UserControls.RackControl(); NewCtrl.RackControlClick += NewCtrl_Click; NewCtrl.ChangeRackName(x["EQUIPMENTID"] as string); NewCtrl.Dock = DockStyle.Fill; if (CommonFuction.IsNullOrWhiteSpace(x["DURABLEPRODUCTNAME"])) { x["DURABLEPRODUCTNAME"] = ""; } NewCtrl.ChangeMaskName((string)x["DURABLEPRODUCTNAME"]); tlpRack.Controls.Add(NewCtrl, (int)x["LOCATIONX"] - 1, (int)x["LOCATIONY"] - 1); if (CommonFuction.IsNullOrWhiteSpace(x["DURABLEID"])) { NewCtrl.ChangeRackState("empty"); } else if ((int)x["WARNINGUSEQTY"] <= (int)x["TOTUSEQTY"]) { NewCtrl.ChangeRackState("warning"); } else { if ((string)x["WORKSTATE"] == "WORKSTATE_USED" || (string)x["WORKSTATE"] == "WORKSTATE_USING") { NewCtrl.ChangeRackState("using"); } else { NewCtrl.ChangeRackState("stock"); } } } } catch (Exception e) { LogFactory.Log(e); } tlpRack.Show(); }
/// <summary> /// 그리드 세팅 /// </summary> private void InitializeGrid() { // 대분류 grdTopCategory.AutoGenerateColumns = false; grdTopCategory.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.EnableResizing; grdTopCategory.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.BottomCenter; grdTopCategory.AllowUserToAddRows = false; grdTopCategory.SelectionMode = DataGridViewSelectionMode.FullRowSelect; grdTopCategory.DefaultCellStyle.SelectionBackColor = Color.Yellow; grdTopCategory.DefaultCellStyle.SelectionForeColor = Color.Black; CommonFuction.SetDataGridViewColumnStyle(grdTopCategory, "NO", "NO", "NO", typeof(string), 50, true, true, DataGridViewContentAlignment.MiddleCenter, 10); CommonFuction.SetDataGridViewColumnStyle(grdTopCategory, "불량코드", "DEFECTCODE", "DEFECTCODE", typeof(string), 120, true, true, DataGridViewContentAlignment.MiddleCenter, 10); CommonFuction.SetDataGridViewColumnStyle(grdTopCategory, "불량명", "DEFECTCODENAME", "DEFECTCODENAME", typeof(string), 180, true, true, DataGridViewContentAlignment.MiddleCenter, 10); CommonFuction.SetDataGridViewColumnStyle(grdTopCategory, "유효여부", "VALIDSTATE", "VALIDSTATE", typeof(string), 100, true, true, DataGridViewContentAlignment.MiddleCenter, 10); CommonFuction.SetDataGridViewColumnStyle(grdTopCategory, "상위불량코드", "PARENTDEFECTCODE", "PARENTDEFECTCODE", typeof(string), 100, true, false, DataGridViewContentAlignment.MiddleLeft, 10); CommonFuction.SetDataGridViewColumnStyle(grdTopCategory, "레벨", "LEVEL", "LEVEL", typeof(string), 100, true, false, DataGridViewContentAlignment.MiddleLeft, 10); CommonFuction.SetDataGridViewColumnStyle(grdTopCategory, "행변경타입", "ROWTYPE", "ROWTYPE", typeof(string), 100, true, false, DataGridViewContentAlignment.MiddleLeft, 10); // 중분류 grdMiddleCategory.AutoGenerateColumns = false; grdMiddleCategory.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.EnableResizing; grdMiddleCategory.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.BottomCenter; grdMiddleCategory.AllowUserToAddRows = false; grdMiddleCategory.SelectionMode = DataGridViewSelectionMode.FullRowSelect; grdMiddleCategory.DefaultCellStyle.SelectionBackColor = Color.Yellow; grdMiddleCategory.DefaultCellStyle.SelectionForeColor = Color.Black; CommonFuction.SetDataGridViewColumnStyle(grdMiddleCategory, "NO", "NO", "NO", typeof(string), 50, true, true, DataGridViewContentAlignment.MiddleCenter, 10); CommonFuction.SetDataGridViewColumnStyle(grdMiddleCategory, "불량코드", "DEFECTCODE", "DEFECTCODE", typeof(string), 120, true, true, DataGridViewContentAlignment.MiddleCenter, 10); CommonFuction.SetDataGridViewColumnStyle(grdMiddleCategory, "불량명", "DEFECTCODENAME", "DEFECTCODENAME", typeof(string), 180, true, true, DataGridViewContentAlignment.MiddleCenter, 10); CommonFuction.SetDataGridViewColumnStyle(grdMiddleCategory, "유효여부", "VALIDSTATE", "VALIDSTATE", typeof(string), 100, true, true, DataGridViewContentAlignment.MiddleCenter, 10); CommonFuction.SetDataGridViewColumnStyle(grdMiddleCategory, "상위불량코드", "PARENTDEFECTCODE", "PARENTDEFECTCODE", typeof(string), 100, true, false, DataGridViewContentAlignment.MiddleLeft, 10); CommonFuction.SetDataGridViewColumnStyle(grdMiddleCategory, "레벨", "LEVEL", "LEVEL", typeof(string), 100, true, false, DataGridViewContentAlignment.MiddleLeft, 10); CommonFuction.SetDataGridViewColumnStyle(grdMiddleCategory, "행변경타입", "ROWTYPE", "ROWTYPE", typeof(string), 100, true, false, DataGridViewContentAlignment.MiddleLeft, 10); // 불량상세 grdDetailCategory.AutoGenerateColumns = false; grdDetailCategory.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.EnableResizing; grdDetailCategory.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.BottomCenter; grdDetailCategory.AllowUserToAddRows = false; grdDetailCategory.SelectionMode = DataGridViewSelectionMode.FullRowSelect; grdDetailCategory.DefaultCellStyle.SelectionBackColor = Color.Yellow; grdDetailCategory.DefaultCellStyle.SelectionForeColor = Color.Black; CommonFuction.SetDataGridViewColumnStyle(grdDetailCategory, "NO", "NO", "NO", typeof(string), 50, true, true, DataGridViewContentAlignment.MiddleCenter, 10); CommonFuction.SetDataGridViewColumnStyle(grdDetailCategory, "불량코드", "DEFECTCODE", "DEFECTCODE", typeof(string), 120, true, true, DataGridViewContentAlignment.MiddleCenter, 10); CommonFuction.SetDataGridViewColumnStyle(grdDetailCategory, "불량명", "DEFECTCODENAME", "DEFECTCODENAME", typeof(string), 180, true, true, DataGridViewContentAlignment.MiddleCenter, 10); CommonFuction.SetDataGridViewColumnStyle(grdDetailCategory, "유효여부", "VALIDSTATE", "VALIDSTATE", typeof(string), 100, true, true, DataGridViewContentAlignment.MiddleCenter, 10); CommonFuction.SetDataGridViewColumnStyle(grdDetailCategory, "상위불량코드", "PARENTDEFECTCODE", "PARENTDEFECTCODE", typeof(string), 100, true, false, DataGridViewContentAlignment.MiddleLeft, 10); CommonFuction.SetDataGridViewColumnStyle(grdDetailCategory, "레벨", "LEVEL", "LEVEL", typeof(string), 100, true, false, DataGridViewContentAlignment.MiddleLeft, 10); CommonFuction.SetDataGridViewColumnStyle(grdDetailCategory, "행변경타입", "ROWTYPE", "ROWTYPE", typeof(string), 100, true, false, DataGridViewContentAlignment.MiddleLeft, 10); }
/// <summary> /// 단축키 입력 및 버튼 입력시 실행되는 코드 /// </summary> public void Btn_Ok_Click() { string ctrlname = ""; if (!CommonFuction.CheckMandatory(gbScrap, ref ctrlname)) { CustomMessageBox.Show(MessageBoxButtons.OK, "확인", ctrlname + "을 확인해주세요"); return; } else { if (string.IsNullOrWhiteSpace(txtNumber.ucValue) == false && string.IsNullOrWhiteSpace(txtRackId.ucValue) == true) { result = CustomMessageBox.Show(MessageBoxButtons.OK, "확인", "해당 모델은 이미 폐기되었습니다."); } else { try { sql = "ProcDurable&HistInMMScrapPop"; result = CustomMessageBox.Show(MessageBoxButtons.OKCancel, "확인", "폐기하시겠습니까?"); if (result == DialogResult.OK) { Dictionary <string, object> param = new Dictionary <string, object>(); param.Add("@id", txtNumber.ucValue); param.Add("@modifier", Program.CurrentUser); param.Add("@comment", txtComment.ucValue); DataTable table = db.ExecuteProcedure(sql, param); result = CustomMessageBox.Show(MessageBoxButtons.OK, "확인", "폐기되었습니다."); resetRack.ResetRackStatus(true); foreach (Control ctrl in gbScrap.Controls) { if (ctrl is UserControls.MaskTextBox) { UserControls.MaskTextBox tb = (UserControls.MaskTextBox)ctrl; if (string.IsNullOrWhiteSpace(tb.ucValue) == false) { tb.ucValue = string.Empty; } } } } } catch (Exception ee) { LogFactory.Log(ee); CustomMessageBox.Show(MessageBoxButtons.OK, "확인", "문제가 발생했습니다.\n 로그를 확인하세요."); } } } }
/// <summary> /// 그리드 세팅 /// </summary> private void InitializeGrid() { grdUser.AutoGenerateColumns = false; grdUser.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.EnableResizing; grdUser.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.BottomCenter; grdUser.AllowUserToAddRows = false; CommonFuction.SetDataGridViewColumnStyle(grdUser, "NO", "NO", "NO", typeof(string), 50, true, true, DataGridViewContentAlignment.MiddleCenter, 10); CommonFuction.SetDataGridViewColumnStyle(grdUser, "순번", "SEQUENCE", "SEQUENCE", typeof(int), 100, false, true, DataGridViewContentAlignment.MiddleCenter, 10); CommonFuction.SetDataGridViewColumnStyle(grdUser, "사번", "USERNUMBER", "USERNUMBER", typeof(string), 200, false, true, DataGridViewContentAlignment.MiddleCenter, 10); CommonFuction.SetDataGridViewColumnStyle(grdUser, "사용자명", "USERNAME", "USERNAME", typeof(string), 200, false, true, DataGridViewContentAlignment.MiddleCenter, 10); CommonFuction.SetDataGridViewColumnStyle(grdUser, "행변경타입", "ROWTYPE", "ROWTYPE", typeof(string), 100, false, false, DataGridViewContentAlignment.MiddleLeft, 10); }
private void BtnSave_Click() { try { sql = "ProcVenderInVenderTab"; string ctrlname = ""; int iRow = -1; if (!CommonFuction.CheckMandatory(groupBox1, ref ctrlname)) { CustomMessageBox.Show(MessageBoxButtons.OK, "확인", ctrlname + "을 확인해주세요"); return; } if (state == false) { result = CustomMessageBox.Show(MessageBoxButtons.OKCancel, "확인", "저장하시겠습니까?"); if (result == DialogResult.OK) { table = db.ExecuteProcedure(sql, AddParam()); TableRefresh(); GridRowChange(iRow); MakeEmpty(); } } else { iRow = dtgVenderList.CurrentRow.Index; ctrlname = ""; if (!CommonFuction.CheckMandatory(groupBox1, ref ctrlname)) { CustomMessageBox.Show(MessageBoxButtons.OK, "확인", ctrlname + "을 확인해주세요"); return; } result = CustomMessageBox.Show(MessageBoxButtons.OKCancel, "확인", "저장하시겠습니까?"); if (result == DialogResult.OK) { table = db.ExecuteProcedure(sql, AddParam()); TableRefresh(); GridRowChange(iRow); MakeEmpty(); } } } catch (Exception ee) { LogFactory.Log(ee); CustomMessageBox.Show(MessageBoxButtons.OK, "확인", "문제가 발생했습니다.\n 로그를 확인하세요."); } }
protected override void OnLoad(EventArgs e) { base.OnLoad(e); SetEvent(); System.Configuration.AppSettingsReader temp = new System.Configuration.AppSettingsReader(); lblCrrUser.Text = CommonFuction.GetUserName(Program.CurrentUser); if (string.IsNullOrEmpty(Program.CurrentUser)) { BtnLogIn_Click(null, null); } //MMManagedReportControl = new MMManagedReportControl(); // MMManagedReportTabPage.Controls.Add(mMManagedReportControl); ResetRackStatus(true); this.txt_MaskNum.txtText.CharacterCasing = CharacterCasing.Upper; }
/// <summary> /// 버튼의 이벤트들이 발생된 후 각각의 컨트롤러의 텍스트들을 초기화 해주는 함수 /// </summary> public void MakeEmpty() { CommonFuction.SetUseYNList(ref cbbUseYN); foreach (Control ctrl in groupBox1.Controls) { if (ctrl is UserControls.MaskTextBox) { UserControls.MaskTextBox tb = (UserControls.MaskTextBox)ctrl; if (tb.ucValue != string.Empty) { tb.ucValue = string.Empty; } } } }
/// <summary> /// 그리드 세팅 /// </summary> private void InitializeGrid() { grdFrameInfo.AutoGenerateColumns = false; grdFrameInfo.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.EnableResizing; grdFrameInfo.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.BottomCenter; grdFrameInfo.AllowUserToAddRows = false; CommonFuction.SetDataGridViewColumnStyle(grdFrameInfo, "NO", "NO", "NO", typeof(string), 50, true, true, DataGridViewContentAlignment.MiddleCenter, 10); CommonFuction.SetDataGridViewColumnStyle(grdFrameInfo, "시간", "PRODUCTTYPE", "rackid", typeof(string), 200, false, true, DataGridViewContentAlignment.MiddleCenter, 20); CommonFuction.SetDataGridViewColumnStyle(grdFrameInfo, "프레임", "PRODUCTNAME", "durableid", typeof(int), 100, false, true, DataGridViewContentAlignment.MiddleCenter, 20); CommonFuction.SetDataGridViewColumnStyle(grdFrameInfo, "자동판정등급", "PRODUCTNO", "productname", typeof(string), 100, false, true, DataGridViewContentAlignment.MiddleCenter, 80); CommonFuction.SetDataGridViewColumnStyle(grdFrameInfo, "불량유형", "CUSTOMERNAME", "inputdate", typeof(string), 100, false, true, DataGridViewContentAlignment.MiddleCenter, 60); CommonFuction.SetDataGridViewColumnStyle(grdFrameInfo, "최종판정", "CREATOR", "inputresult", typeof(string), 100, false, true, DataGridViewContentAlignment.MiddleCenter, 35); CommonFuction.SetDataGridViewColumnStyle(grdFrameInfo, "위치", "CREATETIME", "usedate", typeof(string), 500, false, true, DataGridViewContentAlignment.MiddleLeft, 60); CommonFuction.SetDataGridViewColumnStyle(grdFrameInfo, "행변경타입", "ROWTYPE", "ROWTYPE", typeof(string), 100, false, false, DataGridViewContentAlignment.MiddleLeft, 60); }
private void Btn_Add_Click() { string ctrlname = ""; if (CommonFuction.CheckMandatory(MaskCleanPanel, ref ctrlname)) { if (CustomMessageBox.Show(MessageBoxButtons.OKCancel, "신규", "신규 생성 하시겠습니까?") == DialogResult.OK) { InitReset(); } } else { InitReset(); } }
public string SetMaskDatas(string RackId) { DataSet ds = new DataSet(); ds = conn.CallSelectProcedure_ds(ProcedureName, new SqlParameter[] { new SqlParameter("rackid", RackId) }); if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { DataRow dr = ds.Tables[0].Rows[0]; lblDataMaskID.Text = dr["durableid"].ToString(); lblDataModelCode.Text = dr["durableproductid"].ToString(); lblDataModelName.Text = dr["durableproductname"].ToString(); lblDataRackID.Text = dr["equipmentid"].ToString(); lblDataInputInsp.Text = dr["inputresult"].ToString(); if (!CommonFuction.IsNullOrWhiteSpace(dr["inputdate"])) { lblDataInputDate.Text = dr["inputdate"].ToString(); } else { lblDataInputDate.Text = ""; } if (!CommonFuction.IsNullOrWhiteSpace(dr["usedate"])) { lblDataRecentUse.Text = dr["usedate"].ToString(); } else { lblDataRecentUse.Text = ""; } if ((int)dr["totuseqty"] > 0) { lblDataTotalUse.Text = dr["totuseqty"].ToString(); } else { lblDataTotalUse.Text = ""; } lblDataCleanInsp.Text = dr["cleanresult"].ToString(); lblDataDescription.Text = dr["description"].ToString(); } return(ds.Tables.Count.ToString()); }
private void InitGridView() { dataGridView1.AutoGenerateColumns = false; dataGridView2.AutoGenerateColumns = false; dataGridView1.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.EnableResizing; dataGridView1.ColumnHeadersHeight = dataGridView1.ColumnHeadersHeight * 2; dataGridView1.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.BottomCenter; dataGridView1.Paint += DataGridView1_Paint; dataGridView1.CellPainting += DataGridView1_CellPainting; dataGridView1.ColumnWidthChanged += DataGridView1_ColumnWidthChanged; dataGridView1.Scroll += DataGridView1_Scroll; btnExcel.Click += BtnExcel_Click; btnPrint.Click += BtnPrint_Click; btnSearch.Click += BtnSearch_Click; //컬럼명 setting CommonFuction.SetDataGridViewColumnStyle(dataGridView1, "No", "No", "No", typeof(string), 50, true, true, DataGridViewContentAlignment.MiddleLeft, 10); CommonFuction.SetDataGridViewColumnStyle(dataGridView1, "보관위치", "rackid", "rackid", typeof(string), 70, true, true, DataGridViewContentAlignment.MiddleCenter, 20); CommonFuction.SetDataGridViewColumnStyle(dataGridView1, "Mask No", "durableid", "durableid", typeof(string), 100, true, true, DataGridViewContentAlignment.MiddleCenter, 20); CommonFuction.SetDataGridViewColumnStyle(dataGridView1, "Mask Code", "productname", "productname", typeof(string), 150, true, true, DataGridViewContentAlignment.MiddleLeft, 80); CommonFuction.SetDataGridViewColumnStyle(dataGridView1, "입고일자", "inputdate", "inputdate", typeof(string), 150, true, true, DataGridViewContentAlignment.MiddleLeft, 60); CommonFuction.SetDataGridViewColumnStyle(dataGridView1, "수입검사 결과", "inputresult", "inputresult", typeof(string), 100, true, true, DataGridViewContentAlignment.MiddleCenter, 35); CommonFuction.SetDataGridViewColumnStyle(dataGridView1, "사용일자", "usedate", "usedate", typeof(string), 150, true, true, DataGridViewContentAlignment.MiddleLeft, 60); CommonFuction.SetDataGridViewColumnStyle(dataGridView1, "횟수", "totuseqty", "totuseqty", typeof(string), 100, true, true, DataGridViewContentAlignment.MiddleRight, 35); CommonFuction.SetDataGridViewColumnStyle(dataGridView1, "폐기일", "defectdate", "defectdate", typeof(string), 150, true, true, DataGridViewContentAlignment.MiddleLeft, 60); CommonFuction.SetDataGridViewColumnStyle(dataGridView1, "사유", "defectreason", "defectreason", typeof(string), 100, true, true, DataGridViewContentAlignment.MiddleLeft, 100); CommonFuction.SetDataGridViewColumnStyle(dataGridView1, "durableproductid", "durableproductid", "durableproductid", typeof(string), -1, false, false); CommonFuction.SetDataGridViewColumnStyle(dataGridView1, "state", "state", "state", typeof(string), -1, false, false); //헤더 병합 안된 컬럼들 가운데 정렬하기 dataGridView1.Columns["No"].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter; dataGridView1.Columns["rackid"].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter; dataGridView1.Columns["durableid"].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter; dataGridView1.Columns["productname"].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter; dataGridView1.Columns["inputdate"].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter; dataGridView1.Columns["inputresult"].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter; CommonFuction.SetDataGridViewColumnStyle(dataGridView2, "날짜", "usedate", "usedate", typeof(DateTime), 130, true, true, DataGridViewContentAlignment.MiddleCenter); CommonFuction.SetDataGridViewColumnStyle(dataGridView2, "횟수", "useqty", "useqty", typeof(string), 50, true, true, DataGridViewContentAlignment.MiddleRight); CommonFuction.SetDataGridViewColumnStyle(dataGridView2, "durableid", "durableid", "durableid", typeof(string), -1, false, false); }
/// <summary> /// Table Layout View 초기화 /// Rack의 배치 레이아웃에 맞춰 세팅해줌. /// </summary> public void Initialization() { try { if (MainDataSet != null) { RackDesign = MainDataSet.Tables[0]; if (Program.MaxX.Equals(0) && !CommonFuction.IsNullOrWhiteSpace(RackDesign.Rows[0]["MAX_X"])) { Program.MaxX = (int)RackDesign.Rows[0]["MAX_X"]; } if (Program.MaxY.Equals(0) && !CommonFuction.IsNullOrWhiteSpace(RackDesign.Rows[0]["MAX_Y"])) { Program.MaxY = (int)RackDesign.Rows[0]["MAX_Y"]; } } tlpRack.Hide(); tlpRack.ColumnCount = Program.MaxX + 1; tlpRack.RowCount = Program.MaxY + 1; tlpRack.ColumnStyles.Clear(); tlpRack.RowStyles.Clear(); for (var i = 0; i < tlpRack.ColumnCount; i++) { tlpRack.ColumnStyles.Add(new ColumnStyle(SizeType.Absolute, this.Size.Width / Program.MaxX)); } for (var i = 0; i < tlpRack.RowCount; i++) { tlpRack.RowStyles.Add(new RowStyle(SizeType.Absolute, this.Size.Height / Program.MaxY)); } tlpRack.ColumnStyles.Add(new ColumnStyle(SizeType.Absolute, 1)); tlpRack.RowStyles.Add(new RowStyle(SizeType.Absolute, 1)); tlpRack.Show(); } catch (Exception ee) { LogFactory.Log(ee); } }
/// <summary> /// 그리드 세팅 /// </summary> private void InitializeGrid() { grdAIjubgmentHistory.AutoGenerateColumns = false; grdAIjubgmentHistory.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.EnableResizing; grdAIjubgmentHistory.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.BottomCenter; grdAIjubgmentHistory.AllowUserToAddRows = false; CommonFuction.SetDataGridViewColumnStyle(grdAIjubgmentHistory, "NO", "NO", "NO", typeof(string), 50, true, true, DataGridViewContentAlignment.MiddleCenter, 10); CommonFuction.SetDataGridViewColumnStyle(grdAIjubgmentHistory, "품목ID", "PRODUCTID", "PRODUCTID", typeof(string), 150, false, true, DataGridViewContentAlignment.MiddleCenter, 10); CommonFuction.SetDataGridViewColumnStyle(grdAIjubgmentHistory, "고객", "PRODUCTTYPE", "rackid", typeof(string), 150, false, true, DataGridViewContentAlignment.MiddleCenter, 20); CommonFuction.SetDataGridViewColumnStyle(grdAIjubgmentHistory, "도번", "PRODUCTNAME", "durableid", typeof(int), 180, false, true, DataGridViewContentAlignment.MiddleCenter, 20); CommonFuction.SetDataGridViewColumnStyle(grdAIjubgmentHistory, "품번", "PRODUCTNO", "productname", typeof(string), 180, false, true, DataGridViewContentAlignment.MiddleCenter, 80); CommonFuction.SetDataGridViewColumnStyle(grdAIjubgmentHistory, "LOT번호", "CUSTOMERNAME", "inputdate", typeof(string), 250, false, true, DataGridViewContentAlignment.MiddleCenter, 60); CommonFuction.SetDataGridViewColumnStyle(grdAIjubgmentHistory, "검사일자", "CREATOR", "inputresult", typeof(string), 200, false, true, DataGridViewContentAlignment.MiddleCenter, 35); CommonFuction.SetDataGridViewColumnStyle(grdAIjubgmentHistory, "최종판정", "CREATETIME", "usedate", typeof(string), 100, false, true, DataGridViewContentAlignment.MiddleLeft, 60); CommonFuction.SetDataGridViewColumnStyle(grdAIjubgmentHistory, "AI판정", "MODIFIER", "usedate", typeof(string), 100, false, true, DataGridViewContentAlignment.MiddleLeft, 60); CommonFuction.SetDataGridViewColumnStyle(grdAIjubgmentHistory, "불량유형", "MODIFIEDTIME", "usedate", typeof(string), 100, false, true, DataGridViewContentAlignment.MiddleLeft, 60); CommonFuction.SetDataGridViewColumnStyle(grdAIjubgmentHistory, "행변경타입", "ROWTYPE", "ROWTYPE", typeof(string), 100, false, false, DataGridViewContentAlignment.MiddleLeft, 60); }
private void VenderTabPageControl_Load(object sender, EventArgs e) { this.ActiveControl = txtVenderID; CommonFuction.SetUseYNList(ref cbbUseYN); try { sql = "SelectVender"; db.Open(); Dictionary <string, object> param = new Dictionary <string, object>(); dtgVenderList.DataSource = db.ExecuteProcedure(sql, param); DataGridViewProperties(); } catch (Exception ex) { LogFactory.Log(ex); CustomMessageBox.Show(MessageBoxButtons.OK, "확인", "문제가 발생했습니다.\n 로그를 확인하세요."); } }
/// <summary> /// 텍스트박스 입력 키 제한,엔터키 입력시 TAB키 반환 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void TextBox_KeyPress(object sender, KeyPressEventArgs e) { TextBox txt = (TextBox)sender; Control temp = txt.Parent; MaskTextBox mtb = null; while (temp.Parent != null) { if (temp is MaskTextBox) { mtb = temp as MaskTextBox; break; } temp = temp.Parent; } if (mtb == null) { return; } switch (mtb.Name) { case "txtVenderID": CommonFuction.TypingOnlyEngNum(sender, e, txtVenderID); if (e.KeyChar == (char)Keys.Enter) { SendKeys.Send("{TAB}"); } break; case "txtVenderName": if (Char.IsLetter(e.KeyChar) == false && Char.IsDigit(e.KeyChar) == false && e.KeyChar != 8 && e.KeyChar == ',') { e.Handled = true; } if (e.KeyChar == (char)Keys.Enter) { SendKeys.Send("{TAB}"); } break; } }
private void DurableProdTabPageControl_Load(object sender, EventArgs e) { this.ActiveControl = txtProdId; CommonFuction.SetUseYNList(ref cbbUseYn); txtVender.ucReadOnly = true; try { sql = "SelectDURABLEPRODUCT"; db.Open(); Dictionary <string, object> param = new Dictionary <string, object>(); dtgDurableProd.DataSource = db.ExecuteProcedure(sql, param); DataGridViewProperties(); } catch (Exception ee) { LogFactory.Log(ee); CustomMessageBox.Show(MessageBoxButtons.OK, "확인", "문제가 발생했습니다.\n 로그를 확인하세요."); } }
/// <summary> /// 콤보박스 아이템 세팅 /// </summary> private void SetComboBox() { CommonFuction.SetInputResultList(ref mcbmbInputResult); EmptyEquipList = CommonFuction.GetEmptyEquipList(); ModelCodeList = CommonFuction.ModelCodeList(); if (EmptyEquipList.Count > 0) { mcbmRack.ucComboBoxDataSource = EmptyEquipList; mcbmRack.cboCombo.SelectedIndex = -1; mcmbModelCode.ucComboBoxDataSource = ModelCodeList; mcmbModelCode.cboCombo.SelectedIndex = -1; } else { CustomMessageBox.Show(MessageBoxButtons.OK, "확인", "현재 비어있는 보관함이 없어 신규 Mask를 생성 할 수 없습니다."); btnNew.Enabled = false; } }
private void BtnLogIn_Click(object sender, EventArgs e) { MMCodeHelper CodeHelper = new MMCodeHelper("LOGIN"); CodeHelper.WindowState = FormWindowState.Normal; CodeHelper.ShowDialog(); Program.CurrentUser = CodeHelper.ReturnCodeValue; //2O19-05-15 황지희 관리자인 경우만 DB관리 버튼 VISIBLE 되도록수정 if (Program.CurrentUser.Equals("testadmin")) { lblCrrUser.Text = CodeHelper.ReturnNameValue; btnDB.Visible = true; } else { //2019-05-14 황지희 사용자 이름으로 보여주게 변경 lblCrrUser.Text = CommonFuction.GetUserName(Program.CurrentUser); btnDB.Visible = false; } }
/// <summary> /// 버튼의 이벤트들이 발생된 후 각각의 컨트롤러의 텍스트들을 초기화 해주는 함수 /// </summary> public void MakeEmpty() { CommonFuction.SetUseYNList(ref cbbUseYn); foreach (Control ctrl in groupBox1.Controls) { if (ctrl is UserControls.MaskTextBox) { UserControls.MaskTextBox tb = (UserControls.MaskTextBox)ctrl; if (string.IsNullOrWhiteSpace(tb.ucValue) == false) { tb.ucValue = string.Empty; } } if (ctrl is MaskCodeHelper) { MaskCodeHelper ch = (MaskCodeHelper)ctrl; if (string.IsNullOrWhiteSpace(ch.ucValue) == false) { ch.ucValue = string.Empty; } } } }
private void SaveData() { string ctrlname = ""; bool chkMand = CommonFuction.CheckMandatory(groupBox1, ref ctrlname); if (!chkMand) { return; } StringBuilder sBuilder = new StringBuilder(); sBuilder.Append("Data Source="); sBuilder.Append(mtxtIP.ucValue); sBuilder.Append("; initial Catalog="); sBuilder.Append(mtxtCatalog.ucValue); sBuilder.Append("; user="******"; password="******"DBConnectionString", sBuilder.ToString()); }
private void SaveCleanResult() { //2019-04-30 필수 입력값 확인 string ctrlname = ""; if (CommonFuction.CheckMandatory(grbox_1, ref ctrlname) == false) { CustomMessageBox.Show(MessageBoxButtons.OK, "ERROR", $"{ctrlname} 항목을 확인해주세요."); return; } if (CustomMessageBox.Show(MessageBoxButtons.OKCancel, "확인", "저장하시겠습니까?") == DialogResult.OK) { Dictionary <string, object> Params = new Dictionary <string, object>(); Params.Add("@durableid", this.txt_MaskNum.ucValue); //Mask 일련번호 Params.Add("@durableproductid", this.txt_MaskProd.ucValue); //모델명 Params.Add("@cleanresult", this.cmb_InspResult.ucValue); //Params.Add("@cleandate", DateTime.Now); //최근사용일자 Params.Add("@comment", this.txt_MaskProdName.ucValue); //사양 정보 Params.Add("@modifier", Program.CurrentUser); //수정자 Params.Add("@workstate", "WORKSTATE_WAIT"); //작업 상태 //2019-08-23 적치대 콤보 추가 Params.Add("@Rackid", this.mtxt_rack.ucValue); var PamasArr = DB.GetSqlParameters(Params); int SaveResult = DB.CallNonSelectProcedure("SaveCleanInsp", PamasArr); if (SaveResult > 0) { CustomMessageBox.Show(MessageBoxButtons.OK, "SAVE", "저장하였습니다."); InitReset(); //2019-05-08 저장후 Mask 일련번호로 포커싱 추가 txt_MaskNum.Focus(); resetRack.ResetRackStatus(true); } } }