//========================================================================
//SuperMap IS 客户端程序,版权所有，杭州市房产信息中心，2003-2007。
//本程序只能在有效的授权许可下使用。未经许可，不得以任何手段擅自使用或传播。
//作者：	TongZG
//文件名:	SMSerchProject.js
//功能:		拆迁项目查找
//最后修改时间:
//========================================================================

//生成查询语句
function GetSQL_PrjQry()
{
  var strSQL;
  strSQL = "";

  if(document.all.ProjectName.value != "") {
    strSQL += "PRJ_NAME";
//    if(document.all.NameLike.checked)
      strSQL += " like '%" + document.all.ProjectName.value + "%'";
//    else
//      strSQL +=" = '" + document.all.ProjectName.value + "'";
  }

  if(document.all.SN_CQXK.value != "") {
    if(isNaN(document.all.SN_CQXK.value)) {
      alert("请正确填写查询条件：拆迁许可证号应为数字！");
      return "";
    } else {
      if(strSQL != "")
        strSQL += " and ";
      strSQL += "CQXKZ_CODE = '杭房拆许字" + document.all.Year_CQXK.value;
      strSQL += "第" + document.all.SN_CQXK.value + "号'";
    }
  }

  if(document.all.DistrictName.value != "0") {
    if(strSQL != "")
      strSQL += " and ";
    strSQL += "CQ_NAME = '" + document.all.DistrictName.value + "'";
  }

  if(document.all.UnitName.value != "") {
    if(strSQL != "")
      strSQL += " and ";
    strSQL += "CQ_UNIT";
    if(document.all.UnitNameLike.checked)
      strSQL += " like '%" + document.all.UnitName.value + "%'";
    else
      strSQL +=" = '" + document.all.UnitName.value + "'";
  }
  
  if(document.all.Address.value != "") {
	  if(strSQL != "")
	    strSQL += " and ";
	  strSQL += "exists (select CQXKZ_ID from CQBADMIN.V_FINDCQXKZ where MPH like '%" + document.all.Address.value + "%' and cqxkz_id = cqxkz_code)";
  }

  return strSQL;
}

//查询（相应查询按钮）
function FindProjects()
{
  var strSQL;

  strSQL = GetSQL_PrjQry();
/*  if(strSQL == "") {
    alert("请修改条件后提交查询。");
    return;
  }
*/
  document.PrjSearchForm.hidden2.value = strSQL;
  document.PrjSearchForm.submit();
}

//清空查询条件
function Clear()
{
  document.all.ProjectName.value = "";
  document.all.SN_CQXK.value = "";
  document.all.DistrictName.value = "0";
  document.all.UnitName.value = "";
  document.all.Address.value = "";
}