/// <summary> /// 是否存在该记录 /// </summary> public bool Exists(string C_ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select count(1) from TQB_ZZS_PRINT_MODLE"); 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> /// <param name="gxidstr">工序主键</param> /// <returns></returns> public bool ExistsNOSotpGX(string C_PRO_ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select count(1) from TB_STA"); strSql.Append(" where C_PRO_ID=:C_PRO_ID AND N_STATUS=1"); OracleParameter[] parameters = { new OracleParameter(":C_PRO_ID", OracleDbType.Varchar2, 100) }; parameters[0].Value = C_PRO_ID; return(DbHelperOra.Exists(strSql.ToString(), parameters)); }
/// <summary> /// 检查是否存在重复数据 /// </summary> /// <param name="strProCode">工序主键</param> /// <returns></returns> public bool ExistsByProCode(string strProCode) { StringBuilder strSql = new StringBuilder(); strSql.Append("select count(1) from TB_PRO"); strSql.Append(" where C_PRO_CODE=:C_PRO_CODE AND N_STATUS=1"); OracleParameter[] parameters = { new OracleParameter(":C_PRO_CODE", OracleDbType.Varchar2, 100) }; parameters[0].Value = strProCode; return(DbHelperOra.Exists(strSql.ToString(), parameters)); }
/// <summary> /// 查询某仓库是否存在未停用的区域信息 /// </summary> /// <param name="strCOOLPIT">仓库主键</param> /// <returns></returns> public bool ExistsNOSotpByCOOLPIT(string strCOOLPIT) { StringBuilder strSql = new StringBuilder(); strSql.Append("select count(1) from TPB_COOLPIT_AREA"); strSql.Append(" where C_COOLPIT_ID=:C_COOLPIT_ID AND N_STATUS=1"); OracleParameter[] parameters = { new OracleParameter(":C_COOLPIT_ID", OracleDbType.Varchar2, 100) }; parameters[0].Value = strCOOLPIT; return(DbHelperOra.Exists(strSql.ToString(), parameters)); }
/// <summary> /// 判断包装类型代码是否重复 /// </summary> /// <param name="C_ID"></param> /// <returns></returns> public bool Exists(string C_TYPE) { StringBuilder strSql = new StringBuilder(); strSql.Append("select count(1) from TQB_PACK "); strSql.Append(" where c_pack_type_code=:c_pack_type_code"); OracleParameter[] parameters = { new OracleParameter(":c_pack_type_code", OracleDbType.Varchar2, 100) }; parameters[0].Value = C_TYPE; return(DbHelperOra.Exists(strSql.ToString(), parameters)); }
/// <summary> /// 是否存在该记录 /// </summary> public bool Exists(string C_ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("SELECT count(1) from TB_STA"); 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 ExistsDate(string C_PRO_ID, string C_STA_ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select count(1) from TPB_STEEL_SMELT_TIME where N_STATUS=1 "); strSql.Append(" and C_PRO_ID=:C_PRO_ID "); strSql.Append(" and C_STA_ID=:C_STA_ID "); OracleParameter[] parameters = { new OracleParameter(":C_PRO_ID", OracleDbType.Varchar2, 100), new OracleParameter(":C_STA_ID", OracleDbType.Varchar2, 100) }; parameters[0].Value = C_PRO_ID; parameters[1].Value = C_STA_ID; return(DbHelperOra.Exists(strSql.ToString(), parameters)); }
/// <summary> /// 通过钢种检验是否存在数据 /// </summary> /// <param name="C_PROD_NAME">钢类</param> /// <param name="C_STA_ID">工位</param> /// <param name="C_SPEC">规格</param> /// <param name="C_STL_GRD">钢种</param> /// <param name="C_STD_CODE">执行标准</param> /// <returns></returns> public bool ExistsByGRD(string C_PROD_NAME, string C_STA_ID, string C_SPEC, string C_STL_GRD, string C_STD_CODE) { StringBuilder strSql = new StringBuilder(); strSql.Append("select count(1) from TPB_SLAB_CAPACITY where N_STATUS=1 "); if (C_STL_GRD.Trim() == "") { strSql.Append(" AND C_STL_GRD is null "); strSql.Append(" AND C_STD_CODE is null "); strSql.Append(" and C_STA_ID=:C_STA_ID "); strSql.Append(" and C_SPEC=:C_SPEC "); strSql.Append(" and C_PROD_NAME=:C_PROD_NAME "); OracleParameter[] parameters1 = { new OracleParameter(":C_STA_ID", OracleDbType.Varchar2, 100), new OracleParameter(":C_SPEC", OracleDbType.Varchar2, 100), new OracleParameter(":C_PROD_NAME", OracleDbType.Varchar2, 100) }; parameters1[0].Value = C_STA_ID; parameters1[1].Value = C_SPEC; parameters1[2].Value = C_PROD_NAME; return(DbHelperOra.Exists(strSql.ToString(), parameters1)); } else { strSql.Append(" and C_STA_ID=:C_STA_ID "); strSql.Append(" and C_STL_GRD=:C_STL_GRD "); strSql.Append(" and C_SPEC=:C_SPEC "); strSql.Append(" and C_STD_CODE=:C_STD_CODE "); strSql.Append(" and C_PROD_NAME=:C_PROD_NAME "); OracleParameter[] parameters = { new OracleParameter(":C_STA_ID", OracleDbType.Varchar2, 100), new OracleParameter(":C_STL_GRD", OracleDbType.Varchar2, 100), new OracleParameter(":C_SPEC", OracleDbType.Varchar2, 100), new OracleParameter(":C_STD_CODE", OracleDbType.Varchar2, 100), new OracleParameter(":C_PROD_NAME", OracleDbType.Varchar2, 100) }; parameters[0].Value = C_STA_ID; parameters[1].Value = C_STL_GRD; parameters[2].Value = C_SPEC; parameters[3].Value = C_STD_CODE; parameters[4].Value = C_PROD_NAME; return(DbHelperOra.Exists(strSql.ToString(), parameters)); } }
/// <summary> /// 是否存在相同数据 /// </summary> public bool Exists(string C_STA_ID, string C_SPEC) { StringBuilder strSql = new StringBuilder(); strSql.Append("select count(1) from TPB_STATION_CAPACITY where N_STATUS=1 "); strSql.Append(" AND C_STL_GRD is null "); strSql.Append(" AND C_STD_CODE is null "); strSql.Append(" and C_STA_ID=:C_STA_ID "); strSql.Append(" and C_SPEC=:C_SPEC "); OracleParameter[] parameters = { new OracleParameter(":C_STA_ID", OracleDbType.Varchar2, 100), new OracleParameter(":C_SPEC", OracleDbType.Varchar2, 100) }; parameters[0].Value = C_STA_ID; parameters[1].Value = C_SPEC; return(DbHelperOra.Exists(strSql.ToString(), parameters)); }
/// <summary> /// 是否存在相同数据 /// </summary> public bool ExistsDate(string C_STL_GRD, string C_STD_CODE, string C_STA_ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select count(1) from TPB_CAST_STOVE where N_STATUS=1 "); strSql.Append(" and C_STA_ID=:C_STA_ID "); strSql.Append(" and C_STL_GRD=:C_STL_GRD "); strSql.Append(" and C_STD_CODE=:C_STD_CODE "); OracleParameter[] parameters = { new OracleParameter(":C_STA_ID", OracleDbType.Varchar2, 100), new OracleParameter(":C_STL_GRD", OracleDbType.Varchar2, 100), new OracleParameter(":C_STD_CODE", OracleDbType.Varchar2, 100) }; parameters[0].Value = C_STA_ID; parameters[1].Value = C_STL_GRD; parameters[2].Value = C_STD_CODE; return(DbHelperOra.Exists(strSql.ToString(), parameters)); }
/// <summary> /// 是否存在该记录 /// </summary> public bool Exists(decimal INFOID, decimal DEPTID, DateTime DTDATE, decimal REDEPTID, string INTNUM, string CHRTITLE, string CHRDESC, decimal CLASSID, decimal TYPEID, decimal INTLEVEL, decimal USERID, decimal IS_CAI, DateTime DTAPPENDDDATE, decimal ISCHECK, decimal CHECKID, DateTime CHECKDATE, string SUBJECTID, string NAME, string CHRCLASS, decimal CATEGORYID, string CHRTYPE, string CHRTRUENAME, decimal ISGONE, string CHRNO, string FORMID, decimal ISERROR) { StringBuilder strSql = new StringBuilder(); strSql.Append("select count(1) from INFO_ACCEPT_VIEW"); strSql.Append(" where INFOID=:INFOID and DEPTID=:DEPTID and DTDATE=:DTDATE and REDEPTID=:REDEPTID and INTNUM=:INTNUM and CHRTITLE=:CHRTITLE and CHRDESC=:CHRDESC and CLASSID=:CLASSID and TYPEID=:TYPEID and INTLEVEL=:INTLEVEL and USERID=:USERID and IS_CAI=:IS_CAI and DTAPPENDDDATE=:DTAPPENDDDATE and ISCHECK=:ISCHECK and CHECKID=:CHECKID and CHECKDATE=:CHECKDATE and SUBJECTID=:SUBJECTID and NAME=:NAME and CHRCLASS=:CHRCLASS and CATEGORYID=:CATEGORYID and CHRTYPE=:CHRTYPE and CHRTRUENAME=:CHRTRUENAME and ISGONE=:ISGONE and CHRNO=:CHRNO and FORMID=:FORMID and ISERROR=:ISERROR "); OracleParameter[] parameters = { new OracleParameter(":INFOID", OracleDbType.Int32, 4), new OracleParameter(":DEPTID", OracleDbType.Int32, 4), new OracleParameter(":DTDATE", OracleDbType.Date), new OracleParameter(":REDEPTID", OracleDbType.Int32, 4), new OracleParameter(":INTNUM", OracleDbType.Varchar2, 20), new OracleParameter(":CHRTITLE", OracleDbType.Varchar2, 512), new OracleParameter(":CHRDESC", OracleDbType.Clob, 4000), new OracleParameter(":CLASSID", OracleDbType.Int32, 4), new OracleParameter(":TYPEID", OracleDbType.Int32, 4), new OracleParameter(":INTLEVEL", OracleDbType.Int32, 4), new OracleParameter(":USERID", OracleDbType.Int32, 4), new OracleParameter(":IS_CAI", OracleDbType.Int32, 4), new OracleParameter(":DTAPPENDDDATE", OracleDbType.Date), new OracleParameter(":ISCHECK", OracleDbType.Int32, 4), new OracleParameter(":CHECKID", OracleDbType.Int32, 4), new OracleParameter(":CHECKDATE", OracleDbType.Date), new OracleParameter(":SUBJECTID", OracleDbType.Varchar2, 512), new OracleParameter(":NAME", OracleDbType.Varchar2, 200), new OracleParameter(":CHRCLASS", OracleDbType.Varchar2, 512), new OracleParameter(":CATEGORYID", OracleDbType.Int32, 4), new OracleParameter(":CHRTYPE", OracleDbType.Varchar2, 512), new OracleParameter(":CHRTRUENAME", OracleDbType.Varchar2, 50), new OracleParameter(":ISGONE", OracleDbType.Int32, 4), new OracleParameter(":CHRNO", OracleDbType.Varchar2, 20), new OracleParameter(":FORMID", OracleDbType.Varchar2, 50), new OracleParameter(":ISERROR", OracleDbType.Int32, 4) }; parameters[0].Value = INFOID; parameters[1].Value = DEPTID; parameters[2].Value = DTDATE; parameters[3].Value = REDEPTID; parameters[4].Value = INTNUM; parameters[5].Value = CHRTITLE; parameters[6].Value = CHRDESC; parameters[7].Value = CLASSID; parameters[8].Value = TYPEID; parameters[9].Value = INTLEVEL; parameters[10].Value = USERID; parameters[11].Value = IS_CAI; parameters[12].Value = DTAPPENDDDATE; parameters[13].Value = ISCHECK; parameters[14].Value = CHECKID; parameters[15].Value = CHECKDATE; parameters[16].Value = SUBJECTID; parameters[17].Value = NAME; parameters[18].Value = CHRCLASS; parameters[19].Value = CATEGORYID; parameters[20].Value = CHRTYPE; parameters[21].Value = CHRTRUENAME; parameters[22].Value = ISGONE; parameters[23].Value = CHRNO; parameters[24].Value = FORMID; parameters[25].Value = ISERROR; return(DbHelperOra.Exists(strSql.ToString(), parameters)); }