// ＸＲグラフ作成ボタン押下時の処理
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;
// 因数の決定：検査項目に応じて、２つの測定値の差を、因数で割って表示・登録する（デフォルト因数は１）
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 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);
// ＨＡＹＷＡＲＤ２は１０桁の精度、ＣＡＲは８桁の精度
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;
// 上位と下位の、２つの測定値の差を、３行目に表示する
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;
}
}
// ＤＡＴＥＴＩＭＥＰＩＣＫＥＲを１０日前の日付にする
dtpSet10daysBefore(dtpLotFrom);
// ＤＡＴＥＴＩＭＥＰＩＣＫＥＲの分以下を切り上げる
dtpRoundUpHour(dtpLotTo);
// ＤＡＴＥＴＩＭＥＰＩＣＫＥＲの分以下を下げる
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);
}
