// サブプロシージャ：上限・下限、行セット・列セット、コマンド、の設定
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);
}
