/// <summary>
/// 是否存在该记录
/// </summary>
public bool Exists(string areaID, string start, string end)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(1) from TMB_AREAPLAN");
strSql.Append(" where C_AERA_ID=:C_AERA_ID and to_date('" + Convert.ToDateTime(start) + "', 'yyyy-mm-dd hh24:mi:ss')>=D_START and to_date('" + Convert.ToDateTime(end) + "', 'yyyy-mm-dd hh24:mi:ss') <= D_END ");
OracleParameter[] parameters =
{
new OracleParameter(":C_AERA_ID", OracleDbType.Varchar2, 100)
};
parameters[0].Value = areaID;
return(DbHelperOra.Exists(strSql.ToString(), parameters));
}
/// <summary>
/// 是否存在该记录
/// </summary>
public bool Exists(string C_ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(1) from TMB_AREAPLAN");
strSql.Append(" where C_ID=:C_ID ");
OracleParameter[] parameters =
{
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100)
};
parameters[0].Value = C_ID;
return(DbHelperOra.Exists(strSql.ToString(), parameters));
}
/// <summary>
/// 是否存在该记录
/// </summary>
public bool Exists(string C_CON_NO)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(1) from TMO_CONRULES");
strSql.Append(" where C_CON_NO=:C_CON_NO ");
OracleParameter[] parameters =
{
new OracleParameter(":C_CON_NO", OracleDbType.Varchar2, 100)
};
parameters[0].Value = C_CON_NO;
return(DbHelperOra.Exists(strSql.ToString(), parameters));
}
public bool ExistsZZS(string batch, string stlgrd, string stove, string std)
{
string strSql = $@"SELECT COUNT(1) FROM TQC_ZZS_FILE T WHERE T.C_BATCH_NO='{batch}' AND T.C_STL_GRD='{stlgrd}' AND T.C_STOVE='{stove}' AND T.C_STD_CODE='{std}'";
return(DbHelperOra.Exists(strSql));
}
/// <summary>
/// 是否存在该记录
/// </summary>
public bool Exists(string C_ID)
{
string strSql = $@"SELECT COUNT(1) FROM TQB_PACK WHERE C_PACK_TYPE_CODE='{C_ID}'";
return(DbHelperOra.Exists(strSql));
}
/// <summary>
/// 检查三方关系是否存在
/// </summary>
/// <param name="twoCustCode">二级客户</param>
/// <param name="threeCustCode">三级客户</param>
/// <returns></returns>
public bool Exists(string twoCustCode, string threeCustCode)
{
string strSql = $@"SELECT COUNT(1) FROM TS_CUST_SF T WHERE T.C_CUSTCODE='{twoCustCode}' AND T.C_CUSTCODE_PARENT='{threeCustCode}'";
return(DbHelperOra.Exists(strSql.ToString()));
}
/// <summary>
/// 是否存在该记录
/// </summary>
public bool Exists(string custCode)
{
string strSql = $@"SELECT COUNT(1) FROM TS_CUSTFILE T WHERE T.C_NO='{custCode}'";
return(DbHelperOra.Exists(strSql.ToString()));
}
/// <summary>
/// 是否存在该记录
/// </summary>
public bool Exists(string fyfs, string addr)
{
string strSql = $"SELECT COUNT(0) FROM TMB_NCADDRESS_COST WHERE N_STATUS=0 AND C_ADDRNAME='{addr}' AND C_FAYUN='{fyfs}'";
return(DbHelperOra.Exists(strSql));
}
