Example #1
0
        public void Excluir(HistResp hr)
        {
            var strQuery = string.Format("DELETE FROM tblhistresp WHERE idresp={0} AND " +
                                         "data='{1}' AND documento='{2}'", hr.RespId, hr.Data, hr.Documento);

            using (cnx = new ConexaoBD())
                cnx.CommNom(strQuery);
        }
Example #2
0
        public void Inserir(HistResp histresp)
        {
            var strQuery = "";

            strQuery += "INSERT INTO tblhistresp(idresp, datan, documento, situacao, data) ";
            strQuery += string.Format("VALUES ({0}, {1}, '{2}', {3}, '{4}')",
                                      histresp.RespId.ToString(), histresp.Datan.ToString(), histresp.Documento,
                                      histresp.Situacao.ToString(), histresp.Data.ToString());

            using (cnx = new ConexaoBD())
                cnx.CommNom(strQuery);
        }
Example #3
0
        public void Alterar(HistResp hr)
        {
            var strQuery = "";

            strQuery += "UPDATE tblhistresp SET ";
            strQuery += string.Format("idresp={0}, datan={1}, documento='{2}', situacao={3}, data='{4}' ",
                                      hr.RespId.ToString(), hr.Datan.ToString(), hr.Documento, hr.Situacao.ToString(),
                                      hr.Data.ToString());
            strQuery += string.Format("WHERE idresp={0} AND data='{1}' AND documento='{2}'",
                                      hr.RespId.ToString(), hr.Data.ToString(), hr.Documento);

            using (cnx = new ConexaoBD())
                cnx.CommNom(strQuery);
        }
Example #4
0
 private HistResp One(DataTable dt, int pos)
 {
     if (dt.Rows.Count > 0)
     {
         var registro = new HistResp()
         {
             RespId    = int.Parse(dt.Rows[pos]["idresp"].ToString()),
             Datan     = int.Parse(dt.Rows[pos]["datan"].ToString()),
             Documento = dt.Rows[pos]["documento"].ToString(),
             Situacao  = int.Parse(dt.Rows[pos]["situacao"].ToString()),
             Data      = DateTime.Parse(dt.Rows[pos]["data"].ToString())
         };
         return(registro);
     }
     else
     {
         return(new HistResp());
     }
 }