// XRグラフ作成ボタン押下時の処理 private void btnExport_Click(object sender, EventArgs e) { TfSQL sampl = new TfSQL(); string sample = sampl.sqlExecuteScalarString("select clm_set from tbl_measure_item where inspect = '" + txtInspect.Text + "'"); string descrip = sampl.sqlExecuteScalarString("select description from tbl_measure_item where inspect = '" + txtInspect.Text + "'"); ExcelClassnew xl = new ExcelClassnew(); string dtpFrom = dtpLotFrom.Value.ToString("yyyy/MM/dd"); string dtpTo = dtpLotTo.Value.ToString("yyyy/MM/dd"); xl.exportExcel(txtModel.Text, cmbLine.Text, txtUser.Text, txtUsl.Text, txtLsl.Text, txtProcess.Text, txtInspect.Text, sample, descrip, dgvHistory, dtpFrom, dtpTo); }
// データ受信が発生したときのイベント処理(デレゲート先) private void RcvDataToBufferDataTable(string cmd) { // 測定値の送信要求に対する返信の場合のみ処理 //if (cmd.Length != 17) return; // 因数の決定:検査項目に応じて、2つの測定値の差を、因数で割って表示・登録する(デフォルト因数は1) string inspect = txtInspect.Text; double factor = 1; List <string> list10 = new List <string> { "CAFBVP2", "CAFBVP4", "CAFBVP2", "CAFBVP4", "CAFBVP2", "CAFBVP4" }; List <string> list5 = new List <string> { "RBCAVL", "RBCAVL", "RBCAVL" }; if (list10.Contains(inspect)) { factor = 10; } if (list5.Contains(inspect)) { factor = 5; } // 正しい文字列から始まる受信文字列のみ処理する if (cmd.Substring(0, 2) == command2) { // 測定値のテキストを、DOUBLEに変換してBUFFERTABLEへ格納する double value = 0; string sql = "select dbplace from tbl_model_dbplace where model='" + txtModel.Text + "'"; System.Diagnostics.Debug.Print(sql); TfSQL tf = new TfSQL(); string dbplace = tf.sqlExecuteScalarString(sql); // HAYWARD2は10桁の精度、CARは8桁の精度 if (dbplace == "A") { double.TryParse(cmd.Substring(4, 8), out value); } else if (dbplace == "CAR") { double.TryParse(cmd.Substring(4, 8), out value); } dtBuffer.Rows[vAdr][hAdr] = value; // 上位と下位の、2つの測定値の差を、3行目に表示する if (dtBuffer.Rows[0][hAdr].ToString() != String.Empty && dtBuffer.Rows[1][hAdr].ToString() != String.Empty) { dtBuffer.Rows[2][hAdr] = Math.Round((double.Parse(dtBuffer.Rows[0][hAdr].ToString()) - double.Parse(dtBuffer.Rows[1][hAdr].ToString())) / factor, 4); } // グリットビューの更新 updateDataGripViews(dtBuffer, dtHistory, ref dgvBuffer, ref dgvHistory); // スペック外のセルをマーキングする(一時テーブル) colorBufferViewBySpec(value, ref dgvBuffer); } }
public void updateDataGripViews(ref DataGridView dgv, bool load) { dgv.Columns.Clear(); dtInspectItems.Clear(); dgv.RowTemplate.MinimumHeight = 28; string sql = @"select b.model_sub_cd as model, a.dwr_cd, a.dwr_name, a.doc_name, a.registration_date_time,a.dwr_id from m_drawing a left join m_model b on a.model_id = b.model_id where b.model_cd = '" + cmbModel.Text + "' and b.model_sub_cd = '" + cmbSubModel.Text + "' order by dwr_cd"; TfSQL tf = new TfSQL(); tf.sqlDataAdapterFillDatatable(sql, ref dtInspectItems); dgv.DataSource = dtInspectItems; if (dgv.RowCount > 0) { colNew = new DataGridViewButtonColumn { Text = "Measure New", UseColumnTextForButtonValue = true, }; colCon = new DataGridViewButtonColumn { Text = "Continue", UseColumnTextForButtonValue = true, }; colEdit = new DataGridViewButtonColumn { Text = "Edit", UseColumnTextForButtonValue = true, }; dgv.Columns.Add(colNew); dgv.Columns.Add(colCon); string sqlpermision = "select distinct user_permision from m_user where user_name = '" + username + "'"; if (tf.sqlExecuteScalarString(sqlpermision) == "admin") { dgv.Columns.Add(colEdit); dgv.Columns[8].HeaderText = "Edit"; } dgv.Columns["model"].HeaderText = "Model"; dgv.Columns["dwr_cd"].HeaderText = "Drawing Code"; dgv.Columns["dwr_name"].HeaderText = "Drawing Name"; dgv.Columns["doc_name"].HeaderText = "Document"; dgv.Columns["registration_date_time"].HeaderText = "Date"; dgv.Columns[6].HeaderText = "New"; dgv.Columns[7].HeaderText = "Continue"; dgv.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; dgv.Columns[0].AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells; dgv.Columns[1].AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells; dgv.Columns[2].AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells; dgv.Columns[3].AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells; dgv.Columns[4].Visible = false; dgv.Columns[5].Visible = false; dgv.Columns[7].AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells; dgv.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; } }
public void LoadItem() { dgvTester.Columns.Clear(); txtDwr.Text = DrawingCd; string sql = "select item_id,a.dwr_id , item_measure, item_symbol,item_tool,item_row,item_detail,item_spec_x, item_lower, item_upper from m_item a left join m_drawing b on a.dwr_id = b.dwr_id where b.dwr_cd = '" + DrawingCd + "' order by item_measure,item_id asc "; TfSQL tfSql = new TfSQL(); dt = new DataTable(); tfSql.sqlDataAdapterFillDatatable(sql, ref dt); dgvTester.DataSource = dt; //add columns Delete colDel = new DataGridViewButtonColumn() { Text = "Delete", UseColumnTextForButtonValue = true }; dgvTester.Columns.Add(colDel); //Fix DGV dgvTester.Columns["item_id"].Visible = false; dgvTester.Columns["dwr_id"].Visible = false; dgvTester.Columns["item_measure"].HeaderText = "Item"; dgvTester.Columns["item_symbol"].HeaderText = "Symbol"; dgvTester.Columns["item_spec_x"].HeaderText = "Spec"; dgvTester.Columns["item_lower"].HeaderText = "Lower"; dgvTester.Columns["item_upper"].HeaderText = "Upper"; dgvTester.Columns["item_tool"].HeaderText = "Tool"; dgvTester.Columns["item_detail"].HeaderText = "Detail"; dgvTester.Columns["item_row"].HeaderText = "Row"; dgvTester.Columns[10].HeaderText = "Delete"; dgvTester.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; dgvTester.Columns["item_measure"].AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells; //Load Image to picture box string bytePic = tfSql.sqlExecuteScalarString("select dwr_image from m_drawing where dwr_cd = '" + DrawingCd + "'"); ShowImage(bytePic, picbox); string bytePicMain = tfSql.sqlExecuteScalarString("select dwr_image_main from m_drawing where dwr_cd = '" + DrawingCd + "'"); ShowImage(bytePicMain, picbox_main); }
private void btnAdd_Click(object sender, EventArgs e) { dgvTester.ReadOnly = false; dgvTester.AllowUserToAddRows = true; btnSave.Enabled = true; btnAdd.Enabled = false; TfSQL tf = new TfSQL(); itemId = int.Parse(tf.sqlExecuteScalarString("select max(item_id) from m_item")); }
private void dgvTester_RowsAdded(object sender, DataGridViewRowsAddedEventArgs e) { if (btnAdd.Enabled == false) { TfSQL tf = new TfSQL(); string itemId = tf.sqlExecuteScalarString("select max(item_id) +1 from m_item"); string drwId = tf.sqlExecuteScalarString("select dwr_id from m_drawing where dwr_cd = '" + DrawingCd + "'"); if (dgvTester.Rows.Count >= 1) { dgvTester.Rows[dgvTester.Rows.Count - 2].Cells["item_id"].Value = itemId; dgvTester.Rows[dgvTester.Rows.Count - 2].Cells["dwr_id"].Value = drwId; } else if (dgvTester.Rows.Count == 0) { dgvTester.Rows[0].Cells["item_id"].Value = itemId; dgvTester.Rows[0].Cells["dwr_id"].Value = drwId; } } }
public void SaveImage(PictureBox pic, string column) { OpenFileDialog file = new OpenFileDialog(); file.Title = "Open Image File"; file.Filter = "Image files|*.jpg;*.png"; if (file.ShowDialog() == DialogResult.OK) { if (file.FileName != "") { string fileName = file.FileName.ToString(); long size = new System.IO.FileInfo(fileName).Length / 1024; bool doing = false; if (size > 310) { DialogResult dialog = MessageBox.Show("File size is greater than 300 Kb !" + System.Environment.NewLine + "Do you want continue!", "Note!", MessageBoxButtons.YesNo, MessageBoxIcon.Warning); if (dialog == DialogResult.Yes) { doing = true; } } else { doing = true; } if (doing == true) { byte[] img = System.IO.File.ReadAllBytes(fileName); MemoryStream meStream = new MemoryStream(img); pic.Image = new Bitmap(meStream); pic.SizeMode = PictureBoxSizeMode.Zoom; FileStream fs = new FileStream(fileName, FileMode.Open, FileAccess.Read); byte[] picbyte = new byte[fs.Length]; fs.Read(picbyte, 0, System.Convert.ToInt32(fs.Length)); fs.Close(); TfSQL sql = new TfSQL(); int dwrId = int.Parse(sql.sqlExecuteScalarString("select dwr_id from m_drawing where dwr_cd = '" + DrawingCd + "'")); string sqlEx = "update m_drawing set " + column + " = '" + Convert.ToBase64String(picbyte) + "' where dwr_id = " + dwrId; sql.sqlExecuteNonQueryInt(sqlEx, false); doing = false; } } else { MessageBox.Show("No file selected!", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information); } } }
private void drawingToolStripMenuItem_Click(object sender, EventArgs e) { TfSQL tf = new TfSQL(); string pemission = tf.sqlExecuteScalarString("select distinct user_permision from m_user where user_name = '" + username + "'"); if (pemission == "admin") { IPQC_Part.frmDrawing dwrFrm = new IPQC_Part.frmDrawing(username); dwrFrm.ShowDialog(); } else { MessageBox.Show("Your have not permision", "Error", MessageBoxButtons.RetryCancel, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1); } }
public void LoadItem() { txtDwr.Text = DrawingCd; string sql = "select item_id,a.dwr_id , item_measure, item_symbol,item_tool,item_row,item_detail,item_spec_x, item_lower, item_upper from m_item a left join m_drawing b on a.dwr_id = b.dwr_id where b.dwr_cd = '" + DrawingCd + "' "; TfSQL tfSql = new TfSQL(); dt = new DataTable(); tfSql.sqlDataAdapterFillDatatable(sql, ref dt); dgvTester.DataSource = dt; //Fix DGV //dgvTester.Columns["item_id"].HeaderText = "Id"; //dgvTester.Columns["dwr_cd"].HeaderText = "Drawing"; dgvTester.Columns["item_id"].Visible = false; dgvTester.Columns["dwr_id"].Visible = false; dgvTester.Columns["item_measure"].HeaderText = "Measure Item"; dgvTester.Columns["item_symbol"].HeaderText = "Symbol"; dgvTester.Columns["item_spec_x"].HeaderText = "Spec"; dgvTester.Columns["item_lower"].HeaderText = "Lower"; dgvTester.Columns["item_upper"].HeaderText = "Upper"; dgvTester.Columns["item_tool"].HeaderText = "Tool"; dgvTester.Columns["item_detail"].HeaderText = "Detail"; dgvTester.Columns["item_row"].HeaderText = "Row"; dgvTester.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; //dgvTester.Columns["item_measure"].AutoSizeMode = DataGridViewAutoSizeColumnMode.ColumnHeader; dgvTester.Columns["item_measure"].Width = 100; //Load Image to picture box string bytePic = tfSql.sqlExecuteScalarString("select dwr_image from m_drawing where dwr_cd = '" + DrawingCd + "'"); if (bytePic != "") { byte[] imgBytes = Convert.FromBase64String(bytePic); MemoryStream ms = new MemoryStream(imgBytes, 0, imgBytes.Length); ms.Write(imgBytes, 0, imgBytes.Length); Image image = Image.FromStream(ms, true); picbox.Image = image; picbox.SizeMode = PictureBoxSizeMode.Zoom; } }
private void btnSaveImg_Click(object sender, EventArgs e) { if (txtLink.Text != "") { FileStream fs = new FileStream(txtLink.Text, FileMode.Open, FileAccess.Read); byte[] pic = new byte[fs.Length]; fs.Read(pic, 0, System.Convert.ToInt32(fs.Length)); fs.Close(); TfSQL sql = new TfSQL(); int dwrId = int.Parse(sql.sqlExecuteScalarString("select dwr_id from m_drawing where dwr_cd = '" + DrawingCd + "'")); string sqlEx = "update m_drawing set dwr_image = '" + Convert.ToBase64String(pic) + "' where dwr_id = " + dwrId; bool bsave = true; sql.sqlExecuteNonQueryInt(sqlEx, bsave); } else { MessageBox.Show("Select a file !", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information); txtLink.Text = ""; } }
private void btnLogIn_Click(object sender, EventArgs e) { TfSQL con = new TfSQL(); string sql = "select user_pass from m_user where user_name = '" + cmbUserName.Text + "'"; string pass = con.sqlExecuteScalarString(sql); try { if (pass == txtPassword.Text) { frmItem frm = new frmItem(cmbUserName.Text); frm.ShowDialog(); } else { MessageBox.Show("Pasword is incorrect", "Error", MessageBoxButtons.RetryCancel, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1);//danglq3 test } } catch { MessageBox.Show("An error happened in the process.", "Error", MessageBoxButtons.RetryCancel, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1); } }
// ロード時の処理 private void frmManual_Load(object sender, EventArgs e) { // 当フォームの表示場所を指定 this.Left = 300; this.Top = 15; if (cmbLine.Text == "") { btnMeasure.Enabled = false; } //Exit app if user has been log in by another device TfSQL flag = new TfSQL(); string ipadd = flag.sqlExecuteScalarString("select ip_address from qc_user where qcuser = '******'"); bool expmiss = flag.sqlExecuteScalarBool("select export_permission from qc_user where qcuser = '******'"); if (ipadd == "null") { flag.sqlExecuteScalarString("UPDATE qc_user SET loginstatus=true, ip_address = '" + _ip + "' where qcuser = '******'"); } if (ipadd != "null" && ipadd != _ip) { DialogResult res = MessageBox.Show("User is logged in " + _ip + "," + System.Environment.NewLine + "Do you want to log out and log in again ?", "Notice", MessageBoxButtons.OK, MessageBoxIcon.Question); if (res == DialogResult.OK) { Application.Exit(); } } if (txtUser.Text != "Admin") { string[] a = txtUser.Text.Split('_'); //User permission if (a[1] != "CHK" && txtUser.Text != "Admin") { btnMeasure.Enabled = false; btnRegister.Enabled = false; btnDelete.Enabled = false; } if (expmiss == false && txtUser.Text != "Admin") { btnExport.Enabled = false; } } // DATETIMEPICKERを10日前の日付にする dtpSet10daysBefore(dtpLotFrom); // DATETIMEPICKERの分以下を切り上げる dtpRoundUpHour(dtpLotTo); // DATETIMEPICKERの分以下を下げる dtpRounddownHour(dtpLotInput); // 各種処理用のテーブルを生成してデータを読み込む dtBuffer = new DataTable(); defineBufferAndHistoryTable(ref dtBuffer); dtHistory = new DataTable(); defineBufferAndHistoryTable(ref dtHistory); readDtHistory(ref dtHistory); dtUpLowIns = new DataTable(); setLimitSetAndCommand(ref dtUpLowIns); // グリットビューの更新 updateDataGripViews(dtBuffer, dtHistory, ref dgvBuffer, ref dgvHistory); // グリットビュー右端にボタンを追加(初回のみ) addButtonsToDataGridView(dgvHistory); }