terça-feira, 27 de janeiro de 2015

Valida se a data informada esta no intervalo das datas já existentes

<pre  style="font-family:arial;font-size:12px;border:1px dashed #CCCCCC;width:99%;height:auto;overflow:auto;background:#f0f0f0;;background-image:URL(https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhZVLbi-Qwh8i0xCBCQJoXN7Xtp0X9szzeDzUetl-_V5PaVwfxC3J7RX2x41XBOp3JOPC1q6fw911n7keBZPbkQYfTywElv7zryhOUlKwV2OHvVeZWYFs-XR0n6-wGm7hUZTYfRQVn_iJr1/s320/codebg.gif);padding:0px;color:#000000;text-align:left;line-height:20px;"><code style="color:#000000;word-wrap:normal;"> public bool getValidaData(string sDataIni, string sDataFin, string sCode)
     {
       string sBr1_Company = BrOneConn.oDICompany.CompanyDB;
       string sSqlQuery;
       sSqlQuery = " SELECT MAX(VALIDA) AS Valida" + "\r\n" +
             "  FROM(" + "\r\n" +
             "   SELECT " + "\r\n" +
             "     CASE WHEN U_UPDatIni &lt;= '" + sDataFin + "' AND " + "\r\n" +
             "          U_UPDatFin &gt;= '" + sDataIni + "' THEN 1 ELSE 0 END Valida" + "\r\n" +
             "    FROM [@UPP_OPCG]" + "\r\n" +
             "   WHERE Code &lt;&gt; " + sCode + " " + "\r\n" +
             "  )TX";
       this.doQuery(sSqlQuery);
       if (this.ExecOk == true &amp;&amp; this.oRecordset.RecordCount &gt; 0)
       {
         if (Convert.ToString(this.oRecordset.Fields.Item("Valida").Value) == "1")
           return true;
       }
       return false;
     }
</code></pre>