// サブプロシージャ:上限・下限、行セット・列セット、コマンド、の設定 private void setLimitSetAndCommand(ref DataTable dt) { dt.Clear(); string sql = "select upper, lower, clm_set, row_set, instrument from tbl_measure_item " + "where model = '" + txtModel.Text + "' and " + "inspect = '" + txtInspect.Text + "' and process = '" + txtProcess.Text + "'"; System.Diagnostics.Debug.Print(sql); TfSQL tf = new TfSQL(); tf.sqlDataAdapterFillDatatable(sql, ref dt); upp = (double)dt.Rows[0]["upper"]; txtUsl.Text = upp.ToString(); low = (double)dt.Rows[0]["lower"]; txtLsl.Text = low.ToString(); rowSet = (int)dt.Rows[0]["row_set"]; clmSet = (int)dt.Rows[0]["clm_set"]; if (dt.Rows[0]["instrument"].ToString() == "push") { command = push; } else if (dt.Rows[0]["instrument"].ToString() == "pull") { command = pull; } }
private void readDtHistoryCust(ref DataTable dt) { dt.Clear(); string model = txtModel.Text; string process = txtProcess.Text; string inspect = txtInspect.Text; DateTime lotFrom = dtpLotFrom.Value; DateTime lotTo = dtpLotTo.Value; string line = cmbLine.Text; string sql = "select inspect, lot, inspectdate, line, qc_user, status, " + "m1, m2, m3, m4, m5, x, r FROM tbl_measure_history " + "WHERE model = '" + model + "' AND " + "process = '" + process + "' AND " + "inspect = '" + inspect + "' AND " + "lot >= '" + lotFrom.ToString() + "' AND " + "lot <= '" + lotTo.ToString() + "' AND " + "line = '" + line + "' AND qc_user != '1. Upper' AND qc_user != '2. Lower' AND " + "qc_user not like '%Point%' AND status = '' " + "order by lot, inspectdate"; System.Diagnostics.Debug.Print(sql); TfSQL tf = new TfSQL(); tf.sqlDataAdapterFillDatatable(sql, ref dt); }
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 updateDataGripViews(ref DataGridView dgv, bool load) { dtInspectItems.Clear(); string sql = @"select b.model_sub_cd as model, a.dwr_cd, a.dwr_name, a.doc_name, a.registration_date_time 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"; // System.Diagnostics.Debug.Print(sql); TfSQL tf = new TfSQL(); tf.sqlDataAdapterFillDatatable(sql, ref dtInspectItems); dgv.DataSource = dtInspectItems; }
// 既存測定値の修正 private void dgvHistory_CellContentClick(object sender, DataGridViewCellEventArgs e) { int curRow = int.Parse(e.RowIndex.ToString()); if (dgvHistory.Columns[e.ColumnIndex] == Open && curRow >= 0) { // 編集モードフラグを立て、登録・修正ボタンを「修正」の表示にする editMode = true; btnRegister.Text = "Update"; dtpLotInput.Enabled = false; // 新規登録用バッファーテーブル、バッファーグリットビューを初期化し、ボタンに対応する値を格納する dtBuffer.Clear(); string sql = "select inspect, lot, inspectdate, line, qc_user, status, " + "m1, m2, m3, m4, m5 FROM tbl_measure_history WHERE " + "model = '" + txtModel.Text + "' AND " + "inspect = '" + dgvHistory["inspect", curRow].Value.ToString() + "' AND " + "lot = '" + (DateTime)dgvHistory["lot", curRow].Value + "' AND " + "inspectdate = '" + (DateTime)dgvHistory["inspectdate", curRow].Value + "' AND " + "line = '" + dgvHistory["line", curRow].Value.ToString() + "' " + "order by qc_user"; System.Diagnostics.Debug.Print(sql); TfSQL tf = new TfSQL(); tf.sqlDataAdapterFillDatatable(sql, ref dtBuffer); // グリットビューの更新 updateDataGripViews(dtBuffer, dtHistory, ref dgvBuffer, ref dgvHistory); // 新規登録用グリットビュー(バッファテーブル)へ、ボタンを追加する if (dgvBuffer.Columns.Count <= 13) { addButtonsToDgvBuffer(dgvBuffer, edit1, edit2, edit3, edit4, edit5); } // 変更ターゲット行を表示する if (dgvHistory.Rows.Count >= 1) { dgvHistory.FirstDisplayedScrollingRowIndex = curRow; } // サブプロシージャ:編集中の行をマーキングする colorViewForEdit(ref dgvHistory, curRow); colorViewForEdit(ref dgvBuffer, 0); } }
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; } }
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); }