Esempio n. 1
0
        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)
        {
            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 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)
 {
     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);
     }
 }
Esempio n. 5
0
        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;
            }
        }
Esempio n. 6
0
        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;
            }
        }