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