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