C# (CSharp) ExamesComplementares示例

示例#1

 /// <summary>
 /// INSERE UM NOVO REGISTRO OU ATUALIZA UM DETERMINDO REGISTRO JÁ EXISTENTE.
 /// EXEMPLO:
 /// PARA INSERT BASTA PASSAR O ID DA TEBELA COMO ZERO(0)
 /// PARA UPDATE BASTA PASSAR O ID DA TABELA DIFERENTE DE ZERO(0)
 /// </summary>
 /// <param name="ObjExamesComplementares"></param>
 public void InsertUpdate(ExamesComplementares ObjExamesComplementares)
 {
     try
     {
         string     NomeProc;
         Database   db            = DatabaseFactory.CreateDatabase();
         Validacoes ObjValidacoes = new Validacoes();
         if (ObjExamesComplementares.id != 0)
         {
             NomeProc = "ExamesComplementaresUpdate";
         }
         else
         {
             NomeProc = "ExamesComplementaresInsert";
         }
         DbCommand command = db.GetStoredProcCommand(NomeProc);
         //Caso id(chave primaria for diferente de zero(0) então é passado o parametro para fazer o update
         if (ObjExamesComplementares.id != 0)
         {
             db.AddInParameter(command, "@ID", DbType.Int32, ObjExamesComplementares.id);
         }
         //Dados
         db.AddInParameter(command, "@Descricao", DbType.String, ObjExamesComplementares.Descricao);
         //Executa
         db.ExecuteNonQuery(command);
     }
     catch (Exception e)
     {
         throw e;
     }
 }

示例#2

文件： ExamesComplementaresCadastro.aspx.cs 项目： danygolden/gianfratti

 private void Editar(int id)
 {
     ExamesComplementares ObjExamesComplementares = new ExamesComplementares();
     ExamesComplementaresDAL ObjExamesComplementaresDAL = new ExamesComplementaresDAL();
     ObjExamesComplementares = ObjExamesComplementaresDAL.SelectByID(id);
     txtTipoExame.Text = ObjExamesComplementares.Descricao;
 }

示例#3

文件： ExamesComplementaresCadastro.aspx.cs 项目： danygolden/gianfratti

    private void Editar(int id)
    {
        ExamesComplementares    ObjExamesComplementares    = new ExamesComplementares();
        ExamesComplementaresDAL ObjExamesComplementaresDAL = new ExamesComplementaresDAL();

        ObjExamesComplementares = ObjExamesComplementaresDAL.SelectByID(id);
        txtTipoExame.Text       = ObjExamesComplementares.Descricao;
    }

示例#4

    /// <summary>
    /// Seleciona um determinado registro conformo o ID
    /// </summary>
    /// <param name="id"></param>
    /// <returns></returns>
    public ExamesComplementares SelectByID(int id)
    {
        Database  db      = DatabaseFactory.CreateDatabase();
        DbCommand command = db.GetStoredProcCommand("ExamesComplementaresSelectByID");

        db.AddInParameter(command, "@id", DbType.Int32, id);

        using (IDataReader dr = db.ExecuteReader(command))
        {
            ExamesComplementares ObjExamesComplementares = new ExamesComplementares();
            if (dr.Read())
            {
                ObjExamesComplementares.id        = Convert.ToInt32(dr["id"]);
                ObjExamesComplementares.Descricao = Convert.ToString(dr["Descricao"]);
            }
            return(ObjExamesComplementares);
        }
    }

示例#5

文件： ExamesComplementaresDAL.cs 项目： danygolden/gianfratti

 /// <summary>
 /// INSERE UM NOVO REGISTRO OU ATUALIZA UM DETERMINDO REGISTRO JÁ EXISTENTE.
 /// EXEMPLO:
 /// PARA INSERT BASTA PASSAR O ID DA TEBELA COMO ZERO(0)
 /// PARA UPDATE BASTA PASSAR O ID DA TABELA DIFERENTE DE ZERO(0)
 /// </summary>
 /// <param name="ObjExamesComplementares"></param>
 public void InsertUpdate(ExamesComplementares ObjExamesComplementares)
 {
     try
     {
         string NomeProc;
         Database db = DatabaseFactory.CreateDatabase();
         Validacoes ObjValidacoes = new Validacoes();
         if (ObjExamesComplementares.id != 0) { NomeProc = "ExamesComplementaresUpdate"; } else { NomeProc = "ExamesComplementaresInsert"; }
         DbCommand command = db.GetStoredProcCommand(NomeProc);
         //Caso id(chave primaria for diferente de zero(0) então é passado o parametro para fazer o update
         if (ObjExamesComplementares.id != 0) { db.AddInParameter(command, "@ID", DbType.Int32, ObjExamesComplementares.id); }
         //Dados
         db.AddInParameter(command, "@Descricao", DbType.String, ObjExamesComplementares.Descricao);
         //Executa
         db.ExecuteNonQuery(command);
     }
     catch (Exception e)
     {
         throw e;
     }
 }

示例#6

文件： ExamesComplementaresCadastro.aspx.cs 项目： danygolden/gianfratti

 protected void btnSalvar_Click(object sender, EventArgs e)
 {
     try
     {
         if (txtTipoExame.Text != "")
         {
             ExamesComplementares Obj = new ExamesComplementares();
             Obj.id        = Convert.ToInt32(Request.QueryString["id"]);
             Obj.Descricao = txtTipoExame.Text;
             ExamesComplementaresDAL ObjDAL = new ExamesComplementaresDAL();
             ObjDAL.InsertUpdate(Obj);
             Response.Redirect("default.aspx");
         }
         else
         {
             Page.ClientScript.RegisterClientScriptBlock(GetType(), "Mensage", "alert('Campo Obrigatório')", true);
         }
     }
     catch (Exception ex)
     {
         Response.Write(ex);
     }
 }

示例#7

文件： ExamesComplementaresCadastro.aspx.cs 项目： danygolden/gianfratti

    protected void btnSalvar_Click(object sender, EventArgs e)
    {
        try
        {
        if (txtTipoExame.Text != "")
        {

            ExamesComplementares Obj = new ExamesComplementares();
            Obj.id = Convert.ToInt32(Request.QueryString["id"]);
            Obj.Descricao = txtTipoExame.Text;
            ExamesComplementaresDAL ObjDAL = new ExamesComplementaresDAL();
            ObjDAL.InsertUpdate(Obj);
            Response.Redirect("default.aspx");
        }
        else
        {
            Page.ClientScript.RegisterClientScriptBlock(GetType(), "Mensage", "alert('Campo Obrigatório')", true);
        }
        }
        catch (Exception ex)
        {
            Response.Write(ex);
        }
    }

示例#8

文件： ExamesComplementaresDAL.cs 项目： danygolden/gianfratti

    /// <summary>
    /// Seleciona um determinado registro conformo o ID
    /// </summary>
    /// <param name="id"></param>
    /// <returns></returns>
    public ExamesComplementares SelectByID(int id)
    {
        Database db = DatabaseFactory.CreateDatabase();
        DbCommand command = db.GetStoredProcCommand("ExamesComplementaresSelectByID");
        db.AddInParameter(command, "@id", DbType.Int32, id);

        using (IDataReader dr = db.ExecuteReader(command))
        {
            ExamesComplementares ObjExamesComplementares = new ExamesComplementares();
            if (dr.Read())
            {
                ObjExamesComplementares.id = Convert.ToInt32(dr["id"]);
                ObjExamesComplementares.Descricao = Convert.ToString(dr["Descricao"]);
            }
            return ObjExamesComplementares;
        }
    }