private void btnOk_Click(object sender, EventArgs e)
{
string datetime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
if (checkdata())
{
if (txtNewPass.Text == txtConfirmPass.Text)
{
//insert user into database.
string sqlinsertUser = @"insert into m_user (user_name, user_pass, user_permision,user_dept_cd,registration_date_time) VALUES ('"
+ txtUserName.Text + "','" + txtNewPass.Text + "','" + cmbPermision.Text + "','" + cmbDept.Text + "','" + datetime + "')";
IPQC_Motor.TfSQL con = new IPQC_Motor.TfSQL();
con.sqlExecuteScalarString(sqlinsertUser);
MessageBox.Show("User: '******' is created", "Info");
this.Close();
}
else
{
MessageBox.Show("Password is incorrect", "Error", MessageBoxButtons.RetryCancel, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1);
}
}
else
{
MessageBox.Show("Pls, insert fill full data", "Error", MessageBoxButtons.RetryCancel, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1);
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
try
{
if (dgvDwr.RowCount > 0)
{
int dwrlId = int.Parse(dgvDwr.Rows[dgvDwr.CurrentRow.Index].Cells["dwr_id"].Value.ToString());
IPQC_Motor.TfSQL tf = new IPQC_Motor.TfSQL();
string sqlDel = "delete from m_drawing where dwr_id = " + dwrlId;
DialogResult dialog = MessageBox.Show("Do you want to delete " + dgvDwr.Rows[dgvDwr.CurrentRow.Index].Cells["dwr_cd"].Value.ToString(), "Note !", MessageBoxButtons.YesNo, MessageBoxIcon.Information);
if (dialog == DialogResult.Yes)
{
tf.sqlExecuteNonQuery(sqlDel, false);
btnSearch_Click(sender, e);
}
}
else
{
MessageBox.Show("Choose a Drawing", "Note", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
catch
{ MessageBox.Show("Choose a Drawing", "Note", MessageBoxButtons.OK, MessageBoxIcon.Information); }
}
private void cmbMaSo_SelectedIndexChanged(object sender, EventArgs e)
{
string sqlPageID = "select case when max(page_id) is null then 1 else max(page_id) +1 end as maxcode from m_header";
IPQC_Motor.TfSQL con = new IPQC_Motor.TfSQL();
con.sqlExecuteScalarString(sqlPageID);
}
private void btnOK_Click(object sender, EventArgs e)
{
if (Check())
{
IPQC_Motor.TfSQL tf = new IPQC_Motor.TfSQL();
if (!CheckDup())
{
MessageBox.Show("Drawing Code exist in Database", "Note", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
bool showMes = false;
if (DrawingId == "")
{
string sqlAdd = "Insert into m_drawing(model_id, dwr_cd, dwr_name, doc_name, user_id, registration_date_time) values(" + int.Parse(cmbSubModel.SelectedValue.ToString()) + ", '" + txtDwrCd.Text + "', '" + txtDwrName.Text + "', '" + txtDoc.Text + "', (select user_id from m_user where user_name ='" + User + "'), now())";
showMes = tf.sqlExecuteNonQuery(sqlAdd, false);
}
else
{
string sqlUpdate = "update m_drawing set dwr_cd = '" + txtDwrCd.Text + "', dwr_name = '" + txtDwrName.Text + "', doc_name = '" + txtDoc.Text + "', user_id = (select user_id from m_user where user_name = '" + User + "'), registration_date_time = now() where dwr_id = " + DrawingId;
showMes = tf.sqlExecuteNonQuery(sqlUpdate, false);
}
if (showMes)
{
MessageBox.Show("Successful!", "Database Responce", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
}
private void btnOk_Click(object sender, EventArgs e)
{
IPQC_Motor.TfSQL con = new IPQC_Motor.TfSQL();
string sqlpass = "******" + username + "'";
if (txtOldPass.Text == con.sqlExecuteScalarString(sqlpass))
{//update new password
if (txtNewPass.Text == txtConfirmPass.Text)
{
string sqlupdatepass = "******" + txtNewPass.Text + "' where user_name = '" + username + "'";
IPQC_Motor.TfSQL update = new IPQC_Motor.TfSQL();
update.sqlExecuteScalarString(sqlupdatepass);
MessageBox.Show("your Password is changed", "Info");
this.Close();
}
else
{
MessageBox.Show("New Pasword is incorrect", "Error", MessageBoxButtons.RetryCancel, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1);
}
}
else
{
MessageBox.Show("Old Pasword is incorrect", "Error", MessageBoxButtons.RetryCancel, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1);
}
}
private void frmModel_Load(object sender, EventArgs e)
{
IPQC_Motor.TfSQL tf = new IPQC_Motor.TfSQL();
if (DrawingId == "")
{
Text = "Add Drawing";
string sqlCmbModel = @"select distinct model_cd from(select model_cd ,user_dept_cd from m_model a,m_user b where a.user_id = b.user_id )t,m_user a
where a.user_dept_cd = t.user_dept_cd and a.user_name = '" + User + "'";
getCmb(sqlCmbModel, ref cmbModel);
}
else
{
Text = "Update Drawing";
string sqlDwrCd = "select dwr_cd from m_drawing where dwr_id = " + int.Parse(DrawingId);
string sqlDwrName = "select dwr_name from m_drawing where dwr_id = " + int.Parse(DrawingId);
string sqlDoc = "select doc_name from m_drawing where dwr_id = " + int.Parse(DrawingId);
string sqlModel = "select model_cd from m_model where model_id =" + int.Parse(ModelId);
string sqlModelSub = "select model_sub_cd from m_model where model_id =" + int.Parse(ModelId);
txtDwrCd.Text = tf.sqlExecuteScalarString(sqlDwrCd);
txtDwrName.Text = tf.sqlExecuteScalarString(sqlDwrName);
txtDoc.Text = tf.sqlExecuteScalarString(sqlDoc);
cmbModel.SelectedText = tf.sqlExecuteScalarString(sqlModel);
cmbModel.Text = tf.sqlExecuteScalarString(sqlModel);
cmbSubModel.Text = tf.sqlExecuteScalarString(sqlModelSub);
cmbSubModel.Enabled = false;
cmbModel.Enabled = false;
}
}
private void btnOK_Click(object sender, EventArgs e)
{
if (Check())
{
IPQC_Motor.TfSQL tf = new IPQC_Motor.TfSQL();
if (!CheckDup())
{
MessageBox.Show("Model Sub exist in database!", "Database Responce", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
bool show = false;
if (ModelId == "")
{
string sqlAdd = "Insert into m_model(model_id, model_cd, model_sub_cd, user_id, registration_date_time) values((select max(model_id)+1 from m_model),'" + txtModel.Text + "', '" + txtModelSub.Text + "', (select user_id from m_user where user_name ='" + User + "'), now())";
show = tf.sqlExecuteNonQuery(sqlAdd, false);
}
else
{
string sqlUpdate = "update m_model set model_sub_cd = '" + txtModelSub.Text + "', user_id = (select user_id from m_user where user_name = '" + User + "'), registration_date_time = now() where model_id = " + int.Parse(ModelId);
show = tf.sqlExecuteNonQuery(sqlUpdate, false);
}
if (show)
{
MessageBox.Show("Successful!", "Database Responce", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
else
{
MessageBox.Show("Info is null", "Note", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
private void listTV_DoubleClick(object sender, EventArgs e)
{
try
{
int pageId = 0;
if (int.TryParse(listTV.SelectedNode.Tag.ToString(), out pageId))
{
IPQC_Motor.TfSQL tf = new IPQC_Motor.TfSQL();
string tagNode = "select count(*) from m_header where page_id = " + pageId;
long checkPage = tf.sqlExecuteScalarLong(tagNode);
if (checkPage > 0)
{
string[] a = listTV.SelectedNode.FullPath.ToString().Split('\\');
string DWRCd = a[0];
IPQC_Part.frmFMS from = new IPQC_Part.frmFMS(pageId, username, DWRCd);
this.Hide();
from.ShowDialog();
this.Show();
}
}
else
{
MessageBox.Show("Hãy chọn một mã máy !", "Note!", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
catch { return; }
}
public bool CheckDup()
{
IPQC_Motor.TfSQL tf = new IPQC_Motor.TfSQL();
string sqldup = "select count(*) from m_model where model_cd = '" + txtModel.Text + "' and model_sub_cd ='" + txtModelSub.Text + "'";
if (tf.sqlExecuteScalarDouble(sqldup) >= 1)
{
return(false);
}
return(true);
}
private void frmRegisterUser_Load(object sender, EventArgs e)
{
IPQC_Motor.TfSQL con = new IPQC_Motor.TfSQL();
string sqldept = "select distinct user_dept_cd from m_user order by user_dept_cd";
con.getComboBoxData(sqldept, ref cmbDept);
string sqlPermision = "select distinct user_permision from m_user order by user_permision";
con.getComboBoxData(sqlPermision, ref cmbPermision);
}
public bool CheckDup()
{
IPQC_Motor.TfSQL tf = new IPQC_Motor.TfSQL();
string sqldup = "select count(*) from m_drawing where dwr_cd = '" + txtDwrCd.Text + "'";
if (tf.sqlExecuteScalarDouble(sqldup) >= 1)
{
return(false);
}
return(true);
}
private void cmbModel_SelectedIndexChanged_1(object sender, EventArgs e)
{
IPQC_Motor.TfSQL tf = new IPQC_Motor.TfSQL();
DataTable dtModel = new DataTable();
string sqlCmbModeSub = "select model_sub_cd,model_id from m_model where model_cd = '" + cmbModel.Text + "' order by model_sub_cd";
tf.sqlDataAdapterFillDatatable(sqlCmbModeSub, ref dtModel);
cmbSubModel.DataSource = dtModel;
cmbSubModel.ValueMember = "model_id";
cmbSubModel.DisplayMember = "model_sub_cd";
cmbSubModel.Text = "";
}
void callpic()
{
IPQC_Motor.TfSQL tfSql = new IPQC_Motor.TfSQL();
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 frmModel_Load(object sender, EventArgs e)
{
if (ModelId == "")
{
Text = "Add Model";
}
else
{
IPQC_Motor.TfSQL tf = new IPQC_Motor.TfSQL();
string sqlModel = "select model_cd from m_model where model_id = " + int.Parse(ModelId);
string sqlModelSub = "select model_sub_cd from m_model where model_id = " + int.Parse(ModelId);
Text = "Update Model";
txtModel.Enabled = false;
txtModel.Text = tf.sqlExecuteScalarString(sqlModel);
txtModelSub.Text = tf.sqlExecuteScalarString(sqlModelSub);
}
}
void buildDGV(ref DataGridView dgv)
{
//create datagipview
dtInspectItems = new DataTable();
dtInspectItems.Clear();
string sql = @"
select a.item_measure, a.item_detail, a.item_spec_x, a.item_lower, a.item_upper,
(a.item_upper - a.item_spec_x) as tolerance_up , (a.item_lower - a.item_spec_x) as tolerances_low,a.item_tool,
b.data_1, b.data_2, b.data_3, b.data_4, b.data_5, b.data_x, b.data_est, b.registration_date_time from m_item a left join
(select dwr_cd,dwr_id, user_dept_cd from m_drawing a, m_user b where a.user_id = b.user_id) c on a.dwr_id = c.dwr_id
left join m_data b on a.item_id = b.item_id where c.dwr_cd = '" + drawingcd + "' and c.user_dept_cd = (select distinct user_dept_cd from m_user where user_name = '" + username + @"')
order by registration_date_time desc, item_measure asc ";
IPQC_Motor.TfSQL con = new IPQC_Motor.TfSQL();
con.sqlDataAdapterFillDatatable(sql, ref dtInspectItems);
dgv.DataSource = dtInspectItems;
}
private void btnSearch_Click(object sender, EventArgs e)
{
IPQC_Motor.TfSQL tf = new IPQC_Motor.TfSQL();
dt = new DataTable();
string sqlSearch = "select t.model_id, t.model_cd, t.model_sub_cd from m_user m,(select model_id,model_cd,model_sub_cd, user_dept_cd from m_model a,m_user b where a.user_id = b.user_id ) t where m.user_dept_cd = t.user_dept_cd and m.user_name ='" + User + "' ";
if (!String.IsNullOrEmpty(txtModel.Text))
{
sqlSearch += " and t.model_cd = '" + txtModel.Text + "'";
}
if (!String.IsNullOrEmpty(txtModelSub.Text))
{
sqlSearch += " and t.model_sub_cd = '" + txtModelSub.Text + "'";
}
sqlSearch += " order by t.model_cd, t.model_id";
tf.sqlDataAdapterFillDatatable(sqlSearch, ref dt);
updateDGV(ref dgvModel, ref dt);
}
private void frmFMS_Load(object sender, EventArgs e)
{
IPQC_Motor.TfSQL con = new IPQC_Motor.TfSQL();
string sqlProcedure = @"
select distinct header_procedure from
(select header_procedure, user_dept_cd from m_header a, m_user b where a.user_id = b.user_id)t, m_user a
where a.user_dept_cd = t.user_dept_cd and a.user_name = '" + username + "' order by header_procedure";
con.getComboBoxData(sqlProcedure, ref cmbQuiTrinh);
string sqlMachine = @"
select distinct header_machine from
(select header_machine, user_dept_cd from m_header a, m_user b where a.user_id = b.user_id)t, m_user a
where a.user_dept_cd = t.user_dept_cd and a.user_name = '" + username + "' order by header_machine";
con.getComboBoxData(sqlMachine, ref cmbMaSo);
callpic();
}
private void btnSearch_Click(object sender, EventArgs e)
{
IPQC_Motor.TfSQL tf = new IPQC_Motor.TfSQL();
dt = new DataTable();
string sqlSearch = @"select b.model_id, b.model_sub_cd, 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 1=1 ";
if (!String.IsNullOrEmpty(cmbModel.Text))
{
sqlSearch += " and b.model_cd = '" + cmbModel.Text + "'";
}
if (!String.IsNullOrEmpty(cmbSubModel.Text))
{
sqlSearch += " and b.model_sub_cd = '" + cmbSubModel.Text + "'";
}
if (!String.IsNullOrEmpty(txtDwr.Text))
{
sqlSearch += " and a.dwr_cd = '" + txtDwr.Text + "'";
}
sqlSearch += " order by b.model_id";
tf.sqlDataAdapterFillDatatable(sqlSearch, ref dt);
updateDGV(ref dgvDwr, ref dt);
}
private void frmModel_Load(object sender, EventArgs e)
{
IPQC_Motor.TfSQL con = new IPQC_Motor.TfSQL();
string sql = @"select distinct model_cd from(select model_cd ,user_dept_cd from m_model a,m_user b where a.user_id = b.user_id )t,m_user a
where a.user_dept_cd = t.user_dept_cd and a.user_name = '" + User + "'";
}
public void getCmb(string sql, ref ComboBox cmb)
{
IPQC_Motor.TfSQL tf = new IPQC_Motor.TfSQL();
tf.getComboBoxData(sql, ref cmb);
}
private void TreeView2(string DwrCd, string dateFrom, string dateTo, int limit, bool showDrawing)
{
DataTable dtTV = new DataTable();
listTV.Nodes.Clear();
IPQC_Motor.TfSQL tfSql = new IPQC_Motor.TfSQL();
string sqlTreeDr = "select dwr_cd, dwr_name from m_drawing where model_id in (select model_id from m_model where model_sub_cd = '" + cmbSubModel.Text + "') ";
if (showDrawing)
{
sqlTreeDr += " and dwr_cd = '" + DwrCd + "' ";
}
sqlTreeDr += " order by dwr_cd";
tfSql.sqlDataAdapterFillDatatable(sqlTreeDr, ref dtTV);
if (dtTV.Rows.Count > 0)
{
TreeNode[] header = new TreeNode[dtTV.Rows.Count];
for (int k = 0; k < dtTV.Rows.Count; k++)
{
DataTable dtTreeNode = new DataTable();
TreeNode treeheader = new TreeNode
{
Text = dtTV.Rows[k]["dwr_cd"].ToString(),
Tag = dtTV.Rows[k]["dwr_cd"].ToString()
};
header[k] = treeheader;
if (showDrawing)
{
header[k].Expand();
}
StringBuilder sqlTV = new StringBuilder();
sqlTV.Append(@"select cast(a.registration_date_time as date) dates
from m_header a left join m_data b on a.page_id = b.page_id left join m_item c on b.item_id = c.item_id
where c.dwr_id = (select dwr_id from m_drawing where dwr_cd = '" + header[k].Tag + "') and a.registration_date_time >= '" + dateFrom.ToString() +
"' and cast(a.registration_date_time as date) <= '" + dateTo.ToString() + "' group by dates order by dates desc limit " + limit);
tfSql.sqlDataAdapterFillDatatable(sqlTV.ToString(), ref dtTreeNode);
if (dtTreeNode.Rows.Count > 0)
{
TreeNode[] headerN = new TreeNode[dtTreeNode.Rows.Count];
for (int i = 0; i < dtTreeNode.Rows.Count; i++)
{
TreeNode treeheaderN = new TreeNode
{
Text = DateTime.Parse(dtTreeNode.Rows[i]["dates"].ToString()).ToString("yyyy-MM-dd"),
};
headerN[i] = treeheaderN;
header[k].Nodes.Add(treeheaderN);
DataTable dtChildNode = new DataTable();
string sqlNodeChild = @"select * from (select a.page_id, header_machine, footer_result, cast(a.registration_date_time as date) dates,a.registration_date_time date
from m_header a left join m_data b on a.page_id = b.page_id left join m_item c on b.item_id = c.item_id where c.dwr_id = (select dwr_id from m_drawing where dwr_cd = '" + header[k].Tag + "') group by a.page_id,a.registration_date_time, header_machine, footer_result) tb where tb.dates = '" + headerN[i].Text + "'";
tfSql.sqlDataAdapterFillDatatable(sqlNodeChild, ref dtChildNode);
TreeNode[] headerchild = new TreeNode[dtChildNode.Rows.Count];
for (int j = 0; j < dtChildNode.Rows.Count; j++)
{
TreeNode treeheaderchild = new TreeNode
{
Text = "MM: " + dtChildNode.Rows[j]["header_machine"].ToString() + " -- Page Id: " + dtChildNode.Rows[j]["page_id"].ToString() + " " + dtChildNode.Rows[j]["footer_result"].ToString(),
Tag = dtChildNode.Rows[j]["page_id"].ToString()
};
headerchild[j] = treeheaderchild;
if (dtChildNode.Rows[j]["footer_result"].ToString() == "NG")
{
headerchild[j].BackColor = Color.Red;
}
else if (dtChildNode.Rows[j]["footer_result"].ToString() == "OK")
{
}
else
{
headerchild[j].BackColor = Color.Yellow;
}
headerN[i].Nodes.Add(treeheaderchild);
}
}
}
listTV.Nodes.Add(header[k]);
}
}
}