<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 <= '" + sDataFin + "' AND " + "\r\n" +
" U_UPDatFin >= '" + sDataIni + "' THEN 1 ELSE 0 END Valida" + "\r\n" +
" FROM [@UPP_OPCG]" + "\r\n" +
" WHERE Code <> " + sCode + " " + "\r\n" +
" )TX";
this.doQuery(sSqlQuery);
if (this.ExecOk == true && this.oRecordset.RecordCount > 0)
{
if (Convert.ToString(this.oRecordset.Fields.Item("Valida").Value) == "1")
return true;
}
return false;
}
</code></pre>