/// <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)); }