/// <summary>
/// 是否存在该记录
/// </summary>
public bool Exists(string ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(1) from projectproportion");
strSql.Append(" where ID=@ID ");
MySqlParameter[] parameters =
{
new MySqlParameter("@ID", MySqlDbType.VarChar, 36)
};
parameters[0].Value = ID;
return(DbHelperMySQL.Exists(strSql.ToString(), parameters));
}
/// <summary>
/// 是否存在该记录
/// </summary>
public bool Exists(string ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(1) from taskassignconfigdetails");
strSql.Append(" where ID=@ID ");
MySqlParameter[] parameters =
{
new MySqlParameter("@ID", MySqlDbType.VarChar, 40)
};
parameters[0].Value = ID;
return(DbHelperMySQL.Exists(strSql.ToString(), parameters));
}
/// <summary>
/// 是否存在该记录
/// </summary>
public bool ExistsByParentIDAndChildID(string parentID, string childID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(1) from employeedomination");
strSql.Append(" where PARENTEMPLOYEEID=@parentID AND CHILDEMPLOYEEID = @childID ");
MySqlParameter[] parameters =
{
new MySqlParameter("@parentID", MySqlDbType.VarChar, 36),
new MySqlParameter("@childID", MySqlDbType.VarChar, 36)
};
parameters[0].Value = parentID;
parameters[1].Value = childID;
return(DbHelperMySQL.Exists(strSql.ToString(), parameters));
}