📄 daocustomer.java.svn-base
字号:
}
}
if (eEnEnt_Customer_Enterprise.getChArea() != null &&
! (eEnEnt_Customer_Enterprise.getChArea() + "A").equals("A"))
{
if(i==0){
sql = sql + " Ent_Customer_Enterprise.chArea like '%" + eEnEnt_Customer_Enterprise.getChArea().trim() + "%'";
i++;
}else{
sql = sql + " and Ent_Customer_Enterprise.chArea like '%" + eEnEnt_Customer_Enterprise.getChArea().trim() + "%'";
}
}
if (eEnEnt_Customer_Enterprise.getChEnterpriseGrade() != null &&
! (eEnEnt_Customer_Enterprise.getChEnterpriseGrade() + "A").equals("A"))
{
if(i==0){
sql = sql + " Ent_Customer_Enterprise.chEnterpriseGrade like '%" + eEnEnt_Customer_Enterprise.getChEnterpriseGrade().trim() + "%'";
i++;
}else{
sql = sql + " and Ent_Customer_Enterprise.chEnterpriseGrade like '%" + eEnEnt_Customer_Enterprise.getChEnterpriseGrade().trim() + "%'";
}
}
if (eEnEnt_Customer_Enterprise.getChEnterpriseFax() != null &&
! (eEnEnt_Customer_Enterprise.getChEnterpriseFax() + "A").equals("A"))
{
if(i==0){
sql = sql + " Ent_Customer_Enterprise.chEnterpriseFax like '%" + eEnEnt_Customer_Enterprise.getChEnterpriseFax().trim() + "%'";
i++;
}else{
sql = sql + " and Ent_Customer_Enterprise.chEnterpriseFax like '%" + eEnEnt_Customer_Enterprise.getChEnterpriseFax().trim() + "%'";
}
}
if (eEnEnt_Customer_Enterprise.getChEnterprisePhone() != null &&
! (eEnEnt_Customer_Enterprise.getChEnterprisePhone() + "A").equals("A"))
{
if(i==0){
sql = sql + " Ent_Customer_Enterprise.chEnterprisePhone like '%" + eEnEnt_Customer_Enterprise.getChEnterprisePhone().trim() + "%'";
i++;
}else{
sql = sql + " and Ent_Customer_Enterprise.chEnterprisePhone like '%" + eEnEnt_Customer_Enterprise.getChEnterprisePhone().trim() + "%'";
}
}
if (eEnEnt_Customer_Enterprise.getLinkmanTel() != null &&
! (eEnEnt_Customer_Enterprise.getLinkmanTel() + "A").equals("A"))
{
if(i==0){
sql = sql + " Ent_Customer_Enterprise.LinkmanTel like '%" + eEnEnt_Customer_Enterprise.getLinkmanTel().trim() + "%'";
i++;
}else{
sql = sql + " and Ent_Customer_Enterprise.LinkmanTel like '%" + eEnEnt_Customer_Enterprise.getLinkmanTel().trim() + "%'";
}
}
if (eEnEnt_Customer_Enterprise.getChEnterpriseCategory() != null &&
! (eEnEnt_Customer_Enterprise.getChEnterpriseCategory() + "A").equals("A"))
{
if(i==0){
sql = sql + " Ent_Customer_Enterprise.chEnterpriseCategory like '%" + eEnEnt_Customer_Enterprise.getChEnterpriseCategory().trim() + "%'";
i++;
}else{
sql = sql + " and Ent_Customer_Enterprise.chEnterpriseCategory like '%" + eEnEnt_Customer_Enterprise.getChEnterpriseCategory().trim() + "%'";
}
}
if (eEnEnt_Customer_Enterprise.getChProduct() != null &&
! (eEnEnt_Customer_Enterprise.getChProduct() + "A").equals("A"))
{
if(i==0){
sql = sql + " Ent_Customer_Enterprise.chProduct like '%" + eEnEnt_Customer_Enterprise.getChProduct().trim() + "%'";
i++;
}else{
sql = sql + " and Ent_Customer_Enterprise.chProduct like '%" + eEnEnt_Customer_Enterprise.getChProduct().trim() + "%'";
}
}
if (startTime != null && ! (startTime + "A").equals("A"))
{
if(i==0){ //TO_DATE('01-01-2000','dd-mm-yyyy');
sql = sql + " Ent_Customer_Enterprise.dtOpenAccout >= TO_DATE('" + startTime.trim() + "','yyyy-MM-dd')";
i++;
}else{
sql = sql + " and Ent_Customer_Enterprise.dtOpenAccout >= TO_DATE('" + startTime.trim() + "','yyyy-MM-dd')";
}
}
if (endTime != null &&
! (endTime + "A").equals("A"))
{
if(i==0){
sql = sql + " Ent_Customer_Enterprise.dtOpenAccout <= TO_DATE('" + endTime.trim() + "','yyyy-MM-dd')";
i++;
}else{
sql = sql + " and Ent_Customer_Enterprise.dtOpenAccout <= TO_DATE('" + endTime.trim() + "','yyyy-MM-dd')";
}
}
//select * from (select t.*, t.rowid from ent_customer_enterprise t where t.charea like '%东莞%' or t.Chstation like '%东莞%')where chenterprisefullname like '%中山市百德贸易%'
return sql;
}
public static EnEnt_Customer_Enterprise [] searcheEnContract2(DbAccess db,
EnEnt_Customer_Enterprise SearchEnContract,String startTime,String endTime,String chStationCode,String idstr)
throws Exception
{
String eEnEnt_Customer_Enterprise="";
if ((SearchEnContract.getChEnterpriseLinkman() != null && SearchEnContract.getChEnterpriseLinkman().length() != 0)
||(SearchEnContract.getChEnterpriseFullName() != null && SearchEnContract.getChEnterpriseFullName().length() != 0)
||(SearchEnContract.getChSeatCode() != null && SearchEnContract.getChSeatCode().length() != 0)
||(SearchEnContract.getChStationCode() != null && SearchEnContract.getChStationCode().length() != 0)
||(SearchEnContract.getChStation() != null && SearchEnContract.getChStation().length() != 0)
||(SearchEnContract.getChEnterpriseProvinceCode() != null && SearchEnContract.getChEnterpriseProvinceCode().length() != 0)
||(SearchEnContract.getChEnterpriseCityName() != null && SearchEnContract.getChEnterpriseCityName().length() != 0)
||(SearchEnContract.getChArea() != null && SearchEnContract.getChArea().length() != 0)
||(SearchEnContract.getChEnterpriseGrade() != null && SearchEnContract.getChEnterpriseGrade().length() != 0)
||(SearchEnContract.getChEnterpriseFax() != null && SearchEnContract.getChEnterpriseFax().length() != 0)
||(SearchEnContract.getChEnterprisePhone() != null && SearchEnContract.getChEnterprisePhone().length() != 0)
||(SearchEnContract.getLinkmanTel() != null && SearchEnContract.getLinkmanTel().length() != 0)
||(SearchEnContract.getChEnterpriseCategory() != null && SearchEnContract.getChEnterpriseCategory().length() != 0)
||(SearchEnContract.getChProduct() != null && SearchEnContract.getChProduct().length() != 0)
||(startTime != null && startTime.length()!=0)
||(endTime != null && endTime.length()!=0)
||(SearchEnContract.getChCommitName() != null && SearchEnContract.getChCommitName().toString().length() != 0) )
{
//eEnEnt_Customer_Enterprise = "(select * from Ent_Customer_Enterprise where chIsAudited like '1' and "+ GDPE.customer.enterprise.DAOCustomer.searchSql(SearchEnContract,startTime,endTime)+") Ent_Customer_Enterprise ";
eEnEnt_Customer_Enterprise ="(select * from (select * from ent_customer_enterprise where chAreacode = '"+chStationCode+"' or chStationCode ='"+chStationCode+"' or chCommitCode ='"+idstr+"') Ent_Customer_Enterprise where chIsAudited like '1' and "+ GDPE.customer.enterprise.DAOCustomer.searchSql(SearchEnContract,startTime,endTime)+") Ent_Customer_Enterprise ";
//System.out.println("0000000000000000000"+SearchEnContract.getChEnterpriseName());
}else{
eEnEnt_Customer_Enterprise="Ent_Customer_Enterprise";
}
//System.out.println(Auditor);
String sql="";
//String sql = "select * from Ent_Record_Contract where chContractNo='"+SearchEnContract.getChContractNo()+"'";
sql = sql + " select Ent_Customer_Enterprise.*";
sql = sql + " from "+eEnEnt_Customer_Enterprise;
sql = sql + setDefaultSort();
//System.out.println("sq-------------------------"+sql);
EnEnt_Customer_Enterprise [] aEnEnt_Customer_Enterprise = null;
aEnEnt_Customer_Enterprise =DAOCustomer.SetEnCustomert(db, sql);
return (aEnEnt_Customer_Enterprise);
}
public static EnEnt_Customer_Enterprise [] searcheEnContract3(DbAccess db,
EnEnt_Customer_Enterprise SearchEnContract,String startTime,String endTime,String chStationCode,String idstr)
throws Exception
{
String eEnEnt_Customer_Enterprise="";
if ((SearchEnContract.getChEnterpriseLinkman() != null && SearchEnContract.getChEnterpriseLinkman().length() != 0)
||(SearchEnContract.getChEnterpriseFullName() != null && SearchEnContract.getChEnterpriseFullName().length() != 0)
||(SearchEnContract.getChSeatCode() != null && SearchEnContract.getChSeatCode().length() != 0)
||(SearchEnContract.getChStationCode() != null && SearchEnContract.getChStationCode().length() != 0)
||(SearchEnContract.getChStation() != null && SearchEnContract.getChStation().length() != 0)
||(SearchEnContract.getChEnterpriseProvinceCode() != null && SearchEnContract.getChEnterpriseProvinceCode().length() != 0)
||(SearchEnContract.getChEnterpriseCityName() != null && SearchEnContract.getChEnterpriseCityName().length() != 0)
||(SearchEnContract.getChArea() != null && SearchEnContract.getChArea().length() != 0)
||(SearchEnContract.getChEnterpriseGrade() != null && SearchEnContract.getChEnterpriseGrade().length() != 0)
||(SearchEnContract.getChEnterpriseFax() != null && SearchEnContract.getChEnterpriseFax().length() != 0)
||(SearchEnContract.getChEnterprisePhone() != null && SearchEnContract.getChEnterprisePhone().length() != 0)
||(SearchEnContract.getLinkmanTel() != null && SearchEnContract.getLinkmanTel().length() != 0)
||(SearchEnContract.getChEnterpriseCategory() != null && SearchEnContract.getChEnterpriseCategory().length() != 0)
||(SearchEnContract.getChProduct() != null && SearchEnContract.getChProduct().length() != 0)
||(startTime != null && startTime.length()!=0)
||(endTime != null && endTime.length()!=0)
||(SearchEnContract.getChCommitName() != null && SearchEnContract.getChCommitName().toString().length() != 0) )
{
//eEnEnt_Customer_Enterprise = "(select * from Ent_Customer_Enterprise where chIsAudited like '1' and "+ GDPE.customer.enterprise.DAOCustomer.searchSql(SearchEnContract,startTime,endTime)+") Ent_Customer_Enterprise ";
eEnEnt_Customer_Enterprise ="(select * from (select * from ent_customer_enterprise where chAreacode = '"+chStationCode+"' or chStationCode ='"+chStationCode+"' or chCommitCode ='"+idstr+"') Ent_Customer_Enterprise where "+ GDPE.customer.enterprise.DAOCustomer.searchSql(SearchEnContract,startTime,endTime)+") Ent_Customer_Enterprise ";
//System.out.println("0000000000000000000"+SearchEnContract.getChEnterpriseName());
}else{
eEnEnt_Customer_Enterprise="Ent_Customer_Enterprise";
}
//System.out.println(Auditor);
String sql="";
//String sql = "select * from Ent_Record_Contract where chContractNo='"+SearchEnContract.getChContractNo()+"'";
sql = sql + " select Ent_Customer_Enterprise.*";
sql = sql + " from "+eEnEnt_Customer_Enterprise;
sql = sql + setDefaultSort();
//System.out.println("sq-------------------------"+sql);
EnEnt_Customer_Enterprise [] aEnEnt_Customer_Enterprise = null;
aEnEnt_Customer_Enterprise =DAOCustomer.SetEnCustomert(db, sql);
return (aEnEnt_Customer_Enterprise);
}
}⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -