/// <summary>
/// 是否存在该记录
/// </summary>
public bool Exists(int SupplierId)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(1) from T_Supplier");
strSql.Append(" where SupplierId=@SupplierId ");
SqlParameter[] parameters =
{
new SqlParameter("@SupplierId", SqlDbType.Int, 4)
};
parameters[0].Value = SupplierId;
return(DbBaseHelperSQL.Exists(strSql.ToString(), parameters));
}
/// <summary>
/// 是否存在该记录
/// </summary>
public bool Exists(string PointCode)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(1) from T_StationInformation");
strSql.Append(" where PointCode=@PointCode ");
SqlParameter[] parameters =
{
new SqlParameter("@PointCode", SqlDbType.NVarChar, 20)
};
parameters[0].Value = PointCode;
return(DbBaseHelperSQL.Exists(strSql.ToString(), parameters));
}
/// <summary>
/// 是否存在该记录
/// </summary>
public bool Exists(int PointID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(1) from T_StationNet");
strSql.Append(" where PointID=@PointID ");
SqlParameter[] parameters =
{
new SqlParameter("@PointID", SqlDbType.Int, 4)
};
parameters[0].Value = PointID;
return(DbBaseHelperSQL.Exists(strSql.ToString(), parameters));
}
/// <summary>
/// 是否存在该记录
/// </summary>
public bool Exists(string CompanyCode)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(1) from T_Company");
strSql.Append(" where CompanyCode=@CompanyCode ");
SqlParameter[] parameters =
{
new SqlParameter("@CompanyCode", SqlDbType.NVarChar, 255)
};
parameters[0].Value = CompanyCode;
return(DbBaseHelperSQL.Exists(strSql.ToString(), parameters));
}
/// <summary>
/// 是否存在该记录
/// </summary>
public bool Exists(int Partsid)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(1) from T_EquipmentParts");
strSql.Append(" where Partsid=@Partsid ");
SqlParameter[] parameters =
{
new SqlParameter("@Partsid", SqlDbType.Int, 4)
};
parameters[0].Value = Partsid;
return(DbBaseHelperSQL.Exists(strSql.ToString(), parameters));
}