コード例 #1
0
        /// <summary>
        ///
        /// </summary>
        /// <param name="objEntrada"></param>
        public void RegistroRepairSMDPrincipal(Model_EntradaSMD objEntrada)
        {
            try
            {
                OpenConnection();
                string strInsert = string.Format(@"INSERT INTO dbo.PrincipalProcessRepair 
                                                 VALUES(@data,@hora,@cod,NULL,
                                                 NULL,'',NULL,NULL,
                                                 NULL,'N/A',NULL,
                                                 '','',NULL,NULL,@user,'','WAITING','','','','SMD','0','0')");
                using (cmd = new SqlCommand(strInsert, conn))
                {
                    string data = DateTime.Now.ToString("yyyy/MM/dd");
                    string hora = DateTime.Now.ToString("HH:mm:ss");

                    cmd.Parameters.AddWithValue("@data", data);
                    cmd.Parameters.AddWithValue("@hora", hora);
                    cmd.Parameters.AddWithValue("@cod", objEntrada.EntradaId);
                    cmd.Parameters.AddWithValue("@user", objEntrada.UserName);


                    cmd.ExecuteNonQuery();
                }
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message);
            }
            finally
            {
                ClosedConnection();
            }
        }
コード例 #2
0
 public Model_EntradaSMD GetCodPai()
 {
     try
     {
         OpenConnection();
         string strSelect = string.Format(@"SELECT TOP(1)CodReparoMain FROM EntradaRepairMain  ORDER BY CodReparoMain DESC");
         using (cmd = new SqlCommand(strSelect, conn))
         {
             using (Dr = cmd.ExecuteReader())
             {
                 Model_EntradaSMD objModel = null;
                 while (Dr.Read())
                 {
                     objModel           = new Model_EntradaSMD();
                     objModel.EntradaId = Convert.ToInt32(Dr[0]);
                 }
                 return(objModel);
             }
         }
     }
     catch (SqlException ex)
     {
         throw new Exception(ex.Message);
     }
     finally
     {
         ClosedConnection();
     }
 }
コード例 #3
0
        public void RegistroRepairSMD(Model_EntradaSMD objEntrada)
        {
            try
            {
                OpenConnection();
                string strInsert = string.Format(@"INSERT INTO dbo.EntradaRepairMain VALUES(@data,@hora,NULL,@model,@falhas,@line,NULL,@cn,@user,@tec,'SMD')");
                using (cmd = new SqlCommand(strInsert, conn))
                {
                    string data = DateTime.Now.ToString("yyyy/MM/dd");
                    string hora = DateTime.Now.ToString("HH:mm:ss");

                    cmd.Parameters.AddWithValue("@data", data);
                    cmd.Parameters.AddWithValue("@hora", hora);
                    cmd.Parameters.AddWithValue("@model", objEntrada.Model);
                    cmd.Parameters.AddWithValue("@falhas", objEntrada.Falhas);
                    cmd.Parameters.AddWithValue("@line", objEntrada.Line);
                    cmd.Parameters.AddWithValue("@cn", objEntrada.CN);
                    cmd.Parameters.AddWithValue("@user", objEntrada.UserName);
                    cmd.Parameters.AddWithValue("@tec", objEntrada.TecnicoSMD);
                    cmd.ExecuteNonQuery();
                }
            }
            catch (Exception ex)
            {
                throw new Exception("Error to Insert: " + ex.Message);
            }
            finally
            {
                ClosedConnection();
            }
        }
コード例 #4
0
        protected void btnSalve_Click(object sender, EventArgs e)
        {
            foreach (GridViewRow row in GridView1.Rows)
            {
                if (((CheckBox)row.FindControl("ckeckBoxInsert")).Checked)
                {
                    string EntradaId = ((Label)row.FindControl("lblCodigo")).Text;


                    Model_EntradaSMD objModel = new Model_EntradaSMD();
                    objModel.EntradaId = Convert.ToInt32(EntradaId);
                    objModel.UserName  = ddlTec.SelectedValue;

                    Class_SMD_Board_Plus_Tecnico add = new Class_SMD_Board_Plus_Tecnico();

                    if (ddlTec.SelectedItem.Text != "ALL")
                    {
                        add.RegistrarTecnicoComBoard(objModel);
                        add.UpdateStatus(objModel);
                        ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Relacionamento feito com sucesso');", true);
                    }
                    else
                    {
                        add.RegistrarTecnicoComBoardNUll(objModel);
                        add.UpdateStatusNull(objModel);
                        ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Relacionamento feito com sucesso');", true);
                    }

                    ListaAll();
                    getTec();
                }
            }
        }
コード例 #5
0
 public void RegistrarTecnicoComBoardNUll(Model_EntradaSMD mod)
 {
     try
     {
         OpenConnection();
         string str = string.Format(@"INSERT INTO TecnicoMaisPlaca VALUES(@data,@cod,NULL,@alocado)");
         using (cmd = new SqlCommand(str, conn))
         {
             string data    = DateTime.Now.ToString("yyyy/MM/dd");
             bool   alocada = true;
             cmd.Parameters.AddWithValue("@data", data);
             cmd.Parameters.AddWithValue("@cod", mod.EntradaId);
             cmd.Parameters.AddWithValue("@alocado", alocada);
             cmd.ExecuteNonQuery();
         }
     }
     catch (SqlException ex)
     {
         throw new Exception("Erro ao registrar o tecnico + placa" + ex.Message);
     }
     finally
     {
         ClosedConnection();
     }
 }
コード例 #6
0
 /// <summary>
 ///
 /// </summary>
 public void getCodPai()
 {
     try
     {
         objModel = list.GetCodPai();
         if (objModel != null)
         {
             lblCodPai.Text = Convert.ToString(objModel.EntradaId);
         }
         else
         {
             lblMsg.Text = "Nunhum codigo retornado!";
         }
     }
     catch (Exception ex)
     {
         lblMsg.Text = "Error ao recuperar o Codigo: " + ex.Message;
     }
 }
コード例 #7
0
 /// <summary>
 ///
 /// </summary>
 /// <param name="mod"></param>
 public void UpdateStatus(Model_EntradaSMD mod)
 {
     try
     {
         OpenConnection();
         string str = string.Format(@"UPDATE PrincipalProcessRepair SET Status='TRANSFER TEC' WHERE EntradaId = @cod");
         using (cmd = new SqlCommand(str, conn))
         {
             cmd.Parameters.AddWithValue("@cod", mod.EntradaId);
             cmd.ExecuteNonQuery();
         }
     }
     catch (SqlException ex)
     {
         throw new Exception("Erro ao atualizar os Status: " + ex.Message);
     }
     finally
     {
         ClosedConnection();
     }
 }